I_PROJECT

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);