I_CMMDTYORDFILLQTYBYFILLPACKET
Basic value for Fill Pkt Filled Qty
I_CMMDTYORDFILLQTYBYFILLPACKET is a CDS View in S/4HANA. Basic value for Fill Pkt Filled Qty. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CommodityOrdFillPacketTP | view | left_outer | TRANSACTIONAL | Tran. View for Cmmdty Deriv Ord Fill Pkt |
@AbapCatalog.sqlViewName: 'ICMMDTYPKTFLQTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic value for Fill Pkt Filled Qty'
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType :{ serviceQuality: #X, sizeCategory : #S, dataClass: #TRANSACTIONAL}
@VDM.viewType : #COMPOSITE
define view I_CmmdtyOrdFillQtyByFillPacket
as select from I_CommodityOrderRequestFill
{
key CommodityOrderFillPacketUUID as CommodityOrderFillPacketUUID,
-- Find Sum of Filled Quantity of Fills in a Fill Packet
sum(CmmdtyOrderFillQuantity ) as CmmdtyOrderFillQuantity,
CmmdtyOrderFillQuantityUnit as CmmdtyOrderFillQuantityUnit
}
group by
CommodityOrderFillPacketUUID,
CmmdtyOrderFillQuantityUnit