C_PutawayStatusByDelivery

DDL: C_PUTAWAYSTATUSBYDELIVERY Type: view_entity CONSUMPTION

Count of Items by Putaway Status

C_PutawayStatusByDelivery is a Consumption CDS View that provides data about "Count of Items by Putaway Status" in SAP S/4HANA. It reads from 1 data source (I_InboundDeliveryItem) and exposes 6 fields with key field InboundDelivery.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_InboundDeliveryItem I_InboundDeliveryItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Count of Items by Putaway Status view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey InboundDelivery view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InboundDelivery InboundDelivery
NmbrOfPtwyNotRelevantItems
NmbrOfPtwyNotYetProcessedItems
NmbrOfPtwyPrtlyProcessedItems
NmbrOfPtwyCmpltlyProcdItems
_InboundDelivery _InboundDelivery 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Count of Items by Putaway Status'
@VDM: { viewType: #CONSUMPTION }
@ObjectModel: {
   representativeKey: 'InboundDelivery',
   usageType: {
     serviceQuality: #C,
     sizeCategory:   #XL,
     dataClass:      #TRANSACTIONAL
   },
   semanticKey: ['InboundDelivery']
   }

define root view entity C_PutawayStatusByDelivery
  as select from I_InboundDeliveryItem
{

      @ObjectModel: { foreignKey: { association: '_InboundDelivery' } }
  key InboundDelivery, 
      @EndUserText: { label: 'Number of Not Relevant Items' }
      @UI.lineItem: [{ position: 20 }]
      @UI.fieldGroup: [{ position: 10, qualifier: 'headerFacetPickingStatus' }]
      cast( sum( case when PickingStatus is initial then 1 else 0 end ) as int4 ) as NmbrOfPtwyNotRelevantItems,
      @EndUserText: { label: 'Number of Not Yet Processed Items' }
      @UI.lineItem: [{ position: 30 }]
      cast( sum( case when PickingStatus = 'A' then 1 else 0 end ) as int4 )      as NmbrOfPtwyNotYetProcessedItems,
      @EndUserText: { label: 'Number of Partially Processed Items' }
      @UI.lineItem: [{ position: 40 }]
      cast( sum( case when PickingStatus = 'B' then 1 else 0 end ) as int4 )      as NmbrOfPtwyPrtlyProcessedItems,
      @EndUserText: { label: 'Number of Completely Processed Items' }
      @UI.lineItem: [{ position: 50 }]
      cast( sum( case when PickingStatus = 'C' then 1 else 0 end ) as int4 )      as NmbrOfPtwyCmpltlyProcdItems,

      _InboundDelivery

}
group by
  InboundDelivery
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INBOUNDDELIVERYITEM"
],
"ASSOCIATED":
[
"I_INBOUNDDELIVERY"
],
"BASE":
[
"I_INBOUNDDELIVERYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More