C_FrcElmntToCostCtrGrpRelshpTP

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_FrcElmntToCostCtrGrpRelshpTP.
-- 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: CFECSTCTRGRPREL

CREATE VIEW C_FrcElmntToCostCtrGrpRelshpTP AS
SELECT
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectID AS DfsObjectID,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectSubType AS DfsObjectSubType,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectType AS DfsObjectType,
  FrcElmntToCostCtrGrpRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToCostCtrGrpRelshpTP.FrcElmntOrgGroupName AS FrcElmntOrgGroupName,
  FrcElmntToCostCtrGrpRelshpTP.FrcElmntOrgGroupName AS FrcElmntOrgCostCenterGrpName,
  FrcElmntToCostCtrGrpRelshpTP.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectValdtyStartDateFoEd AS DfsObjectValdtyStartDateFoEd,
  FrcElmntToCostCtrGrpRelshpTP.DfsObjectValdtyEndDateFoEd AS DfsObjectValdtyEndDateFoEd,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  _FrcElmntOrgCostCenterGroupVH.FrcElmntOrgGroupSetClassDesc AS FrcElmntOrgGroupSetClassDesc,
  _PositionDescSubTypeVH.DfsPositionSubTypeName AS DfsPositionSubTypeName,
  _FrcElmntPlndOpTP.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStsCritlty AS DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToAcctgCtrlgRelshpTP AS FrcElmntToCostCtrGrpRelshpTP
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_FrcElmntOrgCostCenterGroupVH AS _FrcElmntOrgCostCenterGroupVH ON DfsObjectSubType = _FrcElmntOrgCostCenterGroupVH.FrcElmntOrgGroupSetClass AND FrcElmntOrgControllingArea = _FrcElmntOrgCostCenterGroupVH.FrcElmntOrgGroupSetSubClass AND FrcElmntOrgCostCenterGrpName = _FrcElmntOrgCostCenterGroupVH.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_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID AND DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate AND _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype = '0101'  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;