SDSLS_SORI

Transparent Table Application Table

Database table for SalesOrderRequest Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
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.

-- Database table for SalesOrderRequest Item
-- 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)
);