/FLDQ/HNACLNSOUT

DQM for SAP output table for transactional cleanse TASK | #transactional | #language | Component: Data Quality Management for SAP
Column Name Description
CLIENT Client
ADDRNUMBER Address Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION 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
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 /FLDQ/STATUS_CODE
STATUS_CODE_PO Address Engine PO Status Code
INFO_CODE Address Information Code /FLDQ/AD_INFO_CODE
INFO_CODE_PO PO Address Information Code /FLDQ/AD_INFO_CODE
ASGMT_TYPE Address Assignment Type /FLDQ/AD_ADDR_ASGMT_TYPE
ASGMT_TYPE_PO PO Address Assignment Type /FLDQ/AD_ADDR_ASGMT_TYPE
ASGMT_LEVEL Assignment level
ASGMT_LEVEL_PO PO Assignment level
REPLY1 Suggestion list prompt string
REGION2_LONG region2 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
County code for county
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • County code for county
  • /FLDQ/HNACLNSOUT.PO_BOX_CTY == ADRCOUNTY.COUNTRY
  • /FLDQ/HNACLNSOUT.PO_BOX_REG == ADRCOUNTY.REGION
  • /FLDQ/HNACLNSOUT.CLIENT == ADRCOUNTY.CLIENT
  • /FLDQ/HNACLNSOUT.COUNTY_CODE == ADRCOUNTY.COUNTY_CODE
Type of Delivery Service
  • Type of Delivery Service
  • ?
Non-Delivery Reason
  • /FLDQ/HNACLNSOUT.CLIENT == TSAD12.CLIENT
  • /FLDQ/HNACLNSOUT.DONT_USE_P == TSAD12.UNDELIVER
Non-Delivery Reason
  • /FLDQ/HNACLNSOUT.CLIENT == TSAD12.CLIENT
  • /FLDQ/HNACLNSOUT.DONT_USE_S == TSAD12.UNDELIVER
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • /FLDQ/HNACLNSOUT.CLIENT == T005S.MANDT
  • /FLDQ/HNACLNSOUT.PO_BOX_CTY == T005S.LAND1
  • /FLDQ/HNACLNSOUT.PO_BOX_REG == T005S.BLAND
Region key
  • Country/Region Key
  • Region (State, Province, County)
  • /FLDQ/HNACLNSOUT.CLIENT == T005S.MANDT
  • /FLDQ/HNACLNSOUT.COUNTRY == T005S.LAND1
  • /FLDQ/HNACLNSOUT.REGION == T005S.BLAND
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