C_CommodityOrdFillPacketLogTP

DDL: C_COMMODITYORDFILLPACKETLOGTP SQL: CCMDTYFLPKTLOGTP Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Consumption View for a Cmmdty Deriv Ord Fill Packet Log

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

Data Sources (1)

SourceAliasJoin Type
I_CommodityOrdFillPacketLogTP FillPacketLog from

Associations (1)

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

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName CCMDTYFLPKTLOGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for a Cmmdty Deriv Ord Fill Packet Log view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE 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
UI.presentationVariant.sortOrder.by CMMDTYODERFILLPKTMSGUUID view
UI.presentationVariant.sortOrder.direction #DESC view
UI.headerInfo.typeNamePlural Commodity Derivative Order Request Fill Packet Log view
UI.headerInfo.typeName Commodity Derivative Order Request Fill Packet Log view
UI.headerInfo.title.label Fill Packet Log view
UI.headerInfo.title.value systemmessageidentification view
UI.headerInfo.description.value systemmessageidentification view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyOrderFillPacketMsgUUID I_CommodityOrdFillPacketLogTP CmmdtyOrderFillPacketMsgUUID Key
CommodityOrderFillPacketUUID I_CommodityOrdFillPacketLogTP CommodityOrderFillPacketUUID Key
CmmdtyOrderFillPacket
CmmdtyOrderFillMessageSource I_CommodityOrdFillPacketLogTP CmmdtyOrderFillMessageSource Message Source
SystemMessageType I_CommodityOrdFillPacketLogTP SystemMessageType Message type
SystemMessageIdentification I_CommodityOrdFillPacketLogTP SystemMessageIdentification Message ID
SystemMessageNumber I_CommodityOrdFillPacketLogTP SystemMessageNumber Message Number
SystemMessageText I_CommodityOrdFillPacketLogTP SystemMessageText Message Text
SystemMessageVariable1 I_CommodityOrdFillPacketLogTP SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_CommodityOrdFillPacketLogTP SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_CommodityOrdFillPacketLogTP SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_CommodityOrdFillPacketLogTP SystemMessageVariable4 Variable 4
CommodityOrderRequestTrader I_CommodityOrdFillPacketLogTP CommodityOrderRequestTrader Trader
CompanyCode I_CommodityOrdFillPacketLogTP CompanyCode Receiver Company Code
CmmdtyOrderFillRequestType I_CommodityOrdFillPacketLogTP CmmdtyOrderFillRequestType Fill Packet Type
Commodity I_CommodityOrdFillPacketLogTP Commodity Commodity Code
CreatedByUser I_CommodityOrdFillPacketLogTP CreatedByUser User Name
CreationDateTime I_CommodityOrdFillPacketLogTP 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 C_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: CCMDTYFLPKTLOGTP

CREATE VIEW C_CommodityOrdFillPacketLogTP AS
SELECT
  FillPacketLog.CmmdtyOrderFillPacketMsgUUID AS CmmdtyOrderFillPacketMsgUUID,
  FillPacketLog.CommodityOrderFillPacketUUID AS CommodityOrderFillPacketUUID,
  : true : 1.0 : #HIGH 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_CommodityOrdFillPacketLogTP AS FillPacketLog
LEFT OUTER JOIN C_CommodityOrdFillPacketTP AS _FillPacket ON CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID  -- association [1..1]
;

Learn More