/FLDQ/HNA_PREQU2 - staging table for RSADRQU2 report
staging table for RSADRQU2 report information is stored in SAP table /FLDQ/HNA_PREQU2.
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".
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/HNA_PREQU2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| RECORD_ID | Parameter ID for Editing object | X | /FLDQ/AD_OBJ_KEY_PID | CHAR | 40 | |
| STATUS_CODE | Address Engine Status Code | /FLDQ/AD_STATUS_CODE | CHAR | 20 | ||
| STATUS_CODE_PO | Address Engine Status Code | /FLDQ/AD_STATUS_CODE | CHAR | 20 | ||
| INFO_CODE | Address Information Code | /FLDQ/AD_INFO_CODE | CHAR | 8 | ||
| INFO_CODE_PO | PO Address Information Code | /FLDQ/AD_INFO_CODE_PO | CHAR | 8 | ||
| ERROR_CODE | Error codes | /FLDQ/AD_ERR_CODE | CHAR | 8 | ||
| ERROR_CODE_PO | Error codes | /FLDQ/AD_ERR_CODE | CHAR | 8 | ||
| COUNTRY | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 20 | ||
| PERSNUMBER | Person Number | AD_PERSNUM | CHAR | 20 | ||
| NATION | Version ID for International Addresses | AD_NATION | CHAR | 2 | ||
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 16 | ||
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 16 | ||
| PACKAGE_NO | Package number for reading quarterly adjustment data | AD_PCKGNO1 | NUMC | 20 | ||
| CITY1 | locality with increased size to stop truncation | /FLDQ/AD_LOCALITY_BIG | CHAR | 400 | ||
| CITY2 | locality with increased size to stop truncation | /FLDQ/AD_LOCALITY_BIG | CHAR | 400 | ||
| CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 24 | ||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 16 | ||
| HOME_CITY | locality with increased size to stop truncation | /FLDQ/AD_LOCALITY_BIG | CHAR | 400 | ||
| CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 24 | ||
| CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 2 | ||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 16 | ||
| POST_CODE1 | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| POST_CODE2 | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 20 | ||
| PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 20 | ||
| PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 20 | ||
| PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 20 | ||
| PO_BOX | po box with increased size to stop truncation | /FLDQ/AD_PO_BOX_BIG | CHAR | 200 | ||
| PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 2 | ||
| PO_BOX_LOC | locality with increased size to stop truncation | /FLDQ/AD_LOCALITY_BIG | CHAR | 400 | ||
| CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 24 | ||
| PO_BOX_REG | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| PO_BOX_REG2 | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| PO_BOX_CTY | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 20 | ||
| STREET | street with increased size to stop truncation | /FLDQ/AD_STREET_BIG | CHAR | 400 | ||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 24 | ||
| STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 4 | ||
| HOUSE_NUM1 | house num1 with increased size to stop truncation | /FLDQ/AD_HOUSE_NUM1_BIG | CHAR | 200 | ||
| HOUSE_NUM2 | house num2 with increased size to stop truncation | /FLDQ/AD_HOUSE_NUM2_BIG | CHAR | 200 | ||
| STR_SUPPL1 | street suppl with increased size to stop truncation | /FLDQ/AD_STR_SUPPL | CHAR | 500 | ||
| STR_SUPPL2 | street suppl with increased size to stop truncation | /FLDQ/AD_STR_SUPPL | CHAR | 500 | ||
| STR_SUPPL3 | street suppl with increased size to stop truncation | /FLDQ/AD_STR_SUPPL | CHAR | 500 | ||
| LOCATION | location with increased size to stop truncation | /FLDQ/AD_LOC | CHAR | 400 | ||
| BUILDING | building with increased size to stop truncation | /FLDQ/AD_BUILDING_BIG | CHAR | 400 | ||
| FLOOR | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| ROOMNUMBER | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| LANGU | Language Key | SPRAS | LANG | 2 | ||
| REGION | big field for output from GAC to stop truncation | /FLDQ/AD_BIG_FIELD_100 | CHAR | 200 | ||
| REGION2 | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| TIME_ZONE | Address time zone | AD_TZONE | CHAR | 12 | ||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 30 | ||
| LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 2 | ||
| NAME_CO | c/o name | AD_NAME_CO | CHAR | 80 | ||
| DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 8 | ||
| DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 8 | ||
| PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 80 | ||
| DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 8 | ||
| DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 20 | ||
| STOP | General Flag | FLAG | CHAR | 2 | ||
| CHCKST_QU | City file check status after quarterly adjustment | AD_CHCKQU | CHAR | 2 | ||
| ERROR_FLAG | Flag: Quarterly adjustment error | AD_ERRQU | CHAR | 2 | ||
| REGION2_LONG | region2 that is larger then bupa field for truncation | /FLDQ/REGION2_BIG | CHAR | 400 |