CMDT_ADR

Generic Master Record: Address | #masterdata | #language | Component: Overhead Cost Controlling
Column Name Description
MANDT FK Client
OBJNR FK Object number
DATBI Valid To Date
STATUS Activation Status of Generic Master Record Show values
Column Name Description
Column Name Description
Column Name Description
DATBI Valid To Date
DATAB Valid-From Date
Column Name Description
STATUS Activation Status of Generic Master Record Show values
Column Name Description Domain name
ANRED Title TEXT15
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
ORT01 City TEXT35
ORT02 District TEXT35
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
PSTLZ Postal Code PSTLZ
PSTL2 P.O. Box Postal Code PSTLZ
TELBX Telebox number TEXT15
TELF1 First telephone number TEXT16
TELF2 Second telephone number TEXT16
TELFX Fax Number TEXT31
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
DATLT Data communication line no. TEXT14
DRNAM Printer Destination for CCtr Report DRNAM
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • CMDT_ADR.LAND1 == T005.LAND1
  • CMDT_ADR.MANDT == T005.MANDT
Client CMDT_ADR.MANDT == T000.MANDT
Object number
  • Valid To Date
  • Activation Status of Generic Master Record
  • Object number
  • CMDT_ADR.DATBI == CMDT.OBJNR
  • CMDT_ADR.STATUS == CMDT.DATBI
  • CMDT_ADR.OBJNR == CMDT.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • CMDT_ADR.MANDT == T005S.MANDT
  • CMDT_ADR.LAND1 == T005S.LAND1
  • CMDT_ADR.REGIO == T005S.BLAND
Language Key CMDT_ADR.SPRAS == T002.SPRAS
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • CMDT_ADR.MANDT == TTXJ.MANDT
  • CMDT_ADR.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • CMDT_ADR.TXJCD == TTXJ.TXJCD