I_CommodityOrdFillPacketLog

DDL: I_COMMODITYORDFILLPACKETLOG SQL: ICMDTYFLPKTLOG Type: view BASIC
19 Fields 1 Data Sources 1 Associations

Basic View for a Commodity Derivative Order Fill Packet Log

I_CommodityOrdFillPacketLog is a Basic CDS View that provides data about "Basic View for a Commodity Derivative Order Fill Packet Log" in SAP S/4HANA. It reads from 1 data source (cmmfdof_d_flmsg) and exposes 19 fields with key field CmmdtyOrderFillPacketMsgUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cmmfdof_d_flmsg cmmfdof_d_flmsg from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CmmdtyOrdFillPacketCommodity _CommodityOrderFillPacket $projection.CommodityOrderFillPacketUUID = _CommodityOrderFillPacket.CommodityOrderFillPacketUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMDTYFLPKTLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Basic View for a Commodity Derivative Order Fill Packet Log view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyOrderFillPacketMsgUUID cmmdtyorderfillpacketmsguuid Key
CommodityOrderFillPacketUUID commodityorderfillpacketuuid Key
CmmdtyOrderFillPacket cmmdtyorderfillpacket Fill Packet Sequence
CmmdtyOrderFillMessageSource cmmdtyorderfillmessagesource Message Source
SystemMessageType systemmessagetype Message type
SystemMessageIdentification systemmessageidentification Message ID
SystemMessageNumber systemmessagenumber Message Number
SystemMessageText systemmessagetext Message Text
SystemMessageVariable1 systemmessagevariable1 Variable 1
SystemMessageVariable2 systemmessagevariable2 Variable 2
SystemMessageVariable3 systemmessagevariable3 Variable 3
SystemMessageVariable4 systemmessagevariable4 Variable 4
CommodityOrderRequestTrader _CommodityOrderFillPacket CommodityOrderRequestTrader Trader
CompanyCode _CommodityOrderFillPacket CompanyCode Receiver Company Code
CmmdtyOrderFillRequestType _CommodityOrderFillPacket CmmdtyOrderFillRequestType Fill Packet Type
Commodity _CommodityOrderFillPacket Commodity Commodity Code
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
Associations_CommodityOrderFillPacket

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CommodityOrdFillPacketLog.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICMDTYFLPKTLOG

CREATE VIEW I_CommodityOrdFillPacketLog AS
SELECT
  CmmdtyOrderFillPacketMsgUUID,
  CommodityOrderFillPacketUUID,
  CmmdtyOrderFillPacket,
  CmmdtyOrderFillMessageSource,
  SystemMessageType,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageText,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  _CommodityOrderFillPacket.CommodityOrderRequestTrader AS CommodityOrderRequestTrader,
  _CommodityOrderFillPacket.CompanyCode AS CompanyCode,
  _CommodityOrderFillPacket.CmmdtyOrderFillRequestType AS CmmdtyOrderFillRequestType,
  _CommodityOrderFillPacket.Commodity AS Commodity,
  CreatedByUser,
  CreationDateTime
FROM cmmfdof_d_flmsg
LEFT OUTER JOIN I_CmmdtyOrdFillPacketCommodity AS _CommodityOrderFillPacket ON CommodityOrderFillPacketUUID = _CommodityOrderFillPacket.CommodityOrderFillPacketUUID  -- association [0..1]
;

Learn More