BUT000_PRC

Transparent Table Application Table
12 Fields 2 CDS Views

Master Data Consolidation: Process Table for BUT000

BUT000_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for BUT000. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BusinessPartnerProcess view from EXTENSION Extension View for Extensibility of BUT000_PRC
I_BusinessPartnerProcess view from BASIC Business Partner Process

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
partner bu_partner Busn. Partner
valid_from bu_bp_valid_from Valid From
valid_to bu_bp_valid_to Valid To
xpcpt bu_xpcpt Purpose Completed
natpers bu_natural_person Natural Person
validation_status mdc_validation_status Status
source_recency mdc_recency Last Changed On
source_filter mdc_source_filter Data Package
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 BUT000
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT000_PRC (
    CLIENT,                    -- Client [mandt]
    PARTNER,                   -- Busn. Partner [bu_partner]
    VALID_FROM,                -- Valid From [bu_bp_valid_from]
    VALID_TO,                  -- Valid To [bu_bp_valid_to]
    XPCPT,                     -- Purpose Completed [bu_xpcpt]
    NATPERS,                   -- Natural Person [bu_natural_person]
    VALIDATION_STATUS,         -- Status [mdc_validation_status]
    SOURCE_RECENCY,            -- Last Changed On [mdc_recency]
    SOURCE_FILTER,             -- Data Package [mdc_source_filter]
    SOURCE_MODIFIED,           -- Modified [mdc_source_modified]
    SOURCE_MODIFICATION_BLIP,  -- Modification [mdc_modification_blip]
    SOURCE_INDEX,              -- Index [mdc_source_index]
    PRIMARY KEY (CLIENT)
);

Learn More