PLSC

Transparent Table Application Table
26 Fields 1 CDS Views

Planning scenarios in long-term planning

PLSC is an SAP database table in S/4HANA. Planning scenarios in long-term planning. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPPlanningScenario view from BASIC MRP Planning Scenario

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plscn PLSCN Planning Scenario
psact PSACT Scenario Status
plsct PLSCT Plng Scenario Text
pdat1 PDAT1 Planning Start Date
pdat2 PDAT2 Planning End Date
mdate MDATE Key date
sbflg SBFLG Dep.reqmts
sstck SSTCK Opening stock
sstfl SSTFL Sim. plant stk
versa KAPVERSAKT Active Version
fixel FIXEL Incl.firm elmts
vrsio VRSIO Version
eisdt EISDT PURCHIS data
vsbco VRSIO_BCO ICO version
bcodt BCODT ICO data trnsfr
fixlo FIXLO NoPlngTimeFence
einpl EINPL Sing.it. plan
kdakz KDAKZ Sales order(s)
fbakz FBAKZ Firm purch.reqs
fpakz FPAFL Firm plnd ordrs
dirkz DIRKZ Direct Prodn
avmkz AVMKZ Without scrap
llskz LLSKZ With gross lot size
ltpls LTPLS LTP - lot size
ltpid LTPID Selection ID

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.

-- Planning scenarios in long-term planning
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLSC (
    MANDT,  -- Client [MANDT]
    PLSCN,  -- Planning Scenario [PLSCN]
    PSACT,  -- Scenario Status [PSACT]
    PLSCT,  -- Plng Scenario Text [PLSCT]
    PDAT1,  -- Planning Start Date [PDAT1]
    PDAT2,  -- Planning End Date [PDAT2]
    MDATE,  -- Key date [MDATE]
    SBFLG,  -- Dep.reqmts [SBFLG]
    SSTCK,  -- Opening stock [SSTCK]
    SSTFL,  -- Sim. plant stk [SSTFL]
    VERSA,  -- Active Version [KAPVERSAKT]
    FIXEL,  -- Incl.firm elmts [FIXEL]
    VRSIO,  -- Version [VRSIO]
    EISDT,  -- PURCHIS data [EISDT]
    VSBCO,  -- ICO version [VRSIO_BCO]
    BCODT,  -- ICO data trnsfr [BCODT]
    FIXLO,  -- NoPlngTimeFence [FIXLO]
    EINPL,  -- Sing.it. plan [EINPL]
    KDAKZ,  -- Sales order(s) [KDAKZ]
    FBAKZ,  -- Firm purch.reqs [FBAKZ]
    FPAKZ,  -- Firm plnd ordrs [FPAFL]
    DIRKZ,  -- Direct Prodn [DIRKZ]
    AVMKZ,  -- Without scrap [AVMKZ]
    LLSKZ,  -- With gross lot size [LLSKZ]
    LTPLS,  -- LTP - lot size [LTPLS]
    LTPID,  -- Selection ID [LTPID]
    PRIMARY KEY (MANDT, PLSCN)
);

Learn More