SDSLS_SOR - Database table for SalesOrderRequest Root
Database table for SalesOrderRequest Root information is stored in SAP table SDSLS_SOR.
It is part of development package VDM_SD_SLS_SOR in software component SD-SLS-API. This development package consists of objects that can be grouped under "VDM SD Sales Order Request".
It is part of development package VDM_SD_SLS_SOR in software component SD-SLS-API. This development package consists of objects that can be grouped under "VDM SD Sales Order Request".
Fields for table SDSLS_SOR
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 | |
| SALESORDERREQUESTCATEGORY | Sales Order Request Category | SLS_ORD_REQ_CATEGORY | CHAR | 2 | ||
| COMPANYCODE | Company Code | FIS_BUKRS | CHAR | 8 | ||
| UPLOADFILECONTENTBINARY | Source File of Sales Order Request | SALESORDERREQUESTPDFCONTENT | RSTR | 8 | ||
| SALESORDERREQUESTFILEMIMETYPE | DD: Mime Type for Full-Text Index | DD_FTI_MIME_TYPE | CHAR | 254 | ||
| SALESORDERREQUESTFILENAME | Name of Uploaded File in Sales Order Request | SLS_ORD_REQ_FILE_NAME | CHAR | 200 | ||
| SALESORDERTYPE | Sales Order Type | SALES_ORDER_TYPE | CHAR | 8 | ||
| SOLDTOPARTY | Sold-to Party | KUNAG | CHAR | 20 | ||
| SHIPTOPARTY | Ship-to Party | SHIP_TO_PARTY_SOR | CHAR | 20 | ||
| TRANSACTIONCURRENCY | SD Document Currency | WAERK | CUKY | 10 | ||
| SALESORDER | Sales Order | VDM_SALES_ORDER | CHAR | 20 | ||
| TOTALNETAMOUNT | Net Value in Document Currency | NETWR | CURR | 8 | ||
| SALESORGANIZATION | Sales Organization | VKORG | CHAR | 8 | ||
| DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | CHAR | 4 | ||
| ORGANIZATIONDIVISION | Division | SPART | CHAR | 4 | ||
| PURCHASEORDERBYCUSTOMER | Customer Reference | BSTKD | CHAR | 70 | ||
| SALESORDERREQUESTEXTRACTORUUID | File ID Returned by "Document Information Extraction" API | SLS_ORD_REQ_EXTRACTOR_UUID | RAW | 16 | ||
| SALESORDERREQEXTRACTIONSTATUS | File Information Extraction Status | SLS_ORD_REQ_EXTRACTION_STATUS | CHAR | 2 | ||
| CREATEDBYUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| CREATIONDATETIME | Creation Date Time | CREATION_DATE_TIME | DEC | 11 | ||
| LASTCHANGEDBYUSER | User Who Last Changed the Business Document | LAST_CHANGED_BY_USER | CHAR | 24 | ||
| LASTCHANGEDATETIME | Last Changed Date Time | LAST_CHANGED_DATE_TIME | DEC | 11 | ||
| SALESORDERREQPROCESSINGSTATUS | Sales Order Request Processing Status | SD_SOR_PROCG_STS | CHAR | 2 | ||
| REQUESTEDDELIVERYDATE | Requested Delivery Date | REQD_DELIVERY_DATE | DATS | 16 | ||
| SALESORDERREQSIMULATIONSTATUS | Simulation Status for Sales Order Request | SLS_ORD_REQ_SIMULATION_STS | CHAR | 2 | ||
| LASTSIMULATEDDATETIME | Time Stamp of Last Simulation | SLS_ORD_REQ_SIMULATED_DATETIME | DEC | 11 | ||
| SALESORDERREQUESTLOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 44 |