P_PurOrdMaintDraftAdminData

DDL: P_PURORDRMAINTDRAFTADMINDATA SQL: PPOMAINTDRAFTADM Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN

Purchase Order Maintenance Draft Administrative Data

P_PurOrdMaintDraftAdminData is a Consumption CDS View that provides data about "Purchase Order Maintenance Draft Administrative Data" in SAP S/4HANA. It reads from 1 data source (I_DraftAdministrativeData) and exposes 11 fields with key field ID. Part of development package ODATA_MM_PUR_PO_MAINTAIN.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_DraftAdministrativeData I_DraftAdministrativeData from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPOMAINTDRAFTADM view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ID
EntityName DraftEntityType
DraftID DraftUUID
CreationDateTime CreationDateTime
CreationUserName CreatedByUser
LastChangedDateTime LastChangeDateTime
LastChangedUserName LastChangedByUser
ProcessedSinceDateTime ProcessingStartDateTime
ProcessorUserName LastChangedByUser
ExclusiveSince EnqueueStartDateTime
ExclusiveBy LastChangedByUser 
@AbapCatalog.sqlViewName: 'PPOMAINTDRAFTADM'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

//Purchase Order Maintenance Draft Administrative Data

define view P_PurOrdMaintDraftAdminData
//    with parameters EntityName : abap.char( 40 )

    as select from I_DraftAdministrativeData  --pom_sdraft_admin 
{
  key bintohex(DraftUUID) as ID,
  DraftEntityType         as EntityName,  
  DraftUUID               as DraftID,
  CreationDateTime        as CreationDateTime, 
  CreatedByUser           as CreationUserName, 
  LastChangeDateTime      as LastChangedDateTime, 
  LastChangedByUser       as LastChangedUserName,
  ProcessingStartDateTime as ProcessedSinceDateTime, 
  LastChangedByUser       as ProcessorUserName,
  EnqueueStartDateTime    as ExclusiveSince,
  LastChangedByUser       as ExclusiveBy 
} where DraftEntityType = 'MM_PO_DRAFT'
//  where entity_name = $parameters.EntityName

Learn More