I_CommodityOrdFillPacketLogTP

DDL: I_COMMODITYORDFILLPACKETLOGTP SQL: ICMDTYFLPKTLOGTP Type: view TRANSACTIONAL
19 Fields 1 Data Sources 1 Associations

Transactional View for a Cmmdty Deriv Ord Fill Packet Log

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

Data Sources (1)

SourceAliasJoin Type
I_CommodityOrdFillPacketLog FillPacketLog from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CommodityOrdFillPacketTP _FillPacket $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICMDTYFLPKTLOGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Transactional View for a Cmmdty Deriv Ord Fill Packet Log view
ObjectModel.writeActivePersistence CMMFDOF_D_FLMSG view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelCategory #BUSINESS_OBJECT view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyOrderFillPacketMsgUUID I_CommodityOrdFillPacketLog CmmdtyOrderFillPacketMsgUUID Key
CommodityOrderFillPacketUUID I_CommodityOrdFillPacketLog CommodityOrderFillPacketUUID Key
CmmdtyOrderFillPacket I_CommodityOrdFillPacketLog CmmdtyOrderFillPacket Fill Packet Sequence
CmmdtyOrderFillMessageSource I_CommodityOrdFillPacketLog CmmdtyOrderFillMessageSource Message Source
SystemMessageType I_CommodityOrdFillPacketLog SystemMessageType Message type
SystemMessageIdentification I_CommodityOrdFillPacketLog SystemMessageIdentification Message ID
SystemMessageNumber I_CommodityOrdFillPacketLog SystemMessageNumber Message Number
SystemMessageText I_CommodityOrdFillPacketLog SystemMessageText Message Text
SystemMessageVariable1 I_CommodityOrdFillPacketLog SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_CommodityOrdFillPacketLog SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_CommodityOrdFillPacketLog SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_CommodityOrdFillPacketLog SystemMessageVariable4 Variable 4
CommodityOrderRequestTrader I_CommodityOrdFillPacketLog CommodityOrderRequestTrader Trader
CompanyCode I_CommodityOrdFillPacketLog CompanyCode Receiver Company Code
CmmdtyOrderFillRequestType I_CommodityOrdFillPacketLog CmmdtyOrderFillRequestType Fill Packet Type
Commodity I_CommodityOrdFillPacketLog Commodity Commodity Code
CreatedByUser I_CommodityOrdFillPacketLog CreatedByUser User Name
CreationDateTime I_CommodityOrdFillPacketLog CreationDateTime Timestamp
Associations_FillPacket

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_CommodityOrdFillPacketLogTP.
-- 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: ICMDTYFLPKTLOGTP

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

Learn More