SAP ABAP Table ADR8 (X.400 Numbers (Business Address Services))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
⤷ SZAD (Package) SAP Technology - Business Services: Address Management
⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
⤷ SZAD (Package) SAP Technology - Business Services: Address Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ADR8 | Table Relationship Diagram |
Short Description | X.400 Numbers (Business Address Services) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ADDRNUMBER | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
3 | PERSNUMBER | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | ADRP | |
4 | DATE_FROM | AD_DATE_FR | DATUM | DATS | 8 | 0 | Valid-from date - in current Release only 00010101 possible | ||
5 | CONSNUMBER | AD_CONSNUM | NUMC3 | NUMC | 3 | 0 | Sequence Number | ||
6 | FLGDEFAULT | AD_FLGDFAD | XFELD | CHAR | 1 | 0 | Flag: this address is the default address | ||
7 | FLG_NOUSE | AD_FLNOUSE | XFELD | CHAR | 1 | 0 | Flag: This Communication Number is Not Used | ||
8 | HOME_FLAG | AD_FLGHOME | XFELD | CHAR | 1 | 0 | Recipient address in this communication type (mail sys.grp) | ||
9 | DFT_RECEIV | AD_DFTRCAD | XFELD | CHAR | 1 | 0 | Flag: Recipient is standard recipient for this address | ||
10 | R3_USER | AD_R3_USER | XFELD | CHAR | 1 | 0 | Flag: Connected to an SAP System | ||
11 | TXT_ENCODE | AD_TENCODE | AD_TENCODE | CHAR | 1 | 0 | Desired text data coding (X.400) | ||
12 | TNEF | AD_TNEF8 | XFELD | CHAR | 1 | 0 | Flag: Receiver can receive TNEF coding via X.400 | ||
13 | X4COUNTRY | AD_X4CNTRY | LAND1 | CHAR | 3 | 0 | X.400 country code | * | |
14 | X4ADMIN | AD_X4ADMIN | CHAR16 | CHAR | 16 | 0 | X.400 administration domain | ||
15 | X4PRIVD | AD_X4PRIVD | CHAR16 | CHAR | 16 | 0 | X.400 private domain | ||
16 | X4ORG | AD_X4ORG | CHAR64 | CHAR | 64 | 0 | X.400 organization | ||
17 | X4ORG1 | AD_X4ORG1 | CHAR32 | CHAR | 32 | 0 | X.400 organizational unit 1 | ||
18 | X4ORG2 | AD_X4ORG2 | CHAR32 | CHAR | 32 | 0 | X.400 organizational unit 2 | ||
19 | X4ORG3 | AD_X4ORG3 | CHAR32 | CHAR | 32 | 0 | X.400 organizational unit 3 | ||
20 | X4ORG4 | AD_X4ORG4 | CHAR32 | CHAR | 32 | 0 | X.400 organizational unit 4 | ||
21 | X4LNAME | AD_X4LNAME | CHAR40 | CHAR | 40 | 0 | X.400 last name | ||
22 | X4FNAME | AD_X4FNAME | CHAR16 | CHAR | 16 | 0 | X.400 first name | ||
23 | X4INI | AD_X4INI | CHAR5 | CHAR | 5 | 0 | X.400 Initials | ||
24 | X4GENER | AD_X4GENER | CHAR3 | CHAR | 3 | 0 | X.400 generation | ||
25 | X4X121 | AD_X4X121 | CHAR15 | CHAR | 15 | 0 | X.400 X.121 network address | ||
26 | X4TERMID | AD_X4TRMID | CHAR24 | CHAR | 24 | 0 | X.400 Terminal ID | ||
27 | X4TERMTP | AD_X4TRMTP | CHAR1 | CHAR | 1 | 0 | X.400 terminal type | ||
28 | X4UANUMID | AD_X4UANID | CHAR32 | CHAR | 32 | 0 | X.400 user agent numeric ID | ||
29 | DDA_TYPE1 | AD_X4DDAT1 | TEXT8 | CHAR | 8 | 0 | X.400 domain defined attribute, type 1 | ||
30 | DDA_VALUE1 | AD_X4DDAV1 | TEXT128 | CHAR | 128 | 0 | X.400 domain defined attribute, value 1 | ||
31 | DDA_TYPE2 | AD_X4DDAT2 | TEXT8 | CHAR | 8 | 0 | X.400 domain defined attribute, type 2 | ||
32 | DDA_VALUE2 | AD_X4DDAV2 | TEXT128 | CHAR | 128 | 0 | X.400 domain defined attribute, value 2 | ||
33 | DDA_TYPE3 | AD_X4DDAT3 | TEXT8 | CHAR | 8 | 0 | X.400 domain defined attribute, type 3 | ||
34 | DDA_VALUE3 | AD_X4DDAV3 | TEXT128 | CHAR | 128 | 0 | X.400 domain defined attribute, value 3 | ||
35 | DDA_TYPE4 | AD_X4DDAT4 | TEXT8 | CHAR | 8 | 0 | X.400 domain defined attribute, type 4 | ||
36 | DDA_VALUE4 | AD_X4DDAV4 | TEXT128 | CHAR | 128 | 0 | X.400 domain defined attribute, value 4 | ||
37 | VALID_FROM | AD_VALFROM | TIMESTMP | CHAR | 14 | 0 | Communication Data: Valid From (YYYYMMDDHHMMSS) | ||
38 | VALID_TO | AD_VALTO | TIMESTAMP | CHAR | 14 | 0 | Communication Data: Valid To (YYYYMMDDHHMMSS) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ADR8 | ADDRNUMBER | ADRC | ADDRNUMBER | REF | C | CN |
2 | ADR8 | CLIENT | T000 | MANDT | KEY | 1 | CN |
3 | ADR8 | PERSNUMBER | ADRP | PERSNUMBER | REF | C | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |