SADRP

Address Management: Personal Data | #masterdata | #language | Component: Address Management/Business Address
Column Name Description
MANDT FK Client
ADRNR Address
NATIO International address version ID
Column Name Description
Column Name Description
Column Name Description
CHDAT Addresses: Change date
CHTIM Addresses: Changed at
CRDAT Addresses: Creation date
CRTIM Addresses: Creation time
Column Name Description
USRTYPE Flag: Person is internal SAP user Show values
Column Name Description Domain name
ANRED Title TEXT15
ABTEI Addresses: Department TEXT30
COSTC Addresses: Cost center TEXT10
ROOMN Addresses: Room number TEXT6
BUILD Addresses: Building number TEXT6
NAME1 Name 1 NAME
NAME2 Name 2 NAME
STDCOM Addresses: Communication type COM_ART
CHNAM Addresses: Changed by USERNAME
CRNAM Addresses: Created by USERNAME
KLASSE Addresses: class assigned to an address KLASSE
DBNAME Addresses: System ID CHAR10
ANREK Addresses: Form of address key ANREK
SORT1 Sort field CHAR10
SORT2 Sort field CHAR20
FNAME A person's first name (Addresses) TEXT35
UCFNAME A person's first name in uppercase (Addresses) CHAR25
LNAME A person's last name (Addresses) TEXT35
UCLNAME A person's last name (Addresses) CHAR25
UCABTEI Department in Uppercase (Addresses) CHAR25
UCNAMECMPY Company Name in Uppercase (Addresses) CHAR25
Master Data Relations Join Conditions
Addresses: Address Number
  • International address version ID
  • Addresses: Address Number
  • Client
  • SADRP.NATIO == SADR.NATIO
  • SADRP.CMPYADR == SADR.ADRNR
  • SADRP.MANDT == SADR.MANDT
Client foreign key SADRP.MANDT == T000.MANDT
Address reference for alias names
  • ?
  • Client
  • Address reference for alias names
  • SADRP.[column in domain "INTER"] == SADRP.NATIO
  • SADRP.MANDT == SADRP.MANDT
  • SADRP.REFNR == SADRP.ADRNR
Foreign key to language key, Tab is not TEXT SADRP.SPRAS == T002.SPRAS