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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

36 columns | Print definition?ERP 6.0  | LINES

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/WT_3S_LINESupplier Self Service - Line Configuration2LINESSupplier Self Service - Lines per Viewnvarchar50
2/OPT/WT_3S_LINETSupplier Self Service - Text Table for Line Configuration2LINESSupplier Self Service - Lines per Viewnvarchar50
3/PTGWFI/IEM_DCVWOptura IE monitor report completed item table6LINESNumber of Line Item Within Accounting Documentnvarchar30
4/PTGWFI/IEM_WFVWOptura IE monitor report completed item table6LINESNumber of Line Item Within Accounting Documentnvarchar30
TOPAdvertising Management
5TJJBEWRKPIS-M/AM: Work Hierarchies Administration9LINESIS-M/AM: Hierarchy Work Area. Number of Entriesnvarchar60
TOPArchiveLink
6TOADL_PARTSub-object of stored print list10LINESNatural Numberint100
TOPBW generation tool and quantity object
7ODQDATAOperational Delta Queue: Data Store for Delta6LINESNumber of Linesint100
8ODQDATA_COperational Delta Queue: Data Storage for Delta Init.6LINESNumber of Linesint100
9ODQDATA_FOperational Delta Queue: Data Storage for One-Off Extraction6LINESNumber of Linesint100
TOPContract Accounts Receivable and Payable
10DFKKOPUSTAXIN00Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
11DFKKOPUSTAXIN01Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
12DFKKOPUSTAXIN02Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
13DFKKOPUSTAXIN03Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
14DFKKOPUSTAXIN04Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
15DFKKOPUSTAXIN05Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
16DFKKOPUSTAXIN06Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
17DFKKOPUSTAXIN07Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
18DFKKOPUSTAXIN08Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
19DFKKOPUSTAXIN09Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
20DFKKOPUSTAXIN10Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
21DFKKOPUSTAXIN11Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
22DFKKOPUSTAXIN12Basic Data for Tax Calculation - Telco Tax (U.S.A.)13LINESTelecommunications Linesint100
23TFK021K_SIZESubscreen Management: Size of Subscreen4LINESABAB Dictionary: Two-Digit Numeric Fieldnvarchar20
TOPInventory Management
24MMIM_PREDOC_ORGParked Material Documents, Organizational Data8LINESNumber of lines in held documentsmallint50
TOPliveCache Applications
25/SAPAPO/OMPROSESTable for holding information about profiling sessions7LINESNatural Numberint100
26LCA_PROSESProfiling-Sessions7LINESNatural Numberint100
TOPPrint and Output Management
27TSP02LSpool: List parameters for spool and print requests3LINESSpooler: Number of lines per pageint100
TOPProduction Orders
28COCF_SR_CSTF_PDFShift Report: Customer's Own Fields (via BAdI)7LINESMax. Number of Lines per Table Cell (Not for Long Text)tinyint30
TOPRuntime WorkbenchMonitoring
29SXIPERF_INDXXI Performance: INDX Cluster2LINESNumerical Character Field of Length 6nvarchar60
TOPSAP Expert Finder
30T7XP_ELEMExpert Profile Element14LINESNumber of Lines in User-Defined Text Boxnvarchar20
TOPSAP System Log
31TSL5DSystem Log Filter Settings Used25LINESSysLog: Number of lines selectednvarchar90
TOPService Data Download
32TCUSHISTData transfer history7LINESGeneral counternvarchar60
TOPStaffing
33T77PDSAP Structural Graphics: PD Profiles5LINESLine typenvarchar20
TOPTranslation Tools
34DELDYNPSList of Table Screens13LINESNUM05 data element for SYSTnvarchar50
35TABDYNPSList of Table Screens13LINESNUM05 data element for SYSTnvarchar50
36TSKTLTranslation Environment Settings: Long Text Editor6LINESInt1tinyint30