SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

59 columns | Print definition?ERP 6.0  | VSNMR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_VSTDMS Header table for VSAFKO_CN table4VSNMRVSNMR for table CNVTDMS_05_VSnvarchar120
2CNVTDMS_05_VS_2TDMS Header table for VS* tables4VSNMRVSNMR for table CNVTDMS_05_VSnvarchar120
TOPCustomer Bill of Services
3BOSPS_ASSIGNMENTBOSPS: PS object links to the specified sales document6VSNMRNumber or description of a versionnvarchar120
TOPFunctional Locations
4IFLOS_VSFunctional Location Labels (Version Table)2VSNMRNumber or description of a versionnvarchar120
5IFLOTX_VSFunctional Location Data Fields: Short Texts (Version Table)2VSNMRNumber or description of a versionnvarchar120
6IFLOT_VSFunctional Location (Version Table)2VSNMRNumber or description of a versionnvarchar120
7ILOA_VSLocation & Account Assignment for PM Object (Version Table)2VSNMRNumber or description of a versionnvarchar120
TOPProduction Orders
8FUNOCMFunction marked for Order Change Management18VSNMRNumber or description of a versionnvarchar120
TOPProgress Analysis
9EVOP_VSObject parameters (Project version)2VSNMRNumber or description of a versionnvarchar120
10EVPOC_VSPercentage of completion (Project version)2VSNMRNumber or description of a versionnvarchar120
TOPRevenues and Earnings
11VPKHEADSales Pricing Header Data24VSNMRNumber or description of a versionnvarchar120
TOPSales and Distribution SD enhancements
12VSVBUK_CNSales Document: Header Status and Administrative Data2VSNMRNumber or description of a versionnvarchar120
13VSVBUP_CNSales Document: Item Status2VSNMRNumber or description of a versionnvarchar120
TOPSimulation
14PROJVS_ENQBlock key project (project versions)4VSNMRNumber or description of a versionnvarchar120
15TCN52Valid user status for version profile6VSNMRNumber or description of a versionnvarchar120
16TCN53Valid system status for version profile5VSNMRNumber or description of a versionnvarchar120
17TCNVSCCustomizing: Possible version number per version category2VSNMRInput template: Version number or descriptionnvarchar120
18TCNVSCTCustomizing: Short description of possible version numbers3VSNMRNumber or description of a versionnvarchar120
19VSAFAB_CNVersion: Network relationships2VSNMRNumber or description of a versionnvarchar120
20VSAFFH_CNVersion: PRT allocation to work order2VSNMRNumber or description of a versionnvarchar120
21VSAFFL_CNVersion: Order sequences PP orders2VSNMRNumber or description of a versionnvarchar120
22VSAFIH_CNVersion: Order header for plant maintenance2VSNMRNumber or description of a versionnvarchar120
23VSAFKO_CNVersion: Order header data for PP orders2VSNMRNumber or description of a versionnvarchar120
24VSAFPO_CNVersion: Order items in PP orders2VSNMRNumber or description of a versionnvarchar120
25VSAFVC_CNVersion: Operation in order2VSNMRNumber or description of a versionnvarchar120
26VSAFVU_CNVersion: User fields in operation in order2VSNMRNumber or description of a versionnvarchar120
27VSAFVV_CNVersion: Quantities/Dates/Values in order operation2VSNMRNumber or description of a versionnvarchar120
28VSAUFK_CNVersion: Order master data2VSNMRNumber or description of a versionnvarchar120
29VSEBAN_CNVersion: Purchase requisition2VSNMRNumber or description of a versionnvarchar120
30VSEBKN_CNVersion: Purchase requisition account assignment2VSNMRNumber or description of a versionnvarchar120
31VSEVFG_CNVersion: PS EV, percent of completion2VSNMRNumber or description of a versionnvarchar120
32VSEVOF_CNObject parameter PS earned value analysis2VSNMRNumber or description of a versionnvarchar120
33VSFPLA_CNVersion: Billing schedule2VSNMRNumber or description of a versionnvarchar120
34VSFPLT_CNVersion: Billing schedule: Dates2VSNMRNumber or description of a versionnvarchar120
35VSJEST_CNVersion: Individual status per object2VSNMRNumber or description of a versionnvarchar120
36VSJSTO_CNVersion: Information on status object2VSNMRNumber or description of a versionnvarchar120
37VSKBED_CNVersion: Capacity requirement records2VSNMRNumber or description of a versionnvarchar120
38VSKBEZ_CNVersion: Additional data for table KBED (ind. capacities)2VSNMRNumber or description of a versionnvarchar120
39VSKBKO_CNVersion: Capacity requirements header for an order2VSNMRNumber or description of a versionnvarchar120
40VSKOPFVersion: Header - general data for a version -2VSNMRNumber or description of a versionnvarchar120
41VSKPER_CNVersion: Workforce Planning2VSNMRNumber or description of a versionnvarchar120
42VSMLST_CNVersion: Milestone2VSNMRNumber or description of a versionnvarchar120
43VSNPTX_CNVersion: PS texts (network)2VSNMRNumber or description of a versionnvarchar120
44VSPLAF_CNVersion: Planned order2VSNMRNumber or description of a versionnvarchar120
45VSPRHI_CNVersion: WBS, edges (hierarchy pointer)2VSNMRNumber or description of a versionnvarchar120
46VSPROJ_CNVersion: Project definition2VSNMRNumber or description of a versionnvarchar120
47VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data2VSNMRNumber or description of a versionnvarchar120
48VSPRTE_CNVersion: Scheduling data for project item2VSNMRNumber or description of a versionnvarchar120
49VSPRTX_CNVersion: PS texts (WBS)2VSNMRNumber or description of a versionnvarchar120
50VSPSTX_CNVersion: PS texts (header)2VSNMRNumber or description of a versionnvarchar120
51VSRESB_CNVersion: Reservation/Dependent requirements2VSNMRNumber or description of a versionnvarchar120
52VSRPSCO_CNVersion: Cumulation table for project reporting2VSNMRNumber or description of a versionnvarchar120
53VSRSADD_CNVersion: Additional fields for reservation2VSNMRNumber or description of a versionnvarchar120
54VSRSDB_CNVersion: Index of RESB for direct procurement elements2VSNMRNumber or description of a versionnvarchar120
55VSSTEUVersion: Control table - one entry per version object -2VSNMRNumber or description of a versionnvarchar120
56VSVBAK_CNVersion: Sales document: Header data2VSNMRNumber or description of a versionnvarchar120
57VSVBAP_CNVersion: Sales document: Item data2VSNMRNumber or description of a versionnvarchar120
58VSVBEP_CNVersion: Sales document: Schedule line data2VSNMRNumber or description of a versionnvarchar120
59VSVBKD_CNVersion: Sales document - commercial data2VSNMRNumber or description of a versionnvarchar120