I_FrcElmntToPrftCostCtrRltnTP

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_FrcElmntToPrftCostCtrRltnTP.
-- 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: IFEORGCOSTCTRTP

CREATE VIEW I_FrcElmntToPrftCostCtrRltnTP AS
SELECT
  FrcElmntToPrftCostCtrRltn.DfsObjectID AS DfsObjectID,
  FrcElmntToPrftCostCtrRltn.DfsPositionRelatedObjectID AS DfsObjectRelatedObjectID,
  FrcElmntToPrftCostCtrRltn.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToPrftCostCtrRltn.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  FrcElmntToPrftCostCtrRltn.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  FrcElmntToPrftCostCtrRltn.DfsObjectType AS DfsObjectType,
  FrcElmntToPrftCostCtrRltn.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  FrcElmntToPrftCostCtrRltn.DfsObjectRelshpSpec AS DfsObjectRelshpSpec,
  FrcElmntToPrftCostCtrRltn.DfsObjectRelshpBtwnObj AS DfsObjectRelshpBtwnObj,
  FrcElmntToPrftCostCtrRltn.DfsObjectRelshpPriority AS DfsObjectRelshpPriority,
  FrcElmntToPrftCostCtrRltn.DfsPositionDescRefSqncNmbr AS NumberOfForceElementOrg,
  FrcElmntToPrftCostCtrRltn.DfsObjectInfoType AS DfsObjectInfoType,
  FrcElmntToPrftCostCtrRltn.DfsObjectSubType AS DfsObjectSubType,
  FrcElmntToPrftCostCtrRltn.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToPrftCostCtrRltn.DfsPositionRelatedObjectType AS DfsObjectRelatedObjectType,
  FrcElmntToPrftCostCtrRltn.DfsObjRelshpLastChgdByUserName AS DfsObjRelshpLastChgdByUserName,
  FrcElmntToPrftCostCtrRltn.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  FrcElmntToPrftCostCtrRltn.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  FrcElmntToPrftCostCtrRltn.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDateFoEd,
  FrcElmntToPrftCostCtrRltn.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDateFoEd,
  _FrcElmntPlndOpTP.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatus AS DfsAssgmtPlanStatusObject,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStsCritlty AS DfsAssgmtPlanOpStsCriticality,
  cast (' ' as scmg_case_guid) AS FrcElmntOrgMeasureUUID,
  cast (' ' as /isdfps/orgm_type) AS FrcElmntOrgMeasureType,
  cast (' ' as /isdfps/orgm_type_text) AS FrcElmntOrgMeasureDesc
FROM I_DFS_ObjStructureRelationship AS FrcElmntToPrftCostCtrRltn
LEFT OUTER JOIN I_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID AND DfsObjectConcatenatedID = _FrcElmntPlndOpTP.FrcElmntOrgConcatenatedID AND DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate AND DfsObjectSubType = _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype AND _FrcElmntPlndOpTP.FrcElmntOrgRefInfoType = '1001'  -- association [1..1]
;