Model / CROSS / ADR3

CROSS — Cross-Application Foundation

ADR3

18 fields · 5 key · 4 foreign keys · sourced from leanx.eu

Fax Numbers (Business Address Services) — the per-communication-type child of ADRC holding fax numbers for a given ADDRNUMBER, sibling to ADR2 (telephone) and ADR6 (e-mail), pointed at by ADRC's FLAGCOMM3 flag. SAP's real ADR3 carries all its fields; this definition carries the table complete, as it is a small check/detail table.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
DML_NUM keydomicilium numerusAddress numberAD_ADDRNUMCHAR 10ADRC
PSN_NUM keypersona numerusPerson numberAD_PERSNUMCHAR 10ADRP
VLA_DIE_EMS keyvalidus ab dies emissioValid-from date - in current Release only 00010101 possibleAD_DATE_FRDATS 8
ORD_NUM keyordo numerusSequence NumberAD_CONSNUMNUMC 3
PTR_TEL_NUMpatria telephonum numerusCountry for telephone/fax numberAD_COMCTRYCHAR 3T005
NRM_DML_GENnorma domicilium genusStandard Sender Address in this Communication TypeAD_FLGDFNRCHAR 1
SGN_NUMsignum numerusFlag: This Communication Number is Not UsedAD_FLNOUSECHAR 1
DML_GENdomicilium genusRecipient address in this communication type (mail sys.grp)AD_FLGHOMECHAR 1
NUM_CODnumerus codexFax number: dialling code+numberAD_FXNMBRCHAR 30
FAX_EXTENSFax no.: ExtensionAD_FXXTNSCHAR 10
NUM_COD2numerus codexComplete number: dialling code+number+extensionAD_FXNRLNGCHAR 30
NUMnumerusFax number for finding senderAD_FAXNRCLCHAR 30
CTScoetusFax group (G3, G4, ...)AD_FXGRPCHAR 1
SGN_NRM_NUMsignum norma numerusFlag: Recipient is standard recipient for this numberAD_DFTRCNRCHAR 1
SGNsignumFlag: Connected to an SAP SystemAD_R3_USERCHAR 1
VLAvalidus abCommunication Data: Valid From (YYYYMMDDHHMMSS)AD_VALFROMCHAR 14
VLDvalidus adCommunication Data: Valid To (YYYYMMDDHHMMSS)AD_VALTOCHAR 14

Foreign keys

FieldCheck tableCheck field
CLIENTT000MANDT
ADDRNUMBERADRCADDRNUMBER
PERSNUMBERADRPPERSNUMBER
COUNTRYT005LAND1

View ADR3.yaml in the repository