SAP table CMDT (Generic Master Record: General Header)

SAP table CMDT has 4 primary key fields being MANDT,OBJNR,DATBI,STATUS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
DATBI Valid To Date DATS 8 0 DATBI
STATUS Activation Status of Generic Master Record CHAR 1 0 CMDT_STATUS
A Active
D Inactive: Delete
I Inactive: Create
U Inactive: Change
DATAB Valid-From Date DATS 8 0 DATAB
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
ERSDA Entered On DATS 8 0 ERFDT
USNAM Entered By CHAR 12 0 ERFNM

CMDT foreign key relationships

Table Field Check Table Check Field
0 CMDT LOGSYSTEM TBDLS Logical system LOGSYS
1 CMDT MANDT T000 Clients MANDT
0 CMDT OBJNR ONR00 General Object Number MANDT