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

49 columns | Print definition?ERP 6.0  | ABR_NR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPRemaining Beverage - Obsolete Objects
1/BEV3/CHABRSTK_SCH Settlement Statistics2ABR_NRSettlement Numbernvarchar100
2/BEV3/CHABRSTZ_KSettlement Record - Header4ABR_NRSettlement Numbernvarchar100
3/BEV3/CHABRSTZ_PCH Settlement Items - With Translations5ABR_NRSettlement Numbernvarchar100
4/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items4ABR_NRSettlement Numbernvarchar100
5/BEV3/CHBKABRNRCH Purchase Control / Settlements6ABR_NRSettlement Numbernvarchar100
6/BEV3/CHBKERGRSLPurchase control results9ABR_NRSettlement Numbernvarchar100
7/BEV3/CHBKHISTORCH Settlement Stats Header Data - Purchase Control History13ABR_NRSettlement Numbernvarchar100
8/BEV3/CHBKRESHISPurchase Control Results - History9ABR_NRSettlement Numbernvarchar100
9/BEV3/CHBKRESULTPurchase control results9ABR_NRSettlement Numbernvarchar100
10/BEV3/CHBKSTK_CCH Settlement Stats for Exception Trigger in Purchase Ctrl6ABR_NRSettlement Numbernvarchar100
11/BEV3/CHBKSTK_TCH Settlement Statistics Final Settlement Information10ABR_NRSettlement Numbernvarchar100
12/BEV3/CHBKTMPTemp. Purchase Control Results9ABR_NRSettlement Numbernvarchar100
13/BEV3/CHBKTMP_CTemp.CH Settlement Stats for Except.Trigger in Purchase Ctrl6ABR_NRSettlement Numbernvarchar100
14/BEV3/CHBKTMP_TTemp. CH Settlement Stats Final Settlement Information10ABR_NRSettlement Numbernvarchar100
15/BEV3/CHCA_PROException Handling: log5ABR_NRSettlement Numbernvarchar100
16/BEV3/CHCIVBFSError Log Collective Run CH Docs. Using Create Invoice3ABR_NRSettlement Numbernvarchar100
17/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents25ABR_NRSettlement Numbernvarchar100
18/BEV3/CHCIVBSSSales Documents of Collective Run for CH Billing Documents3ABR_NRSettlement Numbernvarchar100
19/BEV3/CHERGSTZ_KSettlement Record - Header4ABR_NRSettlement Numbernvarchar100
20/BEV3/CHERGSTZ_PCH Settlement Items - With Translations5ABR_NRSettlement Numbernvarchar100
21/BEV3/CHERGSTZ_SCH Settlement Statistics6ABR_NRSettlement Numbernvarchar100
22/BEV3/CHEVLIACFLCH BTE Event Listener ACCOUNT Fault4ABR_NRSettlement Numbernvarchar100
23/BEV3/CHEXCSTZ_KCH Settlement Header/Non-Posted Docs w/o Date Statistics4ABR_NRSettlement Numbernvarchar100
24/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics5ABR_NRSettlement Numbernvarchar100
25/BEV3/CHPIABRECHPrint Settlements3ABR_NRSettlement Numbernvarchar100
26/BEV3/CHRESSTZ_KSettlement Record - Header - Reset Documents (2/Transaction)4ABR_NRSettlement Numbernvarchar100
27/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)5ABR_NRSettlement Numbernvarchar100
28/BEV3/CHSHTSTZSDSpecial Interface Data for SD - Not CH-Relevant5ABR_NRSettlement Numbernvarchar100
29/BEV3/CHSHTSTZ_KInterface Record - Header (SD)4ABR_NRSettlement Numbernvarchar100
30/BEV3/CHSHTSTZ_PCH Settlement Item5ABR_NRSettlement Numbernvarchar100
31/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions4ABR_NRSettlement Numbernvarchar100
32/BEV3/CHSIMSTK_CCH - Simulation Statistics of Exception Trigger6ABR_NRSettlement Numbernvarchar100
33/BEV3/CHSIMSTK_TCH Simulation Statistics Final Settlement Information10ABR_NRSettlement Numbernvarchar100
34/BEV3/CHSIMSTZ_KSimulation Record - Header4ABR_NRSettlement Numbernvarchar100
35/BEV3/CHSIMSTZ_PCH Simulation Items5ABR_NRSettlement Numbernvarchar100
36/BEV3/CHSIMSTZ_SCH Simulation Statistics6ABR_NRSettlement Numbernvarchar100
37/BEV3/CHSTADMINCancel: Info copied to settlement execution in admin.process7ABR_NRSettlement Numbernvarchar100
38/BEV3/CHTMABRNRCH Dates / Settlements6ABR_NRSettlement Numbernvarchar100
39/BEV3/CHTMHISTORCH Settlement Statistics Header Data - History13ABR_NRSettlement Numbernvarchar100
40/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item4ABR_NRSettlement Numbernvarchar100
41/BEV3/CHTMPSTK_CCH - Temporary Statistics of Exception Trigger6ABR_NRSettlement Numbernvarchar100
42/BEV3/CHTMPSTK_TCH - Temporary Statistics Final Settlement Information10ABR_NRSettlement Numbernvarchar100
43/BEV3/CHTRMSTK_CCH Settlement Statistics of Exception Trigger6ABR_NRSettlement Numbernvarchar100
44/BEV3/CHTRMSTK_TCH Settlement Statistics Final Settlement Information10ABR_NRSettlement Numbernvarchar100
45/BEV3/CHTRMSTZ_KDate Record - Header4ABR_NRSettlement Numbernvarchar100
46/BEV3/CHTRMSTZ_PCH Date Item5ABR_NRSettlement Numbernvarchar100
47/BEV3/CHTRMSTZ_SCH Date Statistics6ABR_NRSettlement Numbernvarchar100
48/BEV3/CHVABRSTZSCH Settlement Statistics6ABR_NRSettlement Numbernvarchar100
49/BEV3/CH_ABRFKTBilling Documents per Settlement3ABR_NRSettlement Numbernvarchar100