SDSLS_SOR

Transparent Table Application Table
43 Fields 1 CDS Views

Database table for SalesOrderRequest Root

SDSLS_SOR is an SAP database table in S/4HANA. Database table for SalesOrderRequest Root. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

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

-- Database table for SalesOrderRequest Root
-- 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,       -- Cust. Ref. Date [bstdk]
    SALESOFFICE,                     -- Sales Office [vkbur]
    SALESGROUP,                      -- Sales Group [vkgrp]
    PRIMARY KEY (MANDT, SALESORDERREQUEST)
);

Learn More