Today we will learn how to create transparent table using SAP, if we want to create a transparent table, we have to add Z or Y as the name prefix. For example Z_tablename1, Y_tablename1.
We can use transparent tables to store data for our custom program, if there should be any requirements from the users that are not covered in the SAP modules.
Here are the steps to create transparent tables.
1. Execute tcode se11, give a table name ztable1 and click CREATE.
**2. **Give the table a description And Select Delivery Class To A (Application Table), Data Browser into Display/Maintenance Allowed.
3. Click on the Fields tab and begin to create your field names here. If you’re creating a table that will be referenced to another table (A relational tables) you need to create data element using the same data type domain, this way you can link between these fields as the key. (Primary and foreign key), you can’t link between fields from two or more tables that don’t have the same domain.
**4. **To create a new data element, just type in the name for the data element and double click the name.
5. You will be prompted with a dialog box asking you whether or not you want to create a new data element, click yes.
6. In the data type tab, select the predefined type that will allow you to have data types provided by SAP. Just select CHAR as the data type with length 10.
7. Click on the technical settings tab, select APPL0 (master data, transparent table) for the data class, and 1 as the size category.
8. Click Extras > Enhancement Category and select the table can be enhanced.
9. Save and activate.
