C_CommodityOrderRequest

DDL: C_COMMODITYORDERREQUEST SQL: CCMMDTYORDREQ Type: view CONSUMPTION
64 Fields 2 Data Sources

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.

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 Key
CommodityOrderRequest I_CommodityOrderRequest CommodityOrderRequest Order ID
CmmdtyOrderRequestStatus I_CommodityOrderRequest CmmdtyOrderRequestStatus Order Status
CommodityOrdReqStatusReason I_CommodityOrderRequest CommodityOrdReqStatusReason Status Reason
CmmdtyOrderReqRejectionReason I_CommodityOrderRequest CmmdtyOrderReqRejectionReason Rejection Reason
CommodityOrderRequestComment I_CommodityOrderRequest CommodityOrderRequestComment Comment
CmmdtyOrderRequestSource I_CommodityOrderRequest CmmdtyOrderRequestSource Order Source
CmmdtyOrdReqSentToBrkrDateTime I_CommodityOrderRequest CmmdtyOrdReqSentToBrkrDateTime Transmitted On
CmmdtyOrderRequestType I_CommodityOrderRequest CmmdtyOrderRequestType Order Type
CmmdtyOrderRequestExchangeType I_CommodityOrderRequest CmmdtyOrderRequestExchangeType Exchange Type
CmmdtyOrdReqNegttnDateTime I_CommodityOrderRequest CmmdtyOrdReqNegttnDateTime Negotiated On
CmmdtyOrdReqExprtnInstruction I_CommodityOrderRequest CmmdtyOrdReqExprtnInstruction Expiry Instruction
CmmdtyOrdRequestExpirationDate I_CommodityOrderRequest CmmdtyOrdRequestExpirationDate Expiration Date
CommodityDerivativeBroker I_CommodityOrderRequest CommodityDerivativeBroker Broker ID
CommodityOrderRequestTrader I_CommodityOrderRequest CommodityOrderRequestTrader Trader
CmmdtyOrderRequestProcessStep I_CommodityOrderRequest CmmdtyOrderRequestProcessStep Process Step
CmmdtyOrdReqInitialStatusIsSet I_CommodityOrderRequest CmmdtyOrdReqInitialStatusIsSet Initial Status
CmmdtyDerivativeQuantityPerLot I_CommodityOrderRequest CmmdtyDerivativeQuantityPerLot DCS Quantity
CmmdtyDrvtvQuantityUnitPerLot I_CommodityOrderRequest CmmdtyDrvtvQuantityUnitPerLot DCS Unit of Measure
CmmdtyDerivativeCurrencyPerLot I_CommodityOrderRequest CmmdtyDerivativeCurrencyPerLot Currency
CmmdtyOrdReqLmtPrc I_CommodityOrderRequest CmmdtyOrdReqLmtPrc Limit Price
CmmdtyOrdReqLmtPrcCurrency I_CommodityOrderRequest CmmdtyOrdReqLmtPrcCurrency Limit Price Crcy
CmmdtyOrdReqLmtPrcQuantity I_CommodityOrderRequest CmmdtyOrdReqLmtPrcQuantity Limit Price Quantity
CmmdtyOrdReqLmtPrcQuantityUnit I_CommodityOrderRequest CmmdtyOrdReqLmtPrcQuantityUnit Limit Pr. Qty UoM
CmmdtyOrdReqLmtSpreadPrc I_CommodityOrderRequest CmmdtyOrdReqLmtSpreadPrc Limit Spread Value
CmmdtyOrdReqLmtSpreadPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqLmtSpreadPrcCrcy Lim Spread Prc Crcy
CmmdtyOrdReqLmtSpreadPrcQty I_CommodityOrderRequest CmmdtyOrdReqLmtSpreadPrcQty Limit Spr. Price Qty
CmmdtyOrdLmtSpreadPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdLmtSpreadPrcQtyUnit Lim Sprd Prc Qty UOM
CmmdtyOrdReqStopPrice I_CommodityOrderRequest CmmdtyOrdReqStopPrice Stop Price
CmmdtyOrdReqStopPriceCrcy I_CommodityOrderRequest CmmdtyOrdReqStopPriceCrcy Stop Price Crcy
CmmdtyOrdReqStopPriceQty I_CommodityOrderRequest CmmdtyOrdReqStopPriceQty Stop Price Quantity
CmmdtyOrdReqStopPriceQtyUnit I_CommodityOrderRequest CmmdtyOrdReqStopPriceQtyUnit Stop Price Qty UoM
CmmdtyOrdReqFxdPrc I_CommodityOrderRequest CmmdtyOrdReqFxdPrc Fixed Price
CmmdtyOrdReqFxdPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqFxdPrcCrcy Requested Price Crcy
CmmdtyOrdReqFxdPrcQty I_CommodityOrderRequest CmmdtyOrdReqFxdPrcQty Rqstd Price Quantity
CmmdtyOrdReqFxdPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdReqFxdPrcQtyUnit Rqstd Prc Qty UoM
CmmdtyOrdReqFxdSpreadPrc I_CommodityOrderRequest CmmdtyOrdReqFxdSpreadPrc Fixed Spread Value
CmmdtyOrdReqFxdSpreadPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqFxdSpreadPrcCrcy Rqstd Spr Prc Crcy
CmmdtyOrdReqFxdSpreadPrcQty I_CommodityOrderRequest CmmdtyOrdReqFxdSpreadPrcQty Rqstd Spr. Price Qty
CmmdtyOrdFxdSpreadPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdFxdSpreadPrcQtyUnit Rqstd Spr Pr Qty UoM
CmmdtyOrdReqLeewayPrc I_CommodityOrderRequest CmmdtyOrdReqLeewayPrc Requested Price
CmmdtyOrdReqLeewayPrcCrcy I_CommodityOrderRequest CmmdtyOrdReqLeewayPrcCrcy Requested Price Crcy
CmmdtyOrdReqLeewayPrcQty I_CommodityOrderRequest CmmdtyOrdReqLeewayPrcQty Rqstd Price Quantity
CmmdtyOrdReqLeewayPrcQtyUnit I_CommodityOrderRequest CmmdtyOrdReqLeewayPrcQtyUnit Rqstd Prc Qty UoM
CmmdtyOrdReqLeewayRngePrc I_CommodityOrderRequest CmmdtyOrdReqLeewayRngePrc Leeway
CmmdtyOrdReqLeewayRngePrcCrcy I_CommodityOrderRequest CmmdtyOrdReqLeewayRngePrcCrcy Leeway Prc Crcy
CmmdtyOrdReqLeewayRngePrcQty I_CommodityOrderRequest CmmdtyOrdReqLeewayRngePrcQty Leeway Prc Qty
CmmdtyOrdLeewayRngePrcQtyUnit I_CommodityOrderRequest CmmdtyOrdLeewayRngePrcQtyUnit Leeway Qty UOM
CommoditySubAccountasCommoditySubAccount
CommoditySubAccountUUID I_CommodityOrderRequest CommoditySubAccountUUID Key
CommoditySubAccountName I_CommoditySubAccount CommoditySubAccountName Subaccount Name
CompanyCode I_CommoditySubAccount CompanyCode Receiver Company Code
Commodity I_CommoditySubAccount Commodity Commodity Code
CmmdtyOrdReqCntrPtySubAcctUUID I_CommodityOrderRequest CmmdtyOrdReqCntrPtySubAcctUUID Key
CounterpartyasCounterparty
CmmdtyOrdReqCntrPtyBroker I_CommodityOrderRequest CmmdtyOrdReqCntrPtyBroker Counterparty Broker
CmmdtyOrdCntrPtyBrokerRefAcct I_CommodityOrderRequest CmmdtyOrdCntrPtyBrokerRefAcct Counterparty Account
CmmdtyOrdRequestReferenceUUID I_CommodityOrderRequest CmmdtyOrdRequestReferenceUUID Key
CommodityOrderRequestReference I_CommodityOrderRequest CommodityOrderRequestReference Origin/Amended Order
CmmdtyOrdReqOriglQuantityInLot I_CommodityOrderRequest CmmdtyOrdReqOriglQuantityInLot Original Order Lots
CreatedByUserasCreatedByUser
CreationDateTime I_CommodityOrderRequest CreationDateTime Timestamp
LastChangedByUser I_CommodityOrderRequest LastChangedByUser User Name
LastChangeDateTime I_CommodityOrderRequest LastChangeDateTime Timestamp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CommodityOrderRequest.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCMMDTYORDREQ

CREATE VIEW C_CommodityOrderRequest AS
SELECT
  OrderRequest.CommodityOrderRequestUUID AS CommodityOrderRequestUUID,
  OrderRequest.CommodityOrderRequest AS CommodityOrderRequest,
  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,
  OrderRequest.CmmdtyDerivativeQuantityPerLot AS CmmdtyDerivativeQuantityPerLot,
  OrderRequest.CmmdtyDrvtvQuantityUnitPerLot AS CmmdtyDrvtvQuantityUnitPerLot,
  OrderRequest.CmmdtyDerivativeCurrencyPerLot AS CmmdtyDerivativeCurrencyPerLot,
  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,
  OrderRequest.CommoditySubAccountUUID AS CommoditySubAccountUUID,
  CommoditySubaccount.CommoditySubAccountName AS CommoditySubAccountName,
  CommoditySubaccount.CompanyCode AS CompanyCode,
  CommoditySubaccount.Commodity AS Commodity,
  OrderRequest.CmmdtyOrdReqCntrPtySubAcctUUID AS CmmdtyOrdReqCntrPtySubAcctUUID,
  OrderRequest.CmmdtyOrdReqCntrPtyBroker AS CmmdtyOrdReqCntrPtyBroker,
  OrderRequest.CmmdtyOrdCntrPtyBrokerRefAcct AS CmmdtyOrdCntrPtyBrokerRefAcct,
  OrderRequest.CmmdtyOrdRequestReferenceUUID AS CmmdtyOrdRequestReferenceUUID,
  OrderRequest.CommodityOrderRequestReference AS CommodityOrderRequestReference,
  OrderRequest.CmmdtyOrdReqOriglQuantityInLot AS CmmdtyOrdReqOriglQuantityInLot,
  OrderRequest.CreationDateTime AS CreationDateTime,
  OrderRequest.LastChangedByUser AS LastChangedByUser,
  OrderRequest.LastChangeDateTime AS LastChangeDateTime
FROM I_CommodityOrderRequest AS OrderRequest
LEFT OUTER JOIN I_CommoditySubAccount AS CommoditySubaccount ON /* join condition not captured in parsed metadata */
;

Learn More