/FLDQ/AD_PUPDATE - Matchcode Records pending to be updated

Matchcode Records pending to be updated information is stored in SAP table /FLDQ/AD_PUPDATE.
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_PUPDATE

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
.INCLUDEXADDR_KEYNR0
ADDRNUMBERAddress NumberXAD_ADDRNUMCHAR20*
PERSNUMBERPerson NumberXAD_PERSNUMCHAR20
ADDR_TYPEAddress type (1=Organization, 2=Person, 3=Contact person)XAD_ADRTYPECHAR2
DATE_FROMValid-from date - in current Release only 00010101 possibleXAD_DATE_FRDATS16
NATIONVersion ID for International AddressesXAD_NATIONCHAR2
APPL_TABLEApplication table logical name (address management)XAD_APPLTABCHAR20
APPL_FIELDApplication table address where-used list logical field nameXAD_APPLFLDCHAR20
.INCLUDE/FLDQ/AD_MTCCODE_STRUC0
MATCH_CODE1Address Match Code/FLDQ/AD_MATCH_CODECHAR40
PO_MATCH_CODEAddress Match Code/FLDQ/AD_MATCH_CODECHAR40
MTC_CODE_NM1Name Match Code/FLDQ/AD_NAME_MATCH_CODECHAR40
MTC_CODE_NM2Name Match Code/FLDQ/AD_NAME_MATCH_CODECHAR40
MTC_CODE_NM3Name Match Code/FLDQ/AD_NAME_MATCH_CODECHAR40
MTC_CODE_NM4Name Match Code/FLDQ/AD_NAME_MATCH_CODECHAR40
MTC_CODE_NM5Name Match Code/FLDQ/AD_NAME_MATCH_CODECHAR40
DEPARTMENTDepartmentAD_DPRTMNTCHAR80
FUNCTIONCompany contact person functionAD_FUNCCHAR80
ID_CODEShort name for correspondenceAD_ID_CODECHAR20
IH_MAILInternal Mail Postal CodeAD_IH_MAILCHAR20
ROOMNUMBERRoom or Apartment NumberAD_ROOMNUMCHAR20
BUILDINGBuilding (Number or Code)AD_BLDNGCHAR40
CITY1CityAD_CITY1CHAR80
CITY2DistrictAD_CITY2CHAR80
COUNTRYCountry/Region KeyLAND1CHAR6*
FLOORFloor in buildingAD_FLOORCHAR20
HOUSE_NUM1House NumberAD_HSNM1CHAR20
HOUSE_NUM2House number supplementAD_HSNM2CHAR20
LOCATIONStreet 5AD_LCTNCHAR80
NAME1Name 1AD_NAME1CHAR80
NAME2Name 2AD_NAME2CHAR80
NAME3Name 3AD_NAME3CHAR80
NAME4Name 4AD_NAME4CHAR80
NAME_COc/o nameAD_NAME_COCHAR80
POST_CODE1City postal codeAD_PSTCD1CHAR20
POST_CODE2PO Box Postal CodeAD_PSTCD2CHAR20
POST_CODE3Company Postal Code (for Large Customers)AD_PSTCD3CHAR20
PO_BOXPO BoxAD_POBXCHAR20
PO_BOX_LOCPO Box cityAD_POBXLOCCHAR80
PO_BOX_CTYPO Box of Country/RegionAD_POBXCTYCHAR6*
REGIONRegion (State, Province, County)REGIOCHAR6*
SORT1Search Term 1AD_SORT1CHAR40
SORT2Search Term 2AD_SORT2CHAR40
STREETStreetAD_STREETCHAR120
STR_SUPPL1Street 2AD_STRSPP1CHAR80
STR_SUPPL2Street 3AD_STRSPP2CHAR80
STR_SUPPL3Street 4AD_STRSPP3CHAR80
NAME_FIRSTFirst nameAD_NAMEFIRCHAR80
NAME_LASTLast nameAD_NAMELASCHAR80
SMTP_ADDRE-Mail AddressAD_SMTPADRCHAR482
TEL_NUMBERFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR60
TEL_EXTENSFirst Telephone No.: ExtensionAD_TLXTNS1CHAR20
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYCHAR80
EXTRA1Text, 255 Characters/FLDQ/AD_TEXT255CHAR510
EXTRA2Text, 255 Characters/FLDQ/AD_TEXT255CHAR510
MTCSTD1Match Standard/FLDQ/AD_MATCH_STDCHAR80
MTCSTD2Match Standard/FLDQ/AD_MATCH_STDCHAR80
BIRTHDTDate of Birth of Business PartnerBU_BIRTHDTDATS16
UPDATE_MODEAddress transfer structure change flagAD_UPDFLAGCHAR2
Privacy Policy