ADR8S

Shadow Table: X.400 Numbers (Business Address Services) | #masterdata | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
TRKORR Request/Task
ADDRNUMBER FK Address Number
PERSNUMBER FK Person Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
CONSNUMBER Sequence Number
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
Column Name Description
FLGDEFAULT Flag: this address is the default address Show values
FLG_NOUSE Flag: This Communication Number is Not Used Show values
HOME_FLAG Recipient address in this communication type (mail sys.grp) Show values
DFT_RECEIV Flag: Recipient is standard recipient for this address Show values
R3_USER Flag: Connected to an SAP System Show values
TXT_ENCODE Required Text Data Encoding (X.400) Show values
TNEF Flag: Receiver can receive TNEF encoding by X.400 Show values
Column Name Description Domain name
X4COUNTRY X.400 Country / Region Key LAND1
X4ADMIN X.400 administration domain CHAR16
X4PRIVD X.400 private domain CHAR16
X4ORG X.400 organization CHAR64
X4ORG1 X.400 organizational unit 1 CHAR32
X4ORG2 X.400 organizational unit 2 CHAR32
X4ORG3 X.400 organizational unit 3 CHAR32
X4ORG4 X.400 organizational unit 4 CHAR32
X4LNAME X.400 last name CHAR40
X4FNAME X.400 first name CHAR16
X4INI X.400 Initials CHAR5
X4GENER X.400 generation CHAR3
X4X121 X.400 X.121 network address CHAR15
X4TERMID X.400 Terminal ID CHAR24
X4TERMTP X.400 terminal type CHAR1
X4UANUMID X.400 user agent numeric ID CHAR32
DDA_TYPE1 X.400 domain defined attribute, type 1 TEXT8
DDA_VALUE1 X.400 domain defined attribute, value 1 TEXT128
DDA_TYPE2 X.400 domain defined attribute, type 2 TEXT8
DDA_VALUE2 X.400 domain defined attribute, value 2 TEXT128
DDA_TYPE3 X.400 domain defined attribute, type 3 TEXT8
DDA_VALUE3 X.400 domain defined attribute, value 3 TEXT128
DDA_TYPE4 X.400 domain defined attribute, type 4 TEXT8
DDA_VALUE4 X.400 domain defined attribute, value 4 TEXT128
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) TIMESTMP
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) TIMESTAMP
Master Data Relations Join Conditions
Address number
  • Address Number
  • ?
  • ?
  • ADR8S.CLIENT == ADRC.CLIENT
  • ADR8S.ADDRNUMBER == ADRC.ADDRNUMBER
  • ADR8S.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADR8S.[column in domain "AD_NATION"] == ADRC.NATION
Client ADR8S.CLIENT == T000.MANDT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • ADR8S.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ADR8S.[column in domain "AD_NATION"] == ADRP.NATION
  • ADR8S.CLIENT == ADRP.CLIENT
  • ADR8S.PERSNUMBER == ADRP.PERSNUMBER