C_CmmdtyOrdFillPacketSts

DDL: C_CMMDTYORDFILLPACKETSTS SQL: CCMMDTYFLPKTSTS Type: view CONSUMPTION

Consumption View for Fill Packet Status

C_CmmdtyOrdFillPacketSts is a Consumption CDS View (Cube) that provides data about "Consumption View for Fill Packet Status" in SAP S/4HANA. It reads from 3 data sources (I_CmmdtyErrorMsgsByFillPacket, I_CmmdtyWrngMsgsByFillPacket, I_CommodityOrderFillPacket).

3 data source(s)

Data Sources (3)

SourceAliasJoin Type
I_CmmdtyErrorMsgsByFillPacket _ErrorCount left_outer
I_CmmdtyWrngMsgsByFillPacket _WarningCount left_outer
I_CommodityOrderFillPacket I_CommodityOrderFillPacket from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCMMDTYFLPKTSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for Fill Packet Status view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.publish true view 
@AbapCatalog.sqlViewName: 'CCMMDTYFLPKTSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption View for Fill Packet Status'
@VDM.viewType: #CONSUMPTION
@Analytics.dataCategory: #CUBE
@Metadata.allowExtensions:true
@ObjectModel: {
    usageType: {
                 serviceQuality : #D,
                 sizeCategory   : #L,
                 dataClass      : #TRANSACTIONAL } }
@OData.publish: true

define view C_CmmdtyOrdFillPacketSts
  as select from    I_CommodityOrderFillPacket

  -- To Get Error Count
    left outer join I_CmmdtyErrorMsgsByFillPacket as _ErrorCount   on I_CommodityOrderFillPacket.CommodityOrderFillPacketUUID = _ErrorCount.CommodityOrderFillPacketUUID

  -- To Get Warning Count
    left outer join I_CmmdtyWrngMsgsByFillPacket  as _WarningCount on I_CommodityOrderFillPacket.CommodityOrderFillPacketUUID = _WarningCount.CommodityOrderFillPacketUUID

{

  -- Fill Packets with messages
  @DefaultAggregation: #SUM
  case
  when _ErrorCount.NumberOfErrorMessages > 0 then
  cast(1  as cmmfdof_cmmdtyflpktwithmsgs)

  when _WarningCount.NumberOfWarningMessages > 0 then
  cast(1  as cmmfdof_cmmdtyflpktwithmsgs)

  else
    0
  end as   CmmdtyOrdNrOfPacketsWithMsgs,

  -- Pending for approval
  @DefaultAggregation: #SUM
  case   I_CommodityOrderFillPacket.CmmdtyOrderFillPacketStatus
  when '02' then
  cast(1  as cmmfdof_cmmdtyflpktapprovalpen)
  else
    0
  end as   CmmdtyOrdNrOfPndgApprvlPackets,

  -- Total Fill Packets with messages and pendng for approval
  @DefaultAggregation: #SUM
  case
  when _ErrorCount.NumberOfErrorMessages > 0 then
  cast(1  as cmmfdor_cmmdtytotalorders)

  when _WarningCount.NumberOfWarningMessages > 0 then
  cast(1  as cmmfdor_cmmdtytotalorders)
  
  when  I_CommodityOrderFillPacket.CmmdtyOrderFillPacketStatus = '02' then
  cast(1  as cmmfdor_cmmdtytotalorders)
  else
  0
  end as   NumberOfRecords



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYERRORMSGSBYFILLPACKET",
"I_CMMDTYWRNGMSGSBYFILLPACKET",
"I_COMMODITYORDERFILLPACKET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More