CMDT_ADR SAP table for – Generic Master Record: Address

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

SAP CMDT_ADR table

Table CMDT_ADR technical data

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

SAP CMDT_ADR 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_ADR table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CMDT_KEY
  • NAME1 : Name 1
    Its data type is C (Character String) with field length 35
  • NAME2 : Name 2
    Its data type is C (Character String) with field length 35
  • NAME3 : Name 3
    Its data type is C (Character String) with field length 35
  • NAME4 : Name 4
    Its data type is C (Character String) with field length 35
  • ORT01
    Its data type is C (Character String) with field length 35
  • ORT02
    Its data type is C (Character String) with field length 35
  • STRAS
    Its data type is C (Character String) with field length 35
  • PFACH
    Its data type is C (Character String) with field length 10
  • PSTLZ : Postal Code
    Its data type is C (Character String) with field length 10
  • PSTL2
    Its data type is C (Character String) with field length 10
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • REGIO : Region (State, Province, County)
    Its data type is C (Character String) with field length 3
  • SPRAS : Language Key
    Its data type is C (Character String) with field length 1
  • TELBX
    Its data type is C (Character String) with field length 15
  • TELF1
    Its data type is C (Character String) with field length 16
  • TELF2
    Its data type is C (Character String) with field length 16
  • TELFX
    Its data type is C (Character String) with field length 31
  • TELTX
    Its data type is C (Character String) with field length 30
  • TELX1
    Its data type is C (Character String) with field length 30
  • DATLT
    Its data type is C (Character String) with field length 14
  • DRNAM
    Its data type is C (Character String) with field length 4
  • OBJNR : Object number
    Its a key field. Its data type is C (Character String) with field length 22
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • 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
  • LAND1 : Country Key
    Its data type is C (Character String) with field length 3
  • ANRED
    Its data type is C (Character String) with field length 15