SDSLS_SOR_SRC

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

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
extractedrequesteddeliverydate SD_SOR_XTD_REQD_DELIV_DATE Extracted Requested Delivery Date
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
detnstrategyforsoldtoparty DETNSTRGYFORSOLDTOPARTY Determination Strategy for Sold-to Party
determinedsoldtoparty DTMNDSOLDTOPARTY Determined Sold-to Party
detnstrategyforshiptoparty DETNSTRGYFORSHIPTOPARTY Determination Strategy for Ship-to Party
determinedshiptoparty DTMNDSHIPTOPARTY Determined Ship-to Party
detnstrategyforsalesarea DETNSTRGYFORSALESAREA Determination Strategy for Sales Area
determinedsalesorganization DTMNDSALESORG Determined Sales Organization
determineddistributionchannel DTMNDDISTRCHANNEL Determined Distribution Channel
determineddivision DTMNDDIVISION Determined Division
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]
    EXTRACTEDREQUESTEDDELIVERYDATE,  -- Extracted Requested Delivery Date [SD_SOR_XTD_REQD_DELIV_DATE]
    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]
    DETNSTRATEGYFORSOLDTOPARTY,      -- Determination Strategy for Sold-to Party [DETNSTRGYFORSOLDTOPARTY]
    DETERMINEDSOLDTOPARTY,           -- Determined Sold-to Party [DTMNDSOLDTOPARTY]
    DETNSTRATEGYFORSHIPTOPARTY,      -- Determination Strategy for Ship-to Party [DETNSTRGYFORSHIPTOPARTY]
    DETERMINEDSHIPTOPARTY,           -- Determined Ship-to Party [DTMNDSHIPTOPARTY]
    DETNSTRATEGYFORSALESAREA,        -- Determination Strategy for Sales Area [DETNSTRGYFORSALESAREA]
    DETERMINEDSALESORGANIZATION,     -- Determined Sales Organization [DTMNDSALESORG]
    DETERMINEDDISTRIBUTIONCHANNEL,   -- Determined Distribution Channel [DTMNDDISTRCHANNEL]
    DETERMINEDDIVISION,              -- Determined Division [DTMNDDIVISION]
    AIFMESSAGEUUID,                  -- UUID [SYSUUID_C]
    PRIMARY KEY (MANDT, SALESORDERREQUEST)
);

Learn More