P_PRToFirstPurchasOrder1

DDL: P_PRTOFIRSTPURCHASORDER1 SQL: PPRFIRSTPO1A Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

First Purchase Order created to a PR

P_PRToFirstPurchasOrder1 is a Consumption CDS View that provides data about "First Purchase Order created to a PR" in SAP S/4HANA. It reads from 2 data sources (P_PRToFirstPurchasOrder, I_PurchaseOrderItem) and exposes 4 fields. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
P_PRToFirstPurchasOrder P_PRToFirstPurchasOrder from
I_PurchaseOrderItem PurchaseOrderItem inner

Parameters (2)

NameTypeDefault
P_StartDate badat
P_EndDate badat

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPRFIRSTPO1A view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label First Purchase Order created to a PR view

Fields (4)

KeyFieldSource TableSource FieldDescription
PurchaseRequisition PurchaseReqItem PurchaseRequisition
PurchaseRequisitionItem PurchaseReqItem PurchaseRequisitionItem
PurchaseOrder
CreationDate I_PurchaseOrderItem CreationDate 
@AbapCatalog.sqlViewName: 'PPRFIRSTPO1A'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'First Purchase Order created to a PR'
define view P_PRToFirstPurchasOrder1
  with parameters
    P_StartDate : badat,
    P_EndDate   : badat
  as select from P_PRToFirstPurchasOrder(P_StartDate : $parameters.P_StartDate,
                                         P_EndDate : $parameters.P_EndDate) as PurchaseReqItem
    inner join   I_PurchaseOrderItem                                        as PurchaseOrderItem on  PurchaseOrderItem.PurchaseRequisition     = PurchaseReqItem.PurchaseRequisition
                                                                                                 and PurchaseOrderItem.PurchaseRequisitionItem = PurchaseReqItem.PurchaseRequisitionItem
                                                                                                 and PurchaseOrderItem.CreationDate            = PurchaseReqItem.CreationDate


{
  PurchaseReqItem.PurchaseRequisition,
  PurchaseReqItem.PurchaseRequisitionItem,
  min(PurchaseOrderItem.PurchaseOrder) as PurchaseOrder,
  PurchaseOrderItem.CreationDate
}
where
  PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
group by
  PurchaseReqItem.PurchaseRequisition,
  PurchaseReqItem.PurchaseRequisitionItem,
  PurchaseOrderItem.CreationDate

Learn More