RTC_DRL

Transparent Table Application Table

Real-Time Consolidation: Data Release Lock

RTC_DRL is an SAP database table in S/4HANA. Real-Time Consolidation: Data Release Lock. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DRLAll view from BASIC

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY model RTC_CON_MODEL Model
KEY verid RTC_VERID Version ID
KEY fyear RTC_GYEAR Fiscal Year
KEY fperi RTC_POPER Fiscal Period
KEY entity RTC_ENTITY Entity
KEY dr_method RTC_DR_METHOD_NAME Data Release Method
KEY dr_pkg RTC_DR_PKG_ID DR. Package ID
status RTC_DR_LOCK_STATUS Lock Status
etime RTC_DR_LOCK_ETIME Effective Time
fiscyearper JAHRPER Period/Year
bpc_catg FCOM_CATEGORY Plan Category
createdby RTC_CREATOR Created By
createdat RTC_TIMESTAMP_C Time Created
changedby RTC_MODIFYIER Changed By
changedat RTC_TIMESTAMP_M Time Changed

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.

-- Real-Time Consolidation: Data Release Lock
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RTC_DRL (
    MANDT,        -- Client [MANDT]
    MODEL,        -- Model [RTC_CON_MODEL]
    VERID,        -- Version ID [RTC_VERID]
    FYEAR,        -- Fiscal Year [RTC_GYEAR]
    FPERI,        -- Fiscal Period [RTC_POPER]
    ENTITY,       -- Entity [RTC_ENTITY]
    DR_METHOD,    -- Data Release Method [RTC_DR_METHOD_NAME]
    DR_PKG,       -- DR. Package ID [RTC_DR_PKG_ID]
    STATUS,       -- Lock Status [RTC_DR_LOCK_STATUS]
    ETIME,        -- Effective Time [RTC_DR_LOCK_ETIME]
    FISCYEARPER,  -- Period/Year [JAHRPER]
    BPC_CATG,     -- Plan Category [FCOM_CATEGORY]
    CREATEDBY,    -- Created By [RTC_CREATOR]
    CREATEDAT,    -- Time Created [RTC_TIMESTAMP_C]
    CHANGEDBY,    -- Changed By [RTC_MODIFYIER]
    CHANGEDAT,    -- Time Changed [RTC_TIMESTAMP_M]
    PRIMARY KEY (MANDT, MODEL, VERID, FYEAR, FPERI, ENTITY, DR_METHOD, DR_PKG)
);