P_OverduePO3

DDL: P_OVERDUEPO3 SQL: POVRDUEPO3 Type: view CONSUMPTION

Overdue PO with Return Items

P_OverduePO3 is a Consumption CDS View that provides data about "Overdue PO with Return Items" in SAP S/4HANA. It reads from 2 data sources (I_PurgAnalyticsConfiguration, I_PurchaseOrderScheduleLine) and exposes 22 fields with key fields PurchaseOrder, PurchaseOrderItem.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgAnalyticsConfiguration MigrationStatus from
I_PurchaseOrderScheduleLine ScheduleLine inner

Parameters (2)

NameTypeDefault
P_StartDate mm_a_delivery_date
P_EndDate mm_a_delivery_date

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName POVRDUEPO3 view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Overdue PO with Return Items view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder
KEY PurchaseOrderItem
Supplier _PurchaseOrder Supplier
PurchasingOrganization _PurchaseOrder PurchasingOrganization
PurchasingGroup _PurchaseOrder PurchasingGroup
PurchaseOrderItemCategory _PurchaseOrderItem PurchaseOrderItemCategory
PurchaseOrderCategory _PurchaseOrderItem PurchaseOrderCategory
PurchaseOrderType _PurchaseOrder PurchaseOrderType
SupplierConfirmationControlKey _PurchaseOrderItem SupplierConfirmationControlKey
Material _PurchaseOrderItem Material
MaterialGroup _PurchaseOrderItem MaterialGroup
PurchaseOrderItemText _PurchaseOrderItem PurchaseOrderItemText
PurgDocHdrCompanyCode _PurchaseOrder CompanyCode
CompanyCode _PurchaseOrderItem CompanyCode
Plant _PurchaseOrderItem Plant
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit
OrderQuantity _PurchaseOrderItem OrderQuantity
DocumentCurrency _PurchaseOrderItem DocumentCurrency
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
OpenPurchaseOrderQuantity OpenPurchaseOrderQuantity
GoodsReceiptQuantity RoughGoodsReceiptQty
OpenPurchaseOrderNetAmount 
@AbapCatalog.sqlViewName: 'POVRDUEPO3'
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private : true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Overdue PO with Return Items'
define view P_OverduePO3 with parameters
    P_StartDate : mm_a_delivery_date,
    P_EndDate   : mm_a_delivery_date

  as select from I_PurgAnalyticsConfiguration as MigrationStatus
    inner join   I_PurchaseOrderScheduleLine as ScheduleLine on MigrationStatus.IsIntrastatReportingRelevant = ''

  association        to I_PurchaseOrder          as _PurchaseOrder          on  ScheduleLine.PurchaseOrder = _PurchaseOrder.PurchaseOrder

  association        to I_PurchaseOrderItem      as _PurchaseOrderItem      on  ScheduleLine.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                            and ScheduleLine.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
{
  key cast( PurchaseOrder as vdm_purchaseorder )            as PurchaseOrder,

  key cast( PurchaseOrderItem as vdm_purchaseorderitem )    as PurchaseOrderItem,
  
      _PurchaseOrder.Supplier,
      _PurchaseOrder.PurchasingOrganization,
      _PurchaseOrder.PurchasingGroup,

      _PurchaseOrderItem.PurchaseOrderItemCategory,
      _PurchaseOrderItem.PurchaseOrderCategory,
      _PurchaseOrder.PurchaseOrderType,
      _PurchaseOrderItem.SupplierConfirmationControlKey,

      _PurchaseOrderItem.Material,
      _PurchaseOrderItem.MaterialGroup,
      _PurchaseOrderItem.PurchaseOrderItemText,               //2860246

      _PurchaseOrder.CompanyCode as PurgDocHdrCompanyCode,
      _PurchaseOrderItem.CompanyCode,
      _PurchaseOrderItem.Plant,

      PurchaseOrderQuantityUnit,
      _PurchaseOrderItem.OrderQuantity,
      _PurchaseOrderItem.DocumentCurrency,      

      ScheduleLineDeliveryDate,

      OpenPurchaseOrderQuantity,

      RoughGoodsReceiptQty                                 as GoodsReceiptQuantity,

      OpenPurchaseOrderNetAmount * cast( case when _PurchaseOrderItem.IsReturnsItem = 'X' then -1 else 1 end as int2 )  as OpenPurchaseOrderNetAmount
}
where OpenPurchaseOrderQuantity                         > 0
  and _PurchaseOrderItem.GoodsReceiptIsExpected         = 'X'
  and _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
  and _PurchaseOrderItem.IsCompletelyDelivered != 'X'
  and _PurchaseOrder.PurchasingCompletenessStatus != 'X'
  and _PurchaseOrderItem.DocumentCurrency               is not null
  and ScheduleLineDeliveryDate                          < $session.system_date
  and ScheduleLineDeliveryDate                          >= $parameters.P_StartDate
  and ScheduleLineDeliveryDate                          <= $parameters.P_EndDate
  and not (
      _PurchaseOrderItem.Material                       =''
      and _PurchaseOrderItem.IsStatisticalItem          ='X'
       )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"I_PURCHASEORDERSCHEDULELINE",
"I_PURGANALYTICSCONFIGURATION"
],
"ASSOCIATED":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More