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