P_OverduePurDocItems

DDL: P_OVERDUEPURDOCITEMS SQL: POVRDPURDOCITEMS Type: view CONSUMPTION Package: ODATA_MM_PUR_POITEMS_MONI

Purchasing Document Overdue Items

P_OverduePurDocItems is a Consumption CDS View that provides data about "Purchasing Document Overdue Items" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 7 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. Part of development package ODATA_MM_PUR_POITEMS_MONI.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine I_PurchaseOrderScheduleLine from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName POVRDPURDOCITEMS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine ScheduleLine
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
OpenPurchaseOrderNetAmount OpenPurchaseOrderNetAmount
Currency Currency
OpenPurchaseOrderQuantity OpenPurchaseOrderQuantity 
@AbapCatalog.sqlViewName: 'POVRDPURDOCITEMS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_OverduePurDocItems
  as select from I_PurchaseOrderScheduleLine
{

  key PurchaseOrder,
  key PurchaseOrderItem,
  key ScheduleLine,

      ScheduleLineDeliveryDate,
      OpenPurchaseOrderNetAmount,
      Currency,
      OpenPurchaseOrderQuantity

}
where
      ScheduleLineDeliveryDate  < $session.system_date
  and OpenPurchaseOrderQuantity > 0

Learn More