I_WBSElementData_2

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_WBSElementData_2.
-- 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_WBSElementData_2 AS
SELECT
  cast ( prps.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  prps.posid_edit AS WBSElementExternalID,
  cast ( prps.posid as ps_posid_edit preserving type ) AS WBSElement,
  prps.poski AS WBSElementShortID,
  cast ( prps.post1 as ps_s4_post1 preserving type ) AS WBSDescription,
  cast ( prps.vernr as ps_s4_vernr preserving type ) AS ResponsiblePerson,
  cast ( prps.verna as ps_s4_verna preserving type ) AS ResponsiblePersonName,
  cast ( prps.astnr as ps_s4_astnr preserving type ) AS ApplicantCode,
  prps.astna AS ApplicantName,
  cast ( prps.pbukr as bukrs preserving type ) AS CompanyCode,
  cast ( prps.pgsbr as gsber preserving type ) AS BusinessArea,
  cast ( prps.pkokr as ps_s4_kokrs preserving type ) AS ControllingArea,
  cast ( prps.func_area as fkber preserving type ) AS FunctionalArea,
  prps.prctr AS ProfitCenter,
  cast ( prps.fkstl as ps_s4_fkstl preserving type ) AS ResponsibleCostCenter,
  prps.werks AS Plant,
  prps.slwid AS FreeDefinedTableFieldSemantic,
  cast ( prps.fabkl as stkal preserving type ) AS FactoryCalendar,
  cast ( prps.pspri as nw_prio preserving type ) AS PriorityCode,
  cast ( prps.pwpos as ps_pwpos preserving type ) AS Currency,
  prps.kalsm AS CostingSheet,
  cast ( prps.kostl as ps_kostl preserving type ) AS CostCenter,
  cast ( prps.akstl as ps_s4_akstl preserving type ) AS RequestingCostCenter,
  cast ( prps.psphi as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  cast ( prps.fakkz as ps_fakkz preserving type ) AS WBSElementIsBillingElement,
  prps.objnr AS WBSElementObject,
  prps.imprf AS InvestmentProfile,
  prps.xstat AS WBSIsStatisticalWBSElement,
  cast ( prps.belkz as ps_s4_belkz preserving type ) AS WBSIsAccountAssignmentElement,
  prps.prart AS ProjectType,
  cast ( prps.plakz as ps_plakz preserving type ) AS WBSElementIsPlanningElement,
  prps.stort AS WorkCenterLocation,
  prps.abgsl AS ResultAnalysisInternalID,
  prps.txjcd AS TaxJurisdiction,
  cast ( prps.tplnr as tplnr_unconverted preserving type ) AS FunctionalLocation,
  prps.ernam AS CreatedByUser,
  prps.erdat AS CreationDate,
  prps.aenam AS LastChangedByUser,
  prps.aedat AS LastChangeDate,
  prps.fkokr AS RespCostCenterControllingArea,
  cast ( prps.plint as plint_t preserving type ) AS WBSIsMarkedForIntegratedPlng,
  prps.equnr AS Equipment,
  prps.aennr AS ProjectObjectChangeNumber,
  prps.stufe AS WBSElementHierarchyLevel,
  cast ( prps.zschl as fin_ovhkey preserving type ) AS OverheadCode,
  cast ( prps.adpsp as ps_s4_addcompare_core preserving type ) AS ReferenceElement,
  prps.zschm AS ProjInterestCalcProfile,
  cast ( prps.evgew as ev_weightd preserving type ) AS ProgressAnlysAggregationWeight,
  prps.akokr AS ReqgCostCenterControllingArea,
  prps.txtsp AS Language,
  cast( prps.loevm as ps_s4_loevm ) AS IsMarkedForDeletion,
  prps.grpkz AS WBSElementIsGroupingWBSElement,
  prps.clasf AS WBSElementIsUsedInProjSmmry,
  prps.klvar AS CostingVariant,
  cast ( prte.pstrt as ps_s4_pstrt preserving type ) AS BasicStartDate,
  cast ( prte.istrt as ps_s4_istrt preserving type ) AS ActualStartDate,
  cast ( prte.pende as ps_s4_pende preserving type ) AS BasicEndDate,
  cast ( prte.iende as ps_s4_iende preserving type ) AS ActualEndDate,
  prps.tadat AS TechnicalCompletionDate,
  cast ( prte.pdaur as ps_s4_pdaur preserving type ) AS BasicDuration,
  cast ( prte.peinh as ps_s4_peinh preserving type ) AS BasicDurationUnit,
  cast ( prte.idaur as ps_s4_idaur preserving type ) AS ActualDuration,
  cast ( prte.ieinh as ps_ieinh preserving type ) AS ActualDurationUnit,
  cast ( prte.pstrm as ps_gstrs preserving type ) AS SchedldBasicEarliestStartDate,
  cast ( prte.petrm as ps_s4_gltrs preserving type ) AS ScheduledBasicLatestEndDate,
  cast ( prte.estrm as ps_s4_gstpp preserving type ) AS SchedldFcstdEarliestStartDate,
  cast ( prte.eetrm as ps_s4_gltpp preserving type ) AS LatestSchedldFcstdEndDate,
  cast ( prte.vistr as ps_s4_istvorl preserving type ) AS TentativeActualStartDate,
  cast ( prte.viend as ps_s4_ienvorl preserving type ) AS TentativeActualEndDate,
  prps.vname AS JointVenture,
  prps.recid AS JointVentureCostRecoveryCode,
  prps.etype AS JointVentureEquityType,
  prps.otype AS JntVntrProjectType,
  prps.jibcl AS JntIntrstBillgClass,
  prps.jibsa AS JntIntrstBillgSubClass,
  prps.subpr AS SubProject,
  prps.izwek AS InvestmentReason,
  prps.isize AS InvestmentScale,
  prps.iumkz AS EnvironmentalInvestmentReason,
  prps.abukr AS RequestingCompanyCode,
  prps.zuord AS NetworkAssignmentType,
  prps.ktrg AS CostObject,
  prps.fplnr AS BillingPlan,
  cast ( prps.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  cast ( prps.usr00 as usr00prps preserving type ) AS FreeDefinedAttribute01,
  cast ( prps.usr01 as usr01prps preserving type ) AS FreeDefinedAttribute02,
  cast ( prps.usr02 as usr02prps preserving type ) AS FreeDefinedAttribute03,
  cast ( prps.usr03 as usr03prps preserving type ) AS FreeDefinedAttribute04,
  cast ( prps.usr04 as usr04prps preserving type ) AS FreeDefinedQuantity1,
  cast ( prps.use04 as use04prps preserving type ) AS FreeDefinedQuantity1Unit,
  cast ( prps.usr05 as usr05prps preserving type ) AS FreeDefinedQuantity2,
  cast ( prps.use05 as use05prps preserving type ) AS FreeDefinedQuantity2Unit,
  cast( cast ( prps.usr06 * 10 as abap.curr(14,2) ) as abap.curr(13,2) ) AS FreeDefinedAmount1,
  cast ( prps.use06 as use06prps preserving type ) AS FreeDefinedAmount1Currency,
  cast( cast ( prps.usr07 * 10 as abap.curr(14,2) ) as abap.curr(13,2) ) AS FreeDefinedAmount2,
  cast ( prps.use07 as use07prps preserving type ) AS FreeDefinedAmount2Currency,
  cast ( prps.usr08 as usr08prps preserving type ) AS FreeDefinedDate1,
  cast ( prps.usr09 as usr09prps preserving type ) AS FreeDefinedDate2,
  cast ( prps.usr10 as usr10prps preserving type ) AS FreeDefinedIndicator1,
  cast ( prps.usr11 as usr11prps preserving type ) AS FreeDefinedIndicator2,
  _StatusObject.StatusProfile AS StatusProfile,
  prps.pgprf AS DistributionProfile,
  cast( prte.petrf as ps_getre preserving type ) AS SchedldBasicEarliestEndDate,
  cast( prte.pstrs as ps_gstre preserving type ) AS SchedldBasicLatestStartDate,
  cast( prte.eetrf as ps_gltrp preserving type ) AS SchedldFcstdEarliestEndDate,
  cast( prte.estrs as ps_gstrp preserving type ) AS LatestSchedldFcstdStartDate,
  prps.prps_status AS StatusCombinationCode,
  _Project.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive
FROM prps
LEFT OUTER JOIN I_ProjectData_2 AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [1..1]
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_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ControllingArea = _ResponsibleCostCenter.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON WBSElementObject = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_ProjectResponsiblePerson AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON ApplicantCode = _ProjectApplicant.ApplicantCode  -- association [0..1]
LEFT OUTER JOIN E_WBSElement_2 AS _Extension ON WBSElementInternalID = _Extension.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProjectObjectShortText AS _WBSElementShortText ON _WBSElementShortText.Language = $session.system_language AND _WBSElementShortText.ProjectApplicationIdentifier = 'PS' AND _WBSElementShortText.ProjectObjectType = 'PR' AND WBSElementObject = _WBSElementShortText.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN I_WBSElementMilestoneData AS _WBSElementMilestone ON WBSElementInternalID = _WBSElementMilestone.WBSElementInternalID  -- association [0..*]
;