I_ProjectBasicData

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProjectBasicData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProjectBasicData AS
SELECT
  cast ( proj.pspnr as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  proj.pspid_edit AS ProjectExternalID,
  proj.pspid AS Project,
  cast ( proj.post1 as ps_s4_proj_post1_v1 preserving type) AS ProjectDescription,
  proj.profl AS ProjectProfileCode,
  cast ( proj.vbukr as bukrs preserving type ) AS CompanyCode,
  cast ( proj.vkokr as kokrs preserving type ) AS ControllingArea,
  cast ( proj.func_area as fkber preserving type ) AS FunctionalArea,
  proj.prctr AS ProfitCenter,
  proj.objnr AS ProjectObject,
  proj.plfaz AS PlannedStartDate,
  proj.plsez AS PlannedEndDate,
  proj.avc_profile AS AvailabilityControlProfile,
  proj.avc_active AS AvailabilityControlIsActive,
  proj.vname AS JointVenture,
  proj.recid AS JointVentureCostRecoveryCode,
  proj.etype AS JointVentureEquityType,
  proj.otype AS JntVntrProjectType,
  proj.jibcl AS JntIntrstBillgClass,
  proj.jibsa AS JntIntrstBillgSubClass,
  proj.stort AS Location,
  proj.cpcurr AS ProjectCurrency,
  proj.txjcd AS TaxJurisdiction,
  proj.settlementtype AS EntProjectSettlementType,
  proj.besta AS EntProjHasProjectStockEnabled,
  proj.werks AS Plant,
  proj.oba_active AS ObjBasedAuthorizationIsActive
FROM proj
LEFT OUTER JOIN I_WBSElementBasicData AS _RootWBSElement ON ProjectInternalID = _RootWBSElement.ProjectInternalID AND ProjectExternalID = _RootWBSElement.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON ProjectInternalID = _WBSElement.ProjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND PlannedStartDate <= _ProfitCenter.ValidityEndDate AND PlannedStartDate >= _ProfitCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter2 ON ControllingArea = _ProfitCenter2.ControllingArea AND ProfitCenter = _ProfitCenter2.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_AvailabilityCtrlProfile AS _AvailabilityCtrlProfile ON AvailabilityControlProfile = _AvailabilityCtrlProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_EntProjectSettlementType AS _EntProjectSettlementType ON EntProjectSettlementType = _EntProjectSettlementType.EntProjectSettlementType  -- association [0..1]
;