I_CmmdtyOrdFillPacketCommodity

@AbapCatalog.sqlViewName: 'IFILLPKTCMMDTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Basic View for Cmmdty Deriv Ord Fill Pkt'


define view I_CmmdtyOrdFillPacketCommodity
  as select from    cmmfdof_d_flpkt                as FillPacket

  --Fill Packet Subaccount Information
    left outer join I_CmmdtyOrderFillPacketSubAcct as FillPacketSubAcct      on FillPacket.commodityorderfillpacketuuid = FillPacketSubAcct.CommodityOrderFillPacketUUID

  --Association To get Order request
    left outer join cmmfdor_d_order                as _CommodityOrderRequest on FillPacket.commodityorderrequestuuid = _CommodityOrderRequest.commodityorderrequestuuid

{
  key FillPacket.commodityorderfillpacketuuid                                                                                         as      CommodityOrderFillPacketUUID,

      -----------------------------------------------Fill Packet Information----------------------------------------------------------------------------
      -------------------------------------------------------------------------------------------------------------------------------------------------
      FillPacket.commodityorderrequestuuid                                                                                            as      CommodityOrderRequestUUID,
      FillPacket.cmmdtyorderfillpacket                                                                                                as      CmmdtyOrderFillPacket,
      FillPacket.cmmdtyordfillpackettype                                                                                              as      CmmdtyOrdFillPacketType,
      FillPacket.commodityorderfillpacketid                                                                                           as      CommodityOrderFillPacketID,
      FillPacket.cmmdtyfillpacketmsgordid                                                                                             as      CmmdtyFillPacketMsgOrdID,
      FillPacket.cmmdtyorderfillrequesttype                                                                                           as      CmmdtyOrderFillRequestType,
      FillPacket.cmmdtyordfillcounterpartyinfo                                                                                        as      CmmdtyOrdFillCounterPartyInfo,
      FillPacket.cmmdtyordreqfilledqtyinlots                                                                                          as      CmmdtyOrdReqFilledQtyInLots,
      FillPacket.cmmdtyordreqrmngqtyinlots                                                                                            as      CmmdtyOrdReqRmngQtyInLots,
      FillPacket.cmmdtyordreqfilledqtyinlots                                                                                          as      CmmdtyOrderFillQuantityInLots,
      FillPacket.cmmdtyordfillrejectionreason                                                                                         as      CmmdtyOrdFillRejectionReason,
      FillPacket.cmmdtyordfillmultilegtype                                                                                            as      CmmdtyOrdFillMultiLegType,
      FillPacket.cmmdtyorderfillpacketstatus                                                                                          as      CmmdtyOrderFillPacketStatus,
      FillPacket.cmmdtyorderisfillwithorder                                                                                           as      CmmdtyOrderIsFillWithOrder,
      FillPacket.cmmdtyordfillfirstdistrddtetme                                                                                       as      CmmdtyOrdFillFirstDistrdDteTme,
      FillPacket.cmmdtyordfilllastdistrddatetme                                                                                       as      CmmdtyOrdFillLastDistrdDateTme,
      FillPacket.commodityorderrequesttrader                                                                                          as      CommodityOrderRequestTrader,
      FillPacket.decidedby                                                                                                            as      CommodityOrderFillDecidedBy,
      FillPacket.decidedon                                                                                                            as      CommodityOrderFillDecidedOn,

      --------------------------------------------------Subaccount Information----------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------

      FillPacketSubAcct.Commodity                                                                                                     as      Commodity,
      FillPacketSubAcct.CommoditySubAccountUUID                                                                                       as      CommoditySubAccountUUID,
      FillPacketSubAcct.DerivativeContrSpecification                                                                                  as      DerivativeContrSpecification,
      FillPacketSubAcct.CommoditySubAccount                                                                                           as      CommoditySubAccount,
      FillPacketSubAcct.CommoditySubAccountName                                                                                       as      CommoditySubAccountName,
      FillPacketSubAcct.CommodityDerivativeBroker                                                                                     as      CommodityDerivativeBroker,
      FillPacketSubAcct.CompanyCode                                                                                                   as      CompanyCode,
      FillPacketSubAcct.ProfitCenter                                                                                                  as      ProfitCenter,

      --------------------------------------------------Order Request Information----------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------

      FillPacket.commodityorderrequest                                                                                                as      CommodityOrderRequest,
      _CommodityOrderRequest.creationdatetime                                                                                         as      CmmdtyOrderDateTime,
      _CommodityOrderRequest.cmmdtyorderrequesttype                                                                                   as      CmmdtyOrderRequestType,
      _CommodityOrderRequest.cmmdtyorderrequestsource                                                                                 as      CmmdtyOrderRequestSource,
      _CommodityOrderRequest.cmmdtyorderrequestreason                                                                                 as      CmmdtyOrderRequestReason,
      @Semantics.quantity.unitOfMeasure: 'CmmdtyOrderRequestQuantityUnit'
      cast(( _CommodityOrderRequest.cmmdtyordrequestquantityinlot * _CommodityOrderRequest.cmmdtyderivativequantityperlot )
                                       as cmmfdor_cmmdtyordrequestqty )                                                               as      CmmdtyOrderRequestQuantity,
      _CommodityOrderRequest.cmmdtydrvtvquantityunitperlot                                                                            as      CmmdtyOrderRequestQuantityUnit,                            

      ----------------------------------------------------------------Admin Data-------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------
      FillPacket.createdbyuser                                                                                                        as      CreatedByUser,
      FillPacket.creationdatetime                                                                                                     as      CreationDateTime,
      FillPacket.lastchangedbyuser                                                                                                    as      LastChangedByUser,
      FillPacket.lastchangedatetime                                                                                                   as      LastChangeDateTime

      ----------------------------------------------------------------------------------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------

}