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

32 columns | Print definition?ERP 6.0  | KENNI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T731Key Figures in Info Library (Transport Table)2KENNIKey figure in the Logistics Information Library (LIL)nvarchar80
2T731TKey Figure Texts (Transport Table)3KENNIKey figure in the Logistics Information Library (LIL)nvarchar80
TOPCapacity Evaluations
3TCYFProfile detailed list: Displayed fields4KENNINumc3, internal usenvarchar30
4TCYFTTexts for displayed fields profile5KENNINumc3, internal usenvarchar30
5TCYPProfile detailed list: Criteria grouping4KENNINumc3, internal usenvarchar30
6TCYPTTexts for criteria grouping5KENNINumc3, internal usenvarchar30
7TCYSProfile detailed list: Sort criteria4KENNINumc3, internal usenvarchar30
8TCYSTTexts for sort criteria profile5KENNINumc3, internal usenvarchar30
TOPInformation System
9TCNAProject Information System: Summarization Criteria (Aggr.)4KENNINumc3, internal usenvarchar30
10TCNATTexts for project information system summarization criteria5KENNINumc3, internal usenvarchar30
11TCNEGProject Information System: Field Selecton for Graphic4KENNINumc3, internal usenvarchar30
12TCNEGTTexts for Fields Displayed in the Project Info System5KENNINumc3, internal usenvarchar30
13TCNFProject Information System: Displayed Fields4KENNINumc3, internal usenvarchar30
14TCNFTTexts for Fields Displayed in the Project Info System5KENNINumc3, internal usenvarchar30
15TCNPProject Info System: Grouping Criteria4KENNINumc3, internal usenvarchar30
16TCNPTText for Grouping Criteria in Project Info System5KENNINumc3, internal usenvarchar30
17TCNSProject Info System: Sort Criteria4KENNINumc3, internal usenvarchar30
18TCNSTTexts for Sort Criteria in Project Info System5KENNINumc3, internal usenvarchar30
19TCNVGProject Information System: Version Comparison Criteria4KENNINumc3, internal usenvarchar30
20TCNVGTTexts for Project Info System Version Comparision Criteria5KENNINumc3, internal usenvarchar30
TOPLogistics Information Library
21MCLIKey Figures in Information Library2KENNIKey figure in the Logistics Information Library (LIL)nvarchar80
22MCLITKey Figure Texts3KENNIKey figure in the Logistics Information Library (LIL)nvarchar80
TOPProduction Orders
23TCOAOBProfile order progress report: Displayed fields objects4KENNINumc3, internal usenvarchar30
24TCOAOBTProfile order progress report: Displayed fields objs (Text)5KENNINumc3, internal usenvarchar30
25TCOFFProfile for Missing Parts Info System: Displayed Fields4KENNINumc3, internal usenvarchar30
26TCOFFTTexts for Missing Parts Info System: Displayed Fields5KENNINumc3, internal usenvarchar30
27TCOFGProfile for missing parts info system: criteria for grouping4KENNINumc3, internal usenvarchar30
28TCOFGTTexts for Missing Parts Info System: Criteria for Grouping5KENNINumc3, internal usenvarchar30
29TCOFSProfile for Missing Parts Info System: Sort Criteria4KENNINumc3, internal usenvarchar30
30TCOFSTTexts for Missing Parts Info System: Sort Criteria5KENNINumc3, internal usenvarchar30
31TCOPSField selection profile5KENNINumc3, internal usenvarchar30
TOPReporting
32TMC8Predefined Key Figures per Analysis6KENNINumber of key figure/information item in LISnvarchar80