I_CommodityOrdFillPacketLogTP

DDL: I_COMMODITYORDFILLPACKETLOGTP SQL: ICMDTYFLPKTLOGTP Type: view TRANSACTIONAL

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
CommodityOrderFillPacketUUID I_CommodityOrdFillPacketLog CommodityOrderFillPacketUUID
CmmdtyOrderFillPacket I_CommodityOrdFillPacketLog CmmdtyOrderFillPacket
CmmdtyOrderFillMessageSource I_CommodityOrdFillPacketLog CmmdtyOrderFillMessageSource
SystemMessageType I_CommodityOrdFillPacketLog SystemMessageType
SystemMessageIdentification I_CommodityOrdFillPacketLog SystemMessageIdentification
SystemMessageNumber I_CommodityOrdFillPacketLog SystemMessageNumber
SystemMessageText I_CommodityOrdFillPacketLog SystemMessageText
SystemMessageVariable1 I_CommodityOrdFillPacketLog SystemMessageVariable1
SystemMessageVariable2 I_CommodityOrdFillPacketLog SystemMessageVariable2
SystemMessageVariable3 I_CommodityOrdFillPacketLog SystemMessageVariable3
SystemMessageVariable4 I_CommodityOrdFillPacketLog SystemMessageVariable4
CommodityOrderRequestTrader I_CommodityOrdFillPacketLog CommodityOrderRequestTrader
CompanyCode I_CommodityOrdFillPacketLog CompanyCode
CmmdtyOrderFillRequestType I_CommodityOrdFillPacketLog CmmdtyOrderFillRequestType
Commodity I_CommodityOrdFillPacketLog Commodity
CreatedByUser I_CommodityOrdFillPacketLog CreatedByUser
CreationDateTime I_CommodityOrdFillPacketLog CreationDateTime
Associations_FillPacket
@AbapCatalog.sqlViewName: 'ICMDTYFLPKTLOGTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label:'Transactional View for a Cmmdty Deriv Ord Fill Packet Log'

---- Business Object Model for Commodity Order Fill Packet Log
@ObjectModel: {
    writeActivePersistence         : 'CMMFDOF_D_FLMSG',
    createEnabled                  : true,
    updateEnabled                  : 'EXTERNAL_CALCULATION',
    deleteEnabled                  : true,
    usageType: {
        serviceQuality : #B,
        sizeCategory   : #L,
        dataClass      : #MIXED   },
    modelCategory            : #BUSINESS_OBJECT,
    semanticKey              : ['CmmdtyOrderFillPacket', 'SystemMessageNumber']

}

define view I_CommodityOrdFillPacketLogTP
  as select from I_CommodityOrdFillPacketLog as FillPacketLog

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

{
  key FillPacketLog.CmmdtyOrderFillPacketMsgUUID,
      FillPacketLog.CommodityOrderFillPacketUUID,
      FillPacketLog.CmmdtyOrderFillPacket,
      FillPacketLog.CmmdtyOrderFillMessageSource,
      FillPacketLog.SystemMessageType,
      FillPacketLog.SystemMessageIdentification,
      FillPacketLog.SystemMessageNumber,
      FillPacketLog.SystemMessageText,
      FillPacketLog.SystemMessageVariable1,
      FillPacketLog.SystemMessageVariable2,
      FillPacketLog.SystemMessageVariable3,
      FillPacketLog.SystemMessageVariable4,
      FillPacketLog.CommodityOrderRequestTrader,
      FillPacketLog.CompanyCode,
      FillPacketLog.CmmdtyOrderFillRequestType,
      FillPacketLog.Commodity,
      FillPacketLog.CreatedByUser,
      FillPacketLog.CreationDateTime,
      ---------------------------------------------------------------------------

      -------------------------Associations--------------------------------------

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _FillPacket
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYORDFILLPACKETLOG"
],
"ASSOCIATED":
[
"I_COMMODITYORDFILLPACKETTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/