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


Related Articles

Create SAP database table within the data dictionary transaction SE11
SAP Dictionary objects - Example code and information of the SAP dictionary
Download SAP database structure to file
Retrieve fixed SAP domain values
SAP Database locking using ENQUEUE and DEQUEUE
Modify your SAP database table maintenance events, screen, interface and code
Create and maintain parameter values in TVARVC using STVAR SAP transaction
Create SAP database table maintenance for your custom Z table using transaction SE11
SAP text table create
Creating transaction code for table maintenance (SM30)
Retrieve text for table field