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

78 columns | Print definition?ERP 6.0  | OBJTXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_T126TRestart Option Texts4OBJTXTDescriptionnvarchar2550
2/OPT/VIM_TPOLTPO Line determination logic Group Definition4OBJTXTPO Line Determination ID Descriptionnvarchar500
3/OPT/VIM_TVALTValidation determination logic Group Definition4OBJTXTValidate Determination ID Descriptionnvarchar500
4/OPT/VIM_UPG_GRTGroup Texts4OBJTXTGroup Textnvarchar800
5/OPT/VT_IMDOCT_TReporting table: Text table for IM document types5OBJTXTDocument Typenvarchar500
6/OPT/VT_PTYPEProcess Type Texts5OBJTXTProcess Typenvarchar800
7/OPT/WI_UPGDWorkflow ID Conversion status table8OBJTXTProcess Typenvarchar800
8/OPT/X019Key Determination Template Texts4OBJTXTKey Determination Template Idnvarchar700
9/OPT/X070Document Type Texts4OBJTXTDocument Typenvarchar500
10/OPT/X072Document Status Texts4OBJTXTDocument Status Textnvarchar800
11/OPT/X075Process Type Determination Table5OBJTXTProcess Type determination - Step Descriptionnvarchar500
12/OPT/X078Document Header Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
13/OPT/X080Document Item Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
14/OPT/X087Duplicate Check Group Definition4OBJTXTDuplicate Group Descriptionnvarchar500
15/OPT/X092Rescan Reason Texts4OBJTXTDescriptionnvarchar2550
16/OPT/X094Obsolete Reason Texts4OBJTXTDescriptionnvarchar2550
17/OPT/X096Document Type Determination Definition4OBJTXTDescriptionnvarchar500
18/OPT/X100Scan Location Texts4OBJTXTScan Location Textnvarchar800
19/OPT/X102Document Priority Texts4OBJTXTDocument Priority Descriptionnvarchar500
20/OPT/X106Process Type Texts4OBJTXTProcess Typenvarchar800
21/OPT/X108Process Option Texts5OBJTXTProcess Option Textnvarchar800
22/OPT/X113PO Line determination logic Group Definition4OBJTXTPO Line Determination ID Descriptionnvarchar500
23/OPT/X117Validation determination logic Group Definition4OBJTXTValidate Determination ID Descriptionnvarchar500
24/OPT/X121Group Texts4OBJTXTGroup Textnvarchar800
25/OPT/X136Process Type Texts5OBJTXTProcess Typenvarchar800
26/OPT/Y019Key Determination Template Texts4OBJTXTKey Determination Template Idnvarchar700
27/OPT/Y070Document Type Texts4OBJTXTDocument Typenvarchar500
28/OPT/Y072Document Status Texts4OBJTXTDocument Status Textnvarchar800
29/OPT/Y075Process Type Determination Table5OBJTXTProcess Type determination - Step Descriptionnvarchar500
30/OPT/Y078Document Header Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
31/OPT/Y080Document Item Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
32/OPT/Y087Duplicate Check Group Definition4OBJTXTDuplicate Group Descriptionnvarchar500
33/OPT/Y092Rescan Reason Texts4OBJTXTDescriptionnvarchar2550
34/OPT/Y094Obsolete Reason Texts4OBJTXTDescriptionnvarchar2550
35/OPT/Y096Document Type Determination Definition4OBJTXTDescriptionnvarchar500
36/OPT/Y100Scan Location Texts4OBJTXTScan Location Textnvarchar800
37/OPT/Y102Document Priority Texts4OBJTXTDocument Priority Descriptionnvarchar500
38/OPT/Y106Process Type Texts4OBJTXTProcess Typenvarchar800
39/OPT/Y108Process Option Texts5OBJTXTProcess Option Textnvarchar800
40/OPT/Y113PO Line determination logic Group Definition4OBJTXTPO Line Determination ID Descriptionnvarchar500
41/OPT/Y117Validation determination logic Group Definition4OBJTXTValidate Determination ID Descriptionnvarchar500
42/OPT/Y121Group Texts4OBJTXTGroup Textnvarchar800
43/OPT/Y136Process Type Texts5OBJTXTProcess Typenvarchar800
44/OPT/Z019Key Determination Template Texts4OBJTXTKey Determination Template Idnvarchar700
45/OPT/Z070Document Type Texts4OBJTXTDocument Typenvarchar500
46/OPT/Z072Document Status Texts4OBJTXTDocument Status Textnvarchar800
47/OPT/Z075Process Type Determination Table5OBJTXTProcess Type determination - Step Descriptionnvarchar500
48/OPT/Z078Document Header Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
49/OPT/Z080Document Item Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
50/OPT/Z087Duplicate Check Group Definition4OBJTXTDuplicate Group Descriptionnvarchar500
51/OPT/Z092Rescan Reason Texts4OBJTXTDescriptionnvarchar2550
52/OPT/Z094Obsolete Reason Texts4OBJTXTDescriptionnvarchar2550
53/OPT/Z096Document Type Determination Definition4OBJTXTDescriptionnvarchar500
54/OPT/Z100Scan Location Texts4OBJTXTScan Location Textnvarchar800
55/OPT/Z102Document Priority Texts4OBJTXTDocument Priority Descriptionnvarchar500
56/OPT/Z106Process Type Texts4OBJTXTProcess Typenvarchar800
57/OPT/Z108Process Option Texts5OBJTXTProcess Option Textnvarchar800
58/OPT/Z113PO Line determination logic Group Definition4OBJTXTPO Line Determination ID Descriptionnvarchar500
59/OPT/Z117Validation determination logic Group Definition4OBJTXTValidate Determination ID Descriptionnvarchar500
60/OPT/Z121Group Texts4OBJTXTGroup Textnvarchar800
61/OPT/Z136Process Type Texts5OBJTXTProcess Typenvarchar800
TOPBasis Application Log
62BALOBJTApplication Log: Object Texts3OBJTXTApplication log: Object textnvarchar600
TOPCross-Application Components
63/OPT/CP_T910TKey Determination Template Texts4OBJTXTKey Determination Template Idnvarchar700
TOPFinancial Accounting
64/OPT/VIM_T100TDocument Type Texts4OBJTXTDocument Typenvarchar500
65/OPT/VIM_T101TDocument Status Texts4OBJTXTDocument Status Textnvarchar800
66/OPT/VIM_T103TProcess Type Determination Table5OBJTXTProcess Type determination - Step Descriptionnvarchar500
67/OPT/VIM_T105TDocument Header Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
68/OPT/VIM_T106TDocument Item Data Fields5OBJTXTRepository Information System: Field label for data elementnvarchar550
69/OPT/VIM_T112TDuplicate Check Group Definition4OBJTXTDuplicate Group Descriptionnvarchar500
70/OPT/VIM_T116TRescan Reason Texts4OBJTXTDescriptionnvarchar2550
71/OPT/VIM_T117TObsolete Reason Texts4OBJTXTDescriptionnvarchar2550
72/OPT/VIM_T118TDocument Type Determination Definition4OBJTXTDescriptionnvarchar500
73/OPT/VIM_T121TScan Location Texts4OBJTXTScan Location Textnvarchar800
74/OPT/VIM_T122TDocument Priority Texts4OBJTXTDocument Priority Descriptionnvarchar500
75/OPT/VIM_T800TProcess Type Texts4OBJTXTProcess Typenvarchar800
76/OPT/VIM_T801TProcess Option Texts5OBJTXTProcess Option Textnvarchar800
TOPLease Accounting
77LAE_CRM_HEADERLAE: CRM Contract Header6OBJTXTDescription of Contractnvarchar500
TOPMarketing Retail Network
78OIFXOLTPermissible object links (IS-Oil MRN) - descr. texts3OBJTXTObject assignment descriptive textnvarchar200