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

38 columns | Print definition?ERP 6.0  | COLLNAM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DITAT_D_COLLDEFCollection definitions3COLLNAMCollection Namenvarchar320
2DITAT_D_LOHDLogical objects header data5COLLNAMCollection Namenvarchar320
3TMAS_OLA_D_AERAccumulated results of failed analyses5COLLNAMCollection Namenvarchar320
4TMAS_OLA_D_ASR7Accumulated results of successful analyses5COLLNAMCollection Namenvarchar320
5TMAS_OLA_D_ERResults of failed analyses7COLLNAMCollection Namenvarchar320
6TMAS_OLA_D_OBJAnalysis objects7COLLNAMCollection Namenvarchar320
7TMAS_OLA_D_SR7Results of successful analyses7COLLNAMCollection Namenvarchar320
8TRANSL_ASSIGNMNTAssignments3COLLNAMCollection Namenvarchar320
TOPTranslation Tools
9LXE_COLCOCollections4COLLNAMCollection Namenvarchar320
10LXE_COLLList of all Collections with their Attributes3COLLNAMCollection Namenvarchar320
11LXE_COLLSMSystem Table INDX7COLLNAMCollection Namenvarchar320
12LXE_COLLTText Table for LXE_COLL4COLLNAMCollection Namenvarchar320
13LXE_COLLTLTarget Languages for a Collection3COLLNAMCollection Namenvarchar320
14LXE_COLLXCollections3COLLNAMCollection Namenvarchar320
15LXE_COLMCCollections4COLLNAMCollection Namenvarchar320
16LXE_COLOBObject Lists7COLLNAMCollection Namenvarchar320
17LXE_COLOB_EXObject Lists5COLLNAMCollection Namenvarchar320
18LXE_CO_2Collection Groups4COLLNAMCollection Namenvarchar320
19LXE_CO_GRAssignments3COLLNAMCollection Namenvarchar320
20LXE_CO_LKLocks3COLLNAMCollection Namenvarchar320
21LXE_LANGTR1Assignment Language - Translator - Collection5COLLNAMCollection Namenvarchar320
22LXE_LANGTR2Translation exclusions4COLLNAMCollection Namenvarchar320
23LXE_PC_HDPC* Objects: Header Data6COLLNAMCollection Namenvarchar320
24LXE_PERF_LOG_AGGAggregated Performance Log Data17COLLNAMCollection Namenvarchar320
25LXE_TDEVCCollections3COLLNAMCollection Namenvarchar320
26LXE_TECHAttributes8COLLNAMCollection Namenvarchar320
27LXE_US_COAssignments5COLLNAMCollection Namenvarchar320
28LXE_US_COLAssignments (Backup)5COLLNAMCollection Namenvarchar320
29LXE_WRKOBObjects in Worklists8COLLNAMCollection Namenvarchar320
30LXE_WRKOB1Objects in Worklists8COLLNAMCollection Namenvarchar320
31LXE_WRKOBDObjects in Worklists8COLLNAMCollection Namenvarchar320
32LXE_WRKOBKObjects in Worklists8COLLNAMCollection Namenvarchar320
33LXE_WRKOBOObjects in Worklists8COLLNAMCollection Namenvarchar320
34LXE_WRKOBSObjects in Worklists8COLLNAMCollection Namenvarchar320
35LXE_WRKOBXObjects in Worklists8COLLNAMCollection Namenvarchar320
36LXE_WRKOBYObjects in Worklists8COLLNAMCollection Namenvarchar320
37LXE_WRKOBZObjects in Worklists8COLLNAMCollection Namenvarchar320
38LXE_XT_HEADERObject Headers5COLLNAMCollection Namenvarchar320