/FLDQ/AD_CHKSTAT - Table to temporarily hold the check status values

Table to temporarily hold the check status values information is stored in SAP table /FLDQ/AD_CHKSTAT.
It is part of development package /FLDQ/GDQC_LINK in software component EIM-DQM-SAP. This development package consists of objects that can be grouped under "Development class for SAP BusinessObjects : DQM for SAP".

Fields for table /FLDQ/AD_CHKSTAT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
GUIDGUID in 'CHAR' format with upper-/lowercase (!)XGUID_22CHAR44
UNAMEUser NameSYUNAMECHAR24
.INCLUDEADRC_STRUC0
NAME_COc/o nameAD_NAME_COCHAR80
CITY1CityAD_CITY1CHAR80
CITY2DistrictAD_CITY2CHAR80
CITY_CODECity code for city/street fileAD_CITYNUMCHAR24ADRCITY
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCHAR16ADRCITYPRT
HOME_CITYCity (different from postal city)AD_CITY3CHAR80
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCHAR24ADRCITY
CHCKSTATUSCity file test statusAD_CHECKSTCHAR2
REGIOGROUPRegional structure groupingREGIOGROUPCHAR16ADRREGGRP
POST_CODE1City postal codeAD_PSTCD1CHAR20
POST_CODE2PO Box Postal CodeAD_PSTCD2CHAR20
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 BoxAD_POBXCHAR20
DONT_USE_PPO Box Address Undeliverable FlagAD_NO_USEPCHAR8TSAD12
PO_BOX_NUMFlag: PO Box Without NumberAD_POBXNUMCHAR2
PO_BOX_LOCPO Box cityAD_POBXLOCCHAR80
CITY_CODE2City PO box code (City file)AD_CIT2NUMCHAR24ADRCITY
PO_BOX_REGRegion for PO Box (Country/Region, State, Province, ...)AD_POBXREGCHAR6T005S
PO_BOX_CTYPO Box of Country/RegionAD_POBXCTYCHAR6T005
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARCHAR30
TRANSPZONETransportation zone to or from which the goods are deliveredLZONECHAR20TZONE
STREETStreetAD_STREETCHAR120
DONT_USE_SStreet Address Undeliverable FlagAD_NO_USESCHAR8TSAD12
STREETCODEStreet Number for City/Street FileAD_STRNUMCHAR24ADRSTREET
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRCHAR4ADRSTRTYPE
HOUSE_NUM1House NumberAD_HSNM1CHAR20
HOUSE_NUM2House number supplementAD_HSNM2CHAR20
HOUSE_NUM3(Not supported) House Number RangeAD_HSNM3CHAR20
STR_SUPPL1Street 2AD_STRSPP1CHAR80
STR_SUPPL2Street 3AD_STRSPP2CHAR80
STR_SUPPL3Street 4AD_STRSPP3CHAR80
LOCATIONStreet 5AD_LCTNCHAR80
BUILDINGBuilding (Number or Code)AD_BLDNGCHAR40
FLOORFloor in buildingAD_FLOORCHAR20
ROOMNUMBERRoom or Apartment NumberAD_ROOMNUMCHAR20
COUNTRYCountry/Region KeyLAND1CHAR6T005
LANGULanguage KeySPRASLANG2T002
REGIONRegion (State, Province, County)REGIOCHAR6T005S
SORT1Search Term 1AD_SORT1ULCHAR40
SORT2Search Term 2AD_SORT2ULCHAR40
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR40
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINACHAR8TSAD6
EXTENSION1Extension (only for data conversion) (e.g. data line)AD_EXTENS1CHAR80
EXTENSION2Extension (only for data conversion) (e.g. telebox)AD_EXTENS2CHAR80
TIME_ZONEAddress time zoneAD_TZONECHAR12TTZZ
TAXJURCODETax JurisdictionAD_TXJCDCHAR30
ADDRESS_ID(Not supported) Physical address IDAD_ADDR_IDCHAR20
REMARKAddress notesAD_REMARK1CHAR100
LANGU_CREAAddress record creation original languageAD_LANGUCRLANG2T002
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYCHAR80
DELI_SERV_TYPEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8ADDRC_DELI_SERV
DELI_SERV_NUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
COUNTY_CODECounty code for countyAD_CNTYNUMCHAR16ADRCOUNTY
COUNTYCountyAD_COUNTYCHAR80
TOWNSHIP_CODETownship code for TownshipAD_TWSHPNUMCHAR16ADRTOWNSHIP
TOWNSHIPTownshipAD_TOWNSHIPCHAR80
Privacy Policy