SDSLS_SOR_SRC

Transparent Table Application Table
48 Fields 1 CDS Views

Sales Order Request Header Source

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesOrderRequestSource view from BASIC Sales Order Request Source

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesorderrequest sd_sales_order_request Sales Order Request
masterdatadeterminationstatus sd_mstr_data_detn_sts MD Determination Sts
languageisocode sd_extracted_lang_isocd Language ISO Code
purchaseorderbycustomer sd_extracted_purchase_order Purchase Order Number
customerpurchaseorderdate sd_extracted_pur_ord_date Purchase Order Date
customerpurchaseorderdatetext sd_extracted_pur_ord_date_text
extractedrequesteddeliverydate sd_sor_xtd_reqd_deliv_date Extracted Requested Delivery Date
requesteddeliverydatetext sd_xtd_reqd_deliv_date_text
customerpaymenttermstext sd_extracted_paymentterms_text Payment Terms
customerincotermstext sd_extracted_incoterms_text Incoterms
customertotalnetamount sd_extracted_total_net_amount Extracted Net Value
customersubtotalamount sd_extracted_subtotal_amount Extracted Subtotal Value
currencyisocode sd_extracted_crcy_isocd Document Currency
transactioncurrency sd_extracted_doc_crcy Document Currency
extractedsupplier sd_extracted_supplier_number Extracted Supplier ID
soldtopartyaddressfullname sd_soldtoparty_full_address Extracted Sold-to Party Address
soldtopartyname sd_soldtoparty_name1 Sold-to Party Name
soldtopartyadditionalname sd_soldtoparty_name2 Sold-to Party Name 2
soldtopartypostalcode sd_soldtoparty_postal_code Postal Code
soldtopartyhousenumber sd_soldtoparty_house_no House Number
soldtopartystreetname sd_soldtoparty_street_name Street
soldtopartydistrictname sd_soldtoparty_district_name District
soldtopartycityname sd_soldtoparty_city_name City
soldtopartyregionname sd_soldtoparty_region_name Region
soldtopartycountryname sd_soldtoparty_country_name Country/Region
soldtopartyemailaddress sd_soldtoparty_email Email
soldtopartytaxregisternumber sd_soldtoparty_tax_regn_no Tax Registration Number
soldtopartytaxnumber sd_soldtoparty_tax_no Additional Tax Number
soldtopartybankaccount sd_soldtoparty_bank_account Bank Account
soldtopartyiban sd_soldtoparty_iban International Bank Account Number
soldtopartytelephonenumber sd_soldtoparty_phone Phone
soldtopartyfaxnumber sd_soldtoparty_fax Fax
soldtopartyextrefid sd_soldtoparty_ext_ref_id Extracted Sold-to Party
shiptopartyaddressfullname sd_shiptoparty_full_address Extracted Ship-to Party Address
shiptopartyname sd_shiptoparty_name1 Ship-to Party Name
shiptopartyadditionalname sd_shiptoparty_name2 Ship-to Party Name 2
shiptopartypostalcode sd_shiptoparty_postal_code Postal Code
shiptopartyhousenumber sd_shiptoparty_house_no House Number
shiptopartystreetname sd_shiptoparty_street_name Street
shiptopartydistrictname sd_shiptoparty_district_name District
shiptopartycityname sd_shiptoparty_city_name City
shiptopartyregionname sd_shiptoparty_region_name Region
shiptopartycountryname sd_shiptoparty_country_name Country/Region
shiptopartytelephonenumber sd_shiptoparty_phone Phone
shiptopartyemailaddress sd_shiptoparty_email Email
shiptopartyfaxnumber sd_shiptoparty_fax Fax
aifmessageuuid sysuuid_c UUID

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 Source
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDSLS_SOR_SRC (
    MANDT,                           -- Client [mandt]
    SALESORDERREQUEST,               -- Sales Order Request [sd_sales_order_request]
    MASTERDATADETERMINATIONSTATUS,   -- MD Determination Sts [sd_mstr_data_detn_sts]
    LANGUAGEISOCODE,                 -- Language ISO Code [sd_extracted_lang_isocd]
    PURCHASEORDERBYCUSTOMER,         -- Purchase Order Number [sd_extracted_purchase_order]
    CUSTOMERPURCHASEORDERDATE,       -- Purchase Order Date [sd_extracted_pur_ord_date]
    CUSTOMERPURCHASEORDERDATETEXT,   -- sd_extracted_pur_ord_date_text
    EXTRACTEDREQUESTEDDELIVERYDATE,  -- Extracted Requested Delivery Date [sd_sor_xtd_reqd_deliv_date]
    REQUESTEDDELIVERYDATETEXT,       -- sd_xtd_reqd_deliv_date_text
    CUSTOMERPAYMENTTERMSTEXT,        -- Payment Terms [sd_extracted_paymentterms_text]
    CUSTOMERINCOTERMSTEXT,           -- Incoterms [sd_extracted_incoterms_text]
    CUSTOMERTOTALNETAMOUNT,          -- Extracted Net Value [sd_extracted_total_net_amount]
    CUSTOMERSUBTOTALAMOUNT,          -- Extracted Subtotal Value [sd_extracted_subtotal_amount]
    CURRENCYISOCODE,                 -- Document Currency [sd_extracted_crcy_isocd]
    TRANSACTIONCURRENCY,             -- Document Currency [sd_extracted_doc_crcy]
    EXTRACTEDSUPPLIER,               -- Extracted Supplier ID [sd_extracted_supplier_number]
    SOLDTOPARTYADDRESSFULLNAME,      -- Extracted Sold-to Party Address [sd_soldtoparty_full_address]
    SOLDTOPARTYNAME,                 -- Sold-to Party Name [sd_soldtoparty_name1]
    SOLDTOPARTYADDITIONALNAME,       -- Sold-to Party Name 2 [sd_soldtoparty_name2]
    SOLDTOPARTYPOSTALCODE,           -- Postal Code [sd_soldtoparty_postal_code]
    SOLDTOPARTYHOUSENUMBER,          -- House Number [sd_soldtoparty_house_no]
    SOLDTOPARTYSTREETNAME,           -- Street [sd_soldtoparty_street_name]
    SOLDTOPARTYDISTRICTNAME,         -- District [sd_soldtoparty_district_name]
    SOLDTOPARTYCITYNAME,             -- City [sd_soldtoparty_city_name]
    SOLDTOPARTYREGIONNAME,           -- Region [sd_soldtoparty_region_name]
    SOLDTOPARTYCOUNTRYNAME,          -- Country/Region [sd_soldtoparty_country_name]
    SOLDTOPARTYEMAILADDRESS,         -- Email [sd_soldtoparty_email]
    SOLDTOPARTYTAXREGISTERNUMBER,    -- Tax Registration Number [sd_soldtoparty_tax_regn_no]
    SOLDTOPARTYTAXNUMBER,            -- Additional Tax Number [sd_soldtoparty_tax_no]
    SOLDTOPARTYBANKACCOUNT,          -- Bank Account [sd_soldtoparty_bank_account]
    SOLDTOPARTYIBAN,                 -- International Bank Account Number [sd_soldtoparty_iban]
    SOLDTOPARTYTELEPHONENUMBER,      -- Phone [sd_soldtoparty_phone]
    SOLDTOPARTYFAXNUMBER,            -- Fax [sd_soldtoparty_fax]
    SOLDTOPARTYEXTREFID,             -- Extracted Sold-to Party [sd_soldtoparty_ext_ref_id]
    SHIPTOPARTYADDRESSFULLNAME,      -- Extracted Ship-to Party Address [sd_shiptoparty_full_address]
    SHIPTOPARTYNAME,                 -- Ship-to Party Name [sd_shiptoparty_name1]
    SHIPTOPARTYADDITIONALNAME,       -- Ship-to Party Name 2 [sd_shiptoparty_name2]
    SHIPTOPARTYPOSTALCODE,           -- Postal Code [sd_shiptoparty_postal_code]
    SHIPTOPARTYHOUSENUMBER,          -- House Number [sd_shiptoparty_house_no]
    SHIPTOPARTYSTREETNAME,           -- Street [sd_shiptoparty_street_name]
    SHIPTOPARTYDISTRICTNAME,         -- District [sd_shiptoparty_district_name]
    SHIPTOPARTYCITYNAME,             -- City [sd_shiptoparty_city_name]
    SHIPTOPARTYREGIONNAME,           -- Region [sd_shiptoparty_region_name]
    SHIPTOPARTYCOUNTRYNAME,          -- Country/Region [sd_shiptoparty_country_name]
    SHIPTOPARTYTELEPHONENUMBER,      -- Phone [sd_shiptoparty_phone]
    SHIPTOPARTYEMAILADDRESS,         -- Email [sd_shiptoparty_email]
    SHIPTOPARTYFAXNUMBER,            -- Fax [sd_shiptoparty_fax]
    AIFMESSAGEUUID,                  -- UUID [sysuuid_c]
    PRIMARY KEY (MANDT, SALESORDERREQUEST)
);

Learn More