FINOC_HARD_DEPENDENCY_WBS

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 FINOC_HARD_DEPENDENCY_WBS.
-- 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 FINOC_HARD_DEPENDENCY_WBS AS
SELECT
  WorkPackage.WBSElementInternalID AS ps_psp_pnr,
  BillingItem.OrganizationalChange AS orgl_change,
  WorkPackageDetails.ControllingArea AS kokrs,
  WorkPackageDetails.CompanyCode AS bukrs,
  case when ProfitCenterToWorkPackage.ProfitCenterBeforeOrglChange is not null then ProfitCenterToWorkPackage.ProfitCenterBeforeOrglChange else WorkPackageDetails.ProfitCenter end as prctr_old AS ProfitCenterendasprctr_old,
  BillingItem.ProfitCenterByOrglChange AS prctr,
  WorkPackageDetails.WBSElementObject AS objnr,
  BillingItem.WBSElementInternalID AS billing_item,
  'WP_BI' as semantic_object AS WBSElementInternalIDasps_psp_pnr
FROM I_OrglChangeWBSElement AS BillingItem
INNER JOIN I_WBSElementStructure AS WorkPackage ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementBasicData AS WorkPackageDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrganizationalChange AS OrglChange ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProfitCenterToWBSElement AS ProfitCenterToWorkPackage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrglChangeWBSElement AS UIEntry ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementStructure AS DirectWorkPackage ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementStructure AS ChildWorkPackage ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementBasicData AS ChildWorkPackageDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementBasicData AS WbsElement ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_OrganizationalChangeProject, I_OrganizationalChangeProject
;