I_WBSElementVersion

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_WBSElementVersion.
-- 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.
-- SQL view name: IWBSELEMENTVERSN

CREATE VIEW I_WBSElementVersion AS
SELECT
  vsprps_cn.mandt AS SAPClient,
  cast( vsprps_cn.posid as ps_posid_edit ) AS WBSElement,
  cast( vsprps_cn.vsnmr as vsnmr_v preserving type ) AS Version,
  vsprps_cn.posid_edit AS WBSElementWithCodingMask,
  cast ( vsprps_cn.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast ( vsprps_cn.psphi as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  _Project.Project AS Project,
  cast ( vsprps_cn.post1 as ps_s4_post1 preserving type ) AS WBSDescription,
  vsprps_cn.objnr AS WBSElementObject,
  cast ( vsprps_cn.ernam as ernam preserving type ) AS CreatedByUser,
  cast ( vsprps_cn.erdat as erdat preserving type ) AS CreationDate,
  cast ( vsprps_cn.aenam as ps_s4_aenam preserving type ) AS LastChangedByUser,
  cast ( vsprps_cn.aedat as ps_s4_updat preserving type ) AS LastChangeDate,
  cast ( vsprps_cn.vernr as ps_s4_vernr preserving type ) AS ResponsiblePerson,
  cast ( vsprps_cn.verna as ps_s4_verna preserving type ) AS ResponsiblePersonName,
  cast ( vsprps_cn.astnr as ps_s4_astnr preserving type ) AS ApplicantCode,
  vsprps_cn.astna AS ApplicantName,
  cast ( vsprps_cn.pbukr as bukrs preserving type ) AS CompanyCode,
  cast ( vsprps_cn.pgsbr as gsber preserving type ) AS BusinessArea,
  cast ( vsprps_cn.pkokr as logbr_kokrs preserving type ) AS ControllingArea,
  vsprps_cn.prctr AS ProfitCenter,
  cast ( vsprps_cn.prart as ps_s4_prart preserving type ) AS ProjectType,
  cast ( vsprps_cn.plakz as ps_plakz preserving type ) AS WBSElementIsPlanningElement,
  cast ( vsprps_cn.belkz as ps_s4_belkz preserving type ) AS WBSIsAccountAssignmentElement,
  cast ( vsprps_cn.fakkz as ps_fakkz preserving type ) AS WBSElementIsBillingElement,
  vsprps_cn.kalsm AS CostingSheet,
  cast ( vsprps_cn.akstl as ps_s4_akstl preserving type ) AS RequestingCostCenter,
  cast ( vsprps_cn.fkstl as ps_s4_fkstl preserving type ) AS ResponsibleCostCenter,
  cast ( vsprps_cn.fabkl as stkal preserving type ) AS FactoryCalendar,
  cast ( vsprps_cn.pspri as nw_prio preserving type ) AS PriorityCode,
  cast ( vsprps_cn.pwpos as ps_pwpos preserving type ) AS Currency,
  vsprps_cn.werks AS Plant,
  vsprps_cn.xstat AS WBSIsStatisticalWBSElement,
  cast( vsprps_cn.txjcd as ps_s4_txjcd preserving type ) AS TaxJurisdiction,
  cast ( vsprps_cn.plint as plint_t preserving type ) AS WBSIsMarkedForIntegratedPlng,
  cast ( vsprps_cn.func_area as fkber preserving type ) AS FunctionalArea,
  vsprps_cn.stort AS Location,
  vsprps_cn.equnr AS Equipment,
  vsprps_cn.tplnr AS FunctionalLocation,
  vsprps_cn.aennr AS ProjectObjectChangeNumber,
  cast ( vsprps_cn.adpsp as ps_s4_addcompare_core preserving type ) AS ProjectObjectReferenceElement,
  vsprps_cn.zschm AS ProjInterestCalcProfile,
  vsprps_cn.imprf AS InvestmentProfile,
  cast ( vsprte_cn.ieinh as ps_ieinh preserving type ) AS ActualDurationUnit,
  cast ( vsprte_cn.peinh as ps_s4_peinh preserving type ) AS BasicDurationUnit,
  cast( vsprte_cn.pdaur as ps_s4_pdaur preserving type ) AS BasicDuration,
  cast ( vsprte_cn.idaur as ps_s4_idaur preserving type ) AS ActualDuration,
  case dats_is_valid( vsprte_cn.pstrs ) when 0 then '00000000' else vsprte_cn.pstrs end as SchedldBasicLatestStartDate AS pstrsendasSchedldBasicLatestStartDate,
  cast ( vsprps_cn.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  vsprps_cn.stufe AS WBSElementHierarchyLevel,
  cast ( vsprps_cn.zschl as fin_ovhkey preserving type ) AS OverheadCode,
  cast ( vsprps_cn.abgsl as psb_bo_abgr_schl_de preserving type ) AS ResultAnalysisInternalID,
  cast ( vsprps_cn.evgew as ev_weightd preserving type ) AS ProgressAnlysAggregationWeight,
  vsprps_cn.poski AS WBSElementShortID,
  vsprps_cn.akokr AS ReqgCostCenterControllingArea,
  vsprps_cn.fkokr AS RespCostCenterControllingArea,
  vsprps_cn.txtsp AS Language,
  vsprps_cn.slwid AS FreeDefinedTableFieldSemantic,
  cast ( vsprps_cn.usr00 as usr00prps preserving type ) AS FreeDefinedAttribute01,
  cast ( vsprps_cn.usr01 as usr01prps preserving type ) AS FreeDefinedAttribute02,
  cast ( vsprps_cn.usr02 as usr02prps preserving type ) AS FreeDefinedAttribute03,
  cast ( vsprps_cn.usr03 as usr03prps preserving type ) AS FreeDefinedAttribute04,
  cast ( vsprps_cn.usr04 as usr04prps preserving type ) AS FreeDefinedQuantity1,
  cast ( vsprps_cn.use04 as use04prps preserving type ) AS FreeDefinedQuantity1Unit,
  cast ( vsprps_cn.usr05 as usr05prps preserving type ) AS FreeDefinedQuantity2,
  cast ( vsprps_cn.use05 as use05prps preserving type ) AS FreeDefinedQuantity2Unit,
  cast ( vsprps_cn.usr06 as usr06prps preserving type ) AS FreeDefinedAmount1,
  cast ( vsprps_cn.use06 as use06prps preserving type ) AS FreeDefinedAmount1Currency,
  cast ( vsprps_cn.usr07 as usr07prps preserving type ) AS FreeDefinedAmount2,
  cast ( vsprps_cn.use07 as use07prps preserving type ) AS FreeDefinedAmount2Currency,
  cast ( vsprps_cn.usr08 as usr08prps preserving type ) AS FreeDefinedDate1,
  cast ( vsprps_cn.usr09 as usr09prps preserving type ) AS FreeDefinedDate2,
  cast ( vsprps_cn.usr10 as usr10prps preserving type ) AS FreeDefinedIndicator1,
  cast ( vsprps_cn.usr11 as usr11prps preserving type ) AS FreeDefinedIndicator2,
  cast ( vsprps_cn.kostl as ps_kostl preserving type ) AS CostCenter,
  vsprps_cn.ktrg AS CostObject,
  vsprps_cn.clasf AS WBSElementIsUsedInProjSmmry,
  cast( vsprps_cn.loevm as ps_s4_loevm preserving type ) AS IsMarkedForDeletion,
  vsprps_cn.kzbws AS InventorySpecialStockValnType,
  vsprps_cn.fplnr AS BillingPlan,
  vsprps_cn.grpkz AS WBSElementIsGroupingWBSElement,
  vsprps_cn.klvar AS CostingVariant,
  vsprps_cn.vname AS JointVenture,
  vsprps_cn.recid AS JointVentureRecoveryCode,
  vsprps_cn.etype AS JointVentureEquityType,
  cast ( vsprps_cn.otype as jv_otype preserving type ) AS JointVentureObjectType,
  vsprps_cn.jibcl AS JointVentureClass,
  vsprps_cn.jibsa AS JointVentureSubClass,
  vsprte_cn.flgvg AS WBSElementHasActivities,
  vsprte_cn.flgew AS WBSHasFcstdDateFromActivity,
  vsprte_cn.flgem AS WBSHasFcstdDateSetManually,
  vsprte_cn.flgvm AS WBSHasBasicDateManuallySet,
  vsprte_cn.flgim AS WBSHasActualDateSetManually,
  vsprte_cn.flgvi AS WBSElmntHasActualDateFromActy
FROM vsprps_cn
LEFT OUTER JOIN vsprte_cn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectVersion AS _Project ON ProjectInternalID = _Project.ProjectInternalID AND Version = _Project.Version  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BasicDurationUnit ON BasicDurationUnit = _BasicDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ActualDurationUnit ON ActualDurationUnit = _ActualDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ForecastedDurationUnit ON ForecastedDurationUnit = _ForecastedDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [1..*]
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_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [1..1]
LEFT OUTER JOIN I_Projecttype AS _ProjectType ON ProjectType = _ProjectType.ProjectType  -- association [1..1]
LEFT OUTER JOIN I_Prioritycode AS _PriorityCode ON PriorityCode = _PriorityCode.PriorityCode  -- association [1..1]
LEFT OUTER JOIN I_Location AS _Location ON Location = _Location.Location AND Plant = _Location.Plant  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Interestcalculationprofile AS _Interestcalculationprofile ON ProjInterestCalcProfile = _Interestcalculationprofile.ProjInterestCalcProfile  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction AND CostingSheet = _TaxJurisdiction.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [1..1]
LEFT OUTER JOIN E_WBSElementVersion AS _Extension ON vsprps_cn.vsnmr = _Extension.Version AND vsprps_cn.posid = _Extension.WBSElement  -- 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 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]
;