BUT050_TD_PRC

Transparent Table Application Table
26 Fields 1 CDS Views

MDC: Process table BUT050 Time Dependent + general data

BUT050_TD_PRC is an SAP database table in S/4HANA. MDC: Process table BUT050 Time Dependent + general data. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusPartRelshpTmeDpndcyProc view_entity from BASIC BP Relationship Time Dependency Proc

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 date_to BU_DATTO Valid To
date_from BU_DATFROM Valid From
reltyp BU_RELTYP Relationsh.Cat.
xrf BU_XRF Role definition
dftval BU_DFTVAL Diff.type char.
rltyp BU_RLTYPE BP role
relkind BU_RELKIND RelationshpType
crusr BU_CRUSR Created by
crdat BU_CRDAT Created On
crtim BU_CRTIM Created at
chusr BU_CHUSR Changed by
chdat BU_CHDAT Changed on
chtim BU_CHTIM Changed at
xdfrel BU_XDFREL Standard
xdfrel2 BU_XDFREL Standard
db_key BUP_SETGUID SETGUID
db_key_td BUP_SETGUID SETGUID
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.

-- MDC: Process table BUT050 Time Dependent + general data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT050_TD_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]
    DATE_TO,                   -- Valid To [BU_DATTO]
    DATE_FROM,                 -- Valid From [BU_DATFROM]
    RELTYP,                    -- Relationsh.Cat. [BU_RELTYP]
    XRF,                       -- Role definition [BU_XRF]
    DFTVAL,                    -- Diff.type char. [BU_DFTVAL]
    RLTYP,                     -- BP role [BU_RLTYPE]
    RELKIND,                   -- RelationshpType [BU_RELKIND]
    CRUSR,                     -- Created by [BU_CRUSR]
    CRDAT,                     -- Created On [BU_CRDAT]
    CRTIM,                     -- Created at [BU_CRTIM]
    CHUSR,                     -- Changed by [BU_CHUSR]
    CHDAT,                     -- Changed on [BU_CHDAT]
    CHTIM,                     -- Changed at [BU_CHTIM]
    XDFREL,                    -- Standard [BU_XDFREL]
    XDFREL2,                   -- Standard [BU_XDFREL]
    DB_KEY,                    -- SETGUID [BUP_SETGUID]
    DB_KEY_TD,                 -- SETGUID [BUP_SETGUID]
    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, DATE_TO)
);

Learn More