P_OpenDelivery

DDL: P_OPENDELIVERY SQL: POPENDELIV Type: view CONSUMPTION Package: ODATA_MM_PUR_SUBCONTRG_COCKPIT

Open Deliveries

P_OpenDelivery is a Consumption CDS View that provides data about "Open Deliveries" in SAP S/4HANA. It reads from 1 data source (I_OutboundDeliveryItem) and exposes 5 fields with key fields Material, Supplier, Plant. Part of development package ODATA_MM_PUR_SUBCONTRG_COCKPIT.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_OutboundDeliveryItem I_OutboundDeliveryItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName POPENDELIV view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Open Deliveries view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Supplier _OutboundDelivery Supplier
KEY Plant Plant
MaterialIsIntBatchManaged MaterialIsIntBatchManaged
ActualDeliveryQuantity 
@AbapCatalog.sqlViewName: 'POPENDELIV'
@VDM.private: true
@VDM.viewType: #CONSUMPTION

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
--@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Open Deliveries'
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@Metadata.ignorePropagatedAnnotations: true

define view P_OpenDelivery
  as select from I_OutboundDeliveryItem



{
  key Material,

  key _OutboundDelivery.Supplier,

  key Plant,

      MaterialIsIntBatchManaged,

      sum(ActualDeliveryQuantity) as ActualDeliveryQuantity


}

where
      I_OutboundDeliveryItem.GoodsMovementType =  '541' //Subcontracting Type


  and ActualDeliveryQuantity                   >  0
  and I_OutboundDeliveryItem.Material          <> ''
  and _OutboundDelivery.Supplier               <> ''
  and Plant                                    <> ''
  and GoodsMovementStatus                      =  'A' // A = Not Yet Started

//Flag has not been considered as Materials which are managed by Batch also need to de calculated

// and MaterialIsIntBatchManaged = ''


//and Reservation = '0000000000'




group by
  Material,
  Plant,
  _OutboundDelivery.Supplier,

  MaterialIsIntBatchManaged

Learn More