SDSLS_SOR_SRC_D - Sales Order Request Header Source Draft Table

Sales Order Request Header Source Draft Table information is stored in SAP table SDSLS_SOR_SRC_D.
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_D

Field Name	Description	Is Key	Data Element	Data Type	Length
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
.INCLUDE	%ADMIN			SYCH_BDL_DRAFT_ADMIN_INC	0
DRAFTENTITYCREATIONDATETIME	Draft Created At		SYCH_BDL_DRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed At		SYCH_BDL_DRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Draft Administration UUID		SYCH_BDL_DRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SYCH_BDL_DRAFT_OPERATION_CODE	CHAR	2
HASACTIVEENTITY	Draft Flag "Has Active Instance"		SYCH_BDL_DRAFT_HASACTIVE	CHAR	2
DRAFTFIELDCHANGES	Draft Field Changes as BLOB		SYCH_BDL_DRAFT_FIELD_CHANGES	RSTR	8