I_FrcElmntToWBSElmntUnion

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_FrcElmntToWBSElmntUnion.
-- 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: IFETOWBSEUNIN

CREATE VIEW I_FrcElmntToWBSElmntUnion AS
SELECT
  FrcElmntToWBSElmntUnion.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntToWBSElmntUnion.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS FrcElmntOrgDraftUUID,
  '1' AS DfsAssgmtActiveDraft,
  FrcElmntToWBSElmntUnion.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntToWBSElmntUnion.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToWBSElmntUnion.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntToWBSElmntUnion.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntToWBSElmntUnion.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntToWBSElmntUnion.FrcElmntOrgRelshpSpec AS FrcElmntOrgRelshpSpec,
  FrcElmntToWBSElmntUnion.FrcElmntOrgRelshpBtwnObj AS FrcElmntOrgRelshpBtwnObj,
  FrcElmntToWBSElmntUnion.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntToWBSElmntUnion.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToWBSElmntUnion.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntToWBSElmntUnion.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntToWBSElmntUnion.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToWBSElmntUnion.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntToWBSElmntUnion.FrcElmntOrgLastChgdByUser AS FrcElmntOrgLastChgdByUser,
  FrcElmntToWBSElmntUnion.WBSElementInternalID AS WBSElementInternalID,
  FrcElmntToWBSElmntUnion.WBSElementExternalID AS WBSElementExternalID,
  FrcElmntToWBSElmntUnion.WBSElement AS WBSElement,
  FrcElmntToWBSElmntUnion.WBSDescription AS WBSDescription,
  FrcElmntToWBSElmntUnion.ProjectProfileCode AS ProjectProfileCode,
  FrcElmntToWBSElmntUnion.ProjectInternalID AS ProjectInternalID,
  FrcElmntToWBSElmntUnion.ProjectExternalID AS ProjectExternalID,
  FrcElmntToWBSElmntUnion.Project AS Project,
  FrcElmntToWBSElmntUnion.ProjectDescription AS ProjectDescription,
  FrcElmntToWBSElmntUnion.ProjectProfileCodeText AS ProjectProfileCodeText,
  cast( 'X' as boole_d preserving type ) AS IsActiveEntity,
  cast( ' ' as boole_d preserving type ) AS HasActiveEntity,
  cast( 3 as int1) AS Criticality,
  _FrcElmntPlndOpTP.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  cast( _FrcElmntPlndOpTP.FrcElmntOrgPlngStatus as abap.char(22) )as DfsAssgmtPlanStatusObject AS char22asDfsAssgmtPlanStatusObject,
  cast( ' ' as boole_d preserving type) AS HasDraftEntity,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatus AS DfsAssgmtPlanStatusObject,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStsCritlty AS DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToWBSElmnt AS FrcElmntToWBSElmntUnion
INNER JOIN I_DraftAdministrativeData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON ForceElementOrgID = _FrcElmntPlndOpTP.ForceElementOrgID AND FrcElmntOrgValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND FrcElmntOrgValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate AND FrcElmntOrgSubType = _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype AND _FrcElmntPlndOpTP.FrcElmntOrgRefInfoType = '1001' AND FrcElmntOrgRelatedOrgID = _FrcElmntPlndOpTP.FrcElmntOrgRelatedOrgID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_FrcElmntToWBSElmntDraft
;