PPSCH_RSCE_DETS

Transparent Table Application Table
16 Fields 2 CDS Views

Details of Resource/Timestream in Live Cache

PPSCH_RSCE_DETS is an SAP database table in S/4HANA. Details of Resource/Timestream in Live Cache. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SchedProdnRsceDets view from BASIC Resource Details
P_SchedProdnRsceDets view from BASIC

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY simsession PPSCH_SIMSESSIONID Simulation Session ID
KEY workcenter ARBPL Work Center
KEY rsceid PPH_CFS_SCH_RSCE_ID Resource ID for Schedule Production
KEY plant WERKS_D Plant
workcenterinternalid CR_OBJID Object ID
workcentertypecode CR_OBJTY Object Type
ismain_workcenter PPSCH_MAIN_WORKCENTER_IND Is Main Work Center
sched_wokrcentertype PPSCH_SCHED_WOKRCENTERTYPE Schedule Production Work Center Type
from_date DATUM Date
to_date DATUM Date
tzone TZNZONE Time Zone
created_by ERNAM Created By
changed_by AENAM Changed By
created_time TIMESTAMP Time Stamp
changed_time TIMESTAMP Time Stamp

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.

-- Details of Resource/Timestream in Live Cache
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPSCH_RSCE_DETS (
    MANDT,                 -- Client [MANDT]
    SIMSESSION,            -- Simulation Session ID [PPSCH_SIMSESSIONID]
    WORKCENTER,            -- Work Center [ARBPL]
    RSCEID,                -- Resource ID for Schedule Production [PPH_CFS_SCH_RSCE_ID]
    PLANT,                 -- Plant [WERKS_D]
    WORKCENTERINTERNALID,  -- Object ID [CR_OBJID]
    WORKCENTERTYPECODE,    -- Object Type [CR_OBJTY]
    ISMAIN_WORKCENTER,     -- Is Main Work Center [PPSCH_MAIN_WORKCENTER_IND]
    SCHED_WOKRCENTERTYPE,  -- Schedule Production Work Center Type [PPSCH_SCHED_WOKRCENTERTYPE]
    FROM_DATE,             -- Date [DATUM]
    TO_DATE,               -- Date [DATUM]
    TZONE,                 -- Time Zone [TZNZONE]
    CREATED_BY,            -- Created By [ERNAM]
    CHANGED_BY,            -- Changed By [AENAM]
    CREATED_TIME,          -- Time Stamp [TIMESTAMP]
    CHANGED_TIME,          -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, SIMSESSION, WORKCENTER, RSCEID, PLANT)
);

Learn More