BUT_ADRC_PRC

Master Data Consolidation: Process Table for ADRC | #transactional | #language | Component: Business Partner.
Column Name Description
CLIENT Client
PROCESS_ID Master Data Change Process Identifier
PROCESS_STEP_NO Master Data Change Process Step Number
SOURCE_SYSTEM Source System
SOURCE_ID Master Data Consolidation: ID of a Source Objects
SOURCE_ADDRNUMBER Address Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
Column Name Description
CHCKSTATUS City file test status Show values
PO_BOX_NUM Flag: PO Box Without Number Show values
FLAGGROUPS Flag: There are more address group assignments Show values
PERS_ADDR Flag: This is a personal address Show values
FLAGCOMM2 Flag: Telephone number(s) defined Show values
FLAGCOMM3 Flag: Fax number(s) defined Show values
FLAGCOMM4 Flag: Teletex number(s) defined Show values
FLAGCOMM5 Flag: Telex number(s) defined Show values
FLAGCOMM6 Flag: E-mail address(es) defined Show values
FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined Show values
FLAGCOMM8 Flag: X.400 addresse(s) defined Show values
FLAGCOMM9 Flag: RFC destination(s) defined Show values
FLAGCOMM10 Flag: Printer defined Show values
FLAGCOMM11 Flag: SSF defined Show values
FLAGCOMM12 Flag: URI/FTP address defined Show values
FLAGCOMM13 Flag: Pager address defined Show values
UUID_BELATED Indicator: UUID created later Show values
ID_CATEGORY Category of an Address ID Show values
ADRC_ERR_STATUS Error Status of Address Show values
XPCPT Business Purpose Completed Flag Show values
Column Name Description Domain name
ADDRNUMBER Address Number AD_ADDRNUM
TITLE Form-of-Address Key AD_TITLE
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
NAME3 Name 3 TEXT40
NAME4 Name 4 TEXT40
NAME_TEXT Converted name field (with form of address) TEXT50
NAME_CO c/o name TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
CITY_CODE City code for city/street file CITY_CODE
CITYP_CODE District code for City and Street file CITYP_CODE
HOME_CITY City (different from postal city) TEXT40
CITYH_CODE Different city for city/street file CITY_CODE
REGIOGROUP Regional structure grouping REGIOGROUP
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR10
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR10
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR10
PO_BOX PO Box CHAR10
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USE
PO_BOX_LOC PO Box city TEXT40
CITY_CODE2 City PO box code (City file) CITY_CODE
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) REGIO
PO_BOX_CTY PO Box of Country/Region LAND1
POSTALAREA (Not Supported) Post Delivery District TEXT15
TRANSPZONE Transportation zone to or from which the goods are delivered ZONE
STREET Street TEXT60
DONT_USE_S Street Address Undeliverable Flag AD_NO_USE
STREETCODE Street Number for City/Street File STRT_CODE
STREETABBR (Not Supported) Abbreviation of Street Name STRTYPEAB
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
HOUSE_NUM3 (Not supported) House Number Range TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
LOCATION Street 5 TEXT40
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
COUNTRY Country/Region Key LAND1
LANGU Language Key SPRAS
REGION Region (State, Province, County) REGIO
ADDR_GROUP Address Group (Key) (Business Address Services) AD_GROUP
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGIN
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR25
MC_CITY1 City name in Uppercase for Search Help CHAR25
MC_STREET Street Name in Uppercase for Search Help CHAR25
EXTENSION1 Extension (only for data conversion) (e.g. data line) TEXT40
EXTENSION2 Extension (only for data conversion) (e.g. telebox) TEXT40
TIME_ZONE Address time zone TZNZONE
TAXJURCODE Tax Jurisdiction AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID
LANGU_CREA Address record creation original language SPRAS
ADRC_UUID UUID Used in the Address SYSUUID
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR10
COUNTY_CODE County code for county CNTY_CODE
COUNTY County TEXT40
TOWNSHIP_CODE Township code for Township TWSHP_CODE
TOWNSHIP Township TEXT40
MC_COUNTY County name in upper case for search help CHAR25
MC_TOWNSHIP Township name in upper case for search help CHAR25
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_MODIFIED Indicator: Source Record modified MDC_SOURCE_MODIFIED
SOURCE_MODIFICATION_BLIP Modification Indicator refering to a field's position
SOURCE_INDEX Index of record
DUNS Dun & Bradstreet number (DUNS) CHAR9
DUNSP4 DUNS+4 number (the last four digit) CHAR4