C_OverduePurchaseOrder

DDL: C_OVERDUEPURCHASEORDER Type: view CONSUMPTION

C_OverduePurchaseOrder is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_PurOrdScheduleLineBasic) and exposes 5 fields with key field PurchaseOrder. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_PurOrdScheduleLineBasic I_PurOrdScheduleLineBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName COVDPURORDER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
ScheduleLineDeliveryDate
NumberOfOverduePurOrders
NumberOfOverduePurOrdItm
_PurchaseOrder _PurchaseOrder 
@VDM.viewType: #CONSUMPTION
@AbapCatalog: { sqlViewName: 'COVDPURORDER' }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK

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

define view C_OverduePurchaseOrder as select from I_PurOrdScheduleLineBasic

association [1..1] to I_PurchaseOrder               as _PurchaseOrder               on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

{   

    key PurchaseOrder ,
    
    min(ScheduleLineDeliveryDate)               as ScheduleLineDeliveryDate,
    count( distinct PurchaseOrder )             as NumberOfOverduePurOrders,
    count( distinct PurchaseOrderItem )         as NumberOfOverduePurOrdItm,
    
    _PurchaseOrder   

}   where ScheduleLineOrderQuantity > RoughGoodsReceiptQty
        and ScheduleLineDeliveryDate is not null and ScheduleLineDeliveryDate between '19720401' and $session.system_date
        and (_PurchaseOrderItem.PurchasingDocumentDeletionCode = '' or _PurchaseOrderItem.PurchasingDocumentDeletionCode is null) //2823679

        and (_PurchaseOrderItem.IsCompletelyDelivered = '' or _PurchaseOrderItem.IsCompletelyDelivered is null) //2839043

        and (_PurchaseOrderItem.IsStatisticalItem = '' or _PurchaseOrderItem.IsStatisticalItem is null)
        group by PurchaseOrder ;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERITEM",
"I_PURORDSCHEDULELINEBASIC"
],
"ASSOCIATED":
[
"I_PURCHASEORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More