ENTPROJELEM_D
Draft table for entity I_ENTERPRISEPROJECTELEMENTTP_2
ENTPROJELEM_D is an SAP database table in S/4HANA. Draft table for entity I_ENTERPRISEPROJECTELEMENTTP_2. It contains 57 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_CommlProjWorkPackageDraft | view_entity | from | EXTENSION | Comml Project WorkPackage - Extension |
| E_EntProjectElementDraft | view_entity | from | EXTENSION | Enterprise Project Element - Extension |
| R_EntProjectElementDraft | view_entity | from | BASIC | Draft query view for Enterprise Project Element |
Fields (57)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | projectelementuuid | /s4ppm/tv_entity_guid | Entity GUID | |||
| projectelement | /s4ppm/project_ele_id | Proj Element ID | ||||
| wbselementinternalid | ps_s4_pspnr | WBS Internal ID | ||||
| projectuuid | /s4ppm/tv_entity_guid | Entity GUID | ||||
| projectelementdescription | /s4ppm/tv_name | Name | ||||
| parentobjectuuid | /s4ppm/tv_parent_entity_guid | Parent GUID | ||||
| tasktemplateuuid | /s4ppm/tv_entity_guid | Entity GUID | ||||
| projectelementordinalnumber | /s4ppm/tv_sort_number | Sort Number | ||||
| processingstatus | dpr_tv_proc_status_own | Proc. Status | ||||
| isprojectmilestone | /s4ppm/ts_milestone | Milestone | ||||
| plannedstartdate | /s4ppm/tv_ltst_start_date | Latest Planned Start | ||||
| plannedenddate | /s4ppm/tv_ltst_end_date | Ltst Planned Finish | ||||
| actualstartdate | /s4ppm/tv_act_start_date | Actual Start | ||||
| actualenddate | /s4ppm/tv_act_end_date | Actual Finish | ||||
| responsiblecostcenter | ps_fkstl | Resp. cost cntr | ||||
| companycode | ps_pbukr | Company code | ||||
| profitcenter | prctr | Profit Center | ||||
| functionalarea | fkber | Functional Area | ||||
| controllingarea | ps_pkokr | CO area | ||||
| plant | werks_d | Plant | ||||
| location | ps_stort | Location | ||||
| taxjurisdiction | txjcd | Tax Jur. | ||||
| functionallocation | tplnr | Functional loc. | ||||
| entprojectelementtype | dpr_tv_tsk_type | Task Type | ||||
| factorycalendar | fabkl | Factory Calend. | ||||
| costingsheet | aufkalsm | Costing Sheet | ||||
| investmentprofile | im_profil | Invest. Profile | ||||
| wbsisstatisticalwbselement | ps_xstat | Statistical | ||||
| costcenter | ps_kostl | CCtr posted | ||||
| wbselementisbillingelement | ps_fakkz | Billing elem. | ||||
| resultanalysisinternalid | abgr_schl | RA Key | ||||
| leadingsalesorder | vbeln_va | Sales Document | ||||
| leadingsalesorderitem | posnr_va | Item | ||||
| entprojectelementobjecttype | dpr_tv_object_type | Object Category | ||||
| entprojectsettlementelement | ps_settlementelement | settlementElement | ||||
| entprojissettlmtruleinherited | ps_settlementruleinherited | Sttle Rule Inherited | ||||
| entprojprofitabilitysegment | /s4ppm/tv_profitabilitysegment | |||||
| createdbyuser | /s4ppm/tv_created_by | Created By | ||||
| creationdatetime | /s4ppm/tv_created_on | Created On | ||||
| lastchangedbyuser | /s4ppm/tv_changed_by | Changed By | ||||
| lastchangedatetime | /s4ppm/tv_changed_on | Changed On | ||||
| forecastedenddate | /s4ppm/tv_frcst_end_date | Forecasted Finish | ||||
| milestoneapprovalstatus | /s4ppm/tv_mlstn_apprvl_status | Milestone Apprvl Sts | ||||
| ismainmilestone | dpr_tv_milestone_is_essential | Main Milestone | ||||
| hierarchynode | abap.char | |||||
| hierarchyparentnode | abap.sstring | |||||
| hierarchydistancefromroot | abap.int4 | |||||
| hierarchydescendantcount | abap.int4 | |||||
| hierarchydrillstate | abap.char | |||||
| hierarchyrank | hum_hierarchy_rank | Hierarchy Rank | ||||
| hierarchylevel | abap.int4 | |||||
| entprojelmntdmndcpyisreqd | boole_d | TRUE | ||||
| entprojelmntsettlmtcpyisreqd | boole_d | TRUE | ||||
| entprojelmntdistributionoption | /s4ppm/tv_distributiontype | |||||
| projectcategory | dpr_tv_pro_category | Proj. Category | ||||
| enterpriseprojectserviceorg | /s4ppm/pws_ws_org_unit_id | Service Org. |
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.
-- Draft table for entity I_ENTERPRISEPROJECTELEMENTTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ENTPROJELEM_D (
MANDT, -- Client [mandt]
PROJECTELEMENTUUID, -- Entity GUID [/s4ppm/tv_entity_guid]
PROJECTELEMENT, -- Proj Element ID [/s4ppm/project_ele_id]
WBSELEMENTINTERNALID, -- WBS Internal ID [ps_s4_pspnr]
PROJECTUUID, -- Entity GUID [/s4ppm/tv_entity_guid]
PROJECTELEMENTDESCRIPTION, -- Name [/s4ppm/tv_name]
PARENTOBJECTUUID, -- Parent GUID [/s4ppm/tv_parent_entity_guid]
TASKTEMPLATEUUID, -- Entity GUID [/s4ppm/tv_entity_guid]
PROJECTELEMENTORDINALNUMBER, -- Sort Number [/s4ppm/tv_sort_number]
PROCESSINGSTATUS, -- Proc. Status [dpr_tv_proc_status_own]
ISPROJECTMILESTONE, -- Milestone [/s4ppm/ts_milestone]
PLANNEDSTARTDATE, -- Latest Planned Start [/s4ppm/tv_ltst_start_date]
PLANNEDENDDATE, -- Ltst Planned Finish [/s4ppm/tv_ltst_end_date]
ACTUALSTARTDATE, -- Actual Start [/s4ppm/tv_act_start_date]
ACTUALENDDATE, -- Actual Finish [/s4ppm/tv_act_end_date]
RESPONSIBLECOSTCENTER, -- Resp. cost cntr [ps_fkstl]
COMPANYCODE, -- Company code [ps_pbukr]
PROFITCENTER, -- Profit Center [prctr]
FUNCTIONALAREA, -- Functional Area [fkber]
CONTROLLINGAREA, -- CO area [ps_pkokr]
PLANT, -- Plant [werks_d]
LOCATION, -- Location [ps_stort]
TAXJURISDICTION, -- Tax Jur. [txjcd]
FUNCTIONALLOCATION, -- Functional loc. [tplnr]
ENTPROJECTELEMENTTYPE, -- Task Type [dpr_tv_tsk_type]
FACTORYCALENDAR, -- Factory Calend. [fabkl]
COSTINGSHEET, -- Costing Sheet [aufkalsm]
INVESTMENTPROFILE, -- Invest. Profile [im_profil]
WBSISSTATISTICALWBSELEMENT, -- Statistical [ps_xstat]
COSTCENTER, -- CCtr posted [ps_kostl]
WBSELEMENTISBILLINGELEMENT, -- Billing elem. [ps_fakkz]
RESULTANALYSISINTERNALID, -- RA Key [abgr_schl]
LEADINGSALESORDER, -- Sales Document [vbeln_va]
LEADINGSALESORDERITEM, -- Item [posnr_va]
ENTPROJECTELEMENTOBJECTTYPE, -- Object Category [dpr_tv_object_type]
ENTPROJECTSETTLEMENTELEMENT, -- settlementElement [ps_settlementelement]
ENTPROJISSETTLMTRULEINHERITED, -- Sttle Rule Inherited [ps_settlementruleinherited]
ENTPROJPROFITABILITYSEGMENT, -- /s4ppm/tv_profitabilitysegment
CREATEDBYUSER, -- Created By [/s4ppm/tv_created_by]
CREATIONDATETIME, -- Created On [/s4ppm/tv_created_on]
LASTCHANGEDBYUSER, -- Changed By [/s4ppm/tv_changed_by]
LASTCHANGEDATETIME, -- Changed On [/s4ppm/tv_changed_on]
FORECASTEDENDDATE, -- Forecasted Finish [/s4ppm/tv_frcst_end_date]
MILESTONEAPPROVALSTATUS, -- Milestone Apprvl Sts [/s4ppm/tv_mlstn_apprvl_status]
ISMAINMILESTONE, -- Main Milestone [dpr_tv_milestone_is_essential]
HIERARCHYNODE, -- abap.char
HIERARCHYPARENTNODE, -- abap.sstring
HIERARCHYDISTANCEFROMROOT, -- abap.int4
HIERARCHYDESCENDANTCOUNT, -- abap.int4
HIERARCHYDRILLSTATE, -- abap.char
HIERARCHYRANK, -- Hierarchy Rank [hum_hierarchy_rank]
HIERARCHYLEVEL, -- abap.int4
ENTPROJELMNTDMNDCPYISREQD, -- TRUE [boole_d]
ENTPROJELMNTSETTLMTCPYISREQD, -- TRUE [boole_d]
ENTPROJELMNTDISTRIBUTIONOPTION, -- /s4ppm/tv_distributiontype
PROJECTCATEGORY, -- Proj. Category [dpr_tv_pro_category]
ENTERPRISEPROJECTSERVICEORG, -- Service Org. [/s4ppm/pws_ws_org_unit_id]
PRIMARY KEY (MANDT, PROJECTELEMENTUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA