PRPSS

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.

-- Standard WBS Element (WBS element) - Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRPSS (
    MANDT,       -- Client [MANDT]
    PSPNR,       -- Std WBS element [PS_SPSNR]
    POSID,       -- Std WBS Element [PS_SPSID]
    POST1,       -- Description [PS_POST1]
    OBJNR,       -- Object number [J_OBJNR]
    PSPHI,       -- Current proj.no [PS_ISPSP]
    POSKI,       -- Short ID [PS_POSKI]
    ERNAM,       -- Created By [ERNAM]
    ERDAT,       -- Created On [ERDAT]
    AENAM,       -- Changed By [AENAM]
    AEDAT,       -- Changed on [UPDAT]
    VERNR,       -- Pers.Resp.No. [PS_VERNR]
    VERNA,       -- Pers.Resp.Name [PS_VERNA]
    ASTNR,       -- Applicant no. [PS_ASTNR]
    ASTNA,       -- Applicant [PS_ASTNA]
    PBUKR,       -- Company code [PS_PBUKR]
    PGSBR,       -- Bus.area [PS_PGSBR]
    PKOKR,       -- CO area [PS_PKOKR]
    PRCTR,       -- Profit Center [PRCTR]
    PRART,       -- Proj.type [PS_PRART]
    STUFE,       -- Level [PS_STUFE]
    PLAKZ,       -- Planning elem [PS_PLAKZ]
    BELKZ,       -- AA element [PS_BELKZ]
    FAKKZ,       -- Billing elem. [PS_FAKKZ]
    NPFAZ,       -- Network/order [PS_NPFAR]
    ZUORD,       -- Network asst [PS_ZUORD]
    TRMEQ,       -- Activity dates [PS_TRMEQ]
    KVEWE,       -- Usage [KVEWE]
    KAPPL,       -- Application [KAPPL]
    KALSM,       -- Costing Sheet [AUFKALSM]
    ZSCHL,       -- Overhead key [AUFZSCHL]
    ABGSL,       -- RA Key [ABGR_SCHL]
    AKOKR,       -- CA (requesting) [PS_AKOKR]
    AKSTL,       -- Req.cost center [PS_AKSTL]
    FKOKR,       -- CA (resp.) [PS_FKOKR]
    FKSTL,       -- Resp. cost cntr [PS_FKSTL]
    FABKL,       -- Factory Calend. [FABKL]
    PSPRI,       -- Priority [PS_PRIOR]
    EQUNR,       -- Equipment [EQUNR]
    TPLNR,       -- Functional loc. [TPLNR]
    PWPOS,       -- Currency [PS_PWPOS]
    WERKS,       -- Plant [WERKS_D]
    TXTSP,       -- Language [SPRAS]
    SLWID,       -- Field key [SLWID]
    USR00,       -- Ufield 1 WBS [USR00PRPS]
    USR01,       -- Ufield 2 WBS [USR01PRPS]
    USR02,       -- Ufield 3 WBS [USR02PRPS]
    USR03,       -- Ufield 4 WBS [USR03PRPS]
    USR04,       -- UF Qnty 1 WBS [USR04PRPS]
    USE04,       -- UF unit 1 WBS [USE04PRPS]
    USR05,       -- UF Qty 2 WBS [USR05PRPS]
    USE05,       -- UF unit 2 WBS [USE05PRPS]
    USR06,       -- UF value 1 WBS [USR06PRPS]
    USE06,       -- UF unit 1 WBS [USE06PRPS]
    USR07,       -- UF value 2 WBS [USR07PRPS]
    USE07,       -- UF unit 2 WBS [USE07PRPS]
    USR08,       -- UF date 1 WBS [USR08PRPS]
    USR09,       -- UF date 2 WBS [USR09PRPS]
    USR10,       -- UF INd. 1 WBS [USR10PRPS]
    USR11,       -- UF INd. 2 WBS [USR11PRPS]
    KOSTL,       -- CCtr posted [PS_KOSTL]
    KTRG,        -- Cost Object [KSTRG]
    BERST,       -- Mstr data auth. [PS_BERST]
    BERTR,       -- Date auth. [PS_BERTR]
    BERKO,       -- Costs/rev. auth [PS_BERKO]
    BERBU,       -- Budget auth. [PS_BERBU]
    CLASF,       -- Project sum. [PS_CLASF]
    SPSNR,       -- Std WBS element [PS_SPSNR]
    SCOPE,       -- Object Class [SCOPE_CV]
    XSTAT,       -- Statistical [PS_XSTAT]
    TXJCD,       -- Tax Jur. [TXJCD]
    ZSCHM,       -- Interest Prof. [PS_ZSCHM]
    IMPRF,       -- Invest. Profile [IM_PROFIL]
    EVGEW,       -- POC weight [EV_WEIGHTD]
    AENNR,       -- Change Number [AENNR]
    SUBPR,       -- Subproject [PS_SUBPR]
    POSTU,       -- Description [PS_POSTU]
    PLINT,       -- Integ. Planning [PLINT]
    LOEVM,       -- Delete [LOEVM]
    KZBWS,       -- Valuation [KZBWS]
    GRPKZ,       -- Grouping WBS el [GRPSPKZ]
    PGPRF,       -- Distri. profile [PGPROFID]
    STORT,       -- Location [PS_STORT]
    FUNC_AREA,   -- Functional Area [FKBER]
    POSID_EDIT,  -- Std WBS Element [PS_SPSID_EDIT]
    VNAME,       -- Joint venture [JV_NAME]
    RECID,       -- Recovery Ind. [JV_RECIND]
    ETYPE,       -- Equity Type [JV_ETYPE]
    OTYPE,       -- JV Object Type [JV_OTYPE]
    JIBCL,       -- JIB/JIBE Class [JV_JIBCL]
    JIBSA,       -- JIB/JIBE SbClsA [JV_JIBSA]
    ADPSP,       -- Ref. Element PM/PS [ADDCOMPARE_CORE]
    PRIMARY KEY (MANDT, PSPNR)
);