I_DFS_UniversalAssignmentUnion

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_UniversalAssignmentUnion.
-- 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: IDFSASSGMTUNION
-- Parameters: P_DfsAssgmtType : dfs_assignment_type, P_DfsAssgmtSourceType : dfs_assignment_type_source

CREATE VIEW I_DFS_UniversalAssignmentUnion AS
SELECT
  ActiveDocument.DfsAssgmtUUID AS DfsAssgmtUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS DraftUUID,
  '1' AS DfsAssgmtActiveDraft,
  ActiveDocument.ForceElementOrgSrceUUID AS ForceElementOrgSrceUUID,
  ActiveDocument.ForceElementOrgTargetUUID AS ForceElementOrgTargetUUID,
  ActiveDocument.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  ActiveDocument.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  ActiveDocument.FlxblMatlPlngObjVariantUUID AS FlxblMatlPlngObjVariantUUID,
  ActiveDocument.FlxblMatlPlngObjVariantID AS FlxblMatlPlngObjVariantID,
  ActiveDocument.ForceElementOrgSrceID AS ForceElementOrgSrceID,
  ActiveDocument.ForceElementOrgTargetID AS ForceElementOrgTargetID,
  ActiveDocument.DfsCapabilityObjectUUID AS DfsCapabilityObjectUUID,
  ActiveDocument.DfsCapabilityObjectID AS DfsCapabilityObjectID,
  ActiveDocument.DfsCapabilityStatementUUID AS DfsCapabilityStatementUUID,
  ActiveDocument.DfsCapabilityStatementID AS DfsCapabilityStatementID,
  ActiveDocument.MissionEssentialTaskUUID AS MissionEssentialTaskUUID,
  ActiveDocument.MissionEssentialTaskID AS MissionEssentialTaskID,
  ActiveDocument.DfsIsAccreditingMsnEsnlTsk AS DfsIsAccreditingMsnEsnlTsk,
  ActiveDocument.DfsCapabilityObjectTargetUUID AS DfsCapabilityObjectTargetUUID,
  ActiveDocument.DfsCapabilityObjectTargetID AS DfsCapabilityObjectTargetID,
  ActiveDocument.Product AS Product,
  ActiveDocument.FrcElmntOrgMaintCapblt AS FrcElmntOrgMaintCapblt,
  ActiveDocument.DfsAssgmtUsageType AS DfsAssgmtUsageType,
  ActiveDocument.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  ActiveDocument.DfsAssgmtType AS DfsAssgmtType,
  ActiveDocument.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  ActiveDocument.DfsAssgmtValdtyStrtTime AS DfsAssgmtValdtyStrtTime,
  ActiveDocument.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  ActiveDocument.DfsAssgmtValdtyEndTime AS DfsAssgmtValdtyEndTime,
  ActiveDocument.DfsAssgmtValdtyTimeZone AS DfsAssgmtValdtyTimeZone,
  ActiveDocument.DfsAssgmtStatusObject AS DfsAssgmtStatusObject,
  ActiveDocument.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  ActiveDocument.DfsAssgmtLogicalSystem AS DfsAssgmtLogicalSystem,
  ActiveDocument.DfsAssgmtComment AS DfsAssgmtComment,
  ActiveDocument.DfsAssgmtPriority AS DfsAssgmtPriority,
  ActiveDocument.DfsAssgmtCreationDateTime AS DfsAssgmtCreationDateTime,
  ActiveDocument.DfsAssgmtCreatedByUser AS DfsAssgmtCreatedByUser,
  ActiveDocument.DfsAssgmtChangeDateTime AS DfsAssgmtChangeDateTime,
  ActiveDocument.DfsAssgmtLastChgdByUser AS DfsAssgmtLastChgdByUser,
  ActiveDocument.DfsAssgmtNmbrOfAssgdMatl AS DfsAssgmtNmbrOfAssgdMatl,
  ActiveDocument.DfsAssgmtMinNmbrOfAssgdMatl AS DfsAssgmtMinNmbrOfAssgdMatl,
  ActiveDocument.DfsAssgmtMaxNmbrOfAssgdMatl AS DfsAssgmtMaxNmbrOfAssgdMatl,
  ActiveDocument.DfsAssgmtMaterialIndicatorCode AS DfsAssgmtMaterialIndicatorCode,
  ActiveDocument.DfsAssgmtCorrectionValue AS DfsAssgmtCorrectionValue,
  ActiveDocument.DfsAssgmtCorrectionReason AS DfsAssgmtCorrectionReason,
  ActiveDocument.DfsAssgmtMaterialWeightingRate AS DfsAssgmtMaterialWeightingRate,
  ActiveDocument.DfsAssgmtIsMandForRdnssCalc AS DfsAssgmtIsMandForRdnssCalc,
  ActiveDocument.DfsAssgmtIsUsedForMassMatlPlng AS DfsAssgmtIsUsedForMassMatlPlng,
  ActiveDocument.DfsAssgmtMaterialCategory AS DfsAssgmtMaterialCategory,
  ActiveDocument.DfsAssgmtInitialSupplyStatus AS DfsAssgmtInitialSupplyStatus,
  ActiveDocument.DfsAssgmtIsOwnProvision AS DfsAssgmtIsOwnProvision,
  ActiveDocument.DfsAssgmtIsDefaultAssignment AS DfsAssgmtIsDefaultAssignment,
  ActiveDocument.DfsAssgmtDamageType AS DfsAssgmtDamageType,
  ActiveDocument.DfsAssgmtExternalProductGroup AS DfsAssgmtExternalProductGroup,
  ActiveDocument.DfsCapbltStmntSqncNmbr AS DfsCapbltStmntSqncNmbr,
  ActiveDocument.DfsCapbltStmntType AS DfsCapbltStmntType,
  ActiveDocument.DfsPositionSourceUUID AS DfsPositionSourceUUID,
  ActiveDocument.DfsPositionSourceID AS DfsPositionSourceID,
  ActiveDocument.DfsJobID AS DfsJobID,
  ActiveDocument.DfsAssgmtFrcElmntTrngAssmtDte AS DfsAssgmtFrcElmntTrngAssmtDte,
  ActiveDocument.DfsAssgmtFrcElmntTrngAssmtBy AS DfsAssgmtFrcElmntTrngAssmtBy,
  ActiveDocument.DfsAssgmtSourceObjectUUID AS DfsAssgmtSourceObjectUUID,
  ActiveDocument.DfsAssgmtSourceObjectType AS DfsAssgmtSourceObjectType,
  ActiveDocument.Equipment AS Equipment,
  ActiveDocument.FrcElmntOrgRotationKey AS FrcElmntOrgRotationKey,
  ActiveDocument.FrcElmntOrgOpExerciseID AS FrcElmntOrgOpExerciseID,
  ActiveDocument.FrcElmntOrgForceProviderID AS FrcElmntOrgForceProviderID,
  ActiveDocument.FrcElmntOrgInitialMatlSuplrID AS FrcElmntOrgInitialMatlSuplrID,
  ActiveDocument.FrcElmntOrgInitialPersSuplrID AS FrcElmntOrgInitialPersSuplrID,
  cast( 'X' as boolean ) AS DfsFrcElmntIsChangeableSrce,
  _FrcElmntWithAuthznAssgmtTrgt.DfsIsStrucAuthznEnabled AS DfsFrcElmntIsChangeableTgt,
  cast( 'X' as boole_d preserving type ) AS IsActiveEntity,
  cast( ' ' as boole_d preserving type ) AS HasActiveEntity,
  ActiveDocument.DfsAssgmtPlanStatusObject AS DfsAssgmtPlanStatusObject,
  ActiveDocument.DfsAssgmtPlanOperationCode AS DfsAssgmtPlanOperationCode,
  ActiveDocument.DfsAssgmtPlanDelimitDate AS DfsAssgmtPlanDelimitDate,
  ActiveDocument.DfsAssgmtPlanDelimitTime AS DfsAssgmtPlanDelimitTime,
  _SrceFrcElmntOrgBasic.ClfnObjectID AS SrceClfnObjectID,
  _TargetFrcElmntOrgBasic.ClfnObjectID AS TargetClfnObjectID,
  cast( ' ' as boole_d preserving type) AS HasDraftEntity
FROM I_DFS_UniversalAssignmentDraft AS DraftDocument
INNER JOIN I_DraftAdministrativeData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FrcElmntWithAuthznForAssgmt AS _FrcElmntWithAuthznAssgmtTrgt ON ForceElementOrgTargetID = _FrcElmntWithAuthznAssgmtTrgt.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN I_DFS_StatusObjectActiveStatus AS _PlanStatusObjectActiveStatus ON DfsAssgmtPlanStatusObject = _PlanStatusObjectActiveStatus.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_DFS_PlannedOperation AS _PlannedOperation ON DfsAssgmtPlanOperationCode = _PlannedOperation.DfsAssgmtPlanOperationCode  -- association [0..1]
LEFT OUTER JOIN I_FrcElmntOrgBasic AS _SrceFrcElmntOrgBasic ON ForceElementOrgSrceID = _SrceFrcElmntOrgBasic.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN I_FrcElmntOrgBasic AS _TargetFrcElmntOrgBasic ON ForceElementOrgTargetID = _TargetFrcElmntOrgBasic.ForceElementOrgID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_DFS_UniversalAssignmentDraft
;