/FLDQ/HNADRCTOUT - Result Table for RSADRQU2 report

Result Table for RSADRQU2 report information is stored in SAP table /FLDQ/HNADRCTOUT.
It is part of development package /FLDQ/DQM_ON_HANA in software component EIM-DQM-SAP. This development package consists of objects that can be grouped under "Development Package for Data Quality on SAP HANA".

Fields for table /FLDQ/HNADRCTOUT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
ADDRNUMBERAddress NumberXAD_ADDRNUMCHAR20
NATIONVersion ID for International AddressesXAD_NATIONCHAR2
DATE_FROMValid-from date - in current Release only 00010101 possibleXAD_DATE_FRDATS16
DATE_TOValid-to date in current Release only 99991231 possibleXAD_DATE_TODATS16
STATUS_CODEAddress Engine Status Code/FLDQ/AD_STATUS_CODECHAR20
STATUS_CODE_POAddress Engine Status Code/FLDQ/AD_STATUS_CODECHAR20
INFO_CODEAddress Information Code/FLDQ/AD_INFO_CODECHAR8
INFO_CODE_POPO Address Information Code/FLDQ/AD_INFO_CODE_POCHAR8
COUNTRYbig field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
CITY1locality with increased size to stop truncation/FLDQ/AD_LOCALITY_BIGCHAR400
CITY2locality with increased size to stop truncation/FLDQ/AD_LOCALITY_BIGCHAR400
CITY_CODECity code for city/street fileAD_CITYNUMCHAR24
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCHAR16
HOME_CITYlocality with increased size to stop truncation/FLDQ/AD_LOCALITY_BIGCHAR400
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCHAR24
CHCKSTATUSCity file test statusAD_CHECKSTCHAR2
REGIOGROUPRegional structure groupingREGIOGROUPCHAR16
POST_CODE1big field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
POST_CODE2big field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
POST_CODE3Company Postal Code (for Large Customers)AD_PSTCD3CHAR20
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeAD_PST1XTCHAR20
PCODE2_EXT(Not Supported) PO Box Postal Code ExtensionAD_PST2XTCHAR20
PCODE3_EXT(Not Supported) Major Customer Postal Code ExtensionAD_PST3XTCHAR20
PO_BOXpo box with increased size to stop truncation/FLDQ/AD_PO_BOX_BIGCHAR200
PO_BOX_NUMFlag: PO Box Without NumberAD_POBXNUMCHAR2
PO_BOX_LOClocality with increased size to stop truncation/FLDQ/AD_LOCALITY_BIGCHAR400
CITY_CODE2City PO box code (City file)AD_CIT2NUMCHAR24
PO_BOX_REGbig field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
PO_BOX_REG2Region (State, Province, County)REGIOCHAR6
PO_BOX_CTYbig field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
TRANSPZONETransportation zone to or from which the goods are deliveredLZONECHAR20
STREETstreet with increased size to stop truncation/FLDQ/AD_STREET_BIGCHAR400
STREETCODEStreet Number for City/Street FileAD_STRNUMCHAR24
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRCHAR4
HOUSE_NUM1house num1 with increased size to stop truncation/FLDQ/AD_HOUSE_NUM1_BIGCHAR200
HOUSE_NUM2house num2 with increased size to stop truncation/FLDQ/AD_HOUSE_NUM2_BIGCHAR200
STR_SUPPL1street suppl with increased size to stop truncation/FLDQ/AD_STR_SUPPLCHAR500
STR_SUPPL2street suppl with increased size to stop truncation/FLDQ/AD_STR_SUPPLCHAR500
STR_SUPPL3street suppl with increased size to stop truncation/FLDQ/AD_STR_SUPPLCHAR500
LOCATIONlocation with increased size to stop truncation/FLDQ/AD_LOCCHAR400
BUILDINGbuilding with increased size to stop truncation/FLDQ/AD_BUILDING_BIGCHAR400
FLOORbig field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
ROOMNUMBERbig field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
LANGULanguage KeySPRASLANG2
REGIONbig field for output from GAC to stop truncation/FLDQ/AD_BIG_FIELD_100CHAR200
REGION2Region (State, Province, County)REGIOCHAR6
TIME_ZONEAddress time zoneAD_TZONECHAR12
TAXJURCODETax JurisdictionAD_TXJCDCHAR30
LANGU_CREAAddress record creation original languageAD_LANGUCRLANG2
NAME_COc/o nameAD_NAME_COCHAR80
DONT_USE_SStreet Address Undeliverable FlagAD_NO_USESCHAR8
DONT_USE_PPO Box Address Undeliverable FlagAD_NO_USEPCHAR8
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYCHAR80
DELI_SERV_TYPEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8
DELI_SERV_NUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
STOPGeneral FlagFLAGCHAR2
CHCKST_QUCity file check status after quarterly adjustmentAD_CHCKQUCHAR2
REGION2_LONGregion2 that is larger then bupa field for truncation/FLDQ/REGION2_BIGCHAR400
Privacy Policy