SAP Sales Tables
Are you looking for the right table related to SAP Sales Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Sales (SD-SLS) module.
Top 10 tables in Sales
| Table | Description |
|---|---|
| SDOC_CAL_RULE_T | Sales Document Calendar Rule: Text |
| SDSLS_SORDI_D | Draft table for entity R_SALESORDERREQUESTDERIVDITMTP |
| OMCHGDOC_OPTYPE | Output Management-Changed Doc: Document Type |
| SDXTST_EMPLPER | Emplstat: Validity periods (only for XPRA test) |
| LORD_SCENARIO_IT | Lean Order: Text for Scenario ID |
| LORD_GAF_EWB_OBJ | Object types for LO GAF Enhancement Workbench |
| LORD_MAPPING_RO | Mapping Table for Lean Order Interface (read-only) |
| B090 | SEPA Mandate - Payment Method |
| LORDC_MAPPING | Mapping Table for Lean Order Interface |
| OMCHGDOC_FILTER | Output Management-Changed Doc: Output Filter (Obsolete) |
List of tables in Sales
| Table | Description |
|---|---|
| SDOC_CAL_RULE_T | Sales Document Calendar Rule: Text |
| SDSLS_SORDI_D | Draft table for entity R_SALESORDERREQUESTDERIVDITMTP |
| OMCHGDOC_OPTYPE | Output Management-Changed Doc: Document Type |
| SDXTST_EMPLPER | Emplstat: Validity periods (only for XPRA test) |
| LORD_SCENARIO_IT | Lean Order: Text for Scenario ID |
| LORD_GAF_EWB_OBJ | Object types for LO GAF Enhancement Workbench |
| LORD_MAPPING_RO | Mapping Table for Lean Order Interface (read-only) |
| B090 | SEPA Mandate - Payment Method |
| LORDC_MAPPING | Mapping Table for Lean Order Interface |
| OMCHGDOC_FILTER | Output Management-Changed Doc: Output Filter (Obsolete) |
| SDXTST_LIKP | SD Document: Delivery Header Data (only for XPRA test) |
| SDSLS_CRT_IN_IDX | Standard index table |
| T661T | Difference Tolerances for External and Internal Conditions |
| SDSLS_SO_IN_IDX | Standard index table |
| SDSLS_SORI | Database table for SalesOrderRequest Item |
| VBKFZ | Cumulative Quantity Corrections |
| TD4VKDFS | Test Double for VKDFS |
| SDSLS_CR_RPL_IDX | Standard index table |
| SDXTST_EMPLLOG | Logging table for CL_SD_XPRA_VBPA_PERNR |
| TB027HR | Conversion of Marital Status: HR - SAP-BP |
| SDXTST_VBAK | Sales Document: Header Data (only for XPRA test) |
| CHK_CLASH_RFC | RFC destinations for the ATC check on clash objects |
| SLSDOCIMPRT_ITM | Sales Document Import - Item Information |
| LINKAGE | Relationships |
| LORD_OBJECT | Lean Order: Interface Objects |
| ISLSITMPLIMDRAFT | I_SALESITEMPROPOSALTP I_SALESITEMPROPOSALITEMTP |
| LORD_XSTRING | Lean Order: Temporary container for DOC/RTL content, XSTRING |
| SDSLS_BUSSYS_IDX | Standard index table |
| TVDC | Delivery Times:Categories |
| TVRMAVT | Repair Procedure: Action Texts |
| CVP_SD_SORT_CTRL | Control of EoP SoRT Definition by SD Application |
| SDXTST_KNVP | Customer Master Partner Functions (only for XPRA test) |
| SDXPRA_EMPLPER | Emplstat: Validity periods (for CL_SD_XPRA_VBPA_PERNR) |
| SLINE_DELIV_CONN | Connection between schedule line and outbound delivery |
| ERP_SLS_SA_LOCT | Portal Targets Description |
| SLS_TMPL_ITEM | Sales: Template Item |
| SDXTST_VBPA | Sales Document: Partner (only for XPRA test) |
| SLS_TMPL_KEY | Sales: Template Key |
| LORD_MAPPING | Mapping Table for Lean Order Interface |
| SALESDOC_CNT | Sales document counter |
| TVSTAT | Display/Maintain Status in Sales Overview |
| LOGIC_OBJREL | Link Table for LOGIC Objects |
| LORD_OIF_MAP_GRP | LO OIF maps Object Type/Field to FPM special groups |
| FPROP_FIELD | Field Properties |
| SDSLS_SO_RPL_IDX | Standard index table |
| SDOC_CAL_RULE | Sales Document Calendar Rule |
| SDXTST_EMPLOYEE | Employee (only for XPRA test) |
| TSD_FUNC_ACT | Activation of additional functionality in SD |
| TVBUR | Organizational Unit: Sales Offices |
| PVINX | Index of New Sales Documents for Product Proposal |
| ERP_SLS_LINK | Worklist Subset Link |
| SDXTST_EMPLPERF | Emplstat: Validity periods gaps filled (only for XPRA test) |
| LORD_OIF_MAP_OVS | LO OIF maps Object Type/Field to OVS |
| SDXPRA_EMPLWKSET | Employee working set (for CL_SD_XPRA_VBPA_PERNR) |
| LORD_GAF_EWB_TAB | Sources for cust fields of object types for LO GAF EWB |
| T176T | Sales Documents: Customer Order Types: Texts |
| SDXTST_EMPLSTAT | Emplstat (only for XPRA test) |
| SDSLS_SORI_D | Draft table for entity R_SALESORDERREQUESTITEMTP |
| SDXPRA_VBPATWIN | VBPA key and PERNR for Twins (for CL_SD_XPRA_VBPA_PERNR) |
| CVP_SD_SORT | SoRT Details of Customer/Supplier/Contact for SD Application |
| SDSSUITEPARAMS | Parameter Table for SD Scenarios in sSuite |
| TVIND_CR | Sales Documents: Update Credit Index VAKCR |
| OMCHGDOC_TDID | Output Management-Changed Doc: Document Text Types |
| TVRMAVK | Repair Procedure: Actions |
| SDDC_PRODH_ORIG | Configuration Origin of Product Hierarchy Determination |
| SLS_TMPL_HEAD | Sales: Template Head |
| SDXTST_VBRK | Billing Document: Header Data (only for XPRA test) |
| CHK_CLASH_TSTMP | Time Stamp for Refreshing CHK_CLASH_TADIR |
| SLSDOCIMPRT | Sales Document Import - Header Information |
| FPROP_FRULE | Field Properties: Assignment Field - Rule |
| ERP_SLS_SUBSET | Worklist Subset |
| TERRF | Erroneous Data for First Data Transfer |
| ERP_SD_FIELDPROP | SD Field Properties |
| FPROP_RULES | Field Properties: Rules |
| SDXTST_EMPLWKSET | Employee working set (only for XPRA test) |
| TSAD3HR | Form of Address Conversion: HR Format - SAP Business Partner |
| ERP_SLS_SNAPSHOT | SD-SLS: Snapshot |
| OMCHGDOC_TEXTS | Output Management-Changed Doc: Changed Texts |
| VBAP | Sales Document: Item Data |
| LORD_SCENARIO_ID | Lean Order: Scenario ID |
| CVP_SD_ADRNR | Address Details of Cust./One-Time Cust. for SD Application |
| TVDCT | Delivery Times: Texts |
| SDXTST_VBPATWIN | VBPA key and PERNR for Twins (only for XPRA test) |
| VBMUET | Sales Document: Characteristic Overview Description |
| VBEH | Schedule line history |
| TVVFT | Variant Determination Procedure: Texts |
| VBMUE | Sales Document: Characteristic Overview |
| LORD_GAF_EWB_MAP | Obsolete, do not use! |
| CHK_CLASH_TADIR | Temporary Mirror Image of ERP TADIR |
| LORDC_INTFOBJ | Lean Order: Interface Objects |
| ERP_SLS_WORKSET | Worklist Workset |
| TVVFS | Variant Matching Procedure: Procedures |
| ERP_SLS_SA_LOC | Portal Targets Sales Assistant |
| LORD_OIF_SETUP | Client-wide settings of Configurable Sales UI |
| VBKD | Sales Document: Business Data |
| SDXPRA_EMPLPERF | Emplstat: Val. per. gaps filled (for CL_SD_XPRA_VBPA_PERNR) |
| VAPMA | Sales Index: Order Items by Material |
| VBPK_E | Selling Recommender: Sales Document: Product Proposal Header |
| VAKPA | Sales Index: Orders by Partner Function |
| VEDA | Contract Data |
| VBSP | SD Document Item for Models of Material Structures |
| CHK_CLASH_SWCOMP | Software components to be checked against |
| VBEP | Sales Document: Schedule Line Data |
| VBREF | SD Object Link to Item References |
| OMCHGDOC_FIELD | Output Management-Changed Doc: Table Fields to Validate |
| VAPPE_ASGN | Assignment of Predefined Price Element to Sales Doc. Type |
| VBLB | Sales document: Release order data |
| ISLSITMPRSLDRAFT | I_SALESITEMPROPOSALTP I_SALESITEMPROPOSALTP |
| VBPV | Sales Document: Product Proposal |
| SDXPRA_EMPLLOG | Logging table for CL_SD_XPRA_VBPA_PERNR |
| SDDC_PH_ASSGMT | Configuration Assignment Product Hierarchy to Distr. Chain |
| VBMUEZ | Sales Document: Characteristic Overview Assignments |
| SDXPRA_EMPLOYEE | Employee (for CL_SD_XPRA_VBPA_PERNR) |
| VBPK | Sales Document: Product Proposal Header |
| TVVFZ | Variant Matching Procedure: Time Control |
| VAKGU | Sales Index: Quotation Validity |
| OMCHGDOC_LOG | Output Management-Changed Doc: Output Change Log |
| OMCHGDOC_OBJECT | Output Management-Changed Doc: Allowed Table/Text Types |
| VBAG | Sales Document: Release Data by Schedule Line in Sch.Agrmt. |
| SDXPRA_EMPLSTAT | Emplstat (for CL_SD_XPRA_VBPA_PERNR) |
| SDSLS_SORDI | Database table for SalesOrderRequest Derived Item |
| VBAK_DAAG_CUST | Data Aging: Customizing for Sales Documents |
| VBUV | Sales Document: Incompletion Log |
| SDSLS_SOR | Database table for SalesOrderRequest Root |
| SDSLS_SOR_D | Draft table for entity R_SALESORDERREQUESTTP |
| OMCHGDOC_PARTNER | Output Management-Changed Doc: Partner Fields to Validate |
| VCRSELA_RES | Cross Selling Analysis: Results |
| SDVARIANT | User-specific Selection Variants for Portal Roles |
| VBPV_E | Selling Recommender: Sales Document: Product Proposal |
| VAKCR | Sales Index: Orders in Credit Management |
| VCRSELA | Cross Selling Analysis |
| VEPVG | Delivery Due Index |
| VLPKM | Scheduling agreements by customer material |
| VKDFS | SD Index: Billing Initiator |
| VBAK | Sales Document: Header Data |
| VBSN | Change status relating to scheduling agreements |