C_CommodityOrderRequest

DDL: C_COMMODITYORDERREQUEST SQL: CCMMDTYORDREQ Type: view CONSUMPTION Package: FS_CMM_CDOTE_ORDER_REQUEST

Cmmdty Drvtv Order Request Details

C_CommodityOrderRequest is a Consumption CDS View that provides data about "Cmmdty Drvtv Order Request Details" in SAP S/4HANA. It reads from 2 data sources (I_CommoditySubAccount, I_CommodityOrderRequest) and exposes 64 fields with key field CommodityOrderRequestUUID. Part of development package FS_CMM_CDOTE_ORDER_REQUEST.

2 data source(s) 64 fields

Data Sources (2)

SourceAliasJoin Type
I_CommoditySubAccount CommoditySubaccount left_outer
I_CommodityOrderRequest OrderRequest from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCMMDTYORDREQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable false view
Metadata.allowExtensions true view
EndUserText.label Cmmdty Drvtv Order Request Details view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY CommodityOrderRequestUUID I_CommodityOrderRequest CommodityOrderRequestUUID
CommodityOrderRequest I_CommodityOrderRequest CommodityOrderRequest
CmmdtyOrderRequestStatus I_CommodityOrderRequest CmmdtyOrderRequestStatus
CommodityOrdReqStatusReason I_CommodityOrderRequest CommodityOrdReqStatusReason
CmmdtyOrderReqRejectionReason I_CommodityOrderRequest CmmdtyOrderReqRejectionReason
CommodityOrderRequestComment I_CommodityOrderRequest CommodityOrderRequestComment
CmmdtyOrderRequestSource I_CommodityOrderRequest CmmdtyOrderRequestSource
CmmdtyOrdReqSentToBrkrDateTime I_CommodityOrderRequest CmmdtyOrdReqSentToBrkrDateTime
CmmdtyOrderRequestType I_CommodityOrderRequest CmmdtyOrderRequestType
CmmdtyOrderRequestExchangeType I_CommodityOrderRequest CmmdtyOrderRequestExchangeType
CmmdtyOrdReqNegttnDateTime I_CommodityOrderRequest CmmdtyOrdReqNegttnDateTime
CmmdtyOrdReqExprtnInstruction I_CommodityOrderRequest CmmdtyOrdReqExprtnInstruction
CmmdtyOrdRequestExpirationDate I_CommodityOrderRequest CmmdtyOrdRequestExpirationDate
CommodityDerivativeBroker I_CommodityOrderRequest CommodityDerivativeBroker
CommodityOrderRequestTrader I_CommodityOrderRequest CommodityOrderRequestTrader
CmmdtyOrderRequestProcessStep I_CommodityOrderRequest CmmdtyOrderRequestProcessStep
CmmdtyOrdReqInitialStatusIsSet I_CommodityOrderRequest CmmdtyOrdReqInitialStatusIsSet
CmmdtyDerivativeQuantityPerLot I_CommodityOrderRequest CmmdtyDerivativeQuantityPerLot
CmmdtyDrvtvQuantityUnitPerLot I_CommodityOrderRequest CmmdtyDrvtvQuantityUnitPerLot
CmmdtyDerivativeCurrencyPerLot I_CommodityOrderRequest CmmdtyDerivativeCurrencyPerLot
CmmdtyOrdReqLmtPrc I_CommodityOrderRequest CmmdtyOrdReqLmtPrc
CmmdtyOrdReqLmtPrcCurrency I_CommodityOrderRequest CmmdtyOrdReqLmtPrcCurrency
CmmdtyOrdReqLmtPrcQuantity I_CommodityOrderRequest CmmdtyOrdReqLmtPrcQuantity
CmmdtyOrdReqLmtPrcQuantityUnit I_CommodityOrderRequest CmmdtyOrdReqLmtPrcQuantityUnit
CmmdtyOrdReqLmtSpreadPrc I_CommodityOrderRequest CmmdtyOrdReqLmtSpreadPrc
CmmdtyOrdReqLmtSpreadPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqLmtSpreadPrcCrcy
CmmdtyOrdReqLmtSpreadPrcQty I_CommodityOrderRequest CmmdtyOrdReqLmtSpreadPrcQty
CmmdtyOrdLmtSpreadPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdLmtSpreadPrcQtyUnit
CmmdtyOrdReqStopPrice I_CommodityOrderRequest CmmdtyOrdReqStopPrice
CmmdtyOrdReqStopPriceCrcy I_CommodityOrderRequest CmmdtyOrdReqStopPriceCrcy
CmmdtyOrdReqStopPriceQty I_CommodityOrderRequest CmmdtyOrdReqStopPriceQty
CmmdtyOrdReqStopPriceQtyUnit I_CommodityOrderRequest CmmdtyOrdReqStopPriceQtyUnit
CmmdtyOrdReqFxdPrc I_CommodityOrderRequest CmmdtyOrdReqFxdPrc
CmmdtyOrdReqFxdPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqFxdPrcCrcy
CmmdtyOrdReqFxdPrcQty I_CommodityOrderRequest CmmdtyOrdReqFxdPrcQty
CmmdtyOrdReqFxdPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdReqFxdPrcQtyUnit
CmmdtyOrdReqFxdSpreadPrc I_CommodityOrderRequest CmmdtyOrdReqFxdSpreadPrc
CmmdtyOrdReqFxdSpreadPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqFxdSpreadPrcCrcy
CmmdtyOrdReqFxdSpreadPrcQty I_CommodityOrderRequest CmmdtyOrdReqFxdSpreadPrcQty
CmmdtyOrdFxdSpreadPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdFxdSpreadPrcQtyUnit
CmmdtyOrdReqLeewayPrc I_CommodityOrderRequest CmmdtyOrdReqLeewayPrc
CmmdtyOrdReqLeewayPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqLeewayPrcCrcy
CmmdtyOrdReqLeewayPrcQty I_CommodityOrderRequest CmmdtyOrdReqLeewayPrcQty
CmmdtyOrdReqLeewayPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdReqLeewayPrcQtyUnit
CmmdtyOrdReqLeewayRngePrc I_CommodityOrderRequest CmmdtyOrdReqLeewayRngePrc
CmmdtyOrdReqLeewayRngePrcCrcy I_CommodityOrderRequest CmmdtyOrdReqLeewayRngePrcCrcy
CmmdtyOrdReqLeewayRngePrcQty I_CommodityOrderRequest CmmdtyOrdReqLeewayRngePrcQty
CmmdtyOrdLeewayRngePrcQtyUnit I_CommodityOrderRequest CmmdtyOrdLeewayRngePrcQtyUnit
CommoditySubAccountasCommoditySubAccount
CommoditySubAccountUUID I_CommodityOrderRequest CommoditySubAccountUUID
CommoditySubAccountName I_CommoditySubAccount CommoditySubAccountName
CompanyCode I_CommoditySubAccount CompanyCode
Commodity I_CommoditySubAccount Commodity
CmmdtyOrdReqCntrPtySubAcctUUID I_CommodityOrderRequest CmmdtyOrdReqCntrPtySubAcctUUID
CounterpartyasCounterparty
CmmdtyOrdReqCntrPtyBroker I_CommodityOrderRequest CmmdtyOrdReqCntrPtyBroker
CmmdtyOrdCntrPtyBrokerRefAcct I_CommodityOrderRequest CmmdtyOrdCntrPtyBrokerRefAcct
CmmdtyOrdRequestReferenceUUID I_CommodityOrderRequest CmmdtyOrdRequestReferenceUUID
CommodityOrderRequestReference I_CommodityOrderRequest CommodityOrderRequestReference
CmmdtyOrdReqOriglQuantityInLot I_CommodityOrderRequest CmmdtyOrdReqOriglQuantityInLot
CreatedByUserasCreatedByUser
CreationDateTime I_CommodityOrderRequest CreationDateTime
LastChangedByUser I_CommodityOrderRequest LastChangedByUser
LastChangeDateTime I_CommodityOrderRequest LastChangeDateTime 
@AbapCatalog.sqlViewName                : 'CCMMDTYORDREQ'
@AbapCatalog.compiler.compareFilter     : true
@AbapCatalog.preserveKey                : true
@AccessControl.authorizationCheck       : #CHECK
@AccessControl.personalData.blocking    : #REQUIRED
@VDM.viewType                           : #CONSUMPTION
@Search.searchable                      : false
@Metadata.allowExtensions               : true
@EndUserText.label                      : 'Cmmdty Drvtv Order Request Details'

@ClientHandling: {
   type         :      #CLIENT_DEPENDENT,
   algorithm    : #SESSION_VARIABLE
}

---- Object Model for Commodity Order Request Leg
@ObjectModel.usageType: {
        serviceQuality : #D,
        sizeCategory   : #L,
        dataClass      : #TRANSACTIONAL
}

define view C_CommodityOrderRequest
  as select from    I_CommodityOrderRequest as OrderRequest

  --To get Commodity Subaccount Details
    left outer join I_CommoditySubAccount   as CommoditySubaccount on OrderRequest.CommoditySubAccountUUID = CommoditySubaccount.CommoditySubAccountUUID

{

  key    OrderRequest.CommodityOrderRequestUUID                                                          as          CommodityOrderRequestUUID,
         OrderRequest.CommodityOrderRequest                                                              as          CommodityOrderRequest,

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

         OrderRequest.CmmdtyOrderRequestReason                                                           as          CmmdtyOrderRequestReason,
         OrderRequest.CmmdtyOrderRequestStatus                                                           as          CmmdtyOrderRequestStatus,
         OrderRequest.CommodityOrdReqStatusReason                                                        as          CommodityOrdReqStatusReason,
         OrderRequest.CmmdtyOrderReqRejectionReason                                                      as          CmmdtyOrderReqRejectionReason,
         OrderRequest.CommodityOrderRequestComment                                                       as          CommodityOrderRequestComment,
         OrderRequest.CmmdtyOrderRequestSource                                                           as          CmmdtyOrderRequestSource,
         OrderRequest.CmmdtyOrdReqSentToBrkrDateTime                                                     as          CmmdtyOrdReqSentToBrkrDateTime,
         OrderRequest.CmmdtyOrderRequestType                                                             as          CmmdtyOrderRequestType,
         OrderRequest.CmmdtyOrderRequestExchangeType                                                     as          CmmdtyOrderRequestExchangeType,
         OrderRequest.CmmdtyOrdReqNegttnDateTime                                                         as          CmmdtyOrdReqNegttnDateTime,
         OrderRequest.CmmdtyOrdReqExprtnInstruction                                                      as          CmmdtyOrdReqExprtnInstruction,
         OrderRequest.CmmdtyOrdRequestExpirationDate                                                     as          CmmdtyOrdRequestExpirationDate,
         OrderRequest.CommodityDerivativeBroker                                                          as          CommodityDerivativeBroker,
         OrderRequest.CommodityOrderRequestTrader                                                        as          CommodityOrderRequestTrader,
         OrderRequest.CmmdtyOrderRequestProcessStep                                                      as          CmmdtyOrderRequestProcessStep,
         OrderRequest.CmmdtyOrdReqInitialStatusIsSet                                                     as          CmmdtyOrdReqInitialStatusIsSet,

         --------------------------Commodity Order Request Quantity Information------------------------------------------------------------------------------

         OrderRequest.CmmdtyOrdRequestQuantityInLot                                                      as          CmmdtyOrdRequestQuantityInLot,
         OrderRequest.CmmdtyDerivativeQuantityPerLot                                                     as          CmmdtyDerivativeQuantityPerLot,
         OrderRequest.CmmdtyDrvtvQuantityUnitPerLot                                                      as          CmmdtyDrvtvQuantityUnitPerLot,
         OrderRequest.CmmdtyDerivativeCurrencyPerLot                                                     as          CmmdtyDerivativeCurrencyPerLot,
         cast(( OrderRequest.CmmdtyOrdRequestQuantityInLot * OrderRequest.CmmdtyDerivativeQuantityPerLot )
            as cmmfdor_cmmdtyordrequestqty )                                                             as          CmmdtyOrderRequestQuantity,
         cast(OrderRequest.CmmdtyDrvtvQuantityUnitPerLot
            as cmmfdor_ordrequantityuom preserving type )                                                as          CmmdtyOrderRequestQuantityUnit,

         --------------------------Commodity Order Request Pricing Information-------------------------------------------------------------------------------

         OrderRequest.CmmdtyOrdReqPrcgExecInstrn                                                         as          CmmdtyOrdReqPrcgExecInstrn,
         OrderRequest.CmmdtyOrdReqLmtPrc                                                                 as          CmmdtyOrdReqLmtPrc,
         OrderRequest.CmmdtyOrdReqLmtPrcCurrency                                                         as          CmmdtyOrdReqLmtPrcCurrency,
         OrderRequest.CmmdtyOrdReqLmtPrcQuantity                                                         as          CmmdtyOrdReqLmtPrcQuantity,
         OrderRequest.CmmdtyOrdReqLmtPrcQuantityUnit                                                     as          CmmdtyOrdReqLmtPrcQuantityUnit,
         OrderRequest.CmmdtyOrdReqLmtSpreadPrc                                                           as          CmmdtyOrdReqLmtSpreadPrc,
         OrderRequest.CmmdtyOrdReqLmtSpreadPrcCrcy                                                       as          CmmdtyOrdReqLmtSpreadPrcCrcy,
         OrderRequest.CmmdtyOrdReqLmtSpreadPrcQty                                                        as          CmmdtyOrdReqLmtSpreadPrcQty,
         OrderRequest.CmmdtyOrdLmtSpreadPrcQtyUnit                                                       as          CmmdtyOrdLmtSpreadPrcQtyUnit,
         OrderRequest.CmmdtyOrdReqStopPrice                                                              as          CmmdtyOrdReqStopPrice,
         OrderRequest.CmmdtyOrdReqStopPriceCrcy                                                          as          CmmdtyOrdReqStopPriceCrcy,
         OrderRequest.CmmdtyOrdReqStopPriceQty                                                           as          CmmdtyOrdReqStopPriceQty,
         OrderRequest.CmmdtyOrdReqStopPriceQtyUnit                                                       as          CmmdtyOrdReqStopPriceQtyUnit,
         OrderRequest.CmmdtyOrdReqFxdPrc                                                                 as          CmmdtyOrdReqFxdPrc,
         OrderRequest.CmmdtyOrdReqFxdPrcCrcy                                                             as          CmmdtyOrdReqFxdPrcCrcy,
         OrderRequest.CmmdtyOrdReqFxdPrcQty                                                              as          CmmdtyOrdReqFxdPrcQty,
         OrderRequest.CmmdtyOrdReqFxdPrcQtyUnit                                                          as          CmmdtyOrdReqFxdPrcQtyUnit,
         OrderRequest.CmmdtyOrdReqFxdSpreadPrc                                                           as          CmmdtyOrdReqFxdSpreadPrc,
         OrderRequest.CmmdtyOrdReqFxdSpreadPrcCrcy                                                       as          CmmdtyOrdReqFxdSpreadPrcCrcy,
         OrderRequest.CmmdtyOrdReqFxdSpreadPrcQty                                                        as          CmmdtyOrdReqFxdSpreadPrcQty,
         OrderRequest.CmmdtyOrdFxdSpreadPrcQtyUnit                                                       as          CmmdtyOrdFxdSpreadPrcQtyUnit,
         OrderRequest.CmmdtyOrdReqLeewayPrc                                                              as          CmmdtyOrdReqLeewayPrc,
         OrderRequest.CmmdtyOrdReqLeewayPrcCrcy                                                          as          CmmdtyOrdReqLeewayPrcCrcy,
         OrderRequest.CmmdtyOrdReqLeewayPrcQty                                                           as          CmmdtyOrdReqLeewayPrcQty,
         OrderRequest.CmmdtyOrdReqLeewayPrcQtyUnit                                                       as          CmmdtyOrdReqLeewayPrcQtyUnit,
         OrderRequest.CmmdtyOrdReqLeewayRngePrc                                                          as          CmmdtyOrdReqLeewayRngePrc,
         OrderRequest.CmmdtyOrdReqLeewayRngePrcCrcy                                                      as          CmmdtyOrdReqLeewayRngePrcCrcy,
         OrderRequest.CmmdtyOrdReqLeewayRngePrcQty                                                       as          CmmdtyOrdReqLeewayRngePrcQty,
         OrderRequest.CmmdtyOrdLeewayRngePrcQtyUnit                                                      as          CmmdtyOrdLeewayRngePrcQtyUnit,

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

         OrderRequest.CommoditySubAccount                                                                as          CommoditySubAccount,
         OrderRequest.CommoditySubAccountUUID                                                            as          CommoditySubAccountUUID,
         CommoditySubaccount.CommoditySubAccountName                                                     as          CommoditySubAccountName,
         CommoditySubaccount.CompanyCode                                                                 as          CompanyCode,
         CommoditySubaccount.Commodity                                                                   as          Commodity,


         --------------------------Counterparty Subaccount Information---------------------------------------------------------------------------------------

         OrderRequest.CmmdtyOrdReqCntrPtySubAcct                                                         as          CmmdtyOrdReqCntrPtySubAcct,
         OrderRequest.CmmdtyOrdReqCntrPtySubAcctUUID                                                     as          CmmdtyOrdReqCntrPtySubAcctUUID,

         --------------------------Counterparty -------------------------------------------------------------------------------------------------------------

         OrderRequest.Counterparty                                                                       as          Counterparty,
         OrderRequest.CmmdtyOrdReqCntrPtyBroker                                                          as          CmmdtyOrdReqCntrPtyBroker,
         OrderRequest.CmmdtyOrdCntrPtyBrokerRefAcct                                                      as          CmmdtyOrdCntrPtyBrokerRefAcct,

         -------------------------- Order Amendment -------------------------------------------------------------------------------------------------------------

         OrderRequest.CmmdtyOrderReqPreviousStatus                                                       as          CmmdtyOrderReqPreviousStatus,
         OrderRequest.CmmdtyOrdRequestReferenceUUID                                                      as          CmmdtyOrdRequestReferenceUUID,
         OrderRequest.CommodityOrderRequestReference                                                     as          CommodityOrderRequestReference,
         OrderRequest.CmmdtyOrdReqOriglQuantityInLot                                                     as          CmmdtyOrdReqOriglQuantityInLot,

         --------------------------Administrative Data-------------------------------------------------------------------------------------------------------

         OrderRequest.CreatedByUser                                                                      as          CreatedByUser,
         OrderRequest.CreationDateTime                                                                   as          CreationDateTime,
         OrderRequest.LastChangedByUser                                                                  as          LastChangedByUser,
         OrderRequest.LastChangeDateTime                                                                 as          LastChangeDateTime

}

Learn More