SDSLS_SORI

Transparent Table Application Table
9 Fields 2 CDS Views

Sales Order Request: Item Data

SDSLS_SORI is an SAP database table in S/4HANA. Sales Order Request: Item Data. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SalesOrderRequestItem view_entity from EXTENSION Sales Order Request Item - Extension
I_SalesOrderRequestItem view from BASIC Sales Order Request Item

Fields (9)

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
product productnumber Product
requestedquantity reqd_qty Requested Quantity
requestedquantityunit reqd_qty_unit Requested Qty Unit
requesteddeliverydate reqd_delivery_date Requested Delivery Date
underlyingpurchaseorderitem posex PO Item
materialbycustomer matnr_ku Cust. Material

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: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SORI (
    MANDT,                        -- Client [mandt]
    SALESORDERREQUEST,            -- Sales Order Request [sd_sales_order_request]
    SALESORDERREQUESTITEM,        -- Item [sd_sales_order_request_item]
    PRODUCT,                      -- Product [productnumber]
    REQUESTEDQUANTITY,            -- Requested Quantity [reqd_qty]
    REQUESTEDQUANTITYUNIT,        -- Requested Qty Unit [reqd_qty_unit]
    REQUESTEDDELIVERYDATE,        -- Requested Delivery Date [reqd_delivery_date]
    UNDERLYINGPURCHASEORDERITEM,  -- PO Item [posex]
    MATERIALBYCUSTOMER,           -- Cust. Material [matnr_ku]
    PRIMARY KEY (MANDT, SALESORDERREQUEST, SALESORDERREQUESTITEM)
);

Learn More