SAP ADRCS2 (Shadow Table 2: Addresses (Business Address Services)) Table & Fields

ADRCS2 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ADRCS2.
  • Table description : Shadow Table 2: Addresses (Business Address Services)
  • Module : BC-SRV-ADR
  • Parent Module : BC
  • Package : SZAD
  • Software Component : SAP_BASIS

ADRCS2 hierarchy

SAP_BASISBCBC-SRV-ADRADRCS2

ADRCS2 Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
TABLENAMEApplication table logical name (address management)AD_APPLTABCHAR10
FIELDNAMEApplication table address where-used list logical field nameAD_APPLFLDCHAR10
OBJKEYAddress owner object IDAD_OBJKEYSWO_TYPEID
DATE_FROMValid-from date - in current Release only 00010101 possibleAD_DATE_FRDATUM
NATIONVersion ID for International AddressesAD_NATIONAD_NATION
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATUM
TITLEForm-of-Address KeyAD_TITLEAD_TITLE
NAME1Name 1AD_NAME1TEXT40
NAME2Name 2AD_NAME2TEXT40
NAME3Name 3AD_NAME3TEXT40
NAME4Name 4AD_NAME4TEXT40
NAME_TEXTConverted name field (with form of address)AD_NAMETXTTEXT50
NAME_COc/o nameAD_NAME_COTEXT40
CITY1CityAD_CITY1TEXT40
CITY2DistrictAD_CITY2TEXT40
CITY_CODECity code for city/street fileAD_CITYNUMCITY_CODE
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCITYP_CODE
HOME_CITYCity (different from postal city)AD_CITY3TEXT40
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCITY_CODE
CHCKSTATUSCity file test statusAD_CHECKSTAD_CHECKST
REGIOGROUPRegional structure groupingREGIOGROUPREGIOGROUP
POST_CODE1City postal codeAD_PSTCD1CHAR10
POST_CODE2PO Box postal codeAD_PSTCD2CHAR10
POST_CODE3Company postal code (for large customers)AD_PSTCD3CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeAD_PST1XTCHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code ExtensionAD_PST2XTCHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code ExtensionAD_PST3XTCHAR10
PO_BOXPO BoxAD_POBXCHAR10
DONT_USE_PPO Box Address Undeliverable FlagAD_NO_USEPAD_NO_USE
PO_BOX_NUMFlag: PO Box without numberAD_POBXNUMXFELD
PO_BOX_LOCPO Box cityAD_POBXLOCTEXT40
CITY_CODE2City PO box code (City file)AD_CIT2NUMCITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...)AD_POBXREGREGIO
PO_BOX_CTYPO box countryAD_POBXCTYLAND1
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARTEXT15
TRANSPZONETransportation zone to or from which the goods are deliveredLZONEZONE
STREETStreetAD_STREETTEXT60
DONT_USE_SStreet Address Undeliverable FlagAD_NO_USESAD_NO_USE
STREETCODEStreet Number for City/Street FileAD_STRNUMSTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRSTRTYPEAB
HOUSE_NUM1House NumberAD_HSNM1TEXT10
HOUSE_NUM2House number supplementAD_HSNM2TEXT10
HOUSE_NUM3(Not supported) House Number RangeAD_HSNM3TEXT10
STR_SUPPL1Street 2AD_STRSPP1TEXT40
STR_SUPPL2Street 3AD_STRSPP2TEXT40
STR_SUPPL3Street 4AD_STRSPP3TEXT40
LOCATIONStreet 5AD_LCTNTEXT40
BUILDINGBuilding (Number or Code)AD_BLDNGTEXT20
FLOORFloor in buildingAD_FLOORTEXT10
ROOMNUMBERRoom or Appartment NumberAD_ROOMNUMTEXT10
COUNTRYCountry KeyLAND1LAND1
LANGULanguage KeySPRASSPRAS
REGIONRegion (State, Province, County)REGIOREGIO
ADDR_GROUPAddress Group (Key) (Business Address Services)AD_GROUPAD_GROUP
FLAGGROUPSFlag: There are more address group assignmentsAD_FLGGPXFELD
PERS_ADDRFlag: This is a personal addressAD_PRSADDRXFELD
SORT1Search Term 1AD_SORT1CHAR20
SORT2Search Term 2AD_SORT2CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR20
DEFLT_COMMCommunication Method (Key) (Business Address Services)AD_COMMAD_COMM
TEL_NUMBERFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR30
TEL_EXTENSFirst Telephone No.: ExtensionAD_TLXTNS1CHAR10
FAX_NUMBERFirst fax no.: dialling code+numberAD_FXNMBR1CHAR30
FAX_EXTENSFirst fax no.: extensionAD_FXXTNS1CHAR10
FLAGCOMM2Flag: Telephone number(s) maintainedAD_FLGCM02XFELD
FLAGCOMM3Flag: Fax number(s) maintainedAD_FLGCM03XFELD
FLAGCOMM4Flag: Teletex number(s) maintainedAD_FLGCM04XFELD
FLAGCOMM5Flag: Telex number(s) maintainedAD_FLGCM05XFELD
FLAGCOMM6Indicator: E-Mail Address(es) MaintainedAD_FLGCM06XFELD
FLAGCOMM7Flag: RML (remote mail) addresse(s) maintainedAD_FLGCM07XFELD
FLAGCOMM8Flag: X.400 addresse(s) maintainedAD_FLGCM08XFELD
FLAGCOMM9Flag: RFC destination(s) maintainedAD_FLGCM09XFELD
FLAGCOMM10Flag: Printer maintainedAD_FLGCM10XFELD
FLAGCOMM11Flag: SSF maintainedAD_FLGCM11XFELD
FLAGCOMM12Flag: URI/FTP address maintainedAD_FLGCM12XFELD
FLAGCOMM13Flag: Pager address maintainedAD_FLGCM13XFELD
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINAAD_ORIGIN
MC_NAME1Name (field NAME1) in upper case for matchcodeAD_MC_NAMECHAR25
MC_CITY1City name in upper case for search helpAD_MC_CITYCHAR25
MC_STREETStreet name in upper case for search helpAD_MC_STRTCHAR25
EXTENSION1Extension (only for data conversion) (e.g. data line)AD_EXTENS1TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox)AD_EXTENS2TEXT40
TIME_ZONEAddress time zoneAD_TZONETZNZONE
TAXJURCODETax JurisdictionAD_TXJCDAD_TXJCD
ADDRESS_ID(Not supported) Physical address IDAD_ADDR_IDAD_ADDR_ID
LANGU_CREAAddress record creation original languageAD_LANGUCRSPRAS
ADRC_ERR_STATUSError Status of AddressAD_ERR_STATUSAD_ERR_STATUS
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYTEXT40
DELI_SERV_TYPEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPEAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR10
COUNTY_CODECounty code for countyAD_CNTYNUMCNTY_CODE
COUNTYCountyAD_COUNTYTEXT40
TOWNSHIP_CODETownship code for TownshipAD_TWSHPNUMTWSHP_CODE
TOWNSHIPTownshipAD_TOWNSHIPTEXT40
MC_COUNTYCounty name in upper case for search helpAD_MC_COUNTYCHAR25
MC_TOWNSHIPTownship name in upper case for search helpAD_MC_TWSHPCHAR25