C_DFS_AssgmtPltfrmToWBSElmntTP

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_AssgmtPltfrmToWBSElmntTP.
-- 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: ASSGMTWBSELMNT

CREATE VIEW C_DFS_AssgmtPltfrmToWBSElmntTP AS
SELECT
  DfsAssgmtUUID,
  _MaintPlatformCodeVH.DfsMaintPlatformLongName AS DfsMaintPlatformLongName,
  DfsMaintPlatformID,
  DfsMaintPlatformUUID,
  DfsAssgmtSourceType,
  DfsAssgmtType,
  DfsAssgmtStatusCode,
  DfsAssgmtValdtyStrtDate,
  DfsAssgmtValdtyEndDate,
  WBSElementInternalID,
  WBSElement,
  WBSElementExternalID,
  WBSDescription,
  DfsIsStrucAuthznEnabled,
  DfsMaintBusinessObjectType,
  DfsMaintBusinessObjectTypeFoEd,
  DfsPlatformDetailsText,
  _MaintPltfrmAssgmtExtnVH.DfsMaintPlatformExtensionText AS DfsMaintPlatformExtensionText,
  DfsPlatformExtension,
  DfsAssgmtComment,
  DfsAssgmtSourceObjectUUID,
  DfsAssgmtCreationDateTime,
  DfsAssgmtCreatedByUser,
  DfsAssgmtChangeDateTime,
  DfsAssgmtLastChgdByUser
FROM I_DFS_UniversalAssignmentTP AS PlatformCodeToWBSElement
LEFT OUTER JOIN C_WBSElementVH AS _WBSElementVH ON WBSElement = _WBSElementVH.WBSElement  -- association [0..1]
LEFT OUTER JOIN C_DFS_MaintPlatformCodeVH AS _MaintPlatformCodeVH ON DfsMaintPlatformID = _MaintPlatformCodeVH.DfsMaintPlatformID  -- association [0..1]
LEFT OUTER JOIN C_DFS_MaintBusinessObjTypeVH AS _MaintBusinessObjTypeVH ON DfsMaintBusinessObjectType = _MaintBusinessObjTypeVH.DfsMaintBusinessObjectType  -- association [1..1]
LEFT OUTER JOIN C_DFS_MaintPltfrmAssgmtDetsVH AS _MaintPltfrmAssgmtDetsVH ON DfsMaintBusinessObjectType = _MaintPltfrmAssgmtDetsVH.DfsMaintBusinessObjectType  -- association [0..*]
LEFT OUTER JOIN C_DFS_MaintPltfrmAssgmtExtnVH AS _MaintPltfrmAssgmtExtnVH ON DfsMaintBusinessObjectType = _MaintPltfrmAssgmtExtnVH.DfsMaintBusinessObjectType AND DfsPlatformExtension = _MaintPltfrmAssgmtExtnVH.DfsPlatformExtension  -- association [0..1]
;