SAP Table VADR3
Change Document Structure; Generated by RSSCD000
VADR3 (Change Document Structure; Generated by RSSCD000) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VADR3 to other SAP tables.
VADR3 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| ADDRNUMBER | Address number | AD_ADDRNUM | ADRC | CHAR | 10 | 0 | ||||||||||||
| PERSNUMBER | Person number | AD_PERSNUM | ADRP | CHAR | 10 | 0 | ||||||||||||
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | 0 | |||||||||||||
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC | 3 | 0 | |||||||||||||
| COUNTRY | Country for telephone/fax number | AD_COMCTRY | T005 | CHAR | 3 | 0 | ||||||||||||
| FLGDEFAULT | Standard Sender Address in this Communication Type | AD_FLGDFNR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | 0 | |||||||||||||
| FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | 0 | |||||||||||||
| FAXNR_LONG | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR | 30 | 0 | |||||||||||||
| FAXNR_CALL | Fax number for finding sender | AD_FAXNRCL | CHAR | 30 | 0 | |||||||||||||
| FAX_GROUP | Fax group (G3, G4, ...) | AD_FXGRP | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| DFT_RECEIV | Flag: Recipient is standard recipient for this number | AD_DFTRCNR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| R3_USER | Flag: Connected to an SAP System | AD_R3_USER | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR | 14 | 0 | |||||||||||||
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR | 14 | 0 | |||||||||||||
| KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||
VADR3 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VADR3 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| VADR3 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| VADR3 | ADDRNUMBER | VADR3 | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| VADR3 | ADDRNUMBER | VADR3 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| VADR3 | CLIENT | VADR3 | CLIENT | T000 | Clients | MANDT |
| VADR3 | COUNTRY | VADR3 | CLIENT | T005 | Countries | MANDT |
| VADR3 | COUNTRY | VADR3 | COUNTRY | T005 | Countries | LAND1 |
| VADR3 | PERSNUMBER | VADR3 | CLIENT | ADRP | Persons (Business Address Services) | CLIENT |
| VADR3 | PERSNUMBER | VADR3 | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| VADR3 | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
| VADR3 | PERSNUMBER | * | ADRP | Persons (Business Address Services) | NATION | |
