C_FrcElmntToWBSElmntList

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 C_FrcElmntToWBSElmntList.
-- 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: CFEWBSELMNTUNON

CREATE VIEW C_FrcElmntToWBSElmntList AS
SELECT
  FrcElmntToWBSElmntUnion.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntToWBSElmntUnion.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntToWBSElmntUnion.FrcElmntOrgDraftUUID AS FrcElmntOrgDraftUUID,
  FrcElmntToWBSElmntUnion.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntToWBSElmntUnion.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToWBSElmntUnion.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  _TechnicalStatusText[1:Language=$session.system_language].DfsAssgmtTechnicalStatusDesc AS DfsAssgmtTechnicalStatusDesc,
  FrcElmntToWBSElmntUnion.DfsAssgmtActiveDraft AS DfsAssgmtActiveDraft,
  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,
  FrcElmntToWBSElmntUnion.IsActiveEntity AS IsActiveEntity,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntToWBSElmntUnion.HasActiveEntity AS HasActiveEntity,
  FrcElmntToWBSElmntUnion.HasDraftEntity AS HasDraftEntity,
  FrcElmntToWBSElmntUnion.Criticality AS Criticality,
  _SrceFrcElmntOrgTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  _SrceFrcElmntOrgTP.FrcElmntOrgName AS FrcElmntOrgName,
  _SrceFrcElmntOrgTP.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  DfsAssgmtPlanOpStsCriticality,
  _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  _FrcElmntOrgSubType._FrcElmntOrgSubTypeText[1:FrcElmntOrgLanguage=$session.system_language].FrcElmntOrgSubTypeName AS FrcElmntOrgSubTypeName
FROM I_FrcElmntToWBSElmntUnion AS FrcElmntToWBSElmntUnion
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON ForceElementOrgID = _FrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgProjectVH AS _FrcElmntOrgProjectVH ON Project = _FrcElmntOrgProjectVH.Project  -- association [1..1]
LEFT OUTER JOIN C_WBSElementVH AS _WBSElementVH ON WBSElementExternalID = _WBSElementVH.WBSElement  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _SrceFrcElmntOrgTP ON ForceElementOrgID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN I_DFS_TechnicalStatusText AS _TechnicalStatusText ON DfsAssgmtActiveDraft = _TechnicalStatusText.DfsAssgmtTechnicalStatus  -- association [0..*]
LEFT OUTER JOIN I_FrcElmntOrgSubType AS _FrcElmntOrgSubType ON FrcElmntOrgSubType = _FrcElmntOrgSubType.FrcElmntOrgSubType AND _FrcElmntOrgSubType.FrcElmntOrgInfoType = '1001'  -- association [0..*]
LEFT OUTER JOIN I_DFS_SenstvyClfnFrcElmnt AS _SenstvyClfn ON ForceElementOrgID = _SenstvyClfn.ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON ForceElementOrgID = _FrcElmntPlndOpTP.ForceElementOrgID AND FrcElmntOrgValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND FrcElmntOrgValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;