I_CmmdtyOrdFillForwardTP

@EndUserText.label: 'Commodity Order Fill Forward Transactional View'
@AbapCatalog.sqlViewName: 'ICMMDTYORDFWDTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL

---- Business Object Model for Commodity Order Fill
@ObjectModel: {
    writeActivePersistence         : 'CMMFDOF_D_FWD',
    createEnabled                  : true,
    updateEnabled                  : 'EXTERNAL_CALCULATION',
    deleteEnabled                  : false,
    usageType: {
        serviceQuality : #B,
        sizeCategory   : #L,
        dataClass      : #MIXED   },
    semanticKey              : ['CommodityOrderFillForwardID'],
    alternativeKey:  [{
        id : 'CommodityOrderFillForwardID',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['CommodityOrderFillForwardID']     }]
}
define view I_CmmdtyOrdFillForwardTP
  as select from I_CmmdtyOrdFillForward

  association [1..1] to I_CommodityOrderFillTP       as _Fill            on $projection.CommodityOrderFillUUID = _Fill.CommodityOrderFillUUID
  association [1..1] to I_CommodityOrdFillPacketTP   as _FillPacket      on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID
  // Commented SAP note 2806161  

  //association [1..1] to I_CmmdtyDrvtvGenericDomainVH as _ForwardStatusVH on $projection.CommodityOrdFillForwardStatus = _ForwardStatusVH.DomainValue

  //                                                                      and _ForwardStatusVH.SAPDataDictionaryDomain = 'CMMFDOF_CMMDTYORDERFRWDSTATUS'

 association [1..1] to I_CmmdtyFwdStatusText as _ForwardStatusVH on $projection.CommodityOrdFillForwardStatus = _ForwardStatusVH.CmmdtyOrdFwdStatus
{
  key     CommodityOrdFillForwardUUID,
          CommodityOrderFillUUID,
          CommodityOrderFillPacketUUID,
          CommodityOrderFillForwardID,
          CommodityOrdFillForwardStatus,
          @ObjectModel.readOnly: true
//          _ForwardStatusVH.DomainText as CmmdtyOrdFillForwardStatusText,

          _ForwardStatusVH.CmmdtyOrdFwdStatusText as CmmdtyOrdFillForwardStatusText,
          CmmdtyOrdFillForwardFinTransID,
          CreatedByUser,
          CreationDateTime,
          LastChangedByUser,
          LastChangeDateTime,
          IsArchived,
          IsReversed,
          @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
          _Fill,
          @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
          _FillPacket
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYFWDSTATUSTEXT",
"I_CMMDTYORDFILLFORWARD"
],
"ASSOCIATED":
[
"I_CMMDTYFWDSTATUSTEXT",
"I_COMMODITYORDERFILLTP",
"I_COMMODITYORDFILLPACKETTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/