CMDT_TEXT SAP table for – Generic Master Record: Texts

Here we would like to draw your attention to CMDT_TEXT 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_TEXT is a SAP standard transparent table used for storing Generic Master Record: Texts related data in SAP. It comes under the package KBAS.

SAP CMDT_TEXT table

Table CMDT_TEXT technical data

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

SAP CMDT_TEXT 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_TEXT table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CMDT_KEY_TXT
  • CSTDRV
    Its data type is C (Character String) with field length 40
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SPRAS : Language Key
    Its a key field. Its data type is C (Character String) with field length 1
  • 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
  • KTEXT
    Its data type is C (Character String) with field length 20
  • LTEXT
    Its data type is C (Character String) with field length 40