R_PPSEntityAttributeDraft

DDL: R_PPSENTITYATTRIBUTEDRAFT Type: view_entity BASIC
17 Fields 1 Data Sources

Entity Attribute - Draft

R_PPSEntityAttributeDraft is a Basic CDS View that provides data about "Entity Attribute - Draft" in SAP S/4HANA. It reads from 1 data source (pps_entity_atr_d) and exposes 17 fields with key fields PPSEntityAttributeUUID, PPSEntityUUID.

Data Sources (1)

SourceAliasJoin Type
pps_entity_atr_d pps_entity_atr_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Entity Attribute - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PPSEntityAttributeUUID ppsentityattributeuuid
KEY PPSEntityUUID ppsentityuuid
PPSEntityAttributeType ppsentityattributetype
PPSEntityProfileUUID ppsentityprofileuuid
PPSEntityProfileID ppsentityprofileid
PPSEntyAttribValdFrmDte ppsentyattribvaldfrmdte Valid From
PPSEntyAttribValdToDte ppsentyattribvaldtodte Valid To
CreatedAtDateTime createdatdatetime Created On
LastChangedAtDateTime lastchangedatdatetime Changed On
CreatedByUser createdbyuser User Name
ChangedBy changedby User Name
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_PPSEntityAttributeDraft.
-- 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 R_PPSEntityAttributeDraft AS
SELECT
  PPSEntityAttributeUUID,
  PPSEntityUUID,
  PPSEntityAttributeType,
  PPSEntityProfileUUID,
  PPSEntityProfileID,
  PPSEntyAttribValdFrmDte,
  PPSEntyAttribValdToDte,
  CreatedAtDateTime,
  LastChangedAtDateTime,
  CreatedByUser,
  ChangedBy,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM pps_entity_atr_d
;

Learn More