I_CMMDTYORDREQDOCUMENT

CDS View
22 Fields 10 CDS Views

Cmmdty Order Request Assgined Document

I_CMMDTYORDREQDOCUMENT is a CDS View in S/4HANA. Cmmdty Order Request Assgined Document. It contains 22 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_CmmdtyOrdFillAssgdDocTP view from CONSUMPTION Assigned Documents Consumption View
I_CmmdtyOrderAssgdDocByOrdFill view left_outer BASIC Basic View to Count Ord Fill Assgd Docs
I_CmmdtyOrderAssgdDocByPacket view left_outer BASIC Basic View to Count Packet Assgd Docs
I_CmmdtyOrdFillAssignedDoc view from BASIC Cmmdty Order Fills Assigned Doc
I_CmmdtyOrdReqAssgdDocByOrdReq view left_outer BASIC Basic View to Count Ord Req Assgd Docs
I_CmmdtyOrdReqBracketItm view left_outer COMPOSITE Cmmdty Order Bracket Item Interface View
I_CmmdtyOrdReqDocsByOrdReq view left_outer COMPOSITE Basic View to Count Assigned Documents
I_CmmdtyOrdReqDocumentTP view from TRANSACTIONAL Cmmdty Order Request Assgined Document
I_CmmdtyOrdToBePrcdQtyByOrdReq view from BASIC Cmmdty Ord Request To Be Priced Quantity
P_CmmdtyOrdFillPrcdQtyByOrdReq view from BASIC Total Priced Quantity for Ord Req View

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CmmdtyOrderRequestDocumentUUID CmmdtyOrderRequestDocumentUUID 1
KEY CommodityOrderRequestUUID CommodityOrderRequestUUID 3
CmmdtyOrdDocLoglRptgIsUpdtd CmmdtyOrdDocLoglRptgIsUpdtd 1
CmmdtyOrderFillPrcgUpdtStatus CmmdtyOrderFillPrcgUpdtStatus 1
CmmdtyOrdReqDocApplication CmmdtyOrdReqDocApplication 3
CmmdtyOrdReqDocContractType CmmdtyOrdReqDocContractType 2
CmmdtyOrdReqDocExternalID CmmdtyOrdReqDocExternalID 1
CmmdtyOrdReqDocOpnQuantity CmmdtyOrdReqDocOpnQuantity 1
CmmdtyOrdReqDocOpnQuantityUnit CmmdtyOrdReqDocOpnQuantityUnit 1
CmmdtyOrdReqDocPricingLot CmmdtyOrdReqDocPricingLot 1
CmmdtyOrdReqDocPricingStatus CmmdtyOrdReqDocPricingStatus 1
CmmdtyOrdReqDocSqncOfFilling CmmdtyOrdReqDocSqncOfFilling 1
CmmdtyOrdReqDocToFillQty CmmdtyOrdReqDocToFillQty 1
CmmdtyOrdReqDocToFillQtyUnit CmmdtyOrdReqDocFilledQtyUnit,CmmdtyOrdReqDocToFillQtyUnit 2
CmmdtyOrdRequestDocumentItem CmmdtyOrdRequestDocumentItem 1
CmmdtyOrdRequestDocumentType CmmdtyOrdRequestDocumentType 2
CommodityOrderFillPacketUUID CommodityOrderFillPacketUUID 1
CommodityOrderRequest CommodityOrderRequest 2
CommodityOrderRequestDocument CommodityOrderRequestDocument 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 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.

-- Cmmdty Order Request Assgined Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYORDREQDOCUMENT (
    CMMDTYORDERREQUESTDOCUMENTUUID,
    COMMODITYORDERREQUESTUUID,
    CMMDTYORDDOCLOGLRPTGISUPDTD,
    CMMDTYORDERFILLPRCGUPDTSTATUS,
    CMMDTYORDREQDOCAPPLICATION,
    CMMDTYORDREQDOCCONTRACTTYPE,
    CMMDTYORDREQDOCEXTERNALID,
    CMMDTYORDREQDOCOPNQUANTITY,
    CMMDTYORDREQDOCOPNQUANTITYUNIT,
    CMMDTYORDREQDOCPRICINGLOT,
    CMMDTYORDREQDOCPRICINGSTATUS,
    CMMDTYORDREQDOCSQNCOFFILLING,
    CMMDTYORDREQDOCTOFILLQTY,
    CMMDTYORDREQDOCTOFILLQTYUNIT,
    CMMDTYORDREQUESTDOCUMENTITEM,
    CMMDTYORDREQUESTDOCUMENTTYPE,
    COMMODITYORDERFILLPACKETUUID,
    COMMODITYORDERREQUEST,
    COMMODITYORDERREQUESTDOCUMENT,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (CMMDTYORDERREQUESTDOCUMENTUUID, COMMODITYORDERREQUESTUUID)
);

Learn More