I_COMMODITYORDERFILLPACKET
Basic View for Cmmdty Deriv Ord Fill Pkt
I_COMMODITYORDERFILLPACKET is a CDS View in S/4HANA. Basic View for Cmmdty Deriv Ord Fill Pkt. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CmmdtyOrdFillPacketSts | view | from | CONSUMPTION | Consumption View for Fill Packet Status |
| I_CommodityOrdFillPacketTP | view | from | TRANSACTIONAL | Tran. View for Cmmdty Deriv Ord Fill Pkt |
@AbapCatalog.sqlViewName: 'ICMMDTYORDFLPKT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Basic View for Cmmdty Deriv Ord Fill Pkt'
define view I_CommodityOrderFillPacket
as select from cmmfdof_d_flpkt as FillPacket
--Fill Packet Subaccount Information
left outer join I_CmmdtyOrderFillPacketSubAcct as FillPacketSubAcct on FillPacket.commodityorderfillpacketuuid = FillPacketSubAcct.CommodityOrderFillPacketUUID
--Association To get Order request
left outer join cmmfdor_d_order as _CommodityOrderRequest on FillPacket.commodityorderrequestuuid = _CommodityOrderRequest.commodityorderrequestuuid
-- Extension View for Commodity Order Fill Packet
association [0..1] to E_CmmdtyOrderFillPacket as _Extension on $projection.CommodityOrderFillPacketUUID = _Extension.CommodityOrderFillPacketUUID
{
key FillPacket.commodityorderfillpacketuuid as CommodityOrderFillPacketUUID,
-----------------------------------------------Fill Packet Information----------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------
FillPacket.commodityorderrequestuuid as CommodityOrderRequestUUID,
FillPacket.cmmdtyorderfillpacket as CmmdtyOrderFillPacket,
FillPacket.cmmdtyordfillpackettype as CmmdtyOrdFillPacketType,
FillPacket.commodityorderfillpacketid as CommodityOrderFillPacketID,
FillPacket.cmmdtyfillpacketmsgordid as CmmdtyFillPacketMsgOrdID,
FillPacket.cmmdtyfillpackettrdexecutionid as CmmdtyFillPacketTrdExecutionID,
FillPacket.cmmdtyorderfillrequesttype as CmmdtyOrderFillRequestType,
FillPacket.cmmdtyordfillcounterpartyinfo as CmmdtyOrdFillCounterPartyInfo,
FillPacket.cmmdtyordreqfilledqtyinlots as CmmdtyOrdReqFilledQtyInLots,
FillPacket.cmmdtyordreqrmngqtyinlots as CmmdtyOrdReqRmngQtyInLots,
FillPacket.cmmdtyordreqfilledqtyinlots as CmmdtyOrderFillQuantityInLots,
FillPacket.cmmdtyordfillrejectionreason as CmmdtyOrdFillRejectionReason,
FillPacket.cmmdtyordfillmultilegtype as CmmdtyOrdFillMultiLegType,
FillPacket.cmmdtyorderfillpacketstatus as CmmdtyOrderFillPacketStatus,
FillPacket.cmmdtyorderisfillwithorder as CmmdtyOrderIsFillWithOrder,
FillPacket.cmmdtyordfillfirstdistrddtetme as CmmdtyOrdFillFirstDistrdDteTme,
FillPacket.cmmdtyordfilllastdistrddatetme as CmmdtyOrdFillLastDistrdDateTme,
FillPacket.commodityorderrequesttrader as CommodityOrderRequestTrader,
FillPacket.decidedby as CommodityOrderFillDecidedBy,
FillPacket.decidedon as CommodityOrderFillDecidedOn,
--------------------------------------------------Subaccount Information----------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
FillPacketSubAcct.Commodity as Commodity,
FillPacketSubAcct.CommoditySubAccountUUID as CommoditySubAccountUUID,
FillPacketSubAcct.DerivativeContrSpecification as DerivativeContrSpecification,
FillPacketSubAcct.CommoditySubAccount as CommoditySubAccount,
FillPacketSubAcct.CommoditySubAccountName as CommoditySubAccountName,
FillPacketSubAcct.CommodityDerivativeBroker as CommodityDerivativeBroker,
FillPacketSubAcct.CompanyCode as CompanyCode,
FillPacketSubAcct.ProfitCenter as ProfitCenter,
--------------------------------------------------Order Request Information----------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
FillPacket.commodityorderrequest as CommodityOrderRequest,
_CommodityOrderRequest.creationdatetime as CmmdtyOrderDateTime,
_CommodityOrderRequest.cmmdtyorderrequesttype as CmmdtyOrderRequestType,
_CommodityOrderRequest.cmmdtyorderrequestsource as CmmdtyOrderRequestSource,
_CommodityOrderRequest.cmmdtyorderrequestreason as CmmdtyOrderRequestReason,
_CommodityOrderRequest.cmmdtyordrequestquantityinlot as CmmdtyOrdRequestQuantityInLot,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrderRequestQuantityUnit'
cast(( _CommodityOrderRequest.cmmdtyordrequestquantityinlot * _CommodityOrderRequest.cmmdtyderivativequantityperlot )
as cmmfdor_cmmdtyordrequestqty ) as CmmdtyOrderRequestQuantity,
_CommodityOrderRequest.cmmdtydrvtvquantityunitperlot as CmmdtyOrderRequestQuantityUnit,
----------------------------------------------------------------Admin Data-------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
FillPacket.createdbyuser as CreatedByUser,
FillPacket.creationdatetime as CreationDateTime,
FillPacket.lastchangedbyuser as LastChangedByUser,
FillPacket.lastchangedatetime as LastChangeDateTime
----------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYORDERFILLPACKETSUBACCT",
"CMMFDOF_D_FLPKT",
"CMMFDOR_D_ORDER"
],
"ASSOCIATED":
[
"E_CMMDTYORDERFILLPACKET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/