I_WBSElementBasicData

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_WBSElementBasicData.
-- 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_WBSElementBasicData AS
SELECT
  cast ( prps.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  prps.posid_edit AS WBSElementExternalID,
  prps.posid AS WBSElement,
  prps.poski AS WBSElementShortID,
  cast ( prps.post1 as ps_s4_post1 preserving type ) AS WBSDescription,
  cast ( prps.pbukr as bukrs preserving type ) AS CompanyCode,
  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,
  cast ( prps.fabkl as stkal preserving type ) AS FactoryCalendar,
  prps.kalsm AS CostingSheet,
  cast ( prps.kostl as ps_kostl preserving type ) AS CostCenter,
  cast ( prps.psphi as ps_psphi 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,
  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.stort AS Location,
  prps.abgsl AS ResultAnalysisInternalID,
  prps.rfund AS Fund,
  prps.rgrant_nbr AS GrantID,
  prps.fund_fix_assign AS FundIsFixAssigned,
  prps.func_area_fix_assigned AS FunctionalAreaIsFixAssigned,
  prps.grant_fix_assigned AS GrantIsFixAssigned,
  prps.sponsoredprog AS SponsoredProgram,
  prps.txjcd AS TaxJurisdiction,
  prps.tplnr AS FunctionalLocation,
  prps.ernam AS CreatedByUser,
  prps.erdat AS CreationDate,
  prps.aenam AS LastChangedByUser,
  prps.aedat AS LastChangeDate,
  prps.fkokr AS RespCostCenterControllingArea,
  prps.posnr_prps AS LeadingSalesOrderItem,
  prps.vbeln_prps AS LeadingSalesOrder,
  prps.settlementelement AS EntProjectSettlementElement,
  prps.settlmtruleinherited AS EntProjIsSettlmtRuleInherited,
  _RaKeyVH.ResultAnalysisDescription AS ResultAnalysisDescription
FROM prps
LEFT OUTER JOIN prte AS _prte ON prps.pspnr = _prte.posnr AND prps.psphi = _prte.psphi  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData 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_Projecttype AS _ProjectType ON ProjectType = _ProjectType.ProjectType  -- association [0..1]
LEFT OUTER JOIN I_Projecttypetext AS _ProjectTypeText ON ProjectType = _ProjectTypeText.ProjectType  -- association [0..*]
LEFT OUTER JOIN I_ResultsAnalysisKeyValueHelp AS _RaKeyVH ON ResultAnalysisInternalID = _RaKeyVH.ResultAnalysisInternalID  -- 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]
;