BUT_ADR3_PRC

Transparent Table Application Table
26 Fields 1 CDS Views

Master Data Consolidation: Process Table for ADR3

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPFaxNumberProcess view from BASIC Shows Fax number data for BP (Process)

Fields (26)

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 consnumber AD_CONSNUM Sequence Number
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
fax_number AD_FXNMBR Fax
fax_extens AD_FXXTNS Extension
faxnr_long AD_FXNRLNG Fax Number
faxnr_call AD_FAXNRCL Sender number
fax_group AD_FXGRP Fax group
dft_receiv AD_DFTRCNR Std.recipient
r3_user AD_R3_USER SAP Connection
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 ADR3
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADR3_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]
    CONSNUMBER,                -- Sequence Number [AD_CONSNUM]
    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]
    FAX_NUMBER,                -- Fax [AD_FXNMBR]
    FAX_EXTENS,                -- Extension [AD_FXXTNS]
    FAXNR_LONG,                -- Fax Number [AD_FXNRLNG]
    FAXNR_CALL,                -- Sender number [AD_FAXNRCL]
    FAX_GROUP,                 -- Fax group [AD_FXGRP]
    DFT_RECEIV,                -- Std.recipient [AD_DFTRCNR]
    R3_USER,                   -- SAP Connection [AD_R3_USER]
    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, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, SOURCE_ADDRNUMBER, DATE_FROM, CONSNUMBER)
);

Learn More