I_PROJECTBASICDATA

CDS View
32 Fields 49 CDS Views

Project Basic Data

I_PROJECTBASICDATA is a CDS View in S/4HANA. Project Basic Data. It contains 32 fields. 49 CDS views read from this table.

CDS Views using this table (49)

ViewTypeJoinVDMDescription
A_FinProject view from BASIC API FIN Project Definition Details
A_FinWBSElement view left_outer BASIC API FIN WBS Element Details
C_EvtBsdCostCtrlgProjectVH view from CONSUMPTION Project
C_EvtBsdRevnRecgnProjMonitor view inner CONSUMPTION EBRR Monitor: Project (2) - main CDS
C_ProjectFinCtrlrOvw view from CONSUMPTION Project Financial Controller Overview
C_RunOverheadProject view from CONSUMPTION Overhead Calculation Project
C_RunSettlementActualProject view from CONSUMPTION Project list for actual settlement
C_SettlementProjectVH view from CONSUMPTION Value Help for Settlement Project
FAC_AUDIT_Z3_PROJECT view from Project
FINOC_RT_PRO_FILL view inner Orgl Change: Fill Runtime for Projects
FINOC_RULE_WBS_DEFAULT_CE view inner OC: Default Rule WBS elmts, EPPM wR CE
I_JVAActualBudgetLineItem view left_outer COMPOSITE Actual Cost and JV Budget
I_PeggingAssignmentProjectVH view_entity from COMPOSITE Pegging Assignment Project
I_PPM_ProjJntVentureAccounting view inner COMPOSITE Extension for Joint Venture Accounting
I_ProjectBasicDataStdVH view_entity from BASIC Project Basic Data
I_ProjectByProjMgr view from COMPOSITE Project by Project Manager
I_ProjectByProjMgr view union_all COMPOSITE Project by Project Manager
I_ProjectByProjMgrVH view from COMPOSITE Project Definition Value Help
I_ProjectHierarchyRootData view_entity from COMPOSITE Project Hierarchy Root Data
I_ProjectObjectHierarchySource view from COMPOSITE Project Hierarchy Source
I_ProjectObjectHierarchySource view inner COMPOSITE Project Hierarchy Source
I_ProjectObjectHierDirSource view from COMPOSITE Hierarchy Directory Source
I_USFedProjectBasicDataVH view_entity from BASIC USFed Project Details
I_USFedProjectBasicDetail view_entity from BASIC Project Details
I_WBSElementSortHierNodeRltn view inner BASIC Parent Child Relationship for Sorting WBS
I_WBSElementSortHierNodeRltn_2 view inner BASIC Parent Child Relationship for Sort WBS
P_ActvPROJECTSWITHPROJCAT6 view from COMPOSITE
P_CnsldtnWBSElement view inner COMPOSITE
P_CnsldtnWBSElementT view inner COMPOSITE
P_EngmtProjActlCnvrsn view from COMPOSITE
P_EngmtProjActlPlnSlsOrd view inner COMPOSITE
P_GetParSemanticTagForProj view from COMPOSITE
P_OrglChgProjectUploadCheck view_entity inner COMPOSITE
P_PPM_Project view left_outer COMPOSITE
P_PPM_Prstcm_ProjData view left_outer CONSUMPTION
P_ProjActualCostLineItems view from COMPOSITE
P_ProjActualCostLineItems view union_all COMPOSITE
P_ProjCmtmtCostLineItms view from COMPOSITE
P_ProjCmtmtCostLineItms view union_all COMPOSITE
P_PROJECTFINBUDGETSMMRY view inner COMPOSITE
P_ProjectObject view from COMPOSITE
P_ProjectStockCostLineItem view from COMPOSITE Project Stock Cost line item
P_ProjectsWithProjCat6 view from COMPOSITE
P_ProjFinSmmryLnItems view from COMPOSITE
P_ProjPlnCostLineItms view from COMPOSITE
P_ProjPlnCostLineItms view union_all COMPOSITE
P_ProjSettlmtRuleProjBasicData view_entity inner COMPOSITE Settlement Rule for Project
P_WhereUsdPrftCtrProject view from CONSUMPTION
P_WPMO_PROJCOSTLINEITEMS view inner COMPOSITE

Fields (32)

KeyField CDS FieldsUsed in Views
KEY Project Project 9
KEY ProjectExternalID PartnerProject,Project,ProjectExternalID 11
KEY ProjectInternalID ProjectInternalID 11
KEY ProjectObject ProjectObject,ProjectObjectRootNode,StatusObject 12
_AvailabilityCtrlProfile _AvailabilityCtrlProfile 2
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 2
_ProfitCenter _ProfitCenter 2
_ProfitCenter2 _ProfitCenter2 2
_WBSElement _WBSElement 2
AvailabilityControlIsActive AvailabilityControlIsActive 11
AvailabilityControlProfile AvailabilityControlProfile 12
CompanyCode CompanyCode 8
ControllingArea ControllingArea 10
EntProjectSettlementType EntProjectSettlementType 1
EntProjHasProjectStockEnabled EntProjHasProjectStockEnabled 1
FunctionalArea FunctionalArea 3
JntIntrstBillgClass JntIntrstBillgClass 3
JntIntrstBillgSubClass JntIntrstBillgSubClass 3
JntVntrProjectType JntVntrProjectType 3
JointVenture JointVenture 3
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 3
JointVentureEquityType JointVentureEquityType 3
Location Location 3
PlannedEndDate PlannedEndDate 5
PlannedStartDate PlannedStartDate 5
Plant Plant 1
ProfitCenter ProfitCenter 10
ProjectCurrency ControllingObjectCurrency,Currency,ProjectCurrency 8
ProjectDescription ControllingObjectDescription,ProjectDescription 13
ProjectProfileCode ProjectProfileCode 10
TaxJurisdiction TaxJurisdiction 3

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 Basic Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTBASICDATA (
    PROJECT,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTOBJECT,
    _AVAILABILITYCTRLPROFILE,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _PROFITCENTER,
    _PROFITCENTER2,
    _WBSELEMENT,
    AVAILABILITYCONTROLISACTIVE,
    AVAILABILITYCONTROLPROFILE,
    COMPANYCODE,
    CONTROLLINGAREA,
    ENTPROJECTSETTLEMENTTYPE,
    ENTPROJHASPROJECTSTOCKENABLED,
    FUNCTIONALAREA,
    JNTINTRSTBILLGCLASS,
    JNTINTRSTBILLGSUBCLASS,
    JNTVNTRPROJECTTYPE,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYTYPE,
    LOCATION,
    PLANNEDENDDATE,
    PLANNEDSTARTDATE,
    PLANT,
    PROFITCENTER,
    PROJECTCURRENCY,
    PROJECTDESCRIPTION,
    PROJECTPROFILECODE,
    TAXJURISDICTION,
    PRIMARY KEY (PROJECT, PROJECTEXTERNALID, PROJECTINTERNALID, PROJECTOBJECT)
);

Learn More