I_COMMODITYORDFILLPACKETLOG
Basic View for a Commodity Derivative Order Fill Packet Log
I_COMMODITYORDFILLPACKETLOG is a CDS View in S/4HANA. Basic View for a Commodity Derivative Order Fill Packet Log. It contains 18 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CmmdtyOrderFillPacketLog | view | from | CONSUMPTION | Consumption View for Order Error Log |
| I_CmmdtyOrderReqPacketLog | view | from | COMPOSITE | Basic View for Order Error Log |
| I_CommodityOrdFillPacketLogTP | view | from | TRANSACTIONAL | Transactional View for a Cmmdty Deriv Ord Fill Packet Log |
Fields (18)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CmmdtyOrderFillPacketMsgUUID | CmmdtyOrderFillPacketMsgUUID | 2 |
| CmmdtyOrderFillMessageSource | CmmdtyOrderFillMessageSource | 1 | |
| CmmdtyOrderFillPacket | CmmdtyOrderFillPacket | 1 | |
| CmmdtyOrderFillRequestType | CmmdtyOrderFillRequestType | 1 | |
| Commodity | Commodity | 1 | |
| CommodityOrderFillPacketUUID | CommodityOrderFillPacketUUID | 2 | |
| CommodityOrderRequestTrader | CommodityOrderRequestTrader | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| SystemMessageIdentification | SystemMessageIdentification | 1 | |
| SystemMessageNumber | SystemMessageNumber | 1 | |
| SystemMessageText | SystemMessageText | 1 | |
| SystemMessageType | SystemMessageType | 1 | |
| SystemMessageVariable1 | SystemMessageVariable1 | 1 | |
| SystemMessageVariable2 | SystemMessageVariable2 | 1 | |
| SystemMessageVariable3 | SystemMessageVariable3 | 1 | |
| SystemMessageVariable4 | SystemMessageVariable4 | 1 |
@AbapCatalog.sqlViewName: 'ICMDTYFLPKTLOG'
@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
@EndUserText.label: 'Basic View for a Commodity Derivative Order Fill Packet Log'
define view I_CommodityOrdFillPacketLog
as select from cmmfdof_d_flmsg
--Association to Get Fill Type from Packet
// association [0..1] to I_CommodityOrderFillPacket as _CommodityOrderFillPacket on $projection.CommodityOrderFillPacketUUID = _CommodityOrderFillPacket.CommodityOrderFillPacketUUID
association [0..1] to I_CmmdtyOrdFillPacketCommodity as _CommodityOrderFillPacket on $projection.CommodityOrderFillPacketUUID = _CommodityOrderFillPacket.CommodityOrderFillPacketUUID
{
key cmmdtyorderfillpacketmsguuid as CmmdtyOrderFillPacketMsgUUID,
commodityorderfillpacketuuid as CommodityOrderFillPacketUUID,
cmmdtyorderfillpacket as CmmdtyOrderFillPacket,
cmmdtyorderfillmessagesource as CmmdtyOrderFillMessageSource,
systemmessagetype as SystemMessageType,
systemmessageidentification as SystemMessageIdentification,
systemmessagenumber as SystemMessageNumber,
systemmessagetext as SystemMessageText,
systemmessagevariable1 as SystemMessageVariable1,
systemmessagevariable2 as SystemMessageVariable2,
systemmessagevariable3 as SystemMessageVariable3,
systemmessagevariable4 as SystemMessageVariable4,
_CommodityOrderFillPacket.CommodityOrderRequestTrader as CommodityOrderRequestTrader,
_CommodityOrderFillPacket.CompanyCode as CompanyCode,
_CommodityOrderFillPacket.CmmdtyOrderFillRequestType as CmmdtyOrderFillRequestType,
_CommodityOrderFillPacket.Commodity as Commodity,
createdbyuser as CreatedByUser,
creationdatetime as CreationDateTime,
---------------------------------------------------------------------------
-------------------------Associations--------------------------------------
_CommodityOrderFillPacket
}