I_DFS_FrcElmntPlndOpTP

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_DFS_FrcElmntPlndOpTP.
-- 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: IPLNDOPTP

CREATE VIEW I_DFS_FrcElmntPlndOpTP AS
SELECT
  I_DFS_FrcElmntPlndOp.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgType AS FrcElmntOrgType,
  cast(I_DFS_FrcElmntPlndOp.ForceElementOrgID as sobid) AS ForceElementOrgID,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  I_DFS_FrcElmntPlndOp.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  I_DFS_FrcElmntPlndOp.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  I_DFS_FrcElmntPlndOp.PlannedRelOpVariationField AS PlannedRelOpVariationField,
  I_DFS_FrcElmntPlndOp.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgRefInfoType AS FrcElmntOrgRefInfoType,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgRefSubtype AS FrcElmntOrgRefSubtype,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgValdtyRefStartDate AS FrcElmntOrgValdtyRefStartDate,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgValdtyRefEndDate AS FrcElmntOrgValdtyRefEndDate,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgRefVariationID AS FrcElmntOrgRefVariationID,
  cast(substring( I_DFS_FrcElmntPlndOp.FrcElmntOrgRefVariationID,3,10 ) as sobid) AS FrcElmntOrgRelatedOrgID,
  'A' AS FrcElmntOrgCnctntdRelshpName,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgRefSequenceNumber AS FrcElmntOrgRefSequenceNumber,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgPlanOpCode AS FrcElmntOrgPlanOpCode,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  I_DFS_FrcElmntPlndOp.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlngStsCritlty
FROM I_DFS_FrcElmntPlndOp
-- UNION ALL with additional select branch(es): I_DFS_FrcElmntPlndOp
;