SDSLS_SOR

Transparent Table Application Table
40 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 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesOrderRequest view from BASIC Sales Order Request

Fields (40)

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

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]
    PRIMARY KEY (MANDT, SALESORDERREQUEST)
);

Learn More