I_ENTERPRISEPROJECT
Enterprise Project
I_ENTERPRISEPROJECT is a CDS View in S/4HANA. Enterprise Project. It contains 23 fields. 37 CDS views read from this table.
CDS Views using this table (37)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BSOrdProcFlwEntProject | view | from | CONSUMPTION | Customer Project Attrib for BSOrd Prgrs |
| C_CreditMemoReqItemWBSElmntVH | view_entity | inner | CONSUMPTION | CMR WBS Element By ExternalID |
| C_EntProjectProfnlSrvcVH | view | from | CONSUMPTION | Enterprise Project for Professional Services |
| C_EntProjectRankingProjectVH | view | from | CONSUMPTION | Ent. Project Ranking Project Value Help |
| C_EntProjProfnlSrvcProjKPIs | view_entity | from | CONSUMPTION | Enterprise Project Header KPIs |
| C_ProjBillgCustomerProjectDets | view_entity | from | CONSUMPTION | Project Details |
| C_ProjBillgCustProjBillableVH | view_entity | from | CONSUMPTION | Srch help for billable customer projects |
| C_ProjDmndProjectDisplay | view | from | CONSUMPTION | Project Details |
| C_SlsDocItemWBSElementVH | view | inner | CONSUMPTION | WBSElement By ExternalID |
| I_EntProjElemChgDocuments | view | inner | COMPOSITE | Chg Doc for Project Elements of Ent Proj |
| I_EntProjProfnlSrvcsProj | view_entity | from | COMPOSITE | Professional Services Projects |
| I_EntProjProfnlSrvcsProjVH | view_entity | from | COMPOSITE | Professional Services Projects |
| I_EntProjProjectChgDocuments | view | inner | COMPOSITE | Chg Doc for General Info of Ent Proj |
| I_EntProjProjectRespPersn | view | inner | BASIC | Responsible Person for Project Header |
| I_EntProjSimilarProjBscData | view | left_outer | COMPOSITE | Interface view for the Similar Projects |
| I_EntProjStsAreaChgDocuments | view | inner | COMPOSITE | Chg Doc for Status Area of Ent Proj |
| I_EntProjTeamChgDocuments | view | inner | COMPOSITE | Chg Doc for Team tab of Ent Proj |
| I_EntProjUserRoleAssignment | view_entity | from | COMPOSITE | Role assignments of the current user in a project |
| I_PPM_ProjCostByFiscalPeriod | view | from | COMPOSITE | Project Costs by Fiscal Period |
| I_PPM_ProjectCostSumOvrl | view | from | COMPOSITE | Project Cost To Date |
| P_BusSolnOrdEntProjectFlwLvl2 | view | inner | CONSUMPTION | Solution Order Enterprise Project Flow: Level 2 |
| P_EnterpriseProject_F7479 | view_entity | from | COMPOSITE | Enterprise Project for App F7479 |
| P_EntPrjProfnlSrvcPrjActlKPIs | view_entity | from | COMPOSITE | Basic CDS view for Actuals KPIs |
| P_EntPrjProfnlSrvcRecgdRevnDoc | view_entity | from | COMPOSITE | Professional Service Recognized Revenue |
| P_EntProjAccCtrlListCompare | view_entity | inner | COMPOSITE | Compare old and new ACL |
| P_EntProjCostLineItems | view | left_outer | COMPOSITE | Enterprise Project Cost Line Items |
| P_EntProjProfnlSrvcCostRevenue | view_entity | from | COMPOSITE | Prj. Cost & Revn in Transaction Currency |
| P_EntProjSDM2522 | view_entity | inner | COMPOSITE | SDM: Private CDS View |
| P_PROJACTUALBUDGETLINEITEMS | view | from | COMPOSITE | Project Budget Actuals |
| P_ProjBillgCustomerProjectDets | view_entity | from | COMPOSITE | Project Billing Customer Project Details |
| P_ProjBillgCustProjVH | view_entity | from | COMPOSITE | Search help for customer project |
| P_ProjectBudgetItems | view | left_outer | COMPOSITE | Project Budget Items |
| P_ProjectFinBdgtSummary | view | inner | COMPOSITE | Project Financial Budget Summary |
| P_PROJECTFINBUDGETSMMRY | view | union_all | COMPOSITE | Project Financial Budget Summary |
| P_ProjPlnBudgetLineItms | view | from | COMPOSITE | Project Budget Plan |
| P_WorkPackageList | view | inner | COMPOSITE | WorkPackages List (Including PPM) |
| R_EntProjElmntBlockFuncTP | view | inner | TRANSACTIONAL | Transactional Processing for proj elmnt block function |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 9 |
| KEY | ControllingArea | ControllingArea | 7 |
| KEY | FunctionalArea | FunctionalArea | 8 |
| KEY | ProfitCenter | ProfitCenter | 6 |
| KEY | Project | Project,ProjectExternalID,UI5NetworkGraphAttributeValue | 14 |
| KEY | ProjectInternalID | ProjectInternalID | 6 |
| KEY | ProjectUUID | ProjectUUID | 13 |
| _AuthGroup | _AuthGroup | 1 | |
| _AuthRole | _AuthRole | 1 | |
| _AuthSubst | _AuthSubst | 1 | |
| _AuthUser | _AuthUser | 1 | |
| AvailabilityControlIsActive | AvailabilityControlIsActive | 1 | |
| AvailabilityControlProfile | AvailabilityControlProfile | 1 | |
| Currency | Currency,ProjectCurrency | 2 | |
| EnterpriseProjectType | EnterpriseProjectType,ProjectType | 9 | |
| Plant | Plant | 6 | |
| ProcessingStatus | ProcessingStatus | 6 | |
| ProjectDescription | ProjectDescription,ProjectName | 6 | |
| ProjectEndDate | ProjectEndDate | 2 | |
| ProjectProfileCode | ProjectProfileCode | 7 | |
| ProjectStartDate | ProjectStartDate | 2 | |
| ProjectSummaryTaskUUID | ProjectSummaryTaskUUID,TaskUUID | 11 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 8 |
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.
-- Enterprise Project
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ENTERPRISEPROJECT (
COMPANYCODE,
CONTROLLINGAREA,
FUNCTIONALAREA,
PROFITCENTER,
PROJECT,
PROJECTINTERNALID,
PROJECTUUID,
_AUTHGROUP,
_AUTHROLE,
_AUTHSUBST,
_AUTHUSER,
AVAILABILITYCONTROLISACTIVE,
AVAILABILITYCONTROLPROFILE,
CURRENCY,
ENTERPRISEPROJECTTYPE,
PLANT,
PROCESSINGSTATUS,
PROJECTDESCRIPTION,
PROJECTENDDATE,
PROJECTPROFILECODE,
PROJECTSTARTDATE,
PROJECTSUMMARYTASKUUID,
RESPONSIBLECOSTCENTER,
PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, FUNCTIONALAREA, PROFITCENTER, PROJECT, PROJECTINTERNALID, PROJECTUUID)
);
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