SIMDQ_TRCLNS_IN

IM in HANA input table for transactional cleanse TASK | #transactional | #language | Component: Data Quality Management API
Column Name Description
CLIENT Client
ADDRNUMBER Address Number
DATE_FROM null
NATION Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM null
Column Name Description
CHCKSTATUS City file test status Show values
PO_BOX_NUM Flag: PO Box Without Number Show values
Column Name Description Domain name
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 TEXT20
SORT2 Search Term 2 TEXT20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
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
REMARK Address notes TEXT50
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_NUMBER Number of Delivery Service CHAR10
COUNTY County TEXT40
TOWNSHIP Township TEXT40
STATUS_CODE Address Engine Status Code
STATUS_CODE_PO Address Engine Status Code
INFO_CODE Address Information Code
INFO_CODE_PO Address Information Code
ASGMT_TYPE Address Assignment Type
ASGMT_TYPE_PO Address Assignment Type
ASGMT_LEVEL Assignment Level
ASGMT_LEVEL_PO Assignment Level
REPLY1 Suggestion list prompt string
REGION2_LONG Region Long Name
REGION2 Region (State, Province, County) REGIO
PO_BOX_REG2 Region (State, Province, County) REGIO
SUGG_ERROR null
SUGG_STATUS null
ASGMT_INFO null
ASGMT_INFO_PO null
Master Data Relations Join Conditions
Address Source
  • SIMDQ_TRCLNS_IN.CLIENT == TSAD6.CLIENT
  • SIMDQ_TRCLNS_IN.ADDRORIGIN == TSAD6.ORIGIN
Different city for city/street file
  • Country/Region Key
  • Client
  • Different city for city/street file
  • SIMDQ_TRCLNS_IN.COUNTRY == ADRCITY.COUNTRY
  • SIMDQ_TRCLNS_IN.CLIENT == ADRCITY.CLIENT
  • SIMDQ_TRCLNS_IN.CITYH_CODE == ADRCITY.CITY_CODE
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • SIMDQ_TRCLNS_IN.COUNTRY == ADRCITY.COUNTRY
  • SIMDQ_TRCLNS_IN.CLIENT == ADRCITY.CLIENT
  • SIMDQ_TRCLNS_IN.CITY_CODE == ADRCITY.CITY_CODE
City PO box code (City file)
  • Country/Region Key
  • Client
  • City PO box code (City file)
  • SIMDQ_TRCLNS_IN.COUNTRY == ADRCITY.COUNTRY
  • SIMDQ_TRCLNS_IN.CLIENT == ADRCITY.CLIENT
  • SIMDQ_TRCLNS_IN.CITY_CODE2 == ADRCITY.CITY_CODE
Country Indicator
  • Country/Region Key
  • Client
  • SIMDQ_TRCLNS_IN.COUNTRY == T005.LAND1
  • SIMDQ_TRCLNS_IN.CLIENT == T005.MANDT
County code for county
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • County code for county
  • SIMDQ_TRCLNS_IN.PO_BOX_CTY == ADRCOUNTY.COUNTRY
  • SIMDQ_TRCLNS_IN.PO_BOX_REG == ADRCOUNTY.REGION
  • SIMDQ_TRCLNS_IN.CLIENT == ADRCOUNTY.CLIENT
  • SIMDQ_TRCLNS_IN.COUNTY_CODE == ADRCOUNTY.COUNTY_CODE
Type of Delivery Service
  • Type of Delivery Service
  • ?
Non-Delivery Reason
  • SIMDQ_TRCLNS_IN.CLIENT == TSAD12.CLIENT
  • SIMDQ_TRCLNS_IN.DONT_USE_P == TSAD12.UNDELIVER
Non-Delivery Reason
  • SIMDQ_TRCLNS_IN.CLIENT == TSAD12.CLIENT
  • SIMDQ_TRCLNS_IN.DONT_USE_S == TSAD12.UNDELIVER
Language Key SIMDQ_TRCLNS_IN.LANGU == T002.SPRAS
Address record creation original language SIMDQ_TRCLNS_IN.LANGU_CREA == T002.SPRAS
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • SIMDQ_TRCLNS_IN.PO_BOX_CTY == T005.LAND1
  • SIMDQ_TRCLNS_IN.CLIENT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • SIMDQ_TRCLNS_IN.CLIENT == T005S.MANDT
  • SIMDQ_TRCLNS_IN.PO_BOX_CTY == T005S.LAND1
  • SIMDQ_TRCLNS_IN.PO_BOX_REG == T005S.BLAND
Regional structure grouping
  • SIMDQ_TRCLNS_IN.CLIENT == ADRREGGRP.CLIENT
  • SIMDQ_TRCLNS_IN.REGIOGROUP == ADRREGGRP.REGIOGROUP
Region Key
  • Country/Region Key
  • Region (State, Province, County)
  • SIMDQ_TRCLNS_IN.CLIENT == T005S.MANDT
  • SIMDQ_TRCLNS_IN.COUNTRY == T005S.LAND1
  • SIMDQ_TRCLNS_IN.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
  • SIMDQ_TRCLNS_IN.CLIENT == ADRSTREET.CLIENT
  • SIMDQ_TRCLNS_IN.COUNTRY == ADRSTREET.COUNTRY
  • SIMDQ_TRCLNS_IN.STREETCODE == ADRSTREET.STRT_CODE
Address time zone
  • SIMDQ_TRCLNS_IN.CLIENT == TTZZ.CLIENT
  • SIMDQ_TRCLNS_IN.TIME_ZONE == TTZZ.TZONE
Township code for Township
  • Region for PO Box (Country/Region, State, Province, ...)
  • County code for county
  • PO Box of Country/Region
  • Township code for Township
Transportation Zone
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • SIMDQ_TRCLNS_IN.COUNTRY == TZONE.LAND1
  • SIMDQ_TRCLNS_IN.CLIENT == TZONE.MANDT
  • SIMDQ_TRCLNS_IN.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