SAP Table CMDT

Generic Master Record: General Header

CMDT (Generic Master Record: General Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CMDT to other SAP tables.

Source: CMDT (Generic Master Record: General Header)

CMDT table fields

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

CMDT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CMDT LOGSYSTEM CMDT LOGSYSTEM TBDLS Logical system LOGSYS
CMDT MANDT CMDT MANDT T000 Clients MANDT
CMDT OBJNR CMDT MANDT ONR00 General Object Number MANDT
CMDT OBJNR CMDT OBJNR ONR00 General Object Number OBJNR