SADR

Address Management: Company Data | #masterdata | #language | Component: Address Management/Business Address
Column Name Description
MANDT FK Client
ADRNR Addresses: Address Number
NATIO International address version ID
Column Name Description
Column Name Description
Column Name Description
CRDAT Addresses: Creation date
CRTIM Addresses: Creation time
CHDAT Addresses: Change date
CHTIM Addresses: Changed at
Column Name Description
FLAG Checkbox Show values
FLAG2 Checkbox Show values
FLAG3 Checkbox Show values
FLAG4 Checkbox Show values
MAIAD Checkbox Show values
DUEFL Status of data transfer into subsequent release 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
PSTLZ Postal code PSTLZ
ORT01 City TEXT35
ORT02 District TEXT35
PSTL2 PO Box postal code PSTLZ
PFACH PO box PFACH
STRAS Street and House Number TEXT35
STRS2 Street and House Number TEXT35
HAUSN House number CHAR6
STOCK Floor STOCK
SORTL Sort field CHAR10
SORT2 Sort field CHAR20
PSTBZ Post delivery district PSTBZ
TELF1 Addresses: telephone no. TEXT30
TELFX Fax number TEXT31
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
MAILN Addresses: Document name DOC_NAM
STDKO Default communications service CHAR1
STDCOM Addresses: Communication type COM_ART
DBNAME Addresses: System ID CHAR10
KLASSE Addresses: class assigned to an address KLASSE
ANREK Addresses: Form of address key ANREK
CRNAM Addresses: Created by USERNAME
CHNAM Addresses: Changed by USERNAME
TXJCD Tax Jurisdiction AD_TXJCD
PFORT PO Box city TEXT40
COUNTY_CODE County code for county CNTY_CODE
COUNTY County TEXT40
TOWNSHIP_CODE Township code for Township TWSHP_CODE
TOWNSHIP Township TEXT40
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • SADR.LAND1 == T005.LAND1
  • SADR.MANDT == T005.MANDT
Delivery zone
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • SADR.LAND1 == TZONE.LAND1
  • SADR.MANDT == TZONE.MANDT
  • SADR.LZONE == TZONE.ZONE1
Address Management: Client Table Check SADR.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • SADR.MANDT == T005S.MANDT
  • SADR.LAND1 == T005S.LAND1
  • SADR.REGIO == T005S.BLAND
Language Key SADR.SPRAS == T002.SPRAS
Time zone
  • SADR.MANDT == TTZZ.CLIENT
  • SADR.TZONE == TTZZ.TZONE