I_CMMDTYORDERREQUESTTYPE

CDS View

Cmmdty Order Request Type

I_CMMDTYORDERREQUESTTYPE is a CDS View in S/4HANA. Cmmdty Order Request Type. It contains 7 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CmmdtyOrderRequestStatus view left_outer CONSUMPTION Consumption View for Order Req Status
C_CmmdtyOrdFillRelatedFill view left_outer CONSUMPTION Assigned Fills Consumption View
I_CommodityOrderFillTP view left_outer TRANSACTIONAL Commodity Order Fill Transactional View
I_CommodityOrderRequestTP view left_outer TRANSACTIONAL Commodity Order Req. Transactional View
I_CommodityOrderRequestVH view left_outer COMPOSITE Value Help View for Order Request
I_CommodityOrdFillPacketTP view left_outer TRANSACTIONAL Tran. View for Cmmdty Deriv Ord Fill Pkt

Fields (7)

KeyField CDS FieldsUsed in Views
CmmdtyDrvtvCounterPartyInfoTxt CmmdtyDrvtvCounterPartyInfoTxt 1
CmmdtyOrderReqDocCardinalValue CmmdtyOrderReqDocCardinalValue 2
CmmdtyOrderRequestKind CmmdtyOrderRequestKind 3
CmmdtyOrderRequestKindText CmmdtyOrderRequestKindText 1
CmmdtyOrderRequestTypeText CmmdtyOrderRequestTypeText 1
CommodityOrderFillCategory CommodityOrderFillCategory 1
Counterparty CmmdtyOrdFillCounterPartyInfo,Counterparty 3

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.

-- Cmmdty Order Request Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYORDERREQUESTTYPE (
    CMMDTYDRVTVCOUNTERPARTYINFOTXT,
    CMMDTYORDERREQDOCCARDINALVALUE,
    CMMDTYORDERREQUESTKIND,
    CMMDTYORDERREQUESTKINDTEXT,
    CMMDTYORDERREQUESTTYPETEXT,
    COMMODITYORDERFILLCATEGORY,
    COUNTERPARTY
);