CMDT SAP table for – Generic Master Record: General Header

Here we would like to draw your attention to CMDT table in SAP. As we know it is being mainly used with the SAP CO-OM (Overhead Cost Controlling in CO) component which is coming under CO module (Controlling). CMDT is a SAP standard transparent table used for storing Generic Master Record: General Header related data in SAP. It comes under the package KBAS.

SAP CMDT table

Table CMDT technical data

TableCMDT
Data storingGeneric Master Record: General Header
ModuleCO
ComponentCO-OM
SAP PackageKBAS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CMDT Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in CMDT table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CMDT_KEY_TOP
  • ERSDA : Created On
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USNAM : User name
    Its data type is C (Character String) with field length 12
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • OBJNR : Object number
    Its a key field. Its data type is C (Character String) with field length 22
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • STATUS : AC: Context Status
    Its a key field. Its data type is C (Character String) with field length 1
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LOGSYSTEM
    Its data type is C (Character String) with field length 10