C_DFS_AssgmtFeToMaintByFeList

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_AssgmtFeToMaintByFeList.
-- 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: CDFSASSGMTMNTBFL

CREATE VIEW C_DFS_AssgmtFeToMaintByFeList 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,
  _AssgmtDamageTypeValueHelp.DfsAssgmtDamageTypeDesc AS DfsAssgmtDamageTypeDesc,
  FeToSupFe.DfsAssgmtDamageType AS DfsAssgmtDamageType,
  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,
  _SrceFrcElmntOrgTP.FrcElmntOrgType AS FrcElmntOrgType,
  _SrceFrcElmntOrgTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  _SrceFrcElmntOrgTP.FrcElmntOrgName AS FrcElmntOrgName,
  _SrceFrcElmntOrgTP.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
FROM I_DFS_UniversalAssignmentUnion
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _SrceFrcElmntOrgTP ON ForceElementOrgSrceID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _TargetFrcElmntOrgTP ON ForceElementOrgTargetID = _TargetFrcElmntOrgTP.ForceElementOrgID  -- association [0..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_DFS_AssgmtDamageTypeVH AS _AssgmtDamageTypeValueHelp ON DfsAssgmtDamageType = _AssgmtDamageTypeValueHelp.DfsAssgmtDamageType  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgRefOrgTP AS _FrcElmntOrgRefOrgTP ON ForceElementOrgSrceID = _FrcElmntOrgRefOrgTP.ForceElementOrgID  -- association [0..1]
;