I_PPS_DraftAdministrationData

DDL: I_PPS_DRAFTADMINISTRATIONDATA Type: view_entity COMPOSITE
14 Fields 1 Data Sources 1 Associations

Administrative Data for - Draft

I_PPS_DraftAdministrationData is a Composite CDS View that provides data about "Administrative Data for - Draft" in SAP S/4HANA. It reads from 1 data source (I_PPS_DrftAdminDataBasic) and exposes 14 fields with key field DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPS_DrftAdminDataBasic I_PPS_DrftAdminDataBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedByUserDesc $projection.CreatedByUser = _CreatedByUserDesc.ContactCardID

Annotations (8)

NameValueLevelField
EndUserText.label Administrative Data for - Draft view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID DraftUUID UUID
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
DraftAccessType DraftAccessType Draft Access Type
ProcessingStartDateTime ProcessingStartDateTime Time Stamp
InProcessByUser InProcessByUser Draft In Process By
DraftIsKeptByUser DraftIsKeptByUser Draft Is Kept By User
EnqueueStartDateTime EnqueueStartDateTime Time Stamp
DraftIsCreatedByMe DraftIsCreatedByMe
DraftIsLastChangedByMe DraftIsLastChangedByMe
DraftIsProcessedByMe DraftIsProcessedByMe
_CreatedByUserDesc _CreatedByUserDesc

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_PPS_DraftAdministrationData.
-- 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.

CREATE VIEW I_PPS_DraftAdministrationData AS
SELECT
  DraftUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  DraftAccessType,
  ProcessingStartDateTime,
  InProcessByUser,
  DraftIsKeptByUser,
  EnqueueStartDateTime,
  DraftIsCreatedByMe,
  DraftIsLastChangedByMe,
  DraftIsProcessedByMe
FROM I_PPS_DrftAdminDataBasic
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserDesc ON CreatedByUser = _CreatedByUserDesc.ContactCardID  -- association [0..1]
;

Learn More