SAP database table settings for Master, Application, Transaction and Customizing data
Assigning correct SAP table delivery class and other settings to determine what kind of data it holds and how it can be maintained.
Application / Transaction Data
This is Transaction data such as new records which are created by your application as in being used. This type of table should
be created within SAP transaction SE11 with the following data dictionary values:
-Delivery Class: A
-Data Browser/Table View Maint: Display/Maintenance Allowed or with restrictions
-Data Class (Goto->technical settings): APPL1
-Size(Goto->technical settings): 0 or whatever is appropriate for table entries.
-Table Maintenance: No
-Transportable Entries: Not if table maintenance is created otherwise can be manually added to transport
Customising data
This is data that is maintained in your development system (DEV) by configuration users and transported through the systems to your Production system (PRD).
When you chnage/create data on your DEV system you will be asked for a transport number.
-Delivery Class: C
-Data Browser/Table View Maint: Display/Maintenance Allowed
-Data Class (Goto->technical settings): APPL2
-Size(Goto->technical settings): 0 or whatever is appropriate for table entries.
-Table Maintenance: Yes
-Transportable Entries: Automatically creates transport when you create entries via table maintenance
Master data
This is for master data values such as search help drop downs specific to the current client. These are maintained directly in your Production system (PRD)
by support admin users and are not usually transported.
-Delivery Class: A
-Data Browser/Table View Maint: Display/Maintenance Allowed
-Data Class (Goto->technical settings): APPL0
-Size(Goto->technical settings): 0 or whatever is appropriate for table entries.
-Table Maintenance: Yes
-Transportable Entries: Not if table maintenance is created