I_COMMODITYORDERREQUEST

CDS View
78 Fields 16 CDS Views

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Commodity Order Request Interface View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COMMODITYORDERREQUEST (
    CMMDTYORDERREQUESTSTATUS,
    COMMODITYORDERREQUEST,
    COMMODITYORDERREQUESTUUID,
    CMMDTYDERIVATIVECURRENCYPERLOT,
    CMMDTYDERIVATIVEQUANTITYPERLOT,
    CMMDTYDRVTVQUANTITYUNITPERLOT,
    CMMDTYORDCNTRPTYBROKERREFACCT,
    CMMDTYORDERREQISCOPIED,
    CMMDTYORDERREQREJECTIONREASON,
    CMMDTYORDERREQUESTCANCELEDBY,
    CMMDTYORDERREQUESTEXCHANGETYPE,
    CMMDTYORDERREQUESTPROCESSSTEP,
    CMMDTYORDERREQUESTQUANTITY,
    CMMDTYORDERREQUESTREASON,
    CMMDTYORDERREQUESTSOURCE,
    CMMDTYORDERREQUESTTYPE,
    CMMDTYORDFXDSPREADPRCQTYUNIT,
    CMMDTYORDINTERNALCOUNTERPARTY,
    CMMDTYORDLEEWAYRNGEPRCQTYUNIT,
    CMMDTYORDLMTSPREADPRCQTYUNIT,
    CMMDTYORDMATCHPREVENTIONINSTRN,
    CMMDTYORDREJECTREFERENCEUUID,
    CMMDTYORDREQCNTRPTYBROKER,
    CMMDTYORDREQCNTRPTYSUBACCTUUID,
    CMMDTYORDREQEXPRTNINSTRUCTION,
    CMMDTYORDREQEXPRYINSTRNCAT,
    CMMDTYORDREQFXDPRC,
    CMMDTYORDREQFXDPRCCRCY,
    CMMDTYORDREQFXDPRCQTY,
    CMMDTYORDREQFXDPRCQTYUNIT,
    CMMDTYORDREQFXDSPREADPRC,
    CMMDTYORDREQFXDSPREADPRCCRCY,
    CMMDTYORDREQFXDSPREADPRCQTY,
    CMMDTYORDREQINITIALSTATUSISSET,
    CMMDTYORDREQLEEWAYPRC,
    CMMDTYORDREQLEEWAYPRCCRCY,
    CMMDTYORDREQLEEWAYPRCQTY,
    CMMDTYORDREQLEEWAYPRCQTYUNIT,
    CMMDTYORDREQLEEWAYRNGEPRC,
    CMMDTYORDREQLEEWAYRNGEPRCCRCY,
    CMMDTYORDREQLEEWAYRNGEPRCQTY,
    CMMDTYORDREQLMTPRC,
    CMMDTYORDREQLMTPRCCURRENCY,
    CMMDTYORDREQLMTPRCQUANTITY,
    CMMDTYORDREQLMTPRCQUANTITYUNIT,
    CMMDTYORDREQLMTSPREADPRC,
    CMMDTYORDREQLMTSPREADPRCCRCY,
    CMMDTYORDREQLMTSPREADPRCQTY,
    CMMDTYORDREQNEGTTNDATETIME,
    CMMDTYORDREQORIGLQUANTITYINLOT,
    CMMDTYORDREQPRCGEXECINSTRNCAT,
    CMMDTYORDREQPRICINGPROGRAM,
    CMMDTYORDREQREJECTIONREFERENCE,
    CMMDTYORDREQSENTTOBRKRDATETIME,
    CMMDTYORDREQSTOPLMTPRC,
    CMMDTYORDREQSTOPLMTPRCCRCY,
    CMMDTYORDREQSTOPLMTPRCQTY,
    CMMDTYORDREQSTOPLMTPRCQTYUNIT,
    CMMDTYORDREQSTOPPRICE,
    CMMDTYORDREQSTOPPRICECRCY,
    CMMDTYORDREQSTOPPRICEQTY,
    CMMDTYORDREQSTOPPRICEQTYUNIT,
    CMMDTYORDREQUESTCANCLNDATETIME,
    CMMDTYORDREQUESTEXPIRATIONDATE,
    CMMDTYORDREQUESTREFERENCEUUID,
    COMMODITY,
    COMMODITYDERIVATIVEBROKER,
    COMMODITYORDERREQUESTCOMMENT,
    COMMODITYORDERREQUESTREFERENCE,
    COMMODITYORDERREQUESTTRADER,
    COMMODITYORDREQSTATUSREASON,
    COMMODITYSUBACCOUNT,
    COMMODITYSUBACCOUNTNAME,
    COMMODITYSUBACCOUNTUUID,
    COMPANYCODE,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (CMMDTYORDERREQUESTSTATUS, COMMODITYORDERREQUEST, COMMODITYORDERREQUESTUUID)
);

Learn More