PRPS

Transparent Table Application Table
128 Fields 63 CDS Views

WBS (Work Breakdown Structure) Element Master Data

PRPS is an SAP database table in S/4HANA. WBS (Work Breakdown Structure) Element Master Data. It contains 128 fields. 63 CDS views read from this table.

CDS Views using this table (63)

ViewTypeJoinVDMDescription
ACE_ACEDSASSGMTC view left_outer Compatibility view for ACEDSASSGMT
ACE_ACESOBJ_ASSGMT view left_outer View From ACEOBJ ACEPSOH ACEDSASSGMT
Adk0_Dli_Wip_Detail_View view inner DLI WIP Detail View for WBS Elements
CTE_CDS_FIN_MON_PJ view inner CDS View for Monotoring Project WBS Element export to Concur
E_WBSElement view from EXTENSION WBS Element - Extension Include
E_WBSElement_2 view from EXTENSION WBS Element - Extension Include
FAC_PURCHASE_ORDER_VH view left_outer Purchase order value help
fco_avc_ps_bdgt view inner Availy Ctrl for PS: Budget
FCO_COR_HSL_DER view left_outer HSL Corr. for Stat. Records in CO: Derivation of CurrKey
Fco_Mig_Check_Coep11_L2 view left_outer Check ACDOCA-records against COEP-records with WRTTP=11
FCO_MIG_DERIV_P view left_outer CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields
fcov_cost_rate_mig view left_outer Activity prices in ACCOSTRATE format
FINOC_CHECK_REC_01_PRCTRS view_entity left_outer Org. Change: PRCTRS of RE Contracts
FINOC_CHECK_REC_01_REC_TO_ALL view_entity left_outer Org. Change: From RE Contract to All
FINOC_CHECK_REC_01_WBS_TO_REC view_entity inner Org. Change: From WBS El. to RE Contract
FINOC_PCK_CPRJE view inner OrglChange: Customer Projects Element
FINOC_PCK_CPRJP view inner OrglChange: Customer Projects Project
FINOC_PCK_EPRJE view inner OrglChange: EPPM Project Element
FINOC_PCK_EPRJP view inner OrglChange: EPPM Projects from Runtime
FINOC_RULE_NWA_EXAMPLE view inner Organizational Change: Customer Rule NWA
FINOC_RULE_WBS_BASE view from Orgl Change-Rule: WBS Elements Base
fins_prctr_of_object_acdoca view left_outer Derive PRCTR & PPRCTR for ACDOCA object
Fins_Rev_Rec_Posid_Recon view inner Search for changed PS_POSID in ACDOCA
I_EnterpriseProject view inner BASIC Enterprise Project
I_SrvcDocWBSElementVH view from BASIC WBS Search Help
I_TravelWBSElementVH view inner BASIC Travel Request WBS Element
I_WBSElement view from BASIC WBS Element Details
I_WBSElementBasicData view_entity from BASIC WBS Element Basic Data
I_WBSElementByExternalID view from BASIC WBSElement By ExternalID
I_WBSElementData view from BASIC WBSElement Data
I_WBSElementData_2 view from BASIC Appl interface for WBS Element Details
I_WBSElementHierarchyNode view union_all BASIC WBS Element Hierarchy Node
P_Combapbilling view inner BASIC
P_Comfpbilling view left_outer BASIC
P_CURRENTMATLVALNPRICE view left_outer BASIC
P_EntProjSdm238 view_entity inner BASIC SDM: Private CDS View for Project Name
P_Ml_Prices_Ckml view left_outer BASIC
P_ObjectStatus view from BASIC
P_ONRPR view inner BASIC
P_Projectwiprevdetlbasic view inner BASIC
P_Ra_Objects view left_outer BASIC
P_Trrmanaccruals view inner COMPOSITE
P_Trrmonbaseplan view from COMPOSITE
PIR_UNION_HEAD_ALL view left_outer All PIR Headers
R_EnterpriseProject view_entity inner BASIC Enterprise Project Internal
SHSM_M_AUKOF view inner View for matchcode ID AUKO-F
SHSM_M_MBANP view inner Purchase Requisitions for Project
SHSM_V_PRPMA view inner cds view for search help PRPMA
SHSM_V_PRPMB view inner cds view for search help PRPMB
SHSM_V_PRPMK view inner cds view for search help PRPMK
SHSM_V_PRPMP view inner cds view for search help PRPMP
SHSM_V_PRPMW view inner WBS Element Wildcard, Project Definition, Descrpt., Respons.
SHSM_V_PRPVW view inner WBS Ele Wildcard,ProjDef,Descript,Respon
SHSM_V_PRPWA view inner View for Search Help PRPWA
SHSM_V_PRPWB view inner View for Search Help PRPWB
SHSM_V_PRPWP view inner View for Search Help PRPWP
SHSM_V_PRPWW view inner View for Search Help PRPWW
v_coep_l1_view view left_outer LOCAL: Line Items COEP for statistical postings
V_Coep_R1_view view left_outer COEP revised version - part 1
v_coep_v2_l1a_view view left_outer LOCAL: Line Items COEP for statistical postings
v_coep_v2_l1b_view view left_outer LOCAL: Line Items COEP for statistical postings
v_ml_account_l2_view view left_outer LOCAL: Material Ledger Periods
v_ml_invacc_l1_view view left_outer Inventory stock - accounts

Fields (128)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pspnr PS_POSNR WBS Element
posid PS_POSID WBS Element
post1 PS_POST1 Description
objnr J_OBJNR Object number
psphi PS_PSPHI Current proj no
poski PS_POSKI Short ID
ernam ERNAM Created By
erdat ERDAT Created On
aenam AENAM Changed By
aedat UPDAT Changed on
vernr PS_VERNR Pers.Resp.No.
verna PS_VERNA Pers.Resp.Name
astnr PS_ASTNR Applicant no.
astna PS_ASTNA Applicant
pbukr PS_PBUKR Company code
pgsbr PS_PGSBR Bus.area
pkokr PS_PKOKR CO area
prctr PRCTR Profit Center
prart PS_PRART Proj.type
stufe PS_STUFE Level
plakz PS_PLAKZ Planning elem
belkz PS_BELKZ AA element
fakkz PS_FAKKZ Billing elem.
npfaz PS_NPFAR Network/order
zuord PS_ZUORD Network asst
trmeq PS_TRMEQ Activity dates
kvewe KVEWE Usage
kappl KAPPL Application
kalsm AUFKALSM Costing Sheet
zschl AUFZSCHL Overhead key
abgsl ABGR_SCHL RA Key
akokr PS_AKOKR CA (requesting)
akstl PS_AKSTL Req.cost center
fkokr PS_FKOKR CA (resp.)
fkstl PS_FKSTL Resp. cost cntr
fabkl FABKL Factory Calend.
pspri NW_PRIO Priority
equnr EQUNR Equipment
tplnr TPLNR Functional loc.
pwpos PS_PWPOS Currency
werks WERKS_D Plant
txtsp SPRAS Language
slwid SLWID Field key
usr00 USR00PRPS Ufield 1 WBS
usr01 USR01PRPS Ufield 2 WBS
usr02 USR02PRPS Ufield 3 WBS
usr03 USR03PRPS Ufield 4 WBS
usr04 USR04PRPS UF Qnty 1 WBS
use04 USE04PRPS UF unit 1 WBS
usr05 USR05PRPS UF Qty 2 WBS
use05 USE05PRPS UF unit 2 WBS
usr06 USR06PRPS UF value 1 WBS
use06 USE06PRPS UF unit 1 WBS
usr07 USR07PRPS UF value 2 WBS
use07 USE07PRPS UF unit 2 WBS
usr08 USR08PRPS UF date 1 WBS
usr09 USR09PRPS UF date 2 WBS
usr10 USR10PRPS UF INd. 1 WBS
usr11 USR11PRPS UF INd. 2 WBS
kostl PS_KOSTL CCtr posted
ktrg KSTRG Cost Object
berst PS_BERST Mstr data auth.
bertr PS_BERTR Date auth.
berko PS_BERKO Costs/rev. auth
berbu PS_BERBU Budget auth.
clasf PS_CLASF Project sum.
spsnr PS_SPSNR Std WBS element
scope SCOPE_CV Object Class
xstat PS_XSTAT Statistical
txjcd TXJCD Tax Jur.
zschm PS_ZSCHM Interest Prof.
imprf IM_PROFIL Invest. Profile
evgew EV_WEIGHTD POC weight
aennr AENNR Change Number
subpr PS_SUBPR Subproject
postu PS_POSTU Description
plint PLINT Integ. Planning
loevm LOEVM Delete
kzbws KZBWS Valuation
fplnr FPLNR Bill. Plan No.
tadat TABGDAT Tech. complete
izwek IZWEK Invest. Reason
isize IM_SIZECL Scale
iumkz AM_UMWKZ Envir. Invest.
abukr IM_ABUKRS Req. co.code
grpkz GRPSPKZ Grouping WBS el
pgprf PGPROFID Distri. profile
logsystem LOGSYSTEM Logical System
pspnr_logs NUM08 Num. field (8)
stort PS_STORT Location
func_area FKBER Functional Area
klvar CK_KLVAR Costing Variant
kalnr CK_KALNR Cost EstimateNo
posid_edit PS_POSID_EDIT WBS Element
pspkz PL_PSPKZ Production lot
matnr MATNR Material
vlpsp PL_PSP_PNR Ref.WBS element
vlpkz PL_VLPKZ Reference WBS
sort1 PL_SORT1 Sort string 1
sort2 PL_SORT2 Sort string 2
sort3 PL_SORT3 Sort string 3
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
etype JV_ETYPE Equity Type
otype JV_OTYPE JV Object Type
jibcl JV_JIBCL JIB/JIBE Class
jibsa JV_JIBSA JIB/JIBE SbClsA
cgpl_guid16 CGPL_GUID16_R3 CGPL_GUID
cgpl_logsys CGPL_LOGSYS Logical system
cgpl_objtype CGPL_OBJECT_TYPE_R3 Object Type
adpsp ADDCOMPARE_CORE Ref. Element PM/PS
rfippnt CN_RPIP Reference Point
eew_prps_ps_dummy DUMMY Dummy function in length 1
rfund BP_GEBER Fund
rgrant_nbr GM_GRANT_NBR Grant
fund_fix_assign PSM_FUND_FIX_ASSIGNED Fund Fixed Assignment
grant_fix_assigned PSM_GRANT_FIX_ASSIGNED Grant Fixed Assignment
func_area_fix_assigned PSM_FUNC_AREA_FIX_ASSIGNED Functional Area Fixed Assignment
sponsoredprog GM_SPONSORED_PROG Sponsored Program
settlementelement PS_SETTLEMENTELEMENT settlementElement
settlmtruleinherited PS_SETTLEMENTRULEINHERITED Sttle Rule Inherited
settlementobject PS_SETTLEMENTOBJECT Settlement Object
cpd_updat /CPD/PFP_SC_TSTMP Time Stamp
ferc_ind FE_IND Reg. indicator
prps_status ACTCMB_DELE Status Comb
posnr_prps POSNR_VA Item
vbeln_prps VBELN_VA Sales Document

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.

-- WBS (Work Breakdown Structure) Element Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRPS (
    MANDT,                   -- Client [MANDT]
    PSPNR,                   -- WBS Element [PS_POSNR]
    POSID,                   -- WBS Element [PS_POSID]
    POST1,                   -- Description [PS_POST1]
    OBJNR,                   -- Object number [J_OBJNR]
    PSPHI,                   -- Current proj no [PS_PSPHI]
    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 [NW_PRIO]
    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]
    FPLNR,                   -- Bill. Plan No. [FPLNR]
    TADAT,                   -- Tech. complete [TABGDAT]
    IZWEK,                   -- Invest. Reason [IZWEK]
    ISIZE,                   -- Scale [IM_SIZECL]
    IUMKZ,                   -- Envir. Invest. [AM_UMWKZ]
    ABUKR,                   -- Req. co.code [IM_ABUKRS]
    GRPKZ,                   -- Grouping WBS el [GRPSPKZ]
    PGPRF,                   -- Distri. profile [PGPROFID]
    LOGSYSTEM,               -- Logical System [LOGSYSTEM]
    PSPNR_LOGS,              -- Num. field (8) [NUM08]
    STORT,                   -- Location [PS_STORT]
    FUNC_AREA,               -- Functional Area [FKBER]
    KLVAR,                   -- Costing Variant [CK_KLVAR]
    KALNR,                   -- Cost EstimateNo [CK_KALNR]
    POSID_EDIT,              -- WBS Element [PS_POSID_EDIT]
    PSPKZ,                   -- Production lot [PL_PSPKZ]
    MATNR,                   -- Material [MATNR]
    VLPSP,                   -- Ref.WBS element [PL_PSP_PNR]
    VLPKZ,                   -- Reference WBS [PL_VLPKZ]
    SORT1,                   -- Sort string 1 [PL_SORT1]
    SORT2,                   -- Sort string 2 [PL_SORT2]
    SORT3,                   -- Sort string 3 [PL_SORT3]
    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]
    CGPL_GUID16,             -- CGPL_GUID [CGPL_GUID16_R3]
    CGPL_LOGSYS,             -- Logical system [CGPL_LOGSYS]
    CGPL_OBJTYPE,            -- Object Type [CGPL_OBJECT_TYPE_R3]
    ADPSP,                   -- Ref. Element PM/PS [ADDCOMPARE_CORE]
    RFIPPNT,                 -- Reference Point [CN_RPIP]
    EEW_PRPS_PS_DUMMY,       -- Dummy function in length 1 [DUMMY]
    RFUND,                   -- Fund [BP_GEBER]
    RGRANT_NBR,              -- Grant [GM_GRANT_NBR]
    FUND_FIX_ASSIGN,         -- Fund Fixed Assignment [PSM_FUND_FIX_ASSIGNED]
    GRANT_FIX_ASSIGNED,      -- Grant Fixed Assignment [PSM_GRANT_FIX_ASSIGNED]
    FUNC_AREA_FIX_ASSIGNED,  -- Functional Area Fixed Assignment [PSM_FUNC_AREA_FIX_ASSIGNED]
    SPONSOREDPROG,           -- Sponsored Program [GM_SPONSORED_PROG]
    SETTLEMENTELEMENT,       -- settlementElement [PS_SETTLEMENTELEMENT]
    SETTLMTRULEINHERITED,    -- Sttle Rule Inherited [PS_SETTLEMENTRULEINHERITED]
    SETTLEMENTOBJECT,        -- Settlement Object [PS_SETTLEMENTOBJECT]
    CPD_UPDAT,               -- Time Stamp [/CPD/PFP_SC_TSTMP]
    FERC_IND,                -- Reg. indicator [FE_IND]
    PRPS_STATUS,             -- Status Comb [ACTCMB_DELE]
    POSNR_PRPS,              -- Item [POSNR_VA]
    VBELN_PRPS,              -- Sales Document [VBELN_VA]
    PRIMARY KEY (MANDT, PSPNR)
);

Learn More