PRTE

Transparent Table Application Table
31 Fields 4 CDS Views

Scheduling Data for Project Item

PRTE is an SAP database table in S/4HANA. Scheduling Data for Project Item. It contains 31 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_Standardwbselement view left_outer BASIC Standard WBS Element Details
I_WBSElement view left_outer BASIC WBS Element Details
I_WBSElementByExternalID view left_outer BASIC WBSElement By ExternalID
P_ObjectStatus view left_outer BASIC

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY posnr PS_POSNR WBS Element
psphi PS_PSPHI Current proj no
pstrt PS_PSTRT_CHG Basic start
estrt PS_ESTRT Forecast Start
istrt PS_ISTRT Actual start
pende PS_PENDE_CHG Basic finish
eende PS_EENDE Forecast End
iende PS_IENDE Actual finish
pdaur PS_PDAUR Basic dates dur
edaur PS_EDAUR Fcst duration
idaur PS_IDAUR Actual duration
ieinh PS_IEINH Unit of measure
eeinh PS_EEINH Unit of measure
peinh PS_PEINH Unit of measure
flgvg PS_FLGVG Dates from act.
flgew PS_FLGEW Expected dates
flgem PS_FLGEM Expected dates
flgvm PS_FLGVM Expected dates
flgim PS_FLGIM Manual actual
flgvi PS_FLGVI Actual dates
pstrm PS_GSTRS Earliest start
petrm PS_GLTRS Latest finish
estrm PS_GSTPP Earliest start
eetrm PS_GLTPP Latest Finish
vistr PS_ISTVORL Tent.Act.Start
viend PS_IENVORL Act.Fin.(Tent.)
pstrs PS_GSTRE LatestBasicStrt
petrf PS_GETRE EarlBasicFinish
estrs PS_GSTRP Latest start
eetrf PS_GLTRP Earliest finish

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.

-- Scheduling Data for Project Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRTE (
    MANDT,  -- Client [MANDT]
    POSNR,  -- WBS Element [PS_POSNR]
    PSPHI,  -- Current proj no [PS_PSPHI]
    PSTRT,  -- Basic start [PS_PSTRT_CHG]
    ESTRT,  -- Forecast Start [PS_ESTRT]
    ISTRT,  -- Actual start [PS_ISTRT]
    PENDE,  -- Basic finish [PS_PENDE_CHG]
    EENDE,  -- Forecast End [PS_EENDE]
    IENDE,  -- Actual finish [PS_IENDE]
    PDAUR,  -- Basic dates dur [PS_PDAUR]
    EDAUR,  -- Fcst duration [PS_EDAUR]
    IDAUR,  -- Actual duration [PS_IDAUR]
    IEINH,  -- Unit of measure [PS_IEINH]
    EEINH,  -- Unit of measure [PS_EEINH]
    PEINH,  -- Unit of measure [PS_PEINH]
    FLGVG,  -- Dates from act. [PS_FLGVG]
    FLGEW,  -- Expected dates [PS_FLGEW]
    FLGEM,  -- Expected dates [PS_FLGEM]
    FLGVM,  -- Expected dates [PS_FLGVM]
    FLGIM,  -- Manual actual [PS_FLGIM]
    FLGVI,  -- Actual dates [PS_FLGVI]
    PSTRM,  -- Earliest start [PS_GSTRS]
    PETRM,  -- Latest finish [PS_GLTRS]
    ESTRM,  -- Earliest start [PS_GSTPP]
    EETRM,  -- Latest Finish [PS_GLTPP]
    VISTR,  -- Tent.Act.Start [PS_ISTVORL]
    VIEND,  -- Act.Fin.(Tent.) [PS_IENVORL]
    PSTRS,  -- LatestBasicStrt [PS_GSTRE]
    PETRF,  -- EarlBasicFinish [PS_GETRE]
    ESTRS,  -- Latest start [PS_GSTRP]
    EETRF,  -- Earliest finish [PS_GLTRP]
    PRIMARY KEY (MANDT, POSNR)
);

Learn More