I_CMMDTYORDFILLPACKETCOMMODITY
Basic View for Cmmdty Deriv Ord Fill Pkt
I_CMMDTYORDFILLPACKETCOMMODITY is a CDS View in S/4HANA. Basic View for Cmmdty Deriv Ord Fill Pkt. It contains 2 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CmmdtyOrderFillPacketLog | view | left_outer | CONSUMPTION | Consumption View for Order Error Log |
| I_CmmdtyErrorMsgsByFillPacket | view | from | COMPOSITE | Fill Packet Warning Error Count |
| I_CmmdtyWrngMsgsByFillPacket | view | from | COMPOSITE | Fill Packet Warning Message Count |
Fields (2)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CommodityOrderFillPacketUUID | CommodityOrderFillPacketUUID | 2 |
| CommodityOrderRequestUUID | CommodityOrderRequestUUID | 1 |
@AbapCatalog.sqlViewName: 'IFILLPKTCMMDTY'
@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_CmmdtyOrdFillPacketCommodity
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
{
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.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,
@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
----------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
}