P_PRToFirstPurchasOrder

DDL: P_PRTOFIRSTPURCHASORDER SQL: PPRFIRSTPO Type: view CONSUMPTION

First Purchas Order created to a PR

P_PRToFirstPurchasOrder is a Consumption CDS View that provides data about "First Purchas Order created to a PR" in SAP S/4HANA. It reads from 3 data sources (P_PurchaseReqnItms, I_PurchaseOrder, I_PurchaseOrderItem) and exposes 3 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
P_PurchaseReqnItms P_PurchaseReqnItms from
I_PurchaseOrder PurchaseOrder inner
I_PurchaseOrderItem PurchaseOrderItem inner

Parameters (2)

NameTypeDefault
P_StartDate badat
P_EndDate badat

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPRFIRSTPO 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 Purchas Order created to a PR view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseReqItem PurchaseRequisition
KEY PurchaseRequisitionItem PurchaseReqItem PurchaseRequisitionItem
CreationDate 
@AbapCatalog.sqlViewName: 'PPRFIRSTPO'
@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 Purchas Order created to a PR'
define view P_PRToFirstPurchasOrder 
 with parameters
    P_StartDate       : badat,
    P_EndDate         : badat
 //as select from I_Purchaserequisitionitem as PurchaseReqItem          //To avoid unnecessary association

   as select from P_PurchaseReqnItms(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
  
    inner join   I_PurchaseOrder           as PurchaseOrder     on PurchaseOrderItem.PurchaseOrder = PurchaseOrder.PurchaseOrder
 
{
  key PurchaseReqItem.PurchaseRequisition,
  key PurchaseReqItem.PurchaseRequisitionItem,
      min( PurchaseOrder.CreationDate ) as CreationDate
}
where
//      PurchaseReqItem.ReleaseIsNotCompleted            = ''

//  and PurReqCreationDate != '00000000'

//  and PurReqCreationDate                               <= $parameters.P_EndDate

//  and PurReqCreationDate                               >= $parameters.P_StartDate

  PurchaseOrder.PurchasingDocumentDeletionCode     = ''
  and PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
  and PurchaseOrder.ReleaseIsNotCompleted              = ''
  and PurchaseOrder.PurchasingCompletenessStatus       = ''
 group by PurchaseReqItem.PurchaseRequisition,PurchaseReqItem.PurchaseRequisitionItem
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"P_PURCHASEREQNITMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More