Transparent Table

                Transparent Table Exists with the same structure both in dictionary as well as in database  exactly with the same data and fields.

               A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement. Transparent table is a one to one relation table i.e. when you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data. 

1. Client Field : It is used to make data Client Departure. 

                       Date Element for Client Field is MANDT.

2. Primary Key : it is useful to uniquely identify the rows in a table by one or  
   more columns so that you can process them in a specified sequence, for    
   example. You can do this by assigning  a “primary key.” The column names
   that are to create the table key are represented by the keywords PRIMARY
   KEY. The input values of the key columns defined in this way must not be a 
   NULL value.

3. Delivery class : The delivery class of a database table controls the transport 
    of table data in installations, upgrades, or client copies, and in transports    
    between customer  systems.

4. Data Browser/Table View Maintenance Locate the document in its SAP Library

    structure.

5. Foreign key is to validate the data that is being entered into a table by          
    checking entries in  a check table

6. Size Category : Shows How many Record can Exits in the Database For Table.

Create Transparent Table. 

Step1.  Go To Transaction  SE11. Enter Name Of Transparent Table in Database
            table. click Create .



Step 2 . Enter Description .Select Data class As per Requirement. Enter.
   

Step 3.  Select Display/ Maintenance Status.



Step 4 . Go To Field Tab and Enter Field Names , Data Element , Data Type and
            Length . 
 ( If Data element is created then after Entering Data Element Press Enter All 
              Other Details Gets Filled by Automatically)



Step 5. Assign Primary keys by Click On Empty box in Key and Initial        
           Values Columns Check Mark  will Appear .Primary key for Client is    
           Mandatory.



Step 6. Go To Technical Setting and Click On Data Class Side Popup .



Step 7 . Select Data class and Enter .



Step 8.  Do it Same for Size Category .



Step 9. Finally Technical Setting Created and Save .



Step 10 . Set Enhancement Category . In Menu bar , Extra n Select 
              Enhancement Category. 



Step 11 . Information  Screen will Appear . Press Enter .



Step 12. Select Radio Button as per requirement . And Click on Copy.



Step 13. Now Create Entries For That Go To menu bar  Follow Path as below 
            and select Create Entries.
             


Step 14. Make Entries as per Field and Save . Entries will be Created.



Step 15. To View Entries Go to Table Content and Click on Execute.




Step 16. In Data Browser . Created Entries  is Stored.

Transparent Table Created Suceessfully.