I_COMMODITYORDERREQUESTFILL

CDS View
13 Fields 5 CDS Views

Basic View for Commodity Order Fill

I_COMMODITYORDERREQUESTFILL is a CDS View in S/4HANA. Basic View for Commodity Order Fill. It contains 13 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CmmdtyOrdFillPacketAssgdFill view from CONSUMPTION Fill Packet Assigned Fills Consump. View
C_CmmdtyOrdReqAssignedFill view from CONSUMPTION Assigned Fills Consumption View
I_CmmdtyLotsOfFillByFillPacket view from COMPOSITE Basic View for Fill Packet Lots
I_CmmdtyOrdFillQtyByFillPacket view from COMPOSITE Basic value for Fill Pkt Filled Qty
I_CmmdtyOrdReqFillQtyByOrdReq view from COMPOSITE Total filled Quantity for Ord Req View

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CommodityOrderFillUUID CommodityOrderFillUUID 2
KEY CommodityOrderRequestUUID CommodityOrderRequestUUID 2
CmmdtyOrderFillDateTime CmmdtyOrderFillDateTime 1
CmmdtyOrderFillPacket CmmdtyOrderFillPacket 1
CmmdtyOrderFillPrice CmmdtyOrderFillPrice 1
CmmdtyOrderFillPriceCrcy CmmdtyOrderFillPriceCrcy 1
CmmdtyOrderFillQuantityUnit CmmdtyOrderFillQuantityUnit,CmmdtyOrdFillCumulativeQtyUnit 1
CmmdtyOrderFillRequestType CmmdtyOrderFillRequestType 1
CmmdtyOrderRequestFlowType CmmdtyOrderRequestFlowType 1
Commodity Commodity 1
CommodityOrderFill CommodityOrderFill 1
CommodityOrderFillPacketUUID CommodityOrderFillPacketUUID 2
CompanyCode CompanyCode 1

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.

-- Basic View for Commodity Order Fill
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COMMODITYORDERREQUESTFILL (
    COMMODITYORDERFILLUUID,
    COMMODITYORDERREQUESTUUID,
    CMMDTYORDERFILLDATETIME,
    CMMDTYORDERFILLPACKET,
    CMMDTYORDERFILLPRICE,
    CMMDTYORDERFILLPRICECRCY,
    CMMDTYORDERFILLQUANTITYUNIT,
    CMMDTYORDERFILLREQUESTTYPE,
    CMMDTYORDERREQUESTFLOWTYPE,
    COMMODITY,
    COMMODITYORDERFILL,
    COMMODITYORDERFILLPACKETUUID,
    COMPANYCODE,
    PRIMARY KEY (COMMODITYORDERFILLUUID, COMMODITYORDERREQUESTUUID)
);

Learn More