I_PROJECT
Project Definition Details
I_PROJECT is a CDS View in S/4HANA. Project Definition Details. It contains 83 fields. 42 CDS views read from this table.
CDS Views using this table (42)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_Project | view | from | BASIC | API Project Definition Details(OBSOLETE) |
| C_ProjectGraphOverview | view_entity | from | CONSUMPTION | Project Graph Overview |
| C_ReExAssignProject | view | from | CONSUMPTION | Project |
| fins_trr_ps_manager_vernr | view | from | Project Manager Value Help | |
| I_CnsldtnMasterData | view | union_all | COMPOSITE | Consolidation - Combined Master Data |
| I_MajorAssemblyProjectStatus | view | from | COMPOSITE | To get Project Status Description |
| I_ManageProjectForEndItem | view | inner | COMPOSITE | Project Details For End Item |
| I_MPNetwork | view | inner | COMPOSITE | Get Master Project Network |
| I_MPWBSElement | view | inner | COMPOSITE | Get Master Project WBS Elements |
| I_MstrProjItmProjStrucNode | view | from | COMPOSITE | Project Structure Node Master Project |
| I_MstrProjItmProjStrucNode | view | union | COMPOSITE | Project Structure Node Master Project |
| I_MstrProjStrctrElmntWBC | view | inner | COMPOSITE | Master Project Structure Element for WBC |
| I_MstrProjStructure | view | inner | COMPOSITE | Master Project Structure Element |
| I_MstrProjStructureElement | view | inner | COMPOSITE | Master Project Structure Element |
| I_MstrProjWBSElement | view | inner | COMPOSITE | PROJECT COMPANION WBS ELEM |
| I_PPM_CurrentPeriod | view | from | COMPOSITE | Current period for a project |
| I_PPM_PrStCmrActvProjCostCht | view | from | COMPOSITE | Provider view for cost to date chart |
| I_ProjectByInternalKey | view | from | BASIC | Project Definition Details By Internal ID |
| I_ProjectValueHelp | view | from | COMPOSITE | Project Definition Value Help |
| I_ProjectWithCodingMaskVH | view | from | COMPOSITE | Value help for project with coding mask |
| P_CnsldtnProject | view | from | COMPOSITE | |
| P_CnsldtnProjectT | view | from | COMPOSITE | |
| P_EntProjProjectRespPersn | view | from | COMPOSITE | Enterprise Project Responsible Person |
| P_EvtBsdRevnRecgnProjWIPItm | view | inner | COMPOSITE | |
| P_Mpnwe | view | inner | COMPOSITE | |
| P_Mpwbs | view | inner | COMPOSITE | |
| P_MstrProjActuals | view | inner | COMPOSITE | |
| P_MstrProjChklstReferenceDoc | view | union | COMPOSITE | |
| P_MstrProjHierarchy | view | inner | COMPOSITE | |
| P_MstrProjStructure | view | union | COMPOSITE | |
| P_MstrProjWIP | view | inner | COMPOSITE | |
| P_PPM_ProjCostMappingWBS | view | inner | COMPOSITE | |
| P_ProjectManagerValueHelp | view | from | COMPOSITE | |
| P_ProjectRespPerson | view | from | COMPOSITE | Project Responsible Person |
| P_Projectwipdetailbasic | view | inner | COMPOSITE | |
| P_ProjectWithVersion | view | union_all | COMPOSITE | |
| P_ProjScheduleProjectAttrib | view | from | COMPOSITE | |
| SHSM_CN_LDST_SH_PD | view | from | Operative Proj Definition via External Number | |
| SHSM_CN_LDST_SH_PR | view | inner | Search for Operative WBS Elements via External Number | |
| SHSM_V_PRSMP | view | from | cds view for search help PRSMP | |
| SHSM_V_PRSMW | view | from | cds view for search help PRSMW | |
| SHSM_V_PRSMZ | view | from | cds view for the search help PRSMZ |
Fields (83)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | bukrs,CompanyCode | 7 |
| KEY | Project | Project,PspId | 17 |
| KEY | ProjectInternalID | ProjectInternalID,PspNr | 9 |
| KEY | ProjectObject | ControllingObject,ProjectObject | 7 |
| KEY | ProjectWithCodingMask | Project,ProjectWithCodingMask,pspid_edit | 4 |
| KEY | ResponsiblePerson | PersonnelNumber,ProjectResponsiblePerson,ResponsiblePerson,vernr | 13 |
| _BusinessArea | _BusinessArea | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingObjectClass | _ControllingObjectClass | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _EntProjProjectRespPersn | _EntProjProjectRespPersn | 3 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _NetworkProfile | _NetworkProfile | 1 | |
| _Plant | _Plant | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjBasicDatePlanMethName | _ProjBasicDatePlanMethName | 1 | |
| _ProjectApplicant | _ProjectApplicant | 6 | |
| _ProjectProfileCode | _ProjectProfileCode | 1 | |
| _ProjectShortText | _ProjectShortText | 1 | |
| _ProjFcstdDatePlanMethName | _ProjFcstdDatePlanMethName | 1 | |
| _ProjInterestCalcProfile | _ProjInterestCalcProfile | 1 | |
| _ResponsiblePerson | _ResponsiblePerson | 8 | |
| _TaxJurisdiction | _TaxJurisdiction | 1 | |
| _Wbsschedulingprofile | _Wbsschedulingprofile | 1 | |
| ApplicantCode | ApplicantCode | 6 | |
| ApplicantName | ApplicantName | 1 | |
| BasicDatesLastScheduledDate | BasicDatesLastScheduledDate | 2 | |
| BudgetProfile | BudgetProfile | 1 | |
| BusinessArea | BusinessArea | 5 | |
| ControllingArea | ControllingArea,kokrs | 11 | |
| ControllingObjectClass | ControllingObjectClass | 1 | |
| CostCenter | CostCenter | 2 | |
| CostObject | CostObject | 2 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| Currency | ControllingObjectCurrency,Currency | 3 | |
| DistributionChannel | DistributionChannel | 2 | |
| Division | Division | 2 | |
| DynItemProcessorPrfl | DynItemProcessorPrfl | 1 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| FcstdDatesLastScheduledDate | FcstdDatesLastScheduledDate | 2 | |
| ForecastedEndDate | ForecastedEndDate | 2 | |
| ForecastedStartDate | ForecastedStartDate | 2 | |
| FunctionalArea | FunctionalArea | 2 | |
| InventorySpecialStockValnType | InventorySpecialStockValnType | 1 | |
| InvestmentProfile | InvestmentProfile | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| JointVenture | JointVenture | 1 | |
| JointVentureClass | JointVentureClass | 1 | |
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | 1 | |
| JointVentureEquityType | JointVentureEquityType | 1 | |
| JointVentureObjectType | JointVentureObjectType | 1 | |
| JointVentureSubClass | JointVentureSubClass | 1 | |
| Language | Language | 3 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| NetworkAssignmentType | NetworkAssignmentType | 1 | |
| NetworkHdrIsVisibleToUser | NetworkHdrIsVisibleToUser | 1 | |
| NetworkProfile | NetworkProfile | 1 | |
| PaymentPlanProfile | PaymentPlanProfile | 1 | |
| PlannedEndDate | PlannedEndDate | 2 | |
| PlannedStartDate | PlannedStartDate | 2 | |
| PlanningMethForProjBasicDate | PlanningMethForProjBasicDate | 1 | |
| PlanningMethForProjFcstdDate | PlanningMethForProjFcstdDate | 1 | |
| PlanningProfile | PlanningProfile | 1 | |
| Plant | Plant | 2 | |
| ProfitCenter | ProfitCenter | 8 | |
| ProjectDescription | ObjectName,Post1,ProjectDescription | 14 | |
| ProjectHasOwnStock | ProjectHasOwnStock | 1 | |
| ProjectProfileCode | ProjectProfileCode | 1 | |
| ProjInterestCalcProfile | ProjInterestCalcProfile | 1 | |
| ResponsiblePersonName | ResponsiblePersonName,verna | 7 | |
| ResultAnalysisInternalID | ResultAnalysisInternalID | 1 | |
| SalesOrganization | SalesOrganization | 2 | |
| SchedulingDurationUnit | SchedulingDurationUnit | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| WBSElmntDatesIsDetailed | WBSElmntDatesIsDetailed | 1 | |
| WBSIsMarkedForAutomReqmtGrpg | WBSIsMarkedForAutomReqmtGrpg | 1 | |
| WBSIsMarkedForIntegratedPlng | WBSIsMarkedForIntegratedPlng | 1 | |
| WBSIsStatisticalWBSElement | WBSIsStatisticalWBSElement | 1 | |
| WBSSchedulingProfile | WBSSchedulingProfile | 1 | |
| WorkCenterLocation | WorkCenterLocation | 1 |
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.
-- Project Definition Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECT (
COMPANYCODE,
PROJECT,
PROJECTINTERNALID,
PROJECTOBJECT,
PROJECTWITHCODINGMASK,
RESPONSIBLEPERSON,
_BUSINESSAREA,
_COMPANYCODE,
_CONTROLLINGAREA,
_CONTROLLINGOBJECTCLASS,
_COSTCENTER,
_ENTPROJPROJECTRESPPERSN,
_FUNCTIONALAREA,
_NETWORKPROFILE,
_PLANT,
_PROFITCENTER,
_PROJBASICDATEPLANMETHNAME,
_PROJECTAPPLICANT,
_PROJECTPROFILECODE,
_PROJECTSHORTTEXT,
_PROJFCSTDDATEPLANMETHNAME,
_PROJINTERESTCALCPROFILE,
_RESPONSIBLEPERSON,
_TAXJURISDICTION,
_WBSSCHEDULINGPROFILE,
APPLICANTCODE,
APPLICANTNAME,
BASICDATESLASTSCHEDULEDDATE,
BUDGETPROFILE,
BUSINESSAREA,
CONTROLLINGAREA,
CONTROLLINGOBJECTCLASS,
COSTCENTER,
COSTOBJECT,
CREATEDBYUSER,
CREATIONDATE,
CURRENCY,
DISTRIBUTIONCHANNEL,
DIVISION,
DYNITEMPROCESSORPRFL,
FACTORYCALENDAR,
FCSTDDATESLASTSCHEDULEDDATE,
FORECASTEDENDDATE,
FORECASTEDSTARTDATE,
FUNCTIONALAREA,
INVENTORYSPECIALSTOCKVALNTYPE,
INVESTMENTPROFILE,
ISMARKEDFORDELETION,
JOINTVENTURE,
JOINTVENTURECLASS,
JOINTVENTURECOSTRECOVERYCODE,
JOINTVENTUREEQUITYTYPE,
JOINTVENTUREOBJECTTYPE,
JOINTVENTURESUBCLASS,
LANGUAGE,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
NETWORKASSIGNMENTTYPE,
NETWORKHDRISVISIBLETOUSER,
NETWORKPROFILE,
PAYMENTPLANPROFILE,
PLANNEDENDDATE,
PLANNEDSTARTDATE,
PLANNINGMETHFORPROJBASICDATE,
PLANNINGMETHFORPROJFCSTDDATE,
PLANNINGPROFILE,
PLANT,
PROFITCENTER,
PROJECTDESCRIPTION,
PROJECTHASOWNSTOCK,
PROJECTPROFILECODE,
PROJINTERESTCALCPROFILE,
RESPONSIBLEPERSONNAME,
RESULTANALYSISINTERNALID,
SALESORGANIZATION,
SCHEDULINGDURATIONUNIT,
TAXJURISDICTION,
WBSELMNTDATESISDETAILED,
WBSISMARKEDFORAUTOMREQMTGRPG,
WBSISMARKEDFORINTEGRATEDPLNG,
WBSISSTATISTICALWBSELEMENT,
WBSSCHEDULINGPROFILE,
WORKCENTERLOCATION,
PRIMARY KEY (COMPANYCODE, PROJECT, PROJECTINTERNALID, PROJECTOBJECT, PROJECTWITHCODINGMASK, RESPONSIBLEPERSON)
);
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