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

29 columns | Print definition?ERP 6.0  | ABGSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T350WMaintenance control parameters: Order type plant10ABGSLResults Analysis Keynvarchar60
2TKKAS_CONVCopy of TKKAS4ABGSLResults Analysis Keynvarchar60
TOPActual Revenues and Forecast
3TORB1Incoming Orders: Cost Element Assignment2ABGSLResults Analysis Keynvarchar60
4TORB2Incoming Orders: Settings for Key2ABGSLResults Analysis Keynvarchar60
TOPBasic Functions
5ANKAAsset classes: general data58ABGSLCapitalization Key for Investment Measurenvarchar60
TOPConstruction Progress Report
6/SAPPCE/TPNV08Construction Site Valuation4ABGSLResults Analysis Keynvarchar60
TOPControlling
7IAOM_CSCENARIOControlling Scenario7ABGSLResults Analysis Keynvarchar60
TOPCost Object
8COKAACO Object: Control Data for Variances and Results Analysis5ABGSLResults Analysis Keynvarchar60
9TKKAACheck Table for Results Analysis Key of RA for Orders2ABGSLResults Analysis Keynvarchar60
10TKKABPosting Rules for Results Analysis Data6ABGSLResults Analysis Keynvarchar60
11TKKADText Table for Results Analysis Keys of Order Results Analys3ABGSLResults Analysis Keynvarchar60
12TKKAKCalculate Capitalization Value of Capital Investment Measure4ABGSLResults Analysis Keynvarchar60
13TKKARRule Table for Results Analysis Update4ABGSLResults Analysis Keynvarchar60
14TKKASControl Table for Results Analysis4ABGSLResults Analysis Keynvarchar60
15TKKAS_LControl Table for Results Analysis4ABGSLResults Analysis Keynvarchar60
16TKKAZAssignment Table for Results Analysis4ABGSLResults Analysis Keynvarchar60
TOPCross-Application Components
17AAUUFKOrder master data65ABGSLResults Analysis Keynvarchar60
TOPOperative Structures
18PROJProject definition55ABGSLResults Analysis Keynvarchar60
19PRPSWBS (Work Breakdown Structure) Element Master Data32ABGSLResults Analysis Keynvarchar60
20TCJ41Default Values for Work Breakdown Structure11ABGSLResults Analysis Keynvarchar60
TOPOverhead Cost Orders
21AUFKOrder master data65ABGSLResults Analysis Keynvarchar60
TOPProduction Orders
22T399XParameters dependent on order type20ABGSLResults Analysis Keynvarchar60
TOPSettlement
23TSR01Automatic Generation of Settlement Rules9ABGSLResults Analysis Keynvarchar60
TOPSimulation
24VSAUFK_CNVersion: Order master data66ABGSLResults Analysis Keynvarchar60
25VSPROJ_CNVersion: Project definition56ABGSLResults Analysis Keynvarchar60
26VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data33ABGSLResults Analysis Keynvarchar60
TOPStatistical Key Figures
27ANLILink table for investment measure -> AuC10ABGSLCapitalization keynvarchar60
TOPTemplates
28PROJSStandard project definition55ABGSLResults Analysis Keynvarchar60
29PRPSSStandard WBS Element (WBS element) - Master Data32ABGSLResults Analysis Keynvarchar60