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

28 columns | Print definition?ERP 6.0  | BITRECTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TFK8156FGroup Fields for Maintenance Dialogs2BITRECTYPERecord Type of Billable Itemnvarchar20
2TFK8156GField Groups for Maintenance Dialogs2BITRECTYPERecord Type of Billable Itemnvarchar20
3TFK8156GTField Groups for Maintenance Dialogs (Texts)3BITRECTYPERecord Type of Billable Itemnvarchar20
4TFK_CC_8152Assign Data Types from CC to Billable Item Fields1BITRECTYPERecord Type of Billable Itemnvarchar20
TOPBilling in Contract Accounts Receivable and Payable
5DFKKBIXBIT_CHChange Sequence of Changed Billable Items3BITRECTYPERecord Type of Billable Itemnvarchar20
6DFKKBIXBIT_GENOBGenerated Objects for Billable Items Class5BITRECTYPERecord Type of Billable Itemnvarchar20
7DFKKBIXBIT_HISTHistory Table for Billable Item Exceptions3BITRECTYPERecord Type of Billable Itemnvarchar20
8DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)3BITRECTYPERecord Type of Billable Itemnvarchar20
9DFKKBIXC8154BIT Class Configuration Version (Table TFK8154)3BITRECTYPERecord Type of Billable Itemnvarchar20
10DFKKBIXC8154FBIT Class Configuration Version (Table TFK8154F)3BITRECTYPERecord Type of Billable Itemnvarchar20
11DFKKBIXC8154TBIT Class Configuration Version (Table TFK8154T)4BITRECTYPERecord Type of Billable Itemnvarchar20
12DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)2BITRECTYPERecord Type of Billable Itemnvarchar20
13DFKKBIXE8154Working Version Configuration BIT Class (Table TFK8154)2BITRECTYPERecord Type of Billable Itemnvarchar20
14DFKKBIXE8154FWorking Version Configuration BIT Class (Table TFK8154F)2BITRECTYPERecord Type of Billable Itemnvarchar20
15DFKKBIXE8154TWorking Version Configuration BIT Class (Table TFK8154T)3BITRECTYPERecord Type of Billable Itemnvarchar20
16DFKKBIXG8152BIT Class Generation Version (Table TFK8152)3BITRECTYPERecord Type of Billable Itemnvarchar20
17DFKKBIXG8154BIT Class Generation Version (Table TFK8154)3BITRECTYPERecord Type of Billable Itemnvarchar20
18DFKKBIXG8154FBIT Class Generation Version (Table TFK8154F)3BITRECTYPERecord Type of Billable Itemnvarchar20
19DFKKBIXG8154TBIT Class Generation Version (Table TFK8154T)4BITRECTYPERecord Type of Billable Itemnvarchar20
20TFK8151AInterface Components: Structures2BITRECTYPERecord Type of Billable Itemnvarchar20
21TFK8151KBillable Items: Structures for Key Definition1BITRECTYPERecord Type of Billable Itemnvarchar20
22TFK8151RBillable Items: Interface Basic Components1BITRECTYPERecord Type of Billable Itemnvarchar20
23TFK8152Fields for a Class of Billable Items2BITRECTYPERecord Type of Billable Itemnvarchar20
24TFK8152EChangeable Fields of Billable Item Class3BITRECTYPERecord Type of Billable Itemnvarchar20
25TFK8154Indexes of Tables of Billable Items2BITRECTYPERecord Type of Billable Itemnvarchar20
26TFK8154FFields of Indexes of Tables of Billable Items2BITRECTYPERecord Type of Billable Itemnvarchar20
27TFK8154TIndexes of Tables of Billable Items (Texts)3BITRECTYPERecord Type of Billable Itemnvarchar20
TOPInvoicing in Contract Accounts Receivable and Payable
28DFKKINVBILL_SSource Items in Billing Document11BITRECTYPERecord Type of Billable Itemnvarchar20