Creating Transparent Master Table

Steps:

• Go to transaction code SE11.

• Click on Database Table radio button.

• Enter the table name starts with Z or Y <table name > and click on Create Button.

• Enter the short Description.

• Delivery Class :- Delivery class to control the transport of table data for an installation, upgrade, or client copy and transports between customer systems. The delivery class is also used in the extended table maintenance.
• Delivery class decides how table should behave while its going to transfer from one system to another / one client to another client.

   

• Select the delivery class. Select ‘A’ .
• Select Data browser / Table View main :- Display / Maintenance  Allowed.

• Click on Fields Tab.

• MANDT : SAP Client is from organizational point of view is standalone system object which means that: All Data of  one client can not be used from another client (all data isolated within client).
• Technically, If MANDT is there in a table then table is Client Dependent else Table is Client Independent.
• Enter field name and Data Element as MANDT to make table as client dependent.
• Check Key and Initial. Press Enter.

• A primary key is a field or group of fields that uniquely identify a record in a table. Primary key fields cannot be NULL and cannot contain duplicate values.
• Enter the field name and make it primary key by clicking check Key and Initial.

• Enter the data Element name which starts with Z or Y <Data Element name >.

• To create data element , double click on data element.

• Click on Yes.
• Save it in Package or Local Package.

• Create the data element? Click on Yes.

• Enter the Short description.

• Click on Field Label tab.

• Enter the Field label.

• You can also enter documentation for the data element. Choose Goto ->Documentation. Or press F9. The text that you enter here will be displayed when you press F1 on the field.

• Click on Data Type tab.

• Enter the Domain Name .
• Double click on the domain name to create the domain for the data element/ field.
• If the domain is not existing then you will get a pop up asking to create one.

• Double click on Domain to create a new domain.

• Click on Yes button.
• Save it in Package or Local package.

• Create the domain? Click on Yes.

• Enter the Short description.

• Select the data type and Enter the length.

• Click on Save->->Check ->Activate to activate the Domain.

• Click on Back Button.
• Activate the Data Element.
• Click on Save->->Check ->Activate.

• Click on Back Button .

• Enter second field name and data element name.

• If data element does not exists, then create the data element.
• Double click on Data Element.

• Click on Yes.
• Create the data element? Click on Yes.

• Enter short description.

• Click on field label tab .

• Enter the field label,

• Click on Data Type tab.

• Enter the Domain name.

• To create new domain double click on Domain name .

• Click on Yes Button.
• Save it in Package or local package.

• Create the domain? Click on Yes.

• Enter short description.

• Enter Domain name and Length.

• Click on Save->->Check ->Activate to activate the Domain.

• Click on Back Button .

• Activate the Data Element.

• Click on Back Button.

• Enter the fields which are required , we can use pre-defined data elements  as well.

Note : For Quantity and Currency fields , we have to provide the reference table name as well as reference field name.

• Click on check.

• Click on back button.
• Click on Currency/Quantity Fields.

• Enter the reference table name as well as reference field name.

Enhancement Category :

• Giving access to  the user , to modify (change) the  data types in future .
• Click on Extras->Enhancement Category.

• Click on continue .

• Select Enhancement category as  per your requirements.

• Click on copy.

Technical Settings:

• Click on Technical settings.

• Click on Yes.

• Technical setting screen will appear.

Data class:

1. If you choose the data class correctly, your table is automatically assigned to the correct area (table space or DB space) of the database when it is created.
2. Each data class corresponds to a physical area in which all the tables assigned to this data class are stored. 
3. There are the following data classes:

• APPL0 (master data): Data which is seldomly changed. An example of master data is the data contained in an address file, such as the name, address and telephone number.
• APPL1 (transaction data): Data that is frequently changed. An example of transaction data is the goods in a warehouse, which change after each purchase order.
• APPL2 (organizational data): Customizing data that is defined when the system is installed and seldomly changed. An example is the table with country codes.
• Two further data classes, USR and USR1, are provided for the customer. These are for user developments. The tables assigned to these data classes are stored in a tablespace for user developments.

• Note : we are creating  Transparent Master Table . So select Data Class as : APPL0.

Size Category:

1. To define the expected space required for the table in the database. You can choose a size category from 0 to 4 for your table.
2. A certain fixed memory size in the database, which depends on the database system used, is assigned to each category.

Buffering

1. Buffering a table improves the performance when accessing the data records contained in the table.
2. The table buffers reside locally on each application server in the system. The data of buffered tables can thus be accessed directly from the buffer of the application server. This avoids the time-consuming process of accessing the database

Buffering

1. Buffering not allowed.
2. Buffering allowed but switched off.
3. Buffering switched on.

Buffering Types:

1. Single-record buffering: Only the records of a table that are really accessed are loaded into the buffer.
2. Generic buffering: When a record of the table is accessed, all the records having this record in the generic key fields (part of the table key that is left-justified, identified by specifying a number of key fields) are loaded into the buffer.
3. Full buffering: All the records of the table are loaded into the buffer when one record of the table is accessed.

• Click on Save and Click on Back Button.
• Click on Save->->Check ->Activate to activate the Table.

To enter records into Table

• Utilities->Table contents->Create Entries.

• Click on save.

To Display records

• Utilities->Table contents->Display.4

• Click on Execute Button.

Output

                                      more information...........