C_DraftAdministrativeData

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_DraftAdministrativeData.
-- 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: CSDRAFT_ADMIN

CREATE VIEW C_DraftAdministrativeData AS
SELECT
  Document.DraftEntityType AS DraftEntityType,
  Document.DraftUUID AS DraftUUID,
  cast( '' as text255 ) AS ObjectKey,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreatedByUserDescription AS CreatedByUserDescription,
  Document.CreationDateTime AS CreationDateTime,
  Document.LastChangedByUser AS LastChangedByUser,
  Document.LastChangedByUserDescription AS LastChangedByUserDescription,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.InProcessByUser AS InProcessByUser,
  Document.InProcessByUserDescription AS InProcessByUserDescription,
  Document.ProcessingStartDateTime AS ProcessingStartDateTime,
  Document.EnqueueStartDateTime AS EnqueueStartDateTime,
  Document.DraftAccessType AS DraftAccessType
FROM I_DraftAdministrativeData AS Document
LEFT OUTER JOIN C_Draftlifecyclelog AS _Sdraft_Log ON _Sdraft_Log.DraftEntityType = DraftEntityType AND _Sdraft_Log.DraftUUID = DraftUUID  -- association [0..*]
LEFT OUTER JOIN C_Draftlifecycleadmindata AS _Root ON Document.DraftEntityType = _Root.DraftEntityType  -- association [1..1]
;