C_DFS_AssgmtFeToSupByFeList

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_DFS_AssgmtFeToSupByFeList.
-- 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: CDFSASSGMTSUPBFL

CREATE VIEW C_DFS_AssgmtFeToSupByFeList AS
SELECT
  FeToSupFe.DfsAssgmtUUID AS DfsAssgmtUUID,
  FeToSupFe.DraftUUID AS DraftUUID,
  FeToSupFe.DfsAssgmtActiveDraft AS DfsAssgmtActiveDraft,
  FeToSupFe.HasActiveEntity AS HasActiveEntity,
  FeToSupFe.HasDraftEntity AS HasDraftEntity,
  FeToSupFe.DfsAssgmtCreationDateTime AS DfsAssgmtCreationDateTime,
  FeToSupFe.DfsAssgmtCreatedByUser AS DfsAssgmtCreatedByUser,
  FeToSupFe.DfsAssgmtChangeDateTime AS DfsAssgmtChangeDateTime,
  FeToSupFe.DfsAssgmtLastChgdByUser AS DfsAssgmtLastChgdByUser,
  FeToSupFe.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  FeToSupFe.DfsAssgmtValdtyStrtTime AS DfsAssgmtValdtyStrtTime,
  FeToSupFe.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  FeToSupFe.DfsAssgmtValdtyEndTime AS DfsAssgmtValdtyEndTime,
  FeToSupFe.DfsAssgmtValdtyTimeZone AS DfsAssgmtValdtyTimeZone,
  FeToSupFe.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  FeToSupFe.DfsAssgmtType AS DfsAssgmtType,
  FeToSupFe.DfsAssgmtIsDefaultAssignment AS DfsAssgmtIsDefaultAssignment,
  FeToSupFe.DfsAssgmtExternalProductGroup AS DfsAssgmtExternalProductGroup,
  FeToSupFe.ForceElementOrgTargetUUID AS ForceElementOrgTargetUUID,
  FeToSupFe.ForceElementOrgSrceUUID AS ForceElementOrgSrceUUID,
  FeToSupFe.DfsAssgmtStatusObject AS DfsAssgmtStatusObject,
  FeToSupFe.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  _StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS Status,
  _AssgmtTimeZoneValueHelp.TimeZoneText AS TimeZoneText,
  ForceElementOrgSrceID,
  ForceElementOrgTargetID,
  ForceElementOrgSrceID AS ForceElementOrgRefSrceID,
  _FrcElmntOrgTP.FrcElmntOrgType AS FrcElmntOrgType,
  _FrcElmntOrgTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  _SrceFrcElmntOrgTP.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  _SrceFrcElmntOrgTP.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  _SrceFrcElmntOrgTP.ForceElementOrgID AS ForceElementOrgID,
  DfsAssgmtPlanOperationCode,
  _PlannedOperation._Text[1:Language = $session.system_language].DfsAssgmtPlanOperationCodeDesc AS DfsAssgmtPlanOperationCodeDesc,
  DfsAssgmtPlanStatusObject,
  DfsAssgmtPlanDelimitDate,
  _PlanStatusObjectActiveStatus._StatusCode._StatusCodeText[1:Language = $session.system_language].StatusName AS DfsAssgmtPlanOperationStatus,
  _PlanStatusObjectActiveStatus.StatusCriticality AS DfsAssgmtPlanOpStsCriticality,
  SrceClfnObjectID,
  TargetClfnObjectID
FROM I_DFS_UniversalAssignmentUnion
LEFT OUTER JOIN C_FrcElmntOrgSuplmntyVrtlElmnt AS _SrceFrcElmntOrgTP ON ForceElementOrgSrceID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgSuplmntyVrtlElmnt AS _TargetFrcElmntOrgTP ON ForceElementOrgTargetID = _TargetFrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON ForceElementOrgSrceID = _FrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN I_DFS_StatusAttributes AS _StatusAttributes ON DfsAssgmtStatusCode = _StatusAttributes.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_DFS_TechnicalStatusText AS _TechnicalStatusText ON DfsAssgmtActiveDraft = _TechnicalStatusText.DfsAssgmtTechnicalStatus  -- association [0..*]
LEFT OUTER JOIN C_DFS_TimeZoneVH AS _AssgmtTimeZoneValueHelp ON DfsAssgmtValdtyTimeZone = _AssgmtTimeZoneValueHelp.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgRefOrgTP AS _FrcElmntOrgRefOrgTP ON ForceElementOrgSrceID = _FrcElmntOrgRefOrgTP.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN I_DFS_SenstvyClfnCnt AS _SrceSenstvyClfn ON SrceClfnObjectID = _SrceSenstvyClfn.ClfnObjectID  -- association [1..1]
LEFT OUTER JOIN I_DFS_SenstvyClfnCnt AS _TargetSenstvyClfn ON TargetClfnObjectID = _TargetSenstvyClfn.ClfnObjectID  -- association [1..1]
;