C_Draftlifecycleadmindata

DDL: C_DRAFTLIFECYCLEADMINDATA SQL: CSDRAFT_LC_ADMIN Type: view CONSUMPTION Package: SADL_GW_DRAFT_ADMINISTRATION
10 Fields 1 Data Sources 1 Associations

Draft Lifecycle Administrative Data

C_Draftlifecycleadmindata is a Consumption CDS View that provides data about "Draft Lifecycle Administrative Data" in SAP S/4HANA. It reads from 1 data source (C_DraftAdministrativeData) and exposes 10 fields with key field DraftEntityType. It has 1 association to related views. Part of development package SADL_GW_DRAFT_ADMINISTRATION.

Data Sources (1)

SourceAliasJoin Type
C_DraftAdministrativeData _Sdraft_Count left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_DraftAdministrativeData _Sdraft_Entry _Sdraft_Entry.DraftEntityType = $projection.DraftEntityType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSDRAFT_LC_ADMIN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Draft Lifecycle Administrative Data view
VDM.viewType #CONSUMPTION view
ObjectModel.compositionRoot true view
Search.searchable true view
UI.headerInfo.typeName Draft Administrative Data view
UI.headerInfo.typeNamePlural Draft Administration view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Draft Administration view
UI.headerInfo.title.value DraftEntityType view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DraftEntityType Document DraftEntityType
DraftTypeDescription Document DraftTypeDescription
EnqueueExpiryNotification Document EnqueueExpiryNotification Enqueue Expiry Notification (min)
RelativeEnqueueExpiry Document RelativeEnqueueExpiry Relative Enqueue Expiry (min)
ProcessingExpiryNotification Document ProcessingExpiryNotification Processing Expiry Notification (min)
RelativeProcessingExpiry Document RelativeProcessingExpiry Relative Processing Expiry (min)
NotKeptNotification Document NotKeptNotification Not Kept Expiry Notification (min)
NotKeptExpiry Document NotKeptExpiry Not Kept Expiry (min)
NumberOfDrafts
_Sdraft_Entry _Sdraft_Entry

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_Draftlifecycleadmindata.
-- 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_LC_ADMIN

CREATE VIEW C_Draftlifecycleadmindata AS
SELECT
  Document.DraftEntityType AS DraftEntityType,
  Document.DraftTypeDescription AS DraftTypeDescription,
  Document.EnqueueExpiryNotification AS EnqueueExpiryNotification,
  Document.RelativeEnqueueExpiry AS RelativeEnqueueExpiry,
  Document.ProcessingExpiryNotification AS ProcessingExpiryNotification,
  Document.RelativeProcessingExpiry AS RelativeProcessingExpiry,
  Document.NotKeptNotification AS NotKeptNotification,
  Document.NotKeptExpiry AS NotKeptExpiry,
  count( distinct _Sdraft_Count.DraftUUID ) AS NumberOfDrafts
LEFT OUTER JOIN C_DraftAdministrativeData AS _Sdraft_Count ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_DraftAdministrativeData AS _Sdraft_Entry ON _Sdraft_Entry.DraftEntityType = DraftEntityType  -- association [0..*]
;

Learn More