SAP Table

SAP /FLDQ/AD_ADRC_QU1 Table Address Data for Quarterly Updates







  

/FLDQ/AD_ADRC_QU1 is a standard SAP Table which is used to store Address Data for Quarterly Updates data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP /FLDQ/AD_ADRC_QU1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.


SAP /FLDQ/AD_ADRC_QU1 dictionary attributes

Delivery Class:

Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions

Enhancement category: Can Be Enhanced (Deep)
See here for more information about this and other SAP enhancement categories

Dictionary Type: Structure

Description: Address Data for Quarterly Updates


Field list of /FLDQ/AD_ADRC_QU1 SAP table

.


Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field
ERROR_CODE/FLDQ/AD_ERR_CODECHAR4(0) Error codesCHAR4
DQ_L_REGIONNAME/FLDQ/AD_DQ_L_REGIONNAMECHAR60(0) DQ Long Region Name
DQ_L_PO_BOXREGNM/FLDQ/AD_DQ_L_REGIONNAMECHAR60(0) DQ Long Region Name
STATUS_CODE/FLDQ/AD_STATUS_CODECHAR10(0) Address Engine Status Code/FLDQ/STATUS_CODE
ERROR_CODE_PO/FLDQ/AD_ERR_CODECHAR4(0) Error codesCHAR4
STATUS_CODE_PO/FLDQ/AD_STATUS_CODECHAR10(0) Address Engine Status Code/FLDQ/STATUS_CODE
COUNTRYLAND1CHAR3(0) Assigned to domainCountry KeyLAND1LNDFB
ADDRNUMBERAD_ADDRNUMCHAR10(0) Assigned to domainAddress numberALPHAAD_ADDRNUMADR
PERSNUMBERAD_PERSNUMCHAR10(0) Assigned to domainPerson numberALPHAAD_PERSNUMCDTADDRESSPERSNUMBER
NATIONAD_NATIONCHAR1(0) Assigned to domainVersion ID for International AddressesAD_NATIONADDRESS_NATION
DATE_FROMAD_DATE_FRDATS8(0) Valid-from date - in current Release only 00010101 possibleDATUM
DATE_TOAD_DATE_TODATS8(0) Valid-to date in current Release only 99991231 possibleDATUM
PACKAGE_NOAD_PCKGNO1NUMC10(0) Package number for reading quarterly adjustment dataNUMC10
CITY1AD_CITY1CHAR40(0) CityTEXT40CLCITYNAMECITY_NAME
CITY2AD_CITY2CHAR40(0) DistrictTEXT40CITY_PARTCITY_PART
CITY_CODEAD_CITYNUMCHAR12(0) Assigned to domainCity code for city/street fileALPHACITY_CODE
CITYP_CODEAD_CITYPNMCHAR8(0) Assigned to domainDistrict code for City and Street fileALPHACITYP_CODE
HOME_CITYAD_CITY3CHAR40(0) City (different from postal city)TEXT40
CITYH_CODEAD_CITYHNMCHAR12(0) Assigned to domainDifferent city for city/street fileALPHACITY_CODE
CHCKSTATUSAD_CHECKSTCHAR1(0) City file test statusAD_CHECKST
REGIOGROUPREGIOGROUPCHAR8(0) Assigned to domainRegional structure groupingREGIOGROUP
POST_CODE1AD_PSTCD1CHAR10(0) City postal codeCHAR10
POST_CODE2AD_PSTCD2CHAR10(0) PO Box Postal CodeCHAR10
POST_CODE3AD_PSTCD3CHAR10(0) Company Postal Code (for Large Customers)CHAR10
PCODE1_EXTAD_PST1XTCHAR10(0) (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeCHAR10
PCODE2_EXTAD_PST2XTCHAR10(0) (Not Supported) PO Box Postal Code ExtensionCHAR10
PCODE3_EXTAD_PST3XTCHAR10(0) (Not Supported) Major Customer Postal Code ExtensionCHAR10
PO_BOXAD_POBXCHAR10(0) PO BoxCHAR10
PO_BOX_NUMAD_POBXNUMCHAR1(0) Flag: PO Box Without NumberXFELD
PO_BOX_LOCAD_POBXLOCCHAR40(0) PO Box cityTEXT40CITY_NAMECITY_NAME
CITY_CODE2AD_CIT2NUMCHAR12(0) Assigned to domainCity PO box code (City file)ALPHACITY_CODE
PO_BOX_REGAD_POBXREGCHAR3(0) Assigned to domainRegion for PO Box (Country, State, Province, ...)REGIO
PO_BOX_CTYAD_POBXCTYCHAR3(0) Assigned to domainPO box countryLAND1
TRANSPZONELZONECHAR10(0) Assigned to domainTransportation zone to or from which the goods are deliveredZONEVV
STREETAD_STREETCHAR60(0) StreetTEXT60CLSTRTNAMESTREET
STREETCODEAD_STRNUMCHAR12(0) Assigned to domainStreet Number for City/Street FileALPHASTRT_CODE
STREETABBRAD_STRABBRCHAR2(0) Assigned to domain(Not Supported) Abbreviation of Street NameSTRTYPEAB
HOUSE_NUM1AD_HSNM1CHAR10(0) House NumberTEXT10
HOUSE_NUM2AD_HSNM2CHAR10(0) House number supplementTEXT10
STR_SUPPL1AD_STRSPP1CHAR40(0) Street 2TEXT40
STR_SUPPL2AD_STRSPP2CHAR40(0) Street 3TEXT40
STR_SUPPL3AD_STRSPP3CHAR40(0) Street 4TEXT40
LOCATIONAD_LCTNCHAR40(0) Street 5TEXT40
BUILDINGAD_BLDNGCHAR20(0) Building (Number or Code)TEXT20
FLOORAD_FLOORCHAR10(0) Floor in buildingTEXT10
ROOMNUMBERAD_ROOMNUMCHAR10(0) Room or Appartment NumberTEXT10
LANGUSPRASLANG1(0) Assigned to domainLanguage KeyISOLASPRASSPRSAPH_T002SPRAS
REGIONREGIOCHAR3(0) Assigned to domainSTATE (State, Province, County)REGIOFB
TIME_ZONEAD_TZONECHAR6(0) Assigned to domainAddress time zoneTZNZONE
TAXJURCODEAD_TXJCDCHAR15(0) Tax JurisdictionAD_TXJCDTXJ
LANGU_CREAAD_LANGUCRLANG1(0) Assigned to domainAddress record creation original languageISOLASPRAS
NAME_COAD_NAME_COCHAR40(0) c/o nameTEXT40
DONT_USE_SAD_NO_USESCHAR4(0) Assigned to domainStreet Address Undeliverable FlagAD_NO_USE
DONT_USE_PAD_NO_USEPCHAR4(0) Assigned to domainPO Box Address Undeliverable FlagAD_NO_USE
PO_BOX_LOBBYAD_PO_BOX_LBYCHAR40(0) PO Box LobbyTEXT40
DELI_SERV_TYPEAD_DELIVERY_SERVICE_TYPECHAR4(0) Type of Delivery ServiceAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERAD_DELIVERY_SERVICE_NUMBERCHAR10(0) Number of Delivery ServiceCHAR10



/FLDQ/AD_ADRC_STRUC - Address Data for Postal Validation Online
/FLDQ/AD_ADR_COMPONENTS - Structure used to hold addr components
/FLDQ/AD_ADR_REVIEW_STRUC - Data to display in the address reviewer view
/FLDQ/AD_ADR_TYPE_RANGE_STRUC - Structure for address type range
/FLDQ/AD_AODSMAP - Map AOF package versions to valid DS versions
/FLDQ/AD_ASGN_XT - Assignment Level Exit Configuration
/FLDQ/AD_AUT_FNC - Authorization Validation Function mappings
/FLDQ/AD_CFGPRMS - Maintain Operating parameters
/FLDQ/AD_CFG_RVW - Maintain Address Reviewer Settings
/FLDQ/AD_CHKSTAT - Table to temporarily hold the check status values



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!