BUT_ADR6_PRC

Transparent Table Application Table
17 Fields 1 CDS Views

Master Data Consolidation: Process Table for ADR12

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPEmailAddressProcess view from BASIC Shows Business Partner Email (Process)

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
addrnumber ad_addrnum Address Number
flgdefault ad_flgdfad Standard addr.
flg_nouse ad_flnouse Do not use
home_flag ad_flghome Home Address
smtp_addr ad_smtpadr E-Mail Address
smtp_srch ad_smtpad2 E-Mail Address
dft_receiv ad_dftrcad Std.recipient
r3_user ad_r3_user SAP Connection
encode ad_encode Coding
tnef ad_tnef6 TNEF
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 ADR12
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADR6_PRC (
    CLIENT,                    -- Client [mandt]
    ADDRNUMBER,                -- Address Number [ad_addrnum]
    FLGDEFAULT,                -- Standard addr. [ad_flgdfad]
    FLG_NOUSE,                 -- Do not use [ad_flnouse]
    HOME_FLAG,                 -- Home Address [ad_flghome]
    SMTP_ADDR,                 -- E-Mail Address [ad_smtpadr]
    SMTP_SRCH,                 -- E-Mail Address [ad_smtpad2]
    DFT_RECEIV,                -- Std.recipient [ad_dftrcad]
    R3_USER,                   -- SAP Connection [ad_r3_user]
    ENCODE,                    -- Coding [ad_encode]
    TNEF,                      -- TNEF [ad_tnef6]
    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