SDSLS_SORI_SRC

Transparent Table Application Table
14 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 14 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 (14)

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
detnstrategyforproduct DETNSTRGYFORPRODUCT Determination Strategy for Product
determinedproduct DTMNDPRODUCT Determined Product

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]
    DETNSTRATEGYFORPRODUCT,       -- Determination Strategy for Product [DETNSTRGYFORPRODUCT]
    DETERMINEDPRODUCT,            -- Determined Product [DTMNDPRODUCT]
    PRIMARY KEY (MANDT, SALESORDERREQUEST, SALESORDERREQUESTITEM)
);

Learn More