I_CommodityOrderRequest
Commodity Order Request Interface View
I_CommodityOrderRequest is a Basic CDS View that provides data about "Commodity Order Request Interface View" in SAP S/4HANA. It reads from 2 data sources (I_CommoditySubAccount, cmmfdor_d_order) and exposes 76 fields with key field CommodityOrderRequestUUID. It has 1 association to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_CommoditySubAccount | CommoditySubaccount | left_outer |
| cmmfdor_d_order | OrderRequest | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_CommodityOrderRequest | _Extension | $projection.CommodityOrderRequestUUID = _Extension.CommodityOrderRequestUUID |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICMMDTYORDREQ | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | Commodity Order Request Interface View | view |
Fields (76)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CommodityOrderRequestUUID | cmmfdor_d_order | commodityorderrequestuuid | |
| CommodityOrderRequest | cmmfdor_d_order | commodityorderrequest | ||
| CmmdtyOrderRequestStatus | cmmfdor_d_order | cmmdtyorderrequeststatus | ||
| CommodityOrdReqStatusReason | cmmfdor_d_order | commodityordreqstatusreason | ||
| CmmdtyOrderReqRejectionReason | cmmfdor_d_order | cmmdtyorderreqrejectionreason | ||
| CommodityOrderRequestComment | cmmfdor_d_order | commodityorderrequestcomment | ||
| CmmdtyOrderRequestSource | cmmfdor_d_order | cmmdtyorderrequestsource | ||
| CmmdtyOrdReqPricingProgram | cmmfdor_d_order | cmmdtyordreqpricingprogram | ||
| CmmdtyOrdReqSentToBrkrDateTime | cmmfdor_d_order | cmmdtyordreqsenttobrkrdatetime | ||
| CmmdtyOrderRequestType | cmmfdor_d_order | cmmdtyorderrequesttype | ||
| CmmdtyOrderRequestExchangeType | cmmfdor_d_order | cmmdtyorderrequestexchangetype | ||
| CmmdtyOrdReqNegttnDateTime | cmmfdor_d_order | cmmdtyordreqnegttndatetime | ||
| CmmdtyOrdReqExprtnInstruction | cmmfdor_d_order | cmmdtyordreqexprtninstruction | ||
| CmmdtyOrdRequestExpirationDate | cmmfdor_d_order | cmmdtyordrequestexpirationdate | ||
| CmmdtyOrdReqExpryInstrnCat | cmmfdor_d_order | cmmdtyordreqexpryinstrncat | ||
| CommodityDerivativeBroker | cmmfdor_d_order | commodityderivativebroker | ||
| CommodityOrderRequestTrader | cmmfdor_d_order | commodityorderrequesttrader | ||
| CmmdtyOrderRequestProcessStep | cmmfdor_d_order | cmmdtyorderrequestprocessstep | ||
| CmmdtyOrdReqInitialStatusIsSet | cmmfdor_d_order | cmmdtyordreqinitialstatusisset | ||
| CmmdtyDerivativeQuantityPerLot | cmmfdor_d_order | cmmdtyderivativequantityperlot | ||
| CmmdtyDrvtvQuantityUnitPerLot | cmmfdor_d_order | cmmdtydrvtvquantityunitperlot | ||
| CmmdtyDerivativeCurrencyPerLot | cmmfdor_d_order | cmmdtyderivativecurrencyperlot | ||
| CmmdtyOrdReqPrcgExecInstrnCat | cmmfdor_d_order | cmmdtyordreqprcgexecinstrncat | ||
| CmmdtyOrdReqLmtPrc | cmmfdor_d_order | cmmdtyordreqlmtprc | ||
| CmmdtyOrdReqLmtPrcCurrency | cmmfdor_d_order | cmmdtyordreqlmtprccurrency | ||
| CmmdtyOrdReqLmtPrcQuantity | cmmfdor_d_order | cmmdtyordreqlmtprcquantity | ||
| CmmdtyOrdReqLmtPrcQuantityUnit | cmmfdor_d_order | cmmdtyordreqlmtprcquantityunit | ||
| CmmdtyOrdReqLmtSpreadPrc | cmmfdor_d_order | cmmdtyordreqlmtspreadprc | ||
| CmmdtyOrdReqLmtSpreadPrcCrcy | cmmfdor_d_order | cmmdtyordreqlmtspreadprccrcy | ||
| CmmdtyOrdReqLmtSpreadPrcQty | cmmfdor_d_order | cmmdtyordreqlmtspreadprcqty | ||
| CmmdtyOrdLmtSpreadPrcQtyUnit | cmmfdor_d_order | cmmdtyordlmtspreadprcqtyunit | ||
| CmmdtyOrdReqStopPrice | cmmfdor_d_order | cmmdtyordreqstopprice | ||
| CmmdtyOrdReqStopPriceCrcy | cmmfdor_d_order | cmmdtyordreqstoppricecrcy | ||
| CmmdtyOrdReqStopPriceQty | cmmfdor_d_order | cmmdtyordreqstoppriceqty | ||
| CmmdtyOrdReqStopPriceQtyUnit | cmmfdor_d_order | cmmdtyordreqstoppriceqtyunit | ||
| CmmdtyOrdReqStopLmtPrc | cmmfdor_d_order | cmmdtyordreqstoplmtprc | ||
| CmmdtyOrdReqStopLmtPrcCrcy | cmmfdor_d_order | cmmdtyordreqstoplmtprccrcy | ||
| CmmdtyOrdReqStopLmtPrcQty | cmmfdor_d_order | cmmdtyordreqstoplmtprcqty | ||
| CmmdtyOrdReqStopLmtPrcQtyUnit | cmmfdor_d_order | cmmdtyordreqstoplmtprcqtyunit | ||
| CmmdtyOrdReqFxdPrc | cmmfdor_d_order | cmmdtyordreqfxdprc | ||
| CmmdtyOrdReqFxdPrcCrcy | cmmfdor_d_order | cmmdtyordreqfxdprccrcy | ||
| CmmdtyOrdReqFxdPrcQty | cmmfdor_d_order | cmmdtyordreqfxdprcqty | ||
| CmmdtyOrdReqFxdPrcQtyUnit | cmmfdor_d_order | cmmdtyordreqfxdprcqtyunit | ||
| CmmdtyOrdReqFxdSpreadPrc | cmmfdor_d_order | cmmdtyordreqfxdspreadprc | ||
| CmmdtyOrdReqFxdSpreadPrcCrcy | cmmfdor_d_order | cmmdtyordreqfxdspreadprccrcy | ||
| CmmdtyOrdReqFxdSpreadPrcQty | cmmfdor_d_order | cmmdtyordreqfxdspreadprcqty | ||
| CmmdtyOrdFxdSpreadPrcQtyUnit | cmmfdor_d_order | cmmdtyordfxdspreadprcqtyunit | ||
| CmmdtyOrdReqLeewayPrc | cmmfdor_d_order | cmmdtyordreqleewayprc | ||
| CmmdtyOrdReqLeewayPrcCrcy | cmmfdor_d_order | cmmdtyordreqleewayprccrcy | ||
| CmmdtyOrdReqLeewayPrcQty | cmmfdor_d_order | cmmdtyordreqleewayprcqty | ||
| CmmdtyOrdReqLeewayPrcQtyUnit | cmmfdor_d_order | cmmdtyordreqleewayprcqtyunit | ||
| CmmdtyOrdReqLeewayRngePrc | cmmfdor_d_order | cmmdtyordreqleewayrngeprc | ||
| CmmdtyOrdReqLeewayRngePrcCrcy | cmmfdor_d_order | cmmdtyordreqleewayrngeprccrcy | ||
| CmmdtyOrdReqLeewayRngePrcQty | cmmfdor_d_order | cmmdtyordreqleewayrngeprcqty | ||
| CmmdtyOrdLeewayRngePrcQtyUnit | cmmfdor_d_order | cmmdtyordleewayrngeprcqtyunit | ||
| commoditysubaccountasCommoditySubAccount | ||||
| CommoditySubAccountUUID | cmmfdor_d_order | commoditysubaccountuuid | ||
| CompanyCode | I_CommoditySubAccount | CompanyCode | ||
| Commodity | I_CommoditySubAccount | Commodity | ||
| CmmdtyOrdReqCntrPtySubAcctUUID | cmmfdor_d_order | cmmdtyordreqcntrptysubacctuuid | ||
| counterpartyasCounterparty | ||||
| CmmdtyOrdReqCntrPtyBroker | cmmfdor_d_order | cmmdtyordreqcntrptybroker | ||
| CmmdtyOrdCntrPtyBrokerRefAcct | cmmfdor_d_order | cmmdtyordcntrptybrokerrefacct | ||
| CmmdtyOrdInternalCounterparty | cmmfdor_d_order | cmmdtyordinternalcounterparty | ||
| CmmdtyOrdRequestCanclnDateTime | cmmfdor_d_order | cmmdtyordrequestcanclndatetime | ||
| CmmdtyOrderRequestCanceledBy | cmmfdor_d_order | cmmdtyorderrequestcanceledby | ||
| CmmdtyOrdRequestReferenceUUID | cmmfdor_d_order | cmmdtyordrequestreferenceuuid | ||
| CommodityOrderRequestReference | cmmfdor_d_order | commodityorderrequestreference | ||
| CmmdtyOrdReqOriglQuantityInLot | cmmfdor_d_order | cmmdtyordreqoriglquantityinlot | ||
| CmmdtyOrdReqRejectionReference | cmmfdor_d_order | cmmdtyordreqrejectionreference | ||
| CmmdtyOrdRejectReferenceUUID | cmmfdor_d_order | cmmdtyordrejectreferenceuuid | ||
| CmmdtyOrdMatchPreventionInstrn | cmmfdor_d_order | cmmdtyordmatchpreventioninstrn | ||
| createdbyuserasCreatedByUser | ||||
| CreationDateTime | cmmfdor_d_order | creationdatetime | ||
| LastChangedByUser | cmmfdor_d_order | lastchangedbyuser | ||
| LastChangeDateTime | cmmfdor_d_order | lastchangedatetime |
@AbapCatalog.sqlViewName : 'ICMMDTYORDREQ'
@AbapCatalog.compiler.compareFilter : true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.authorizationCheck : #CHECK
@VDM.viewType : #BASIC
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.serviceQuality : #B
@ObjectModel.usageType.dataClass : #MIXED
@Metadata.ignorePropagatedAnnotations : true
@EndUserText.label : 'Commodity Order Request Interface View'
--- Interface View for Commodity Order Request
define view I_CommodityOrderRequest
as select from cmmfdor_d_order as OrderRequest
--To get Commodity Subaccount Details
left outer join I_CommoditySubAccount as CommoditySubaccount on OrderRequest.commoditysubaccountuuid = CommoditySubaccount.CommoditySubAccountUUID
-- Extension View for Free Characteristics in Commodity Derivative Order Request
association [0..1] to E_CommodityOrderRequest as _Extension on $projection.CommodityOrderRequestUUID = _Extension.CommodityOrderRequestUUID
{
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.cmmdtyordreqpricingprogram as CmmdtyOrdReqPricingProgram,
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.cmmdtyordreqexpryinstrncat as CmmdtyOrdReqExpryInstrnCat,
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,
@Semantics.quantity.unitOfMeasure: 'CmmdtyDrvtvQuantityUnitPerLot'
OrderRequest.cmmdtyderivativequantityperlot as CmmdtyDerivativeQuantityPerLot,
OrderRequest.cmmdtydrvtvquantityunitperlot as CmmdtyDrvtvQuantityUnitPerLot,
OrderRequest.cmmdtyderivativecurrencyperlot as CmmdtyDerivativeCurrencyPerLot,
@Semantics.quantity.unitOfMeasure: 'CmmdtyDrvtvQuantityUnitPerLot'
cast(( OrderRequest.cmmdtyordrequestquantityinlot * OrderRequest.cmmdtyderivativequantityperlot )
as cmmfdor_cmmdtyordrequestqty ) as CmmdtyOrderRequestQuantity,
--------------------------Commodity Order Request Pricing Information-------------------------------------------------------------------------------
OrderRequest.cmmdtyordreqprcgexecinstrn as CmmdtyOrdReqPrcgExecInstrn,
OrderRequest.cmmdtyordreqprcgexecinstrncat as CmmdtyOrdReqPrcgExecInstrnCat,
OrderRequest.cmmdtyordreqlmtprc as CmmdtyOrdReqLmtPrc,
OrderRequest.cmmdtyordreqlmtprccurrency as CmmdtyOrdReqLmtPrcCurrency,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdReqLmtPrcQuantityUnit'
OrderRequest.cmmdtyordreqlmtprcquantity as CmmdtyOrdReqLmtPrcQuantity,
OrderRequest.cmmdtyordreqlmtprcquantityunit as CmmdtyOrdReqLmtPrcQuantityUnit,
OrderRequest.cmmdtyordreqlmtspreadprc as CmmdtyOrdReqLmtSpreadPrc,
OrderRequest.cmmdtyordreqlmtspreadprccrcy as CmmdtyOrdReqLmtSpreadPrcCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdLmtSpreadPrcQtyUnit'
OrderRequest.cmmdtyordreqlmtspreadprcqty as CmmdtyOrdReqLmtSpreadPrcQty,
OrderRequest.cmmdtyordlmtspreadprcqtyunit as CmmdtyOrdLmtSpreadPrcQtyUnit,
OrderRequest.cmmdtyordreqstopprice as CmmdtyOrdReqStopPrice,
OrderRequest.cmmdtyordreqstoppricecrcy as CmmdtyOrdReqStopPriceCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdReqStopPriceQtyUnit'
OrderRequest.cmmdtyordreqstoppriceqty as CmmdtyOrdReqStopPriceQty,
OrderRequest.cmmdtyordreqstoppriceqtyunit as CmmdtyOrdReqStopPriceQtyUnit,
OrderRequest.cmmdtyordreqstoplmtprc as CmmdtyOrdReqStopLmtPrc,
OrderRequest.cmmdtyordreqstoplmtprccrcy as CmmdtyOrdReqStopLmtPrcCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdReqStopLmtPrcQtyUnit'
OrderRequest.cmmdtyordreqstoplmtprcqty as CmmdtyOrdReqStopLmtPrcQty,
OrderRequest.cmmdtyordreqstoplmtprcqtyunit as CmmdtyOrdReqStopLmtPrcQtyUnit,
OrderRequest.cmmdtyordreqfxdprc as CmmdtyOrdReqFxdPrc,
OrderRequest.cmmdtyordreqfxdprccrcy as CmmdtyOrdReqFxdPrcCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdReqFxdPrcQtyUnit'
OrderRequest.cmmdtyordreqfxdprcqty as CmmdtyOrdReqFxdPrcQty,
OrderRequest.cmmdtyordreqfxdprcqtyunit as CmmdtyOrdReqFxdPrcQtyUnit,
OrderRequest.cmmdtyordreqfxdspreadprc as CmmdtyOrdReqFxdSpreadPrc,
OrderRequest.cmmdtyordreqfxdspreadprccrcy as CmmdtyOrdReqFxdSpreadPrcCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdFxdSpreadPrcQtyUnit'
OrderRequest.cmmdtyordreqfxdspreadprcqty as CmmdtyOrdReqFxdSpreadPrcQty,
OrderRequest.cmmdtyordfxdspreadprcqtyunit as CmmdtyOrdFxdSpreadPrcQtyUnit,
OrderRequest.cmmdtyordreqleewayprc as CmmdtyOrdReqLeewayPrc,
OrderRequest.cmmdtyordreqleewayprccrcy as CmmdtyOrdReqLeewayPrcCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdReqLeewayPrcQtyUnit'
OrderRequest.cmmdtyordreqleewayprcqty as CmmdtyOrdReqLeewayPrcQty,
OrderRequest.cmmdtyordreqleewayprcqtyunit as CmmdtyOrdReqLeewayPrcQtyUnit,
OrderRequest.cmmdtyordreqleewayrngeprc as CmmdtyOrdReqLeewayRngePrc,
OrderRequest.cmmdtyordreqleewayrngeprccrcy as CmmdtyOrdReqLeewayRngePrcCrcy,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdLeewayRngePrcQtyUnit'
OrderRequest.cmmdtyordreqleewayrngeprcqty as CmmdtyOrdReqLeewayRngePrcQty,
OrderRequest.cmmdtyordleewayrngeprcqtyunit as CmmdtyOrdLeewayRngePrcQtyUnit,
--------------------------Subaccount Information----------------------------------------------------------------------------------------------------
OrderRequest.commoditysubaccount as CommoditySubAccount,
OrderRequest.commoditysubaccountuuid as CommoditySubAccountUUID,
cast(CommoditySubaccount.CommoditySubAccountName
as cmmfdor_assignedsubaccountname preserving type ) 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,
OrderRequest.cmmdtyordinternalcounterparty as CmmdtyOrdInternalCounterparty,
-------------------- Order Cancellation-------------------------------------------------------------------------------------------------------------
OrderRequest.cmmdtyordrequestcancellationid as CmmdtyOrdRequestCancellationID,
OrderRequest.cmmdtyordrequestcanclndatetime as CmmdtyOrdRequestCanclnDateTime,
OrderRequest.cmmdtyorderrequestcanceledby as CmmdtyOrderRequestCanceledBy,
-------------------------- Order Amendment -------------------------------------------------------------------------------------------------------------
OrderRequest.cmmdtyorderreqpreviousstatus as CmmdtyOrderReqPreviousStatus,
OrderRequest.cmmdtyordrequestreferenceuuid as CmmdtyOrdRequestReferenceUUID,
OrderRequest.commodityorderrequestreference as CommodityOrderRequestReference,
OrderRequest.cmmdtyordreqoriglquantityinlot as CmmdtyOrdReqOriglQuantityInLot,
OrderRequest.cmmdtyordreqrejectionreference as CmmdtyOrdReqRejectionReference,
OrderRequest.cmmdtyordrejectreferenceuuid as CmmdtyOrdRejectReferenceUUID,
-------------------------- Order Copy -------------------------------------------------------------------------------------------------------------
OrderRequest.cmmdtyorderreqiscopied as CmmdtyOrderReqIsCopied,
-------------------------- Self Match Prevention -------------------------------------------------------------------------------------------------------------
OrderRequest.cmmdtyordselfmatchpreventionid as CmmdtyOrdSelfMatchPreventionID,
OrderRequest.cmmdtyordmatchpreventioninstrn as CmmdtyOrdMatchPreventionInstrn,
-- -------------------------- -----TAS -------------------------------------------------------------------------------------------------------------
OrderRequest.commodityorderrequestticks as CommodityOrderRequestTicks,
-------------------------- -----Subaccount -------------------------------------------------------------------------------------------------------------
CommoditySubaccount.MarketIdentifierCode as MarketIdentifierCode,
--------------------------Administrative Data-------------------------------------------------------------------------------------------------------
OrderRequest.createdbyuser as CreatedByUser,
OrderRequest.creationdatetime as CreationDateTime,
OrderRequest.lastchangedbyuser as LastChangedByUser,
OrderRequest.lastchangedatetime as LastChangeDateTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYSUBACCOUNT",
"CMMFDOR_D_ORDER"
],
"ASSOCIATED":
[
"E_COMMODITYORDERREQUEST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA