SDSLS_SORDI

Transparent Table Application Table
16 Fields 1 CDS Views

Database table for SalesOrderRequest Derived Item

SDSLS_SORDI is an SAP database table in S/4HANA. Database table for SalesOrderRequest Derived Item. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesOrderRequestDerivedItem view from BASIC Sales Order Request Derived Item

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY salesorderrequest SD_SALES_ORDER_REQUEST Sales Order Request
KEY salesorderrequestitem SD_SALES_ORDER_REQUEST_ITEM Item
KEY salesorderitem SALES_ORDER_ITEM Item
higherlevelitem UEPOS Higher-Lev.Item
product PRODUCTNUMBER Product
requestedquantity REQD_QTY Requested Quantity
requestedquantityunit REQD_QTY_UNIT Requested Qty Unit
netamount NETWR_AP Net Value
transactioncurrency WAERK Doc. Currency
salesorderitemcategory SLS_ORD_REQ_ITEM_CATEGORY Item Category
materialbycustomer SLS_ORD_REQ_CUST_MATERIAL Customer Mat.
confddelivqtyinorderqtyunit SLS_ORD_REQ_CONF_QTY Confd Quantity
confirmeddeliverydate SLS_ORD_REQ_CONF_DELV_DATE Confirmed Delivery Date
orderquantityunit SLS_ORD_REQ_ORD_QTY_UNIT Sales Unit
requesteddeliverydate REQD_DELIVERY_DATE Requested Delivery Date

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.

-- Database table for SalesOrderRequest Derived Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SORDI (
    MANDT,                        -- Client [MANDT]
    SALESORDERREQUEST,            -- Sales Order Request [SD_SALES_ORDER_REQUEST]
    SALESORDERREQUESTITEM,        -- Item [SD_SALES_ORDER_REQUEST_ITEM]
    SALESORDERITEM,               -- Item [SALES_ORDER_ITEM]
    HIGHERLEVELITEM,              -- Higher-Lev.Item [UEPOS]
    PRODUCT,                      -- Product [PRODUCTNUMBER]
    REQUESTEDQUANTITY,            -- Requested Quantity [REQD_QTY]
    REQUESTEDQUANTITYUNIT,        -- Requested Qty Unit [REQD_QTY_UNIT]
    NETAMOUNT,                    -- Net Value [NETWR_AP]
    TRANSACTIONCURRENCY,          -- Doc. Currency [WAERK]
    SALESORDERITEMCATEGORY,       -- Item Category [SLS_ORD_REQ_ITEM_CATEGORY]
    MATERIALBYCUSTOMER,           -- Customer Mat. [SLS_ORD_REQ_CUST_MATERIAL]
    CONFDDELIVQTYINORDERQTYUNIT,  -- Confd Quantity [SLS_ORD_REQ_CONF_QTY]
    CONFIRMEDDELIVERYDATE,        -- Confirmed Delivery Date [SLS_ORD_REQ_CONF_DELV_DATE]
    ORDERQUANTITYUNIT,            -- Sales Unit [SLS_ORD_REQ_ORD_QTY_UNIT]
    REQUESTEDDELIVERYDATE,        -- Requested Delivery Date [REQD_DELIVERY_DATE]
    PRIMARY KEY (MANDT, SALESORDERREQUEST, SALESORDERREQUESTITEM, SALESORDERITEM)
);

Learn More