I_WBSElementByExternalID

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_WBSElementByExternalID.
-- 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: IWBSELEBYEXTKEY

CREATE VIEW I_WBSElementByExternalID AS
SELECT
  prps.posid_edit AS WBSElementExternalID,
  cast ( prps.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  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_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,
  prps.prart AS ProjectType,
  prps.jibcl AS JntIntrstBillgClass,
  prps.jibsa AS JntIntrstBillgSubClass
FROM prps
LEFT OUTER JOIN prte ON /* join condition not captured in parsed metadata */
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_FinWBSElementHierarchyNode AS _FinWBSElementHierarchyNode ON WBSElementExternalID = _FinWBSElementHierarchyNode.WBSElementExternalID  -- association [0..*]
;