SDSLS_SOR

Transparent Table Application Table
43 Fields 2 CDS Views

Sales Order Request: Header Data

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SalesOrderRequest view_entity from EXTENSION Sales Order Request - Extension
I_SalesOrderRequest view from BASIC Sales Order Request

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesorderrequest sd_sales_order_request Sales Order Request
salesorderrequestcategory sls_ord_req_category SOR Category
companycode fis_bukrs Company Code
uploadfilecontentbinary salesorderrequestpdfcontent Source File
salesorderrequestfilemimetype dd_fti_mime_type MIME Type
salesorderrequestfilename sls_ord_req_file_name File Name
salesordertype sales_order_type Sales Order Type
soldtoparty kunag Sold-to Party
soldtopartyaddressid adrnr_ag Sold-To Address
shiptoparty ship_to_party_sor Ship-to Party
shiptopartyaddressid adrnr_we Ship-to address
transactioncurrency waerk Doc. Currency
salesorder vdm_sales_order Sales Order
totalnetamount netwr Net Value
salesorganization vkorg Sales Org.
distributionchannel vtweg Distr. Channel
organizationdivision spart Division
purchaseorderbycustomer bstkd Cust. Reference
sdpricingprocedure kalsmasd Pric. Procedure
salesorderrequestextractoruuid sls_ord_req_extractor_uuid Extractor UUID
salesorderreqextractionstatus sls_ord_req_extraction_status Data Extraction
createdbyuser ernam Created By
creationdatetime creation_date_time Created On
lastchangedbyuser last_changed_by_user Last Changed By
lastchangedatetime last_changed_date_time Last Changed On
salesorderreqprocessingstatus sd_sor_procg_sts SOR Procg Status
requesteddeliverydate reqd_delivery_date Requested Delivery Date
salesorderreqsimulationstatus sls_ord_req_simulation_sts Order Simulation
salesorderreqapprovalstatus sls_ord_req_approval_sts Sales Order Request Approval Status
lastsimulateddatetime sls_ord_req_simulated_datetime Last Simulated On
salesorderrequestloghandle balloghndl Handle
slsordreqfilecontenthash sls_ord_req_file_cont_hash Hash
slsordreqsilentdtamigrtnvers sls_ord_req_sdm_version SDM Version
incotermsclassification inco1 Incoterms
incotermsversion incov Inco. Version
incotermslocation1 inco2_l Inco. Location1
incotermslocation2 inco3_l Inco. Location2
customerpaymentterms dzterm Pyt Terms
fixedvaluedate valdt Fixed Val. Date
customerpurchaseorderdate sls_ord_req_cust_ref_date
salesoffice vkbur Sales Office
salesgroup vkgrp Sales Group

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: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SOR (
    MANDT,                           -- Client [mandt]
    SALESORDERREQUEST,               -- Sales Order Request [sd_sales_order_request]
    SALESORDERREQUESTCATEGORY,       -- SOR Category [sls_ord_req_category]
    COMPANYCODE,                     -- Company Code [fis_bukrs]
    UPLOADFILECONTENTBINARY,         -- Source File [salesorderrequestpdfcontent]
    SALESORDERREQUESTFILEMIMETYPE,   -- MIME Type [dd_fti_mime_type]
    SALESORDERREQUESTFILENAME,       -- File Name [sls_ord_req_file_name]
    SALESORDERTYPE,                  -- Sales Order Type [sales_order_type]
    SOLDTOPARTY,                     -- Sold-to Party [kunag]
    SOLDTOPARTYADDRESSID,            -- Sold-To Address [adrnr_ag]
    SHIPTOPARTY,                     -- Ship-to Party [ship_to_party_sor]
    SHIPTOPARTYADDRESSID,            -- Ship-to address [adrnr_we]
    TRANSACTIONCURRENCY,             -- Doc. Currency [waerk]
    SALESORDER,                      -- Sales Order [vdm_sales_order]
    TOTALNETAMOUNT,                  -- Net Value [netwr]
    SALESORGANIZATION,               -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [vtweg]
    ORGANIZATIONDIVISION,            -- Division [spart]
    PURCHASEORDERBYCUSTOMER,         -- Cust. Reference [bstkd]
    SDPRICINGPROCEDURE,              -- Pric. Procedure [kalsmasd]
    SALESORDERREQUESTEXTRACTORUUID,  -- Extractor UUID [sls_ord_req_extractor_uuid]
    SALESORDERREQEXTRACTIONSTATUS,   -- Data Extraction [sls_ord_req_extraction_status]
    CREATEDBYUSER,                   -- Created By [ernam]
    CREATIONDATETIME,                -- Created On [creation_date_time]
    LASTCHANGEDBYUSER,               -- Last Changed By [last_changed_by_user]
    LASTCHANGEDATETIME,              -- Last Changed On [last_changed_date_time]
    SALESORDERREQPROCESSINGSTATUS,   -- SOR Procg Status [sd_sor_procg_sts]
    REQUESTEDDELIVERYDATE,           -- Requested Delivery Date [reqd_delivery_date]
    SALESORDERREQSIMULATIONSTATUS,   -- Order Simulation [sls_ord_req_simulation_sts]
    SALESORDERREQAPPROVALSTATUS,     -- Sales Order Request Approval Status [sls_ord_req_approval_sts]
    LASTSIMULATEDDATETIME,           -- Last Simulated On [sls_ord_req_simulated_datetime]
    SALESORDERREQUESTLOGHANDLE,      -- Handle [balloghndl]
    SLSORDREQFILECONTENTHASH,        -- Hash [sls_ord_req_file_cont_hash]
    SLSORDREQSILENTDTAMIGRTNVERS,    -- SDM Version [sls_ord_req_sdm_version]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    CUSTOMERPAYMENTTERMS,            -- Pyt Terms [dzterm]
    FIXEDVALUEDATE,                  -- Fixed Val. Date [valdt]
    CUSTOMERPURCHASEORDERDATE,       -- sls_ord_req_cust_ref_date
    SALESOFFICE,                     -- Sales Office [vkbur]
    SALESGROUP,                      -- Sales Group [vkgrp]
    PRIMARY KEY (MANDT, SALESORDERREQUEST)
);

Learn More