/FLDQ/AD_QTRRVW SAP (Cleansed addresses from RSADRQU2 to review before comitting) Table details
Dictionary Type: Table
Description: Cleansed addresses from RSADRQU2 to review before comitting
Description: Cleansed addresses from RSADRQU2 to review before comitting
ABAP Code to SELECT data from /FLDQ/AD_QTRRVW
Related tables to /FLDQ/AD_QTRRVW
Access table /FLDQ/AD_QTRRVW
Related tables to /FLDQ/AD_QTRRVW
Access table /FLDQ/AD_QTRRVW
Table field list including key, data, relationships and ABAP select examples
/FLDQ/AD_QTRRVW is a standard SAP Table which is used to store Cleansed addresses from RSADRQU2 to review before comitting data and is available within R/3 SAP systems depending on the version and release level.
The /FLDQ/AD_QTRRVW table consists of various fields, each holding specific information or linking keys about Cleansed addresses from RSADRQU2 to review before comitting data available in SAP. These include ADDRNUMBER (Address number), DATE_FROM (Valid-from date - in current Release only 00010101 possible), NATION (Version ID for International Addresses), STATUS_CODE (Status Code returned from DS).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /FLDQ/AD_QTRRVW table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
| NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | Assigned to domain | AD_NATION | ADDRESS_NATION | ||
| STATUS_CODE | Status Code returned from DS | 0 | |||||||
| STATUS_CODE_PO | Status Code of PO Box address returned from DS | 0 | |||||||
| LINE_COLOR | Line color for display | 0 | |||||||
| REC_TYPE | Specifies if this is the original or cleansed address | 0 | |||||||
| LAST_LINE_CHG | Parameter Value | /FLDQ/AD_PARAM_VALUE | CHAR | 80 | CHAR80 | ||||
| ADDR_LINE_CHG | Parameter Value | /FLDQ/AD_PARAM_VALUE | CHAR | 80 | CHAR80 | ||||
| SEC_LINE_CHG | Parameter Value | /FLDQ/AD_PARAM_VALUE | CHAR | 80 | CHAR80 | ||||
| LAST_LINE_CHG_PO | Parameter Value | /FLDQ/AD_PARAM_VALUE | CHAR | 80 | CHAR80 | ||||
| ADDR_LINE_CHG_PO | Parameter Value | /FLDQ/AD_PARAM_VALUE | CHAR | 80 | CHAR80 | ||||
| SEC_LINE_CHG_PO | Parameter Value | /FLDQ/AD_PARAM_VALUE | CHAR | 80 | CHAR80 | ||||
| COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
| PACKAGE_NO | Package number for reading quarterly adjustment data | AD_PCKGNO1 | NUMC | 10 | NUMC10 | ||||
| CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
| CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
| CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | Assigned to domain | ALPHA | CITYP_CODE | ||
| HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
| CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
| CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | Assigned to domain | REGIOGROUP | |||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
| POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
| POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
| PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
| PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
| PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
| CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
| PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | Assigned to domain | REGIO | |||
| PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | Assigned to domain | LAND1 | |||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | Assigned to domain | ZONE | |||
| STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | Assigned to domain | ALPHA | STRT_CODE | ||
| HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
| HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
| STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
| STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
| STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
| LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
| BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
| REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
| TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
| LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
| NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
| DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | Assigned to domain | AD_NO_USE | |||
| DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | Assigned to domain | AD_NO_USE |
| Key field | Non-key field |
How do I retrieve data from SAP table /FLDQ/AD_QTRRVW using ABAP code
The following ABAP code Example will allow you to do a basic selection on /FLDQ/AD_QTRRVW to SELECT all data from the tableDATA: WA_/FLDQ/AD_QTRRVW TYPE /FLDQ/AD_QTRRVW.
SELECT SINGLE *
FROM /FLDQ/AD_QTRRVW
INTO CORRESPONDING FIELDS OF WA_/FLDQ/AD_QTRRVW
WHERE...
How to access SAP table /FLDQ/AD_QTRRVW
Within an ECC or HANA version of SAP you can also view further information about /FLDQ/AD_QTRRVW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects