C_FrcElmntToPrftCtrGrpRelshpTP

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_FrcElmntToPrftCtrGrpRelshpTP.
-- 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: CFEPRFCTRGRPREL

CREATE VIEW C_FrcElmntToPrftCtrGrpRelshpTP AS
SELECT
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectID AS DfsObjectID,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectSubType AS DfsObjectSubType,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectType AS DfsObjectType,
  FrcElmntToPrftCtrGrpRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToPrftCtrGrpRelshpTP.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  FrcElmntToPrftCtrGrpRelshpTP.FrcElmntOrgGroupName AS FrcElmntOrgProfitCtrGrpName,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectValdtyStartDateFoEd AS DfsObjectValdtyStartDateFoEd,
  FrcElmntToPrftCtrGrpRelshpTP.DfsObjectValdtyEndDateFoEd AS DfsObjectValdtyEndDateFoEd,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  _FrcElmntOrgPrftCenterGroupVH.FrcElmntOrgGroupSetClassDesc AS FrcElmntOrgGroupSetClassDesc,
  _PositionDescSubTypeVH.DfsPositionSubTypeName AS DfsPositionSubTypeName,
  FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStsCritlty AS DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToAcctgCtrlgRelshpTP AS FrcElmntToPrftCtrGrpRelshpTP
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_ControllingAreaVH AS _ControllingAreaVH ON FrcElmntOrgControllingArea = _ControllingAreaVH.ControllingArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPrftCenterGroupVH AS _FrcElmntOrgPrftCenterGroupVH ON DfsObjectSubType = _FrcElmntOrgPrftCenterGroupVH.FrcElmntOrgGroupSetClass AND FrcElmntOrgControllingArea = _FrcElmntOrgPrftCenterGroupVH.FrcElmntOrgGroupSetSubClass AND FrcElmntOrgProfitCtrGrpName = _FrcElmntOrgPrftCenterGroupVH.FrcElmntOrgGroupSetClassName  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = DfsObjectPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionDescSubTypeVH AS _PositionDescSubTypeVH ON DfsObjectSubType = _PositionDescSubTypeVH.DfsPositionSubType  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
LEFT OUTER JOIN C_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID AND DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate AND _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype = '0106'  -- association [1..1]
;