BUT_ADR2_PRC

Transparent Table Application Table
18 Fields 1 CDS Views

Master Data Consolidation: Process Table for ADR2

BUT_ADR2_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for ADR2. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusPartPhoneNumbersProc view from BASIC Core View: Bus Part All Phones (Process)

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
addrnumber ad_addrnum Address Number
country ad_comctry Country/Region
flgdefault ad_flgdfnr Standard No.
flg_nouse ad_flnouse Do not use
home_flag ad_flghome Home Address
tel_number ad_tlnmbr Telephone
tel_extens ad_tlxtns Extension
telnr_long ad_telnrlg Telephone no.
telnr_call ad_telnrcl Caller number
dft_receiv ad_flgsms SMS-Enab.
r3_user ad_flgmob Mobile phone
valid_from ad_valfrom Valid From
valid_to ad_valto Valid To
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

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 ADR2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADR2_PRC (
    CLIENT,                    -- Client [mandt]
    ADDRNUMBER,                -- Address Number [ad_addrnum]
    COUNTRY,                   -- Country/Region [ad_comctry]
    FLGDEFAULT,                -- Standard No. [ad_flgdfnr]
    FLG_NOUSE,                 -- Do not use [ad_flnouse]
    HOME_FLAG,                 -- Home Address [ad_flghome]
    TEL_NUMBER,                -- Telephone [ad_tlnmbr]
    TEL_EXTENS,                -- Extension [ad_tlxtns]
    TELNR_LONG,                -- Telephone no. [ad_telnrlg]
    TELNR_CALL,                -- Caller number [ad_telnrcl]
    DFT_RECEIV,                -- SMS-Enab. [ad_flgsms]
    R3_USER,                   -- Mobile phone [ad_flgmob]
    VALID_FROM,                -- Valid From [ad_valfrom]
    VALID_TO,                  -- Valid To [ad_valto]
    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]
    PRIMARY KEY (CLIENT)
);

Learn More