BUT_ADRC_IMOUT - Master Data Consolidation: Process Table for ADRC

Master Data Consolidation: Process Table for ADRC information is stored in SAP table BUT_ADRC_IMOUT.
It is part of development package MDC_BP_ADAPTER_OP in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: BP Service Adapter On Premise".

Fields for table BUT_ADRC_IMOUT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
.INCLUDEPROCESS_KEYXMDC_PROCESS_KEY0
.INCLUDESTEP_KEYXMDC_STEP_KEY0
PROCESS_IDMaster Data Change Process IdentifierXMDC_PROCESS_IDNUMC24
PROCESS_STEP_NOMaster Data Change Process Step NumberXMDC_PROCESS_STEP_NONUMC8
.INCLUDESOURCE_KEYXMDC_SOURCE_KEY0
SOURCE_SYSTEMSource SystemXMDC_BUSINESS_SYSTEMCHAR120
SOURCE_IDMaster Data Consolidation: ID of a Source ObjectsXMDC_SOURCE_IDCHAR120
SOURCE_ADDRNUMBERAddress NumberXAD_ADDRNUMCHAR20
DATE_FROMValid-from date - in current Release only 00010101 possibleXAD_DATE_FRDATS16
NATIONVersion ID for International AddressesXAD_NATIONCHAR2
ADDRNUMBERAddress NumberAD_ADDRNUMCHAR20
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATS16
TITLEForm-of-Address KeyAD_TITLECHAR8
NAME1Name 1AD_NAME1CHAR80
NAME2Name 2AD_NAME2CHAR80
NAME3Name 3AD_NAME3CHAR80
NAME4Name 4AD_NAME4CHAR80
NAME_TEXTConverted name field (with form of address)AD_NAMETXTCHAR100
NAME_COc/o nameAD_NAME_COCHAR80
CITY1CityAD_CITY1CHAR80
CITY2DistrictAD_CITY2CHAR80
CITY_CODECity code for city/street fileAD_CITYNUMCHAR24
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCHAR16
HOME_CITYCity (different from postal city)AD_CITY3CHAR80
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCHAR24
CHCKSTATUSCity file test statusAD_CHECKSTCHAR2
REGIOGROUPRegional structure groupingREGIOGROUPCHAR16
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_USEPCHAR8
PO_BOX_NUMFlag: PO Box Without NumberAD_POBXNUMCHAR2
PO_BOX_LOCPO Box cityAD_POBXLOCCHAR80
CITY_CODE2City PO box code (City file)AD_CIT2NUMCHAR24
PO_BOX_REGRegion for PO Box (Country/Region, State, Province, ...)AD_POBXREGCHAR6
PO_BOX_CTYPO Box of Country/RegionAD_POBXCTYCHAR6
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARCHAR30
TRANSPZONETransportation zone to or from which the goods are deliveredLZONECHAR20
STREETStreetAD_STREETCHAR120
DONT_USE_SStreet Address Undeliverable FlagAD_NO_USESCHAR8
STREETCODEStreet Number for City/Street FileAD_STRNUMCHAR24
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRCHAR4
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 KeyLAND1CHAR6
LANGULanguage KeySPRASLANG2
REGIONRegion (State, Province, County)REGIOCHAR6
ADDR_GROUPAddress Group (Key) (Business Address Services)AD_GROUPCHAR8
FLAGGROUPSFlag: There are more address group assignmentsAD_FLGGPCHAR2
PERS_ADDRFlag: This is a personal addressAD_PRSADDRCHAR2
SORT1Search Term 1AD_SORT1CHAR40
SORT2Search Term 2AD_SORT2CHAR40
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR40
DEFLT_COMMCommunication Method (Key) (Business Address Services)AD_COMMCHAR6
TEL_NUMBERFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR60
TEL_EXTENSFirst Telephone No.: ExtensionAD_TLXTNS1CHAR20
FAX_NUMBERFirst Fax No.: Area Code + NumberAD_FXNMBR1CHAR60
FAX_EXTENSFirst fax no.: extensionAD_FXXTNS1CHAR20
FLAGCOMM2Flag: Telephone number(s) definedAD_FLGCM02CHAR2
FLAGCOMM3Flag: Fax number(s) definedAD_FLGCM03CHAR2
FLAGCOMM4Flag: Teletex number(s) definedAD_FLGCM04CHAR2
FLAGCOMM5Flag: Telex number(s) definedAD_FLGCM05CHAR2
FLAGCOMM6Flag: E-mail address(es) definedAD_FLGCM06CHAR2
FLAGCOMM7Flag: RML (remote mail) addresse(s) definedAD_FLGCM07CHAR2
FLAGCOMM8Flag: X.400 addresse(s) definedAD_FLGCM08CHAR2
FLAGCOMM9Flag: RFC destination(s) definedAD_FLGCM09CHAR2
FLAGCOMM10Flag: Printer definedAD_FLGCM10CHAR2
FLAGCOMM11Flag: SSF definedAD_FLGCM11CHAR2
FLAGCOMM12Flag: URI/FTP address definedAD_FLGCM12CHAR2
FLAGCOMM13Flag: Pager address definedAD_FLGCM13CHAR2
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINACHAR8
MC_NAME1Name (Field NAME1) in Uppercase for Search HelpAD_MC_NAMECHAR50
MC_CITY1City name in Uppercase for Search HelpAD_MC_CITYCHAR50
MC_STREETStreet Name in Uppercase for Search HelpAD_MC_STRTCHAR50
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_TZONECHAR12
TAXJURCODETax JurisdictionAD_TXJCDCHAR30
ADDRESS_ID(Not supported) Physical address IDAD_ADDR_IDCHAR20
LANGU_CREAAddress record creation original languageAD_LANGUCRLANG2
ADRC_UUIDUUID Used in the AddressAD_UUIDRAW16
UUID_BELATEDIndicator: UUID created laterAD_UUID_BELATEDCHAR2
ID_CATEGORYCategory of an Address IDAD_ID_CATEGORYCHAR2
ADRC_ERR_STATUSError Status of AddressAD_ERR_STATUSCHAR2
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYCHAR80
DELI_SERV_TYPEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8
DELI_SERV_NUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
COUNTY_CODECounty code for countyAD_CNTYNUMCHAR16
COUNTYCountyAD_COUNTYCHAR80
TOWNSHIP_CODETownship code for TownshipAD_TWSHPNUMCHAR16
TOWNSHIPTownshipAD_TOWNSHIPCHAR80
MC_COUNTYCounty name in upper case for search helpAD_MC_COUNTYCHAR50
MC_TOWNSHIPTownship name in upper case for search helpAD_MC_TWSHPCHAR50
XPCPTBusiness Purpose Completed FlagAD_XPCPTCHAR2
SOURCE_RECENCYMaster Data Consolidation: RecencyMDC_RECENCYDEC8
.INCLUDEINFO_CODE0
ADDR_INFO_CODEAddress information codeADDR_INFO_CODECHAR10
ADDR_PO_BOX_INFO_CODEAddress PO box information codeADDR_PO_BOX_INFO_CODECHAR10
Privacy Policy