I_COMMODITYORDERREQUEST
Commodity Order Request Interface View
I_COMMODITYORDERREQUEST is a CDS View in S/4HANA. Commodity Order Request Interface View. It contains 78 fields. 16 CDS views read from this table.
CDS Views using this table (16)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CmmdtyOrderRequestStatus | view | from | CONSUMPTION | Consumption View for Order Req Status |
| C_CommodityOrderRequest | view | from | CONSUMPTION | Cmmdty Drvtv Order Request Details |
| C_CommodityOrderRequestLeg | view | left_outer | CONSUMPTION | Cmmdty Drvtv Order Request Leg Details |
| I_ACMMntnPrcgLotCmmdtyOrder | view | inner | COMPOSITE | Interface Layer Trading Contract Price Fix CDote Details |
| I_CmmdtyOrderReqLegTP | view | left_outer | TRANSACTIONAL | Cmmdty Order Req. Leg Transactional View |
| I_CmmdtyOrderRequestReference | view | from | BASIC | Basic View for Order Request Reference |
| I_CmmdtyOrdErrMsgsByOrdReq | view | from | COMPOSITE | Basic View to Count Ord Req Error Msgs |
| I_CmmdtyOrdReqBracketItm | view | left_outer | COMPOSITE | Cmmdty Order Bracket Item Interface View |
| I_CmmdtyOrdReqDocsByOrdReq | view | from | COMPOSITE | Basic View to Count Assigned Documents |
| I_CmmdtyOrdReqFilledVH | view | from | BASIC | Value Help View for Order Request Status |
| I_CmmdtyOrdReqMsgsByOrdReq | view | from | COMPOSITE | Basic View to Count Ord Req Messages |
| I_CmmdtyOrdReqMsgTypeText | view | from | COMPOSITE | Basic View for Message Type |
| I_CmmdtyOrdWrngMsgsByOrdReq | view | from | COMPOSITE | Basic View to Count Ord Req Warning Msgs |
| I_CommodityOrderRequestTP | view | from | TRANSACTIONAL | Commodity Order Req. Transactional View |
| I_CommodityOrderRequestVH | view | from | COMPOSITE | Value Help View for Order Request |
| I_TrdgContrPrcFixCmmdtyOrder | view | inner | COMPOSITE | Interface Layer Trading Contract Price Fix CDote Details |
Fields (78)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CmmdtyOrderRequestStatus | CmmdtyOrderRequestStatus | 7 |
| KEY | CommodityOrderRequest | CommodityOrderRequest | 6 |
| KEY | CommodityOrderRequestUUID | CommodityOrderRequestUUID | 7 |
| CmmdtyDerivativeCurrencyPerLot | CmmdtyDerivativeCurrencyPerLot | 2 | |
| CmmdtyDerivativeQuantityPerLot | CmmdtyDerivativeQuantityPerLot | 2 | |
| CmmdtyDrvtvQuantityUnitPerLot | CmmdtyDrvtvQuantityUnitPerLot,CmmdtyOrdReqFilledQuantityUnit,CmmdtyOrdReqPricedQuantityUnit,CmmdtyOrdReqToPriceTotQtyUnit | 3 | |
| CmmdtyOrdCntrPtyBrokerRefAcct | CmmdtyOrdCntrPtyBrokerRefAcct | 2 | |
| CmmdtyOrderReqIsCopied | CmmdtyOrderReqIsCopied | 1 | |
| CmmdtyOrderReqRejectionReason | CmmdtyOrderReqRejectionReason | 2 | |
| CmmdtyOrderRequestCanceledBy | CmmdtyOrderRequestCanceledBy | 1 | |
| CmmdtyOrderRequestExchangeType | CmmdtyOrderRequestExchangeType | 2 | |
| CmmdtyOrderRequestProcessStep | CmmdtyOrderRequestProcessStep | 2 | |
| CmmdtyOrderRequestQuantity | CmmdtyOrderRequestQuantity | 1 | |
| CmmdtyOrderRequestReason | CmmdtyOrderRequestReason | 4 | |
| CmmdtyOrderRequestSource | CmmdtyOrderRequestSource | 3 | |
| CmmdtyOrderRequestType | CmmdtyOrderRequestType | 3 | |
| CmmdtyOrdFxdSpreadPrcQtyUnit | CmmdtyOrdFxdSpreadPrcQtyUnit | 2 | |
| CmmdtyOrdInternalCounterparty | CmmdtyOrdInternalCounterparty | 1 | |
| CmmdtyOrdLeewayRngePrcQtyUnit | CmmdtyOrdLeewayRngePrcQtyUnit | 2 | |
| CmmdtyOrdLmtSpreadPrcQtyUnit | CmmdtyOrdLmtSpreadPrcQtyUnit | 2 | |
| CmmdtyOrdMatchPreventionInstrn | CmmdtyOrdMatchPreventionInstrn | 1 | |
| CmmdtyOrdRejectReferenceUUID | CmmdtyOrdRejectReferenceUUID | 1 | |
| CmmdtyOrdReqCntrPtyBroker | CmmdtyOrdReqCntrPtyBroker | 2 | |
| CmmdtyOrdReqCntrPtySubAcctUUID | CmmdtyOrdReqCntrPtySubAcctUUID | 2 | |
| CmmdtyOrdReqExprtnInstruction | CmmdtyOrdReqExprtnInstruction | 2 | |
| CmmdtyOrdReqExpryInstrnCat | CmmdtyOrdReqExpryInstrnCat | 1 | |
| CmmdtyOrdReqFxdPrc | CmmdtyOrdReqFxdPrc | 2 | |
| CmmdtyOrdReqFxdPrcCrcy | CmmdtyOrdReqFxdPrcCrcy | 2 | |
| CmmdtyOrdReqFxdPrcQty | CmmdtyOrdReqFxdPrcQty | 2 | |
| CmmdtyOrdReqFxdPrcQtyUnit | CmmdtyOrdReqFxdPrcQtyUnit | 2 | |
| CmmdtyOrdReqFxdSpreadPrc | CmmdtyOrdReqFxdSpreadPrc | 2 | |
| CmmdtyOrdReqFxdSpreadPrcCrcy | CmmdtyOrdReqFxdSpreadPrcCrcy | 2 | |
| CmmdtyOrdReqFxdSpreadPrcQty | CmmdtyOrdReqFxdSpreadPrcQty | 2 | |
| CmmdtyOrdReqInitialStatusIsSet | CmmdtyOrdReqInitialStatusIsSet | 2 | |
| CmmdtyOrdReqLeewayPrc | CmmdtyOrdReqLeewayPrc | 2 | |
| CmmdtyOrdReqLeewayPrcCrcy | CmmdtyOrdReqLeewayPrcCrcy | 2 | |
| CmmdtyOrdReqLeewayPrcQty | CmmdtyOrdReqLeewayPrcQty | 2 | |
| CmmdtyOrdReqLeewayPrcQtyUnit | CmmdtyOrdReqLeewayPrcQtyUnit | 2 | |
| CmmdtyOrdReqLeewayRngePrc | CmmdtyOrdReqLeewayRngePrc | 2 | |
| CmmdtyOrdReqLeewayRngePrcCrcy | CmmdtyOrdReqLeewayRngePrcCrcy | 2 | |
| CmmdtyOrdReqLeewayRngePrcQty | CmmdtyOrdReqLeewayRngePrcQty | 2 | |
| CmmdtyOrdReqLmtPrc | CmmdtyOrdReqLmtPrc | 2 | |
| CmmdtyOrdReqLmtPrcCurrency | CmmdtyOrdReqLmtPrcCurrency | 2 | |
| CmmdtyOrdReqLmtPrcQuantity | CmmdtyOrdReqLmtPrcQuantity | 2 | |
| CmmdtyOrdReqLmtPrcQuantityUnit | CmmdtyOrdReqLmtPrcQuantityUnit | 2 | |
| CmmdtyOrdReqLmtSpreadPrc | CmmdtyOrdReqLmtSpreadPrc | 2 | |
| CmmdtyOrdReqLmtSpreadPrcCrcy | CmmdtyOrdReqLmtSpreadPrcCrcy | 2 | |
| CmmdtyOrdReqLmtSpreadPrcQty | CmmdtyOrdReqLmtSpreadPrcQty | 2 | |
| CmmdtyOrdReqNegttnDateTime | CmmdtyOrdReqNegttnDateTime | 2 | |
| CmmdtyOrdReqOriglQuantityInLot | CmmdtyOrdReqOriglQuantityInLot | 2 | |
| CmmdtyOrdReqPrcgExecInstrnCat | CmmdtyOrdReqPrcgExecInstrnCat | 1 | |
| CmmdtyOrdReqPricingProgram | CmmdtyOrdReqPricingProgram | 1 | |
| CmmdtyOrdReqRejectionReference | CmmdtyOrdReqRejectionReference | 1 | |
| CmmdtyOrdReqSentToBrkrDateTime | CmmdtyOrdReqSentToBrkrDateTime | 2 | |
| CmmdtyOrdReqStopLmtPrc | CmmdtyOrdReqStopLmtPrc | 1 | |
| CmmdtyOrdReqStopLmtPrcCrcy | CmmdtyOrdReqStopLmtPrcCrcy | 1 | |
| CmmdtyOrdReqStopLmtPrcQty | CmmdtyOrdReqStopLmtPrcQty | 1 | |
| CmmdtyOrdReqStopLmtPrcQtyUnit | CmmdtyOrdReqStopLmtPrcQtyUnit | 1 | |
| CmmdtyOrdReqStopPrice | CmmdtyOrdReqStopPrice | 2 | |
| CmmdtyOrdReqStopPriceCrcy | CmmdtyOrdReqStopPriceCrcy | 2 | |
| CmmdtyOrdReqStopPriceQty | CmmdtyOrdReqStopPriceQty | 2 | |
| CmmdtyOrdReqStopPriceQtyUnit | CmmdtyOrdReqStopPriceQtyUnit | 2 | |
| CmmdtyOrdRequestCanclnDateTime | CmmdtyOrdRequestCanclnDateTime | 1 | |
| CmmdtyOrdRequestExpirationDate | CmmdtyOrdRequestExpirationDate | 2 | |
| CmmdtyOrdRequestReferenceUUID | CmmdtyOrdRequestReferenceUUID | 1 | |
| Commodity | Commodity | 1 | |
| CommodityDerivativeBroker | CommodityDerivativeBroker | 2 | |
| CommodityOrderRequestComment | CommodityOrderRequestComment | 2 | |
| CommodityOrderRequestReference | CommodityOrderRequestReference | 1 | |
| CommodityOrderRequestTrader | CommodityOrderRequestTrader | 2 | |
| CommodityOrdReqStatusReason | CommodityOrdReqStatusReason | 2 | |
| CommoditySubAccount | CommoditySubAccount | 2 | |
| CommoditySubAccountName | CommoditySubAccountName | 1 | |
| CommoditySubAccountUUID | CommoditySubAccountUUID | 2 | |
| CompanyCode | CompanyCode | 1 | |
| CreationDateTime | CreationDateTime | 2 | |
| LastChangeDateTime | LastChangeDateTime | 2 | |
| LastChangedByUser | LastChangedByUser | 2 |
@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
}