ADR3S

Shadow table: Fax 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 Standard Sender Address in this Communication Type 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
FAX_GROUP Fax group (G3, G4, ...) Show values
DFT_RECEIV Flag: Recipient is standard recipient for this number Show values
R3_USER Flag: Connected to an SAP System Show values
Column Name Description Domain name
FAX_NUMBER Fax number: dialling code+number CHAR30
FAX_EXTENS Fax no.: Extension CHAR10
FAXNR_LONG Complete number: dialling code+number+extension CHAR30
FAXNR_CALL Fax number for finding sender CHAR30
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
  • ?
  • ?
  • ADR3S.CLIENT == ADRC.CLIENT
  • ADR3S.ADDRNUMBER == ADRC.ADDRNUMBER
  • ADR3S.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADR3S.[column in domain "AD_NATION"] == ADRC.NATION
Client ADR3S.CLIENT == T000.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Client
  • ADR3S.COUNTRY == T005.LAND1
  • ADR3S.CLIENT == T005.MANDT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • ADR3S.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ADR3S.[column in domain "AD_NATION"] == ADRP.NATION
  • ADR3S.CLIENT == ADRP.CLIENT
  • ADR3S.PERSNUMBER == ADRP.PERSNUMBER