I_ProjectData

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_ProjectData.
-- 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_ProjectData AS
SELECT
  cast ( proj.pspnr as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  proj.pspid_edit AS ProjectExternalID,
  cast ( proj.pspid as ps_p_pspid preserving type ) 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.stort AS WorkCenterLocation,
  proj.txjcd AS TaxJurisdiction,
  proj.vernr AS ResponsiblePerson,
  cast ( proj.verna as ps_s4_verna ) AS ResponsiblePersonName,
  cast ( proj.astnr as ps_s4_astnr ) AS ApplicantCode,
  proj.astna AS ApplicantName,
  proj.ernam AS CreatedByUser,
  proj.erdat AS CreationDate,
  proj.aenam AS LastChangedByUser,
  cast ( proj.aedat as ps_s4_aedat ) AS LastChangeDate,
  proj.aedte AS BasicDatesLastScheduledDate,
  cast ( proj.aedtp as ps_aedtp ) AS FcstdDatesLastScheduledDate,
  cast ( proj.kalid as appca ) AS FactoryCalendar,
  cast ( proj.zteht as cgpl_duration_unit ) AS SchedulingDurationUnit,
  cast ( proj.vgsbr as gsber ) AS BusinessArea,
  proj.werks AS Plant,
  cast ( proj.pwhie as ps_pwhie ) AS Currency,
  proj.bprof AS BudgetProfile,
  proj.pprof AS PlanningProfile,
  proj.imprf AS InvestmentProfile,
  cast ( proj.zschm as ps_zschm ) AS ProjInterestCalcProfile,
  proj.abgsl AS ResultAnalysisInternalID,
  proj.pargr AS PartnerDeterminationProcedure,
  cast ( proj.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  proj.vprof AS NetworkProfile,
  cast ( proj.scprf as ps_s4_schdprf ) AS WBSSchedulingProfile,
  cast ( proj.vgplf as ps_s4_vgplf preserving type ) AS PlanningMethForProjBasicDate,
  cast ( proj.ewplf as ps_s4_ewplf preserving type ) AS PlanningMethForProjFcstdDate,
  proj.zuord AS NetworkAssignmentType,
  proj.xstat AS WBSIsStatisticalWBSElement,
  proj.plint AS WBSIsMarkedForIntegratedPlng,
  cast ( proj.besta as psb_stock ) AS ProjectHasOwnStock,
  proj.kzbws AS InventorySpecialStockValnType,
  proj.grtop AS WBSIsMarkedForAutomReqmtGrpg,
  proj.vkorg AS SalesOrganization,
  proj.vtweg AS DistributionChannel,
  proj.txtsp AS Language,
  proj.kimsk AS WBSElementExternalID,
  proj.spart AS Division,
  proj.dppprof AS DynItemProcessorPrfl,
  proj.stspd AS StatusProfile,
  proj.stspr AS WBSStatusProfile,
  proj.smprf AS SimulationProfile,
  proj.schtyp AS SchedulingScenario,
  proj.pgprf AS DistributionProfile,
  proj.vname AS JointVenture,
  proj.recid AS JointVentureCostRecoveryCode,
  proj.etype AS JointVentureEquityType,
  proj.otype AS JointVentureObjectType,
  proj.jibcl AS JntIntrstBillgClass,
  proj.jibsa AS JntIntrstBillgSubClass,
  proj.slwid AS FreeDefinedTableFieldSemantic,
  cast ( proj.usr00 as usr00prps preserving type ) AS FreeDefinedAttribute01,
  cast ( proj.usr01 as usr01prps preserving type ) AS FreeDefinedAttribute02,
  cast ( proj.usr02 as usr02prps preserving type ) AS FreeDefinedAttribute03,
  cast ( proj.usr03 as usr03prps preserving type ) AS FreeDefinedAttribute04,
  cast ( proj.usr04 as usr04prps preserving type ) AS FreeDefinedQuantity1,
  cast ( proj.use04 as use04prps preserving type ) AS FreeDefinedQuantity1Unit,
  cast ( proj.usr05 as usr05prps preserving type ) AS FreeDefinedQuantity2,
  cast ( proj.use05 as use05prps preserving type ) AS FreeDefinedQuantity2Unit,
  cast ( proj.usr06 as abap.curr( 10, 2 ) ) AS FreeDefinedAmount1,
  cast ( proj.use06 as use06prps preserving type ) AS FreeDefinedAmount1Currency,
  cast ( proj.usr07 as abap.curr( 10, 2 ) ) AS FreeDefinedAmount2,
  cast ( proj.use07 as use07prps preserving type ) AS FreeDefinedAmount2Currency,
  cast ( proj.usr08 as usr08prps preserving type ) AS FreeDefinedDate1,
  cast ( proj.usr09 as usr09prps preserving type ) AS FreeDefinedDate2,
  cast ( proj.usr10 as usr10prps preserving type ) AS FreeDefinedIndicator1,
  cast ( proj.usr11 as usr11prps preserving type ) AS FreeDefinedIndicator2
FROM proj
LEFT OUTER JOIN I_WBSElementData 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  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProjectProfileCode AS _ProjectProfileCode ON ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode  -- association [1..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_ProjectObjectShortText AS _ProjectShortText ON _ProjectShortText.Language = $session.system_language AND _ProjectShortText.ProjectApplicationIdentifier = 'PS' AND _ProjectShortText.ProjectObjectType = 'PD' AND ProjectObject = _ProjectShortText.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN E_Project_2 AS _Extension ON ProjectInternalID = _Extension.ProjectInternalID  -- association [1..1]
;