I_COMMODITYORDERFILL
Commodity Order Fill
I_COMMODITYORDERFILL is a CDS View in S/4HANA. Commodity Order Fill. It contains 54 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CmmdtyOrdFillRelatedFill | view | from | CONSUMPTION | Assigned Fills Consumption View |
| I_CmmdtyOrdReqAssignedFill | view | from | COMPOSITE | Assigned Fills Basic View |
| I_CommodityOrderFillTP | view | from | TRANSACTIONAL | Commodity Order Fill Transactional View |
Fields (54)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CommodityOrderFillUUID | CommodityOrderFillUUID | 2 |
| CmmdtyOrderDateTime | CmmdtyOrderDateTime | 1 | |
| CmmdtyOrderFillCounterParty | CmmdtyOrderFillCounterParty | 1 | |
| CmmdtyOrderFillCurrencyPerLot | CmmdtyOrderFillCurrencyPerLot | 1 | |
| CmmdtyOrderFillDateTime | CmmdtyOrderFillDateTime | 1 | |
| CmmdtyOrderFillFutureID | CmmdtyOrderFillFutureID | 1 | |
| CmmdtyOrderFillPacket | CmmdtyOrderFillPacket | 2 | |
| CmmdtyOrderFillPrice | CmmdtyOrderFillPrice | 2 | |
| CmmdtyOrderFillPriceCrcy | CmmdtyOrderFillPriceCrcy | 1 | |
| CmmdtyOrderFillQuantityInLots | CmmdtyOrderFillQuantityInLots | 1 | |
| CmmdtyOrderFillQuantityUnit | CmmdtyOrderFillQuantityUnit | 1 | |
| CmmdtyOrderFillRequestType | CmmdtyOrderFillRequestType | 1 | |
| CmmdtyOrderFillStatus | CmmdtyOrderFillStatus | 1 | |
| CmmdtyOrderFillTotalPrice | CmmdtyOrderFillTotalPrice | 1 | |
| CmmdtyOrderFillTotalPriceCrcy | CmmdtyOrderFillTotalPriceCrcy | 1 | |
| CmmdtyOrderFillTotalQuantity | CmmdtyOrderFillTotalQuantity | 1 | |
| CmmdtyOrderFillTotQuantityUnit | CmmdtyOrderFillTotQuantityUnit | 1 | |
| CmmdtyOrderIsFillWithOrder | CmmdtyOrderIsFillWithOrder | 1 | |
| CmmdtyOrderReqLegOwnerRole | CmmdtyOrderReqLegOwnerRole | 1 | |
| CmmdtyOrderReqLegUUID | CmmdtyOrderReqLegUUID | 1 | |
| CmmdtyOrderRequestFlowType | CmmdtyOrderRequestFlowType | 1 | |
| CmmdtyOrderRequestQuantity | CmmdtyOrderRequestQuantity | 1 | |
| CmmdtyOrderRequestReason | CmmdtyOrderRequestReason | 1 | |
| CmmdtyOrderRequestSource | CmmdtyOrderRequestSource | 1 | |
| CmmdtyOrderRequestType | CmmdtyOrderRequestType | 1 | |
| CmmdtyOrdFillAssignOrder | CmmdtyOrdFillAssignOrder | 1 | |
| CmmdtyOrdFillCumulativeQtyUnit | CmmdtyOrdFillCumulativeQtyUnit | 1 | |
| CmmdtyOrdFillFinancialTransID | CmmdtyOrdFillFinancialTransID | 1 | |
| CmmdtyOrdFillQuantityPerLot | CmmdtyOrdFillQuantityPerLot | 1 | |
| CmmdtyOrdFillRejectionReason | CmmdtyOrdFillRejectionReason | 1 | |
| CmmdtyOrdFillUoMPerLot | CmmdtyOrderFillQtyToPriceUnit,CmmdtyOrdFillPricedQtyUnit,CmmdtyOrdFillUoMPerLot | 1 | |
| CmmdtyOrdReqCntrPtyBroker | CmmdtyOrdReqCntrPtyBroker | 1 | |
| CmmdtyOrdReqCntrPtySubAcct | CmmdtyOrdReqCntrPtySubAcct | 1 | |
| CmmdtyOrdRequestQuantityInLot | CmmdtyOrdRequestQuantityInLot | 1 | |
| Commodity | Commodity | 1 | |
| CommodityOrderFill | CommodityOrderFill | 1 | |
| CommodityOrderFillPacketID | CommodityOrderFillPacketID | 1 | |
| CommodityOrderFillPacketUUID | CommodityOrderFillPacketUUID | 2 | |
| CommodityOrderRequest | CommodityOrderRequest | 1 | |
| CommodityOrderRequestUUID | CommodityOrderRequestUUID | 2 | |
| CommodityProductSymbol | CommodityProductSymbol | 1 | |
| CommoditySubAccount | CommoditySubAccount | 1 | |
| CommoditySubAccountName | CommoditySubAccountName | 1 | |
| CommoditySubAccountUUID | CommoditySubAccountUUID | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| DerivativeContrSpecification | DerivativeContrSpecification | 1 | |
| IsArchived | IsArchived | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| MarketIdentifierCode | MarketIdentifierCode | 1 | |
| MaturityKeyDate | MaturityKeyDate | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceBrokerAccount | ReferenceBrokerAccount | 1 |
@AbapCatalog.sqlViewName: 'ICMMDTYORDERFILL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Commodity Order Fill'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
--- Basic View for Commodity Order Fill
define view I_CommodityOrderFill
as select from cmmfdof_d_fill as Fill
--Association To get Order request
left outer join cmmfdor_d_order as CommodityOrderRequest on Fill.commodityorderrequestuuid = CommodityOrderRequest.commodityorderrequestuuid
--Association To get Subaccount
left outer join cmmfsa_d_subacct as CommoditySubaccount on Fill.commoditysubaccountuuid = CommoditySubaccount.commoditysubaccountuuid
--Association to Get Fill Type from Packet
left outer join cmmfdof_d_flpkt as CommodityOrderFillPacket on Fill.commodityorderfillpacketuuid = CommodityOrderFillPacket.commodityorderfillpacketuuid
-- Extension View for Free Characteristics in Commodity Order Fill
association [0..1] to E_CommodityOrderFill as _Extension on $projection.CommodityOrderFillUUID = _Extension.CommodityOrderFillUUID
{
key Fill.commodityorderfilluuid as CommodityOrderFillUUID,
Fill.commodityorderfillpacketuuid as CommodityOrderFillPacketUUID,
CommodityOrderFillPacket.commodityorderfillpacketid as CommodityOrderFillPacketID,
Fill.commodityorderfill as CommodityOrderFill,
CommodityOrderFillPacket.cmmdtyorderfillrequesttype as CmmdtyOrderFillRequestType,
Fill.cmmdtyorderfillpacket as CmmdtyOrderFillPacket,
Fill.cmmdtyorderfilldatetime as CmmdtyOrderFillDateTime,
Fill.commodityorderrequestuuid as CommodityOrderRequestUUID,
Fill.cmmdtyorderreqleguuid as CmmdtyOrderReqLegUUID,
CommodityOrderRequest.commodityorderrequest as CommodityOrderRequest,
CommodityOrderRequest.creationdatetime as CmmdtyOrderDateTime,
CommodityOrderRequest.cmmdtyorderrequesttype as CmmdtyOrderRequestType,
CommodityOrderRequest.cmmdtyorderrequestsource as CmmdtyOrderRequestSource,
CommodityOrderRequest.cmmdtyorderrequestreason as CmmdtyOrderRequestReason,
CommodityOrderRequest.cmmdtyordrequestquantityinlot as CmmdtyOrdRequestQuantityInLot,
CommodityOrderRequest.cmmdtyderivativequantityperlot as CmmdtyDerivativeQuantityPerLot,
cast(( CommodityOrderRequest.cmmdtyordrequestquantityinlot * CommodityOrderRequest.cmmdtyderivativequantityperlot )
as cmmfdor_cmmdtyordrequestqty ) as CmmdtyOrderRequestQuantity,
Fill.cmmdtyorderfillstatus as CmmdtyOrderFillStatus,
Fill.commoditysubaccountuuid as CommoditySubAccountUUID,
CommoditySubaccount.commoditysubaccount as CommoditySubAccount,
CommoditySubaccount.commoditysubaccountname as CommoditySubAccountName,
Fill.commodityderivativebroker as CommodityDerivativeBroker,
Fill.referencebrokeraccount as ReferenceBrokerAccount,
Fill.cmmdtyordreqcntrptybroker as CmmdtyOrdReqCntrPtyBroker,
Fill.cmmdtyordreqcntrptysubacct as CmmdtyOrdReqCntrPtySubAcct,
Fill.cmmdtyorderreqlegownerrole as CmmdtyOrderReqLegOwnerRole,
CommoditySubaccount.profitcenter as ProfitCenter,
CommoditySubaccount.companycode as CompanyCode,
Fill.cmmdtyordfillfinancialtransid as CmmdtyOrdFillFinancialTransID,
Fill.cmmdtyorderrequestflowtype as CmmdtyOrderRequestFlowType,
Fill.cmmdtyorderfillfutureid as CmmdtyOrderFillFutureID,
Fill.commodity as Commodity,
Fill.marketidentifiercode as MarketIdentifierCode,
Fill.derivativecontrspecification as DerivativeContrSpecification,
Fill.maturitykeydate as MaturityKeyDate,
Fill.cmmdtyordfillquantityperlot as CmmdtyOrdFillQuantityPerLot,
Fill.cmmdtyordfilluomperlot as CmmdtyOrdFillUoMPerLot,
Fill.cmmdtyorderfillcurrencyperlot as CmmdtyOrderFillCurrencyPerLot,
Fill.cmmdtyorderfillquantityinlots as CmmdtyOrderFillQuantityInLots,
Fill.cmmdtyorderfillprice as CmmdtyOrderFillPrice,
Fill.cmmdtyorderfillpricecrcy as CmmdtyOrderFillPriceCrcy,
Fill.cmmdtyordfillassignorder as CmmdtyOrdFillAssignOrder,
CommodityOrderFillPacket.cmmdtyorderfillpacketstatus as CmmdtyOrderFillPacketStatus,
CommodityOrderFillPacket.cmmdtyfillpacketmsgordid as CmmdtyFillPacketMsgOrdID,
CommodityOrderFillPacket.cmmdtyfillpackettrdexecutionid as CmmdtyFillPacketTrdExecutionID,
-- Fill Quantity
cast ( ( Fill.cmmdtyorderfillquantityinlots * Fill.cmmdtyordfillquantityperlot) as cmmfdof_cmmdtyordfillqty )
as CmmdtyOrderFillQuantity,
-- Fill Quantity UOM
Fill.cmmdtyordfilluomperlot as CmmdtyOrderFillQuantityUnit,
-- Cummulative Quantity UOM
Fill.cmmdtyordfilluomperlot as CmmdtyOrdFillCumulativeQtyUnit,
-- Total Price
cast ( ( Fill.cmmdtyorderfillprice * ( Fill.cmmdtyorderfillquantityinlots * Fill.cmmdtyordfillquantityperlot) )
as cmmfdof_cmmdtyordfilltotprice ) as CmmdtyOrderFillTotalPrice,
-- Total Price UOM
Fill.cmmdtyorderfillpricecrcy as CmmdtyOrderFillTotalPriceCrcy,
-- Total Quantity
cast ( ( Fill.cmmdtyorderfillquantityinlots * Fill.cmmdtyordfillquantityperlot) as cmmfdof_cmmdtyordfilltotalqty )
as CmmdtyOrderFillTotalQuantity,
Fill.cmmdtyordfilluomperlot as CmmdtyOrderFillTotQuantityUnit,
-- Quantity to be priced
cast ( ( Fill.cmmdtyorderfillquantityinlots * Fill.cmmdtyordfillquantityperlot) as cmmfdof_cmmdtyordfillqtytopri )
as CmmdtyOrderFillQuantityToPrice,
Fill.cmmdtyordfilluomperlot as CmmdtyOrderFillQtyToPriceUnit,
-- Priced Quantity
Fill.cmmdtyordfilluomperlot as CmmdtyOrdFillPricedQtyUnit,
----------------
Fill.createdbyuser as CreatedByUser,
Fill.creationdatetime as CreationDateTime,
Fill.lastchangedbyuser as LastChangedByUser,
Fill.lastchangedatetime as LastChangeDateTime,
Fill.decidedby as CommodityOrderFillDecidedBy,
Fill.decidedon as CommodityOrderFillDecidedOn,
Fill.cmmdtyordfillrejectionreason as CmmdtyOrdFillRejectionReason,
Fill.cmmdtyorderfillcounterparty as CmmdtyOrderFillCounterParty,
Fill.cmmdtyorderisfillwithorder as CmmdtyOrderIsFillWithOrder,
-- Number of Ticks in case of Trade at Settlement Order Request
Fill.commodityorderrequestticks as CommodityOrderRequestTicks,
Fill.commodityproductsymbol as CommodityProductSymbol,
Fill.cmmdtyordfillismktclsprcassgd as CmmdtyOrdFillIsMktClsPrcAssgd,
Fill.cmmdtyordfillmarketcloseprice as CmmdtyOrdFillMarketClosePrice,
Fill.cmmdtyordfillmktprcatfwdcrtn as CmmdtyOrdFillMktPrcAtFwdCrtn,
Fill.cmmdtyorderreqistrdatsettlmt as CmmdtyOrderReqIsTrdAtSettlmt,
Fill.succ_archive as IsArchived
}