SDSLS_SORI_SRC

Transparent Table Application Table
12 Fields 1 CDS Views

Sales Order Request Item Source

SDSLS_SORI_SRC is an SAP database table in S/4HANA. Sales Order Request Item Source. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesOrderRequestItemSource view from BASIC Sales Order Request Source Item

Fields (12)

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
slsordreqitemchangetype sls_ord_req_item_change_type Sales Order Request EDI Item Change Type
extractedcustomermaterial sd_extracted_cust_material Extracted Customer Material
extractedproduct sd_extracted_product Extracted Product
extractedproductdescription sd_extracted_prod_desc Extracted Description
unitofmeasuretext sd_extracted_uom_text Extracted Unit of Measure
customerunitprice sd_extracted_unit_price Extracted Unit Price
extractedpoitemnetamount sd_extracted_item_net_amount Extracted Net Value
transactioncurrency sd_extracted_item_crcy Document Currency
currencyisocode sd_extracted_item_isocd Currency ISO Code

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 Source
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SORI_SRC (
    MANDT,                        -- Client [mandt]
    SALESORDERREQUEST,            -- Sales Order Request [sd_sales_order_request]
    SALESORDERREQUESTITEM,        -- Item [sd_sales_order_request_item]
    SLSORDREQITEMCHANGETYPE,      -- Sales Order Request EDI Item Change Type [sls_ord_req_item_change_type]
    EXTRACTEDCUSTOMERMATERIAL,    -- Extracted Customer Material [sd_extracted_cust_material]
    EXTRACTEDPRODUCT,             -- Extracted Product [sd_extracted_product]
    EXTRACTEDPRODUCTDESCRIPTION,  -- Extracted Description [sd_extracted_prod_desc]
    UNITOFMEASURETEXT,            -- Extracted Unit of Measure [sd_extracted_uom_text]
    CUSTOMERUNITPRICE,            -- Extracted Unit Price [sd_extracted_unit_price]
    EXTRACTEDPOITEMNETAMOUNT,     -- Extracted Net Value [sd_extracted_item_net_amount]
    TRANSACTIONCURRENCY,          -- Document Currency [sd_extracted_item_crcy]
    CURRENCYISOCODE,              -- Currency ISO Code [sd_extracted_item_isocd]
    PRIMARY KEY (MANDT, SALESORDERREQUEST, SALESORDERREQUESTITEM)
);

Learn More