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

69 columns | Print definition?ERP 6.0  | BITCAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKBIXBITX_DELHHistory Table for Deletion of Excepted Items2BITCATBillable Item Classnvarchar40
2DFKKINVBILL_LOGLog of Billing Runs11BITCATBillable Item Classnvarchar40
3DFKKPARTRELRelease Order of Partner Items for Partner Settlement11BITCATBillable Item Classnvarchar40
TOPBilling in Contract Accounts Receivable and Payable
4DFKKBIXBIT4_DELHHistory Table for Deletion of Billed Items2BITCATBillable Item Classnvarchar40
5DFKKBIXBIT4_LOGLog of Data Store of Billed Items2BITCATBillable Item Classnvarchar40
6DFKKBIXBIT_CHChange Sequence of Changed Billable Items2BITCATBillable Item Classnvarchar40
7DFKKBIXBIT_GENGeneration Info for Billable Items Class1BITCATBillable Item Classnvarchar40
8DFKKBIXBIT_GENHGeneration Info for Billable Item Class (History)1BITCATBillable Item Classnvarchar40
9DFKKBIXBIT_GENOBGenerated Objects for Billable Items Class1BITCATBillable Item Classnvarchar40
10DFKKBIXBIT_HISTHistory Table for Billable Item Exceptions2BITCATBillable Item Classnvarchar40
11DFKKBIXBIT_LOGLog of Data Storage of Billable Items2BITCATBillable Item Classnvarchar40
12DFKKBIXC8101BIT Class Configuration Version (Table TFK8101)1BITCATBillable Item Classnvarchar40
13DFKKBIXC8101TBIT Class Configuration Version (Table TFK8101T)2BITCATBillable Item Classnvarchar40
14DFKKBIXC8151CBIT Class Configuration Version (Table TFK8151C)1BITCATBillable Item Classnvarchar40
15DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)1BITCATBillable Item Classnvarchar40
16DFKKBIXC8153BIT Class Configuration Version (Table TFK8153)1BITCATBillable Item Classnvarchar40
17DFKKBIXC8153SBIT Class Configuration Version (Table TFK8153S)1BITCATBillable Item Classnvarchar40
18DFKKBIXC8153STBIT Class Configuration Version (Table TFK8153ST)2BITCATBillable Item Classnvarchar40
19DFKKBIXC8153TBIT Class Configuration Version (Table TFK8153T)2BITCATBillable Item Classnvarchar40
20DFKKBIXC8154BIT Class Configuration Version (Table TFK8154)1BITCATBillable Item Classnvarchar40
21DFKKBIXC8154FBIT Class Configuration Version (Table TFK8154F)1BITCATBillable Item Classnvarchar40
22DFKKBIXC8154TBIT Class Configuration Version (Table TFK8154T)2BITCATBillable Item Classnvarchar40
23DFKKBIXE8101Working Version Configuration BIT Class (Table TFK8101)1BITCATBillable Item Classnvarchar40
24DFKKBIXE8101TWorking Version Configuration BIT Class (Table TFK8101T)2BITCATBillable Item Classnvarchar40
25DFKKBIXE8151CWorking Version Configuration BIT Class (Table TFK8151C)1BITCATBillable Item Classnvarchar40
26DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)1BITCATBillable Item Classnvarchar40
27DFKKBIXE8153Working Version Configuration BIT Class (Table TFK8153)1BITCATBillable Item Classnvarchar40
28DFKKBIXE8153SWorking Version Configuration BIT Class (Table TFK8153S)1BITCATBillable Item Classnvarchar40
29DFKKBIXE8153STWorking Version Configuration BIT Class (Table TFK8153ST)2BITCATBillable Item Classnvarchar40
30DFKKBIXE8153TWorking Version Configuration BIT Class (Table TFK8153T)2BITCATBillable Item Classnvarchar40
31DFKKBIXE8154Working Version Configuration BIT Class (Table TFK8154)1BITCATBillable Item Classnvarchar40
32DFKKBIXE8154FWorking Version Configuration BIT Class (Table TFK8154F)1BITCATBillable Item Classnvarchar40
33DFKKBIXE8154TWorking Version Configuration BIT Class (Table TFK8154T)2BITCATBillable Item Classnvarchar40
34DFKKBIXG8101BIT Class Generation Version (Table TFK8101)1BITCATBillable Item Classnvarchar40
35DFKKBIXG8101TBIT Class Generation Version (Table TFK8101T)2BITCATBillable Item Classnvarchar40
36DFKKBIXG8151CBIT Class Generation Version (Table TFK8151C)1BITCATBillable Item Classnvarchar40
37DFKKBIXG8152BIT Class Generation Version (Table TFK8152)1BITCATBillable Item Classnvarchar40
38DFKKBIXG8153BIT Class Generation Version (Table TFK8153)1BITCATBillable Item Classnvarchar40
39DFKKBIXG8153SBIT Class Generation Version (Table TFK8153S)1BITCATBillable Item Classnvarchar40
40DFKKBIXG8153STBIT Class Generation Version (Table TFK8153ST)2BITCATBillable Item Classnvarchar40
41DFKKBIXG8153TBIT Class Generation Version (Table TFK8153T)2BITCATBillable Item Classnvarchar40
42DFKKBIXG8154BIT Class Generation Version (Table TFK8154)1BITCATBillable Item Classnvarchar40
43DFKKBIXG8154FBIT Class Generation Version (Table TFK8154F)1BITCATBillable Item Classnvarchar40
44DFKKBIXG8154TBIT Class Generation Version (Table TFK8154T)2BITCATBillable Item Classnvarchar40
45FKKBIXTEST_PPCFGPrepaid Test Environment: Configure3BITCATBillable Item Classnvarchar40
46TFK8101Classes of Billable Items1BITCATBillable Item Classnvarchar40
47TFK8101ARCArchiving: Residence Times for Billable Items2BITCATBillable Item Classnvarchar40
48TFK8101CActive Classes of Client2BITCATBillable Item Classnvarchar40
49TFK8101EClasses of Billable Items (Client-Dependent)2BITCATBillable Item Classnvarchar40
50TFK8101EVBillable Item Classes: Program Enhancements2BITCATBillable Item Classnvarchar40
51TFK8101TClasses of Billable Items (Texts)2BITCATBillable Item Classnvarchar40
52TFK8102CAllowed Classes for Billable Item Types (Obsolete)3BITCATBillable Item Classnvarchar40
53TFK8104CAssign Subprocesses to Classes2BITCATBillable Item Classnvarchar40
54TFK8111CSelection Variant: Assign Billable Item Classes3BITCATBillable Item Classnvarchar40
55TFK8111CBSelection Variant: Assign Billable Item Types3BITCATBillable Item Classnvarchar40
56TFK8111CSSelection Variant: Assign Source Transaction Types3BITCATBillable Item Classnvarchar40
57TFK8151CActive Interface Components for Billable Item Class1BITCATBillable Item Classnvarchar40
58TFK8152Fields for a Class of Billable Items1BITCATBillable Item Classnvarchar40
59TFK8152EChangeable Fields of Billable Item Class2BITCATBillable Item Classnvarchar40
60TFK8153Management of BIT4 Tables1BITCATBillable Item Classnvarchar40
61TFK8153SManagement of BIT4 Tables1BITCATBillable Item Classnvarchar40
62TFK8153STManagement of BIT4 Tables (Texts)2BITCATBillable Item Classnvarchar40
63TFK8153TManagement of BIT4 Tables (Texts)2BITCATBillable Item Classnvarchar40
64TFK8154Indexes of Tables of Billable Items1BITCATBillable Item Classnvarchar40
65TFK8154FFields of Indexes of Tables of Billable Items1BITCATBillable Item Classnvarchar40
66TFK8154TIndexes of Tables of Billable Items (Texts)2BITCATBillable Item Classnvarchar40
67TFK8155DB Tables for Storage of Billed Items2BITCATBillable Item Classnvarchar40
68TFK8155SDB Tables for Storage of Simulated Billed Items2BITCATBillable Item Classnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
69DFKKINVBILL_SSource Items in Billing Document9BITCATBillable Item Classnvarchar40