SDSLS_SOR_SRC - Sales Order Request Header Source
Sales Order Request Header Source information is stored in SAP table SDSLS_SOR_SRC.
It is part of development package VDM_SD_SLS_AUTOEXTRN in software component SD-SLS-IMP-DOX. This development package consists of objects that can be grouped under "VDM SD Create Sales Order Automatic Extraction".
It is part of development package VDM_SD_SLS_AUTOEXTRN in software component SD-SLS-IMP-DOX. This development package consists of objects that can be grouped under "VDM SD Create Sales Order Automatic Extraction".
Fields for table SDSLS_SOR_SRC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| SALESORDERREQUEST | Sales Order Request | X | SD_SALES_ORDER_REQUEST | CHAR | 30 | |
| MASTERDATADETERMINATIONSTATUS | Master Data Determination Status | SD_MSTR_DATA_DETN_STS | CHAR | 2 | ||
| LANGUAGEISOCODE | 2-Character SAP Language Code | SD_EXTRACTED_LANG_ISOCD | CHAR | 4 | ||
| PURCHASEORDERBYCUSTOMER | Extracted Purchase Order Number | SD_EXTRACTED_PURCHASE_ORDER | CHAR | 70 | ||
| CUSTOMERPURCHASEORDERDATE | Extracted Purchase Order Date | SD_EXTRACTED_PUR_ORD_DATE | DATS | 16 | ||
| EXTRACTEDREQUESTEDDELIVERYDATE | Requested Delivery Date | SD_SOR_XTD_REQD_DELIV_DATE | DATS | 16 | ||
| CUSTOMERPAYMENTTERMSTEXT | Payment Terms Extracted from Purchase Order | SD_EXTRACTED_PAYMENTTERMS_TEXT | CHAR | 60 | ||
| CUSTOMERINCOTERMSTEXT | Incoterms Extracted from Purchase Order | SD_EXTRACTED_INCOTERMS_TEXT | CHAR | 60 | ||
| CUSTOMERTOTALNETAMOUNT | Header Net Value Extracted from Purchase Order | SD_EXTRACTED_TOTAL_NET_AMOUNT | CURR | 8 | ||
| CUSTOMERSUBTOTALAMOUNT | Net Value of All Items Extracted from Purchase Order | SD_EXTRACTED_SUBTOTAL_AMOUNT | CURR | 8 | ||
| CURRENCYISOCODE | ISO Code of Document Currency Extracted from Purchase Order | SD_EXTRACTED_CRCY_ISOCD | CHAR | 6 | ||
| TRANSACTIONCURRENCY | Document Currency Extracted from Purchase Order | SD_EXTRACTED_DOC_CRCY | CUKY | 10 | ||
| EXTRACTEDSUPPLIER | Supplier ID Extracted from Purchase Order | SD_EXTRACTED_SUPPLIER_NUMBER | CHAR | 20 | ||
| SOLDTOPARTYADDRESSFULLNAME | Sold-to Party Address Extracted from Purchase Order | SD_SOLDTOPARTY_FULL_ADDRESS | CHAR | 510 | ||
| SOLDTOPARTYNAME | Sold-to Party Name 1 Extracted from Purchase Order | SD_SOLDTOPARTY_NAME1 | CHAR | 160 | ||
| SOLDTOPARTYADDITIONALNAME | Additional Sold-to Party Name Info Extracted from PurOrd | SD_SOLDTOPARTY_NAME2 | CHAR | 160 | ||
| SOLDTOPARTYPOSTALCODE | Postal Code Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_POSTAL_CODE | CHAR | 20 | ||
| SOLDTOPARTYHOUSENUMBER | House Number Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_HOUSE_NO | CHAR | 20 | ||
| SOLDTOPARTYSTREETNAME | Street Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_STREET_NAME | CHAR | 120 | ||
| SOLDTOPARTYDISTRICTNAME | District Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_DISTRICT_NAME | CHAR | 80 | ||
| SOLDTOPARTYCITYNAME | City Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_CITY_NAME | CHAR | 80 | ||
| SOLDTOPARTYREGIONNAME | Region Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_REGION_NAME | CHAR | 40 | ||
| SOLDTOPARTYCOUNTRYNAME | Country/Region Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_COUNTRY_NAME | CHAR | 100 | ||
| SOLDTOPARTYEMAILADDRESS | Email Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_EMAIL | CHAR | 482 | ||
| SOLDTOPARTYTAXREGISTERNUMBER | Tax Registration Number Extracted from PurOrd(Sold-to-party) | SD_SOLDTOPARTY_TAX_REGN_NO | CHAR | 40 | ||
| SOLDTOPARTYTAXNUMBER | Additional Tax Number Extracted from Pur Ord (Sold-to-party) | SD_SOLDTOPARTY_TAX_NO | CHAR | 160 | ||
| SOLDTOPARTYBANKACCOUNT | Bank Account Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_BANK_ACCOUNT | CHAR | 36 | ||
| SOLDTOPARTYIBAN | IBAN Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_IBAN | CHAR | 68 | ||
| SOLDTOPARTYTELEPHONENUMBER | Phone Number Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_PHONE | CHAR | 60 | ||
| SOLDTOPARTYFAXNUMBER | Fax Number Extracted from Purchase Order (Sold-to Party) | SD_SOLDTOPARTY_FAX | CHAR | 60 | ||
| SOLDTOPARTYEXTREFID | Sold-to Party ID Extracted from Purchase Order | SD_SOLDTOPARTY_EXT_REF_ID | CHAR | 70 | ||
| SHIPTOPARTYADDRESSFULLNAME | Ship-to Party Address Extracted from Purchase Order | SD_SHIPTOPARTY_FULL_ADDRESS | CHAR | 510 | ||
| SHIPTOPARTYNAME | Ship-to Party Name 1 Extracted from Purchase Order | SD_SHIPTOPARTY_NAME1 | CHAR | 160 | ||
| SHIPTOPARTYADDITIONALNAME | Additional Ship-to Party Name Info Extracted from Pur Ord | SD_SHIPTOPARTY_NAME2 | CHAR | 160 | ||
| SHIPTOPARTYPOSTALCODE | Postal Code Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_POSTAL_CODE | CHAR | 20 | ||
| SHIPTOPARTYHOUSENUMBER | House Number Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_HOUSE_NO | CHAR | 20 | ||
| SHIPTOPARTYSTREETNAME | Street Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_STREET_NAME | CHAR | 120 | ||
| SHIPTOPARTYDISTRICTNAME | District Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_DISTRICT_NAME | CHAR | 80 | ||
| SHIPTOPARTYCITYNAME | City Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_CITY_NAME | CHAR | 80 | ||
| SHIPTOPARTYREGIONNAME | Region Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_REGION_NAME | CHAR | 40 | ||
| SHIPTOPARTYCOUNTRYNAME | Country/Region Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_COUNTRY_NAME | CHAR | 100 | ||
| SHIPTOPARTYTELEPHONENUMBER | Phone Number Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_PHONE | CHAR | 32 | ||
| SHIPTOPARTYEMAILADDRESS | Email Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_EMAIL | CHAR | 482 | ||
| SHIPTOPARTYFAXNUMBER | Fax Number Extracted from Purchase Order (Ship-to Party) | SD_SHIPTOPARTY_FAX | CHAR | 60 |