ADRCS2

Shadow Table 2: Addresses (Business Address Services) | #masterdata | #language | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
TABLENAME Application table logical name (address management)
FIELDNAME Application table address where-used list logical field name
OBJKEY Address owner object ID
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
Column Name Description
CHCKSTATUS City file test status Show values
PO_BOX_NUM Flag: PO Box Without Number Show values
FLAGGROUPS Flag: There are more address group assignments Show values
PERS_ADDR Flag: This is a personal address Show values
FLAGCOMM2 Flag: Telephone number(s) defined Show values
FLAGCOMM3 Flag: Fax number(s) defined Show values
FLAGCOMM4 Flag: Teletex number(s) defined Show values
FLAGCOMM5 Flag: Telex number(s) defined Show values
FLAGCOMM6 Flag: E-mail address(es) defined Show values
FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined Show values
FLAGCOMM8 Flag: X.400 addresse(s) defined Show values
FLAGCOMM9 Flag: RFC destination(s) defined Show values
FLAGCOMM10 Flag: Printer defined Show values
FLAGCOMM11 Flag: SSF defined Show values
FLAGCOMM12 Flag: URI/FTP address defined Show values
FLAGCOMM13 Flag: Pager address defined Show values
ADRC_ERR_STATUS Error Status of Address Show values
Column Name Description Domain name
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
NAME3 Name 3 TEXT40
NAME4 Name 4 TEXT40
NAME_TEXT Converted name field (with form of address) TEXT50
NAME_CO c/o name TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
HOME_CITY City (different from postal city) TEXT40
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR10
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR10
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
POSTALAREA (Not Supported) Post Delivery District TEXT15
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
HOUSE_NUM3 (Not supported) House Number Range TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
LOCATION Street 5 TEXT40
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR25
MC_CITY1 City name in Uppercase for Search Help CHAR25
MC_STREET Street Name in Uppercase for Search Help CHAR25
EXTENSION1 Extension (only for data conversion) (e.g. data line) TEXT40
EXTENSION2 Extension (only for data conversion) (e.g. telebox) TEXT40
TAXJURCODE Tax Jurisdiction AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID
LANGU_CREA Address record creation original language SPRAS
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR10
COUNTY_CODE County code for county CNTY_CODE
COUNTY County TEXT40
TOWNSHIP_CODE Township code for Township TWSHP_CODE
TOWNSHIP Township TEXT40
MC_COUNTY County name in upper case for search help CHAR25
MC_TOWNSHIP Township name in upper case for search help CHAR25
Master Data Relations Join Conditions
Source of address data
  • ADRCS2.CLIENT == TSAD6.CLIENT
  • ADRCS2.ADDRORIGIN == TSAD6.ORIGIN
Address group ADRCS2.ADDR_GROUP == TSAD7.ADDR_GROUP
Different city for city/street file
  • Country/Region Key
  • Client
  • Different city for city/street file
  • ADRCS2.COUNTRY == ADRCITY.COUNTRY
  • ADRCS2.CLIENT == ADRCITY.CLIENT
  • ADRCS2.CITYH_CODE == ADRCITY.CITY_CODE
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
City PO box code (City file)
  • ?
  • Client
  • City PO box code (City file)
  • ADRCS2.[column in domain "LAND1"] == ADRCITY.COUNTRY
  • ADRCS2.CLIENT == ADRCITY.CLIENT
  • ADRCS2.CITY_CODE2 == ADRCITY.CITY_CODE
Client containing the address ADRCS2.CLIENT == T000.MANDT
Country key
  • Country/Region Key
  • Client
  • ADRCS2.COUNTRY == T005.LAND1
  • ADRCS2.CLIENT == T005.MANDT
Communication Method ADRCS2.DEFLT_COMM == TSAC.COMM_TYPE
Non-Delivery Reason
  • ADRCS2.CLIENT == TSAD12.CLIENT
  • ADRCS2.DONT_USE_P == TSAD12.UNDELIVER
Non-Delivery Reason
  • ADRCS2.CLIENT == TSAD12.CLIENT
  • ADRCS2.DONT_USE_S == TSAD12.UNDELIVER
Language key ADRCS2.LANGU == T002.SPRAS
Version ID for International Addresses ADRCS2.NATION == TSADV.NATION
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • ADRCS2.PO_BOX_CTY == T005.LAND1
  • ADRCS2.CLIENT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • ADRCS2.CLIENT == T005S.MANDT
  • ADRCS2.PO_BOX_CTY == T005S.LAND1
  • ADRCS2.PO_BOX_REG == T005S.BLAND
Regional structure grouping
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • ADRCS2.CLIENT == T005S.MANDT
  • ADRCS2.COUNTRY == T005S.LAND1
  • ADRCS2.REGION == T005S.BLAND
(Not Supported) Abbreviation of Street Name
  • Country/Region Key
  • (Not Supported) Abbreviation of Street Name
Street Number for City/Street File
  • Country/Region Key
  • Street Number for City/Street File
Address time zone
  • ADRCS2.CLIENT == TTZZ.CLIENT
  • ADRCS2.TIME_ZONE == TTZZ.TZONE
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • ADRCS2.TITLE == TSAD3.TITLE
  • ADRCS2.CLIENT == TSAD3.CLIENT
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • ADRCS2.COUNTRY == TZONE.LAND1
  • ADRCS2.CLIENT == TZONE.MANDT
  • ADRCS2.TRANSPZONE == TZONE.ZONE1
Other Relations | to Master Data Relations ↑ Join Conditions
District code for City and Street file
  • Country/Region Key
  • City code for city/street file
  • District code for City and Street file