SAP table ADR3 (Fax Numbers (Business Address Services))

SAP table ADR3 has 5 primary key fields being CLIENT,ADDRNUMBER,PERSNUMBER,DATE_FROM,CONSNUMBER.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
ADDRNUMBER Address Number CHAR 10 0 ADRC AD_ADDRNUM
PERSNUMBER Person Number CHAR 10 0 ADRP AD_PERSNUM
DATE_FROM Valid-from date - in current Release only 00010101 possible DATS 8 0 AD_DATE_FR
CONSNUMBER Sequence Number NUMC 3 0 AD_CONSNUM
COUNTRY Country/Region for Telephone/Fax Number CHAR 3 0 T005 AD_COMCTRY
FLGDEFAULT Standard Sender Address in this Communication Type CHAR 1 0 AD_FLGDFNR
FLG_NOUSE Flag: This Communication Number is Not Used CHAR 1 0 AD_FLNOUSE
HOME_FLAG Recipient address in this communication type (mail sys.grp) CHAR 1 0 AD_FLGHOME
FAX_NUMBER Fax number: dialling code+number CHAR 30 0 AD_FXNMBR
FAX_EXTENS Fax no.: Extension CHAR 10 0 AD_FXXTNS
FAXNR_LONG Complete number: dialling code+number+extension CHAR 30 0 AD_FXNRLNG
FAXNR_CALL Fax number for finding sender CHAR 30 0 AD_FAXNRCL
FAX_GROUP Fax group (G3, G4, ...) CHAR 1 0 AD_FXGRP
3 G3
4 G4
DFT_RECEIV Flag: Recipient is standard recipient for this number CHAR 1 0 AD_DFTRCNR
R3_USER Flag: Connected to an SAP System CHAR 1 0 AD_R3_USER
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) CHAR 14 0 AD_VALFROM
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) CHAR 14 0 AD_VALTO
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

ADR3 foreign key relationships

Table Field Check Table Check Field
0 ADR3 ADDRNUMBER ADRC Addresses (Business Address Services) DATE_FROM
0 ADR3 ADDRNUMBER ADRC Addresses (Business Address Services) NATION
1 ADR3 CLIENT T000 Clients MANDT
0 ADR3 COUNTRY T005 Countries MANDT
0 ADR3 COUNTRY T005 Countries LAND1
1 ADR3 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
1 ADR3 PERSNUMBER ADRP Persons (Business Address Services) DATE_FROM
1 ADR3 PERSNUMBER ADRP Persons (Business Address Services) NATION