I_SALESORDERREQUESTDERIVEDITEM

CDS View

Sales Order Request Simulated Item

I_SALESORDERREQUESTDERIVEDITEM is a CDS View in S/4HANA. Sales Order Request Simulated Item. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SalesOrderRequestDerivdItmTP view_entity from TRANSACTIONAL Sales Order Request Simulated Item TP

Fields (15)

KeyField CDS FieldsUsed in Views
KEY SalesOrderItem SalesOrderItem 1
KEY SalesOrderRequest SalesOrderRequest 1
KEY SalesOrderRequestItem SalesOrderRequestItem 1
ConfdDelivQtyInOrderQtyUnit ConfdDelivQtyInOrderQtyUnit 1
ConfirmedDeliveryDate ConfirmedDeliveryDate 1
HigherLevelItem HigherLevelItem 1
MaterialByCustomer MaterialByCustomer 1
NetAmount NetAmount 1
OrderQuantityUnit OrderQuantityUnit 1
Product Product 1
RequestedDeliveryDate RequestedDeliveryDate 1
RequestedQuantity RequestedQuantity 1
RequestedQuantityUnit RequestedQuantityUnit 1
SalesOrderItemCategory SalesOrderItemCategory 1
TransactionCurrency TransactionCurrency 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.

-- Sales Order Request Simulated Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDERREQUESTDERIVEDITEM (
    SALESORDERITEM,
    SALESORDERREQUEST,
    SALESORDERREQUESTITEM,
    CONFDDELIVQTYINORDERQTYUNIT,
    CONFIRMEDDELIVERYDATE,
    HIGHERLEVELITEM,
    MATERIALBYCUSTOMER,
    NETAMOUNT,
    ORDERQUANTITYUNIT,
    PRODUCT,
    REQUESTEDDELIVERYDATE,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    SALESORDERITEMCATEGORY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESORDERITEM, SALESORDERREQUEST, SALESORDERREQUESTITEM)
);