BUT021_FS_PRC

Transparent Table Application Table
16 Fields 3 CDS Views

Master Data Consolidation: Process Table for BUT021_FS

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BusPartAddressUsageProc view from BASIC Core View: Bus Part Addr Usage (Process)
I_BusPartProtectedAddressProc view from BASIC Core View: Protected Address (Process)
P_BPCurrentDefaultAddressProc view inner BASIC Business Partner current default address (Process)

Fields (16)

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 valid_to BU_ADVW_VALID_TO Valid To
KEY adr_kind BU_ADRKIND Address Type
KEY source_addrnumber AD_ADDRNUM Address Number
partner BU_PARTNER Busn. Partner
addrnumber AD_ADDRNUM Address Number
valid_from BU_ADVW_VALID_FROM Valid From
xdfadu BU_XDFADU Standard Usage
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 BUT021_FS
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT021_FS_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]
    VALID_TO,                  -- Valid To [BU_ADVW_VALID_TO]
    ADR_KIND,                  -- Address Type [BU_ADRKIND]
    SOURCE_ADDRNUMBER,         -- Address Number [AD_ADDRNUM]
    PARTNER,                   -- Busn. Partner [BU_PARTNER]
    ADDRNUMBER,                -- Address Number [AD_ADDRNUM]
    VALID_FROM,                -- Valid From [BU_ADVW_VALID_FROM]
    XDFADU,                    -- Standard Usage [BU_XDFADU]
    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, VALID_TO, ADR_KIND, SOURCE_ADDRNUMBER)
);

Learn More