VADRC SAP (Change Document Structure; Generated by RSSCD000) Structure details

Dictionary Type: Structure
Description: Change Document Structure; Generated by RSSCD000




ABAP Code to SELECT data from VADRC
Related tables to VADRC
Access table VADRC




Structure field list including key, data, relationships and ABAP select examples

VADRC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Document Structure; Generated by RSSCD000" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VADRC TYPE VADRC.

The VADRC table consists of various fields, each holding specific information or linking keys about Change Document Structure; Generated by RSSCD000 data available in SAP. These include CLIENT (Client), ADDRNUMBER (Address number), DATE_FROM (Valid-from date - in current Release only 00010101 possible), NATION (Version ID for International Addresses).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VADRC structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
ADDRNUMBERAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
NATIONVersion ID for International Addresses AD_NATIONCHAR1TSADVAD_NATIONADDRESS_NATION
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
TITLEForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_TEXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ADRCITYALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ADRCITYPRTALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ADRCITYALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4TSAD12AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ADRCITYALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3T005SREGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3T005LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4TSAD12AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ADRSTREETALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
LANGULanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
ADDR_GROUPAddress Group (Key) (Business Address Services) AD_GROUPCHAR4TSAD7AD_GROUP
FLAGGROUPSFlag: There are more address group assignments AD_FLGGPCHAR1XFELD
PERS_ADDRFlag: This is a personal address AD_PRSADDRCHAR1XFELD
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
DEFLT_COMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL_EXTENSFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
FLAGCOMM2Flag: Telephone number(s) maintained AD_FLGCM02CHAR1XFELD
FLAGCOMM3Flag: Fax number(s) maintained AD_FLGCM03CHAR1XFELD
FLAGCOMM4Flag: Teletex number(s) maintained AD_FLGCM04CHAR1XFELD
FLAGCOMM5Flag: Telex number(s) maintained AD_FLGCM05CHAR1XFELD
FLAGCOMM6Indicator: E-Mail Address(es) Maintained AD_FLGCM06CHAR1XFELD
FLAGCOMM7Flag: RML (remote mail) addresse(s) maintained AD_FLGCM07CHAR1XFELD
FLAGCOMM8Flag: X.400 addresse(s) maintained AD_FLGCM08CHAR1XFELD
FLAGCOMM9Flag: RFC destination(s) maintained AD_FLGCM09CHAR1XFELD
FLAGCOMM10Flag: Printer maintained AD_FLGCM10CHAR1XFELD
FLAGCOMM11Flag: SSF maintained AD_FLGCM11CHAR1XFELD
FLAGCOMM12Flag: URI/FTP address maintained AD_FLGCM12CHAR1XFELD
FLAGCOMM13Flag: Pager address maintained AD_FLGCM13CHAR1XFELD
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4TSAD6AD_ORIGIN
MC_NAME1Name (field NAME1) in upper case for matchcode AD_MC_NAMECHAR25CHAR25
MC_CITY1City name in upper case for search help AD_MC_CITYCHAR25CHAR25
MC_STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1Assigned to domainISOLASPRAS
ADRC_UUIDUUID Used in the Address AD_UUIDRAW16SYSUUID
UUID_BELATEDIndicator: UUID was generated later AD_UUID_BELATEDCHAR1AD_UUID_BELATED
ID_CATEGORYCategory of an Address ID AD_ID_CATEGORYCHAR1AD_ID_CATEGORY
ADRC_ERR_STATUSError Status of Address AD_ERR_STATUSCHAR1AD_ERR_STATUS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4ADDRC_DELI_SERVAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
MC_COUNTYCounty name in upper case for search help AD_MC_COUNTYCHAR25CHAR25
MC_TOWNSHIPTownship name in upper case for search help AD_MC_TWSHPCHAR25CHAR25
.INCLU--AP 0
DUNSDun & Bradstreet number (DUNS) /SAPHT/RN_DUNSCHAR9CHAR9
DUNSP4DUNS+4 number (the last four digit) /SAPHT/RN_DUNSP4CHAR4CHAR4
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

Key field Non-key field



How do I retrieve data from SAP structure VADRC using ABAP code?

As VADRC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VADRC as there is no data to select.

How to access SAP table VADRC

Within an ECC or HANA version of SAP you can also view further information about VADRC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!