I_CmmdtyOrderReqPacketLog

DDL: I_CMMDTYORDERREQPACKETLOG SQL: ICMDTYORDLOG Type: view COMPOSITE

Basic View for Order Error Log

I_CmmdtyOrderReqPacketLog is a Composite CDS View that provides data about "Basic View for Order Error Log" in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyOrderReqQueueErrLog, I_CommodityOrdFillPacketLog) and exposes 12 fields with key field CmmdtyOrderFillPacketMsgUUID. It has 1 association to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_CmmdtyOrderReqQueueErrLog I_CmmdtyOrderReqQueueErrLog union
I_CommodityOrdFillPacketLog I_CommodityOrdFillPacketLog from

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMDTYORDLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Basic View for Order Error Log view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyOrderFillPacketMsgUUID CmmdtyOrderFillPacketMsgUUID
CommodityOrderFillPacketUUID CommodityOrderFillPacketUUID
CommodityOrderRequestUUID _FillPacket CommodityOrderRequestUUID
CmmdtyOrderRequestMessageType SystemMessageType
CommodityOrderFillPacketUUID CommodityOrderFillPacketUUID
CommodityOrderRequestUUID CommodityOrderRequestUUID
CmmdtyOrderRequestMessageType CmmdtyOrderRequestMessageType
CmmdtyOrderFillPacket CmmdtyOrderFillPacket
CmmdtyOrdReqMessageDateTime CmmdtyOrdReqMessageDateTime
CmmdtyOrderReqMessageSource CmmdtyOrderReqMessageSource
CmmdtyOrderRequestMessageText CmmdtyOrderRequestMessageText
Associations_FillPacket 
@AbapCatalog.sqlViewName: 'ICMDTYORDLOG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Basic View for Order Error Log'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view I_CmmdtyOrderReqPacketLog
  as select from I_CommodityOrdFillPacketLog

  --Association To get Fill Packet Info
  //association [1..1] to I_CommodityOrderFillPacket as _FillPacket on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID

  association [1..1] to I_CmmdtyOrdFillPacketCommodity as _FillPacket on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID
{


  key CmmdtyOrderFillPacketMsgUUID                                           as CmmdtyOrderFillPacketMsgUUID,
      CommodityOrderFillPacketUUID                                           as CommodityOrderFillPacketUUID,
      _FillPacket.CommodityOrderRequestUUID                                  as CommodityOrderRequestUUID,
      SystemMessageType                                                      as CmmdtyOrderRequestMessageType,
      -- Commodity Order Fill Packet
      CmmdtyOrderFillPacket                                                  as CmmdtyOrderFillPacket,
      -- Message Creation Date & Time
      CreationDateTime                                                       as CmmdtyOrdReqMessageDateTime,
      -- System Message Source
      CmmdtyOrderFillMessageSource                                           as CmmdtyOrderReqMessageSource,
      -- System Message Text
      SystemMessageText                                                      as CmmdtyOrderRequestMessageText,
      -------------------------Associations--------------------------------------
      @Consumption.filter.hidden: true
      _FillPacket

}


-- Merge the Status of the bgRFC queue for the corrersponding Qrder Request in case it is in Error State
union select from I_CmmdtyOrderReqQueueErrLog

--Association To get Fill Packet Info (Dummy because CommodityOrderFillPacketUUID = CommodityOrderRequestUUID)
//association [1..1] to I_CommodityOrderFillPacket as _FillPacket on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID

association [1..1] to I_CmmdtyOrdFillPacketCommodity as _FillPacket on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID
{
  key CmmdtyOrderFillPacketMsgUUID,
      CommodityOrderFillPacketUUID,
      CommodityOrderRequestUUID,
      CmmdtyOrderRequestMessageType,
      CmmdtyOrderFillPacket,
      CmmdtyOrdReqMessageDateTime,
      CmmdtyOrderReqMessageSource,
      CmmdtyOrderRequestMessageText,
      -------------------------Associations--------------------------------------
      _FillPacket
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYORDERREQQUEUEERRLOG",
"I_CMMDTYORDFILLPACKETCOMMODITY",
"I_COMMODITYORDFILLPACKETLOG"
],
"ASSOCIATED":
[
"I_CMMDTYORDFILLPACKETCOMMODITY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More