BUT_ADRC_PRC

Transparent Table Application Table
110 Fields 3 CDS Views

Master Data Consolidation: Process Table for ADRC

BUT_ADRC_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for ADRC. It contains 110 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BusinessPartnerAddrProcDsp view_entity inner BASIC Business Partner Address Process Display
I_BusPartScriptedGrpAddrProc view_entity inner BASIC Bus Partner Group Addr Vers in Process
I_BusPartScriptedOrgAddrProc view_entity inner BASIC Bus Partner Org Addr Vers in Process

Fields (110)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY source_addrnumber AD_ADDRNUM Address Number
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
addrnumber AD_ADDRNUM Address Number
date_to AD_DATE_TO To
title AD_TITLE Title Key
name1 AD_NAME1 Name
name2 AD_NAME2 Name 2
name3 AD_NAME3 Name 3
name4 AD_NAME4 Name 4
name_text AD_NAMETXT Conv. name
name_co AD_NAME_CO c/o
city1 AD_CITY1 City
city2 AD_CITY2 District
city_code AD_CITYNUM City Code
cityp_code AD_CITYPNM District
home_city AD_CITY3 Different City
cityh_code AD_CITYHNM City Code
chckstatus AD_CHECKST Check Status
regiogroup REGIOGROUP Structure Group
post_code1 AD_PSTCD1 Postal Code
post_code2 AD_PSTCD2 PO Box Post Cde
post_code3 AD_PSTCD3 Company Post Cd
pcode1_ext AD_PST1XT Postal Code Ext
pcode2_ext AD_PST2XT Postal Code Ext
pcode3_ext AD_PST3XT Postal Code Ext
po_box AD_POBX PO Box
dont_use_p AD_NO_USEP Undeliverable
po_box_num AD_POBXNUM PO Box w/o No.
po_box_loc AD_POBXLOC PO Box City
city_code2 AD_CIT2NUM City Code
po_box_reg AD_POBXREG PO Region
po_box_cty AD_POBXCTY PO Box C/R
postalarea AD_PSTLAR Delivery Dist.
transpzone LZONE Transport Zone
street AD_STREET Street
dont_use_s AD_NO_USES Undeliverable
streetcode AD_STRNUM Street Code
streetabbr AD_STRABBR Street Abbrev.
house_num1 AD_HSNM1 House Number
house_num2 AD_HSNM2 Supplement
house_num3 AD_HSNM3 Number Range
str_suppl1 AD_STRSPP1 Street 2
str_suppl2 AD_STRSPP2 Street 3
str_suppl3 AD_STRSPP3 Street 4
location AD_LCTN Street 5
building AD_BLDNG Building Code
floor AD_FLOOR Floor
roomnumber AD_ROOMNUM Room Number
country LAND1 Country/Reg.
langu SPRAS Language
region REGIO Region
addr_group AD_GROUP Address group
flaggroups AD_FLGGP Flag: There are more address group assignments
pers_addr AD_PRSADDR pers. address
sort1 AD_SORT1 Search Term 1
sort2 AD_SORT2 Search Term 2
sort_phn AD_SRTPHN Phonet. Sort.
deflt_comm AD_COMM Comm. Method
tel_number AD_TLNMBR1 Telephone
tel_extens AD_TLXTNS1 Extension
fax_number AD_FXNMBR1 Fax
fax_extens AD_FXXTNS1 Extension
flagcomm2 AD_FLGCM02 Telephone...
flagcomm3 AD_FLGCM03 Fax...
flagcomm4 AD_FLGCM04 Teletex
flagcomm5 AD_FLGCM05 Telex
flagcomm6 AD_FLGCM06 E-Mail Defined
flagcomm7 AD_FLGCM07 R/Mail
flagcomm8 AD_FLGCM08 X.400
flagcomm9 AD_FLGCM09 RFC
flagcomm10 AD_FLGCM10 Printer
flagcomm11 AD_FLGCM11 SSF
flagcomm12 AD_FLGCM12 URI/FTP
flagcomm13 AD_FLGCM13 Pager
addrorigin AD_ORIGINA Address Source
mc_name1 AD_MC_NAME Name
mc_city1 AD_MC_CITY City
mc_street AD_MC_STRT Street
extension1 AD_EXTENS1 Data line
extension2 AD_EXTENS2 Telebox
time_zone AD_TZONE Time Zone
taxjurcode AD_TXJCD Tax Jurisdiction
address_id AD_ADDR_ID Address ID
langu_crea AD_LANGUCR Creation lang.
adrc_uuid AD_UUID Address UUID
uuid_belated AD_UUID_BELATED Subsequent UUID
id_category AD_ID_CATEGORY ID Category
adrc_err_status AD_ERR_STATUS Error Status
po_box_lobby AD_PO_BOX_LBY PO Box Lobby
deli_serv_type AD_DELIVERY_SERVICE_TYPE Delvry Serv Type
deli_serv_number AD_DELIVERY_SERVICE_NUMBER Delivery Service No.
county_code AD_CNTYNUM County code
county AD_COUNTY County
township_code AD_TWSHPNUM Township code
township AD_TOWNSHIP Township
mc_county AD_MC_COUNTY County
mc_township AD_MC_TWSHP Township
xpcpt AD_XPCPT PurposeComplete Flag
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index
duns /SAPHT/RN_DUNS DUNS Number
dunsp4 /SAPHT/RN_DUNSP4 DUNS+4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Master Data Consolidation: Process Table for ADRC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADRC_PRC (
    CLIENT,                    -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    SOURCE_ADDRNUMBER,         -- Address Number [AD_ADDRNUM]
    DATE_FROM,                 -- From [AD_DATE_FR]
    NATION,                    -- Address Version [AD_NATION]
    ADDRNUMBER,                -- Address Number [AD_ADDRNUM]
    DATE_TO,                   -- To [AD_DATE_TO]
    TITLE,                     -- Title Key [AD_TITLE]
    NAME1,                     -- Name [AD_NAME1]
    NAME2,                     -- Name 2 [AD_NAME2]
    NAME3,                     -- Name 3 [AD_NAME3]
    NAME4,                     -- Name 4 [AD_NAME4]
    NAME_TEXT,                 -- Conv. name [AD_NAMETXT]
    NAME_CO,                   -- c/o [AD_NAME_CO]
    CITY1,                     -- City [AD_CITY1]
    CITY2,                     -- District [AD_CITY2]
    CITY_CODE,                 -- City Code [AD_CITYNUM]
    CITYP_CODE,                -- District [AD_CITYPNM]
    HOME_CITY,                 -- Different City [AD_CITY3]
    CITYH_CODE,                -- City Code [AD_CITYHNM]
    CHCKSTATUS,                -- Check Status [AD_CHECKST]
    REGIOGROUP,                -- Structure Group [REGIOGROUP]
    POST_CODE1,                -- Postal Code [AD_PSTCD1]
    POST_CODE2,                -- PO Box Post Cde [AD_PSTCD2]
    POST_CODE3,                -- Company Post Cd [AD_PSTCD3]
    PCODE1_EXT,                -- Postal Code Ext [AD_PST1XT]
    PCODE2_EXT,                -- Postal Code Ext [AD_PST2XT]
    PCODE3_EXT,                -- Postal Code Ext [AD_PST3XT]
    PO_BOX,                    -- PO Box [AD_POBX]
    DONT_USE_P,                -- Undeliverable [AD_NO_USEP]
    PO_BOX_NUM,                -- PO Box w/o No. [AD_POBXNUM]
    PO_BOX_LOC,                -- PO Box City [AD_POBXLOC]
    CITY_CODE2,                -- City Code [AD_CIT2NUM]
    PO_BOX_REG,                -- PO Region [AD_POBXREG]
    PO_BOX_CTY,                -- PO Box C/R [AD_POBXCTY]
    POSTALAREA,                -- Delivery Dist. [AD_PSTLAR]
    TRANSPZONE,                -- Transport Zone [LZONE]
    STREET,                    -- Street [AD_STREET]
    DONT_USE_S,                -- Undeliverable [AD_NO_USES]
    STREETCODE,                -- Street Code [AD_STRNUM]
    STREETABBR,                -- Street Abbrev. [AD_STRABBR]
    HOUSE_NUM1,                -- House Number [AD_HSNM1]
    HOUSE_NUM2,                -- Supplement [AD_HSNM2]
    HOUSE_NUM3,                -- Number Range [AD_HSNM3]
    STR_SUPPL1,                -- Street 2 [AD_STRSPP1]
    STR_SUPPL2,                -- Street 3 [AD_STRSPP2]
    STR_SUPPL3,                -- Street 4 [AD_STRSPP3]
    LOCATION,                  -- Street 5 [AD_LCTN]
    BUILDING,                  -- Building Code [AD_BLDNG]
    FLOOR,                     -- Floor [AD_FLOOR]
    ROOMNUMBER,                -- Room Number [AD_ROOMNUM]
    COUNTRY,                   -- Country/Reg. [LAND1]
    LANGU,                     -- Language [SPRAS]
    REGION,                    -- Region [REGIO]
    ADDR_GROUP,                -- Address group [AD_GROUP]
    FLAGGROUPS,                -- Flag: There are more address group assignments [AD_FLGGP]
    PERS_ADDR,                 -- pers. address [AD_PRSADDR]
    SORT1,                     -- Search Term 1 [AD_SORT1]
    SORT2,                     -- Search Term 2 [AD_SORT2]
    SORT_PHN,                  -- Phonet. Sort. [AD_SRTPHN]
    DEFLT_COMM,                -- Comm. Method [AD_COMM]
    TEL_NUMBER,                -- Telephone [AD_TLNMBR1]
    TEL_EXTENS,                -- Extension [AD_TLXTNS1]
    FAX_NUMBER,                -- Fax [AD_FXNMBR1]
    FAX_EXTENS,                -- Extension [AD_FXXTNS1]
    FLAGCOMM2,                 -- Telephone... [AD_FLGCM02]
    FLAGCOMM3,                 -- Fax... [AD_FLGCM03]
    FLAGCOMM4,                 -- Teletex [AD_FLGCM04]
    FLAGCOMM5,                 -- Telex [AD_FLGCM05]
    FLAGCOMM6,                 -- E-Mail Defined [AD_FLGCM06]
    FLAGCOMM7,                 -- R/Mail [AD_FLGCM07]
    FLAGCOMM8,                 -- X.400 [AD_FLGCM08]
    FLAGCOMM9,                 -- RFC [AD_FLGCM09]
    FLAGCOMM10,                -- Printer [AD_FLGCM10]
    FLAGCOMM11,                -- SSF [AD_FLGCM11]
    FLAGCOMM12,                -- URI/FTP [AD_FLGCM12]
    FLAGCOMM13,                -- Pager [AD_FLGCM13]
    ADDRORIGIN,                -- Address Source [AD_ORIGINA]
    MC_NAME1,                  -- Name [AD_MC_NAME]
    MC_CITY1,                  -- City [AD_MC_CITY]
    MC_STREET,                 -- Street [AD_MC_STRT]
    EXTENSION1,                -- Data line [AD_EXTENS1]
    EXTENSION2,                -- Telebox [AD_EXTENS2]
    TIME_ZONE,                 -- Time Zone [AD_TZONE]
    TAXJURCODE,                -- Tax Jurisdiction [AD_TXJCD]
    ADDRESS_ID,                -- Address ID [AD_ADDR_ID]
    LANGU_CREA,                -- Creation lang. [AD_LANGUCR]
    ADRC_UUID,                 -- Address UUID [AD_UUID]
    UUID_BELATED,              -- Subsequent UUID [AD_UUID_BELATED]
    ID_CATEGORY,               -- ID Category [AD_ID_CATEGORY]
    ADRC_ERR_STATUS,           -- Error Status [AD_ERR_STATUS]
    PO_BOX_LOBBY,              -- PO Box Lobby [AD_PO_BOX_LBY]
    DELI_SERV_TYPE,            -- Delvry Serv Type [AD_DELIVERY_SERVICE_TYPE]
    DELI_SERV_NUMBER,          -- Delivery Service No. [AD_DELIVERY_SERVICE_NUMBER]
    COUNTY_CODE,               -- County code [AD_CNTYNUM]
    COUNTY,                    -- County [AD_COUNTY]
    TOWNSHIP_CODE,             -- Township code [AD_TWSHPNUM]
    TOWNSHIP,                  -- Township [AD_TOWNSHIP]
    MC_COUNTY,                 -- County [AD_MC_COUNTY]
    MC_TOWNSHIP,               -- Township [AD_MC_TWSHP]
    XPCPT,                     -- PurposeComplete Flag [AD_XPCPT]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    DUNS,                      -- DUNS Number [/SAPHT/RN_DUNS]
    DUNSP4,                    -- DUNS+4 [/SAPHT/RN_DUNSP4]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, SOURCE_ADDRNUMBER, DATE_FROM, NATION)
);

Learn More