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

33 columns | Print definition?ERP 6.0  | RKONDGR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1JBRDBCOMBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction29RKONDGRDirection of Transactionnvarchar10
2JBRHCOMBEWEGhRM: Version Table BEWEG for Extended Cat. of Primary Trans.30RKONDGRDirection of Transactionnvarchar10
3JBRSVCOMBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets30RKONDGRDirection of Transactionnvarchar10
TOPRisk Analysis
4JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction6RKONDGRDirection of Transactionnvarchar10
5JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.7RKONDGRDirection of Transactionnvarchar10
6JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets7RKONDGRDirection of Transactionnvarchar10
TOPTransaction Management
7TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table6RKONDGRDirection of Transactionnvarchar10
TOPTransaction Manager
8AT11Allocation of Condition Types to Transaction Types6RKONDGRDirection of Transactionnvarchar10
9AT13Allocation of Flow Types to Transaction Types6RKONDGRDirection of Transactionnvarchar10
10OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions6RKONDGRDirection of Transactionnvarchar10
11OTC_CONV_FHAPOBackup Table for Financial Transaction Flows20RKONDGRDirection of Transactionnvarchar10
12OTC_CONV_FHAZUBackup Table for Financial Transaction Activities40RKONDGRDirection of Transactionnvarchar10
13OTC_CONV_FINKOBackup Table for Financial Transaction Conditions6RKONDGRDirection of Transactionnvarchar10
14OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions5RKONDGRDirection of Transactionnvarchar10
15OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows18RKONDGRDirection of Transactionnvarchar10
16OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions5RKONDGRDirection of Transactionnvarchar10
17TRDT_FLOWPersistent distributor flows82RKONDGRDirection of Transactionnvarchar10
18TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)40RKONDGRDirection of Transactionnvarchar10
19TRQT_FLOWTreasury: Flow Data Quantity Ledger28RKONDGRDirection of Transactionnvarchar10
20VTBAFINKOAlternative Conditions6RKONDGRDirection of Transactionnvarchar10
21VTBFHAPOTransaction Flow20RKONDGRDirection of Transactionnvarchar10
22VTBFHAPO_MIGRMigrated Financial Flows20RKONDGRDirection of Transactionnvarchar10
23VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows20RKONDGRDirection of Transactionnvarchar10
24VTBFHAZUTransaction Activity40RKONDGRDirection of Transactionnvarchar10
25VTBFINKOTransaction Condition6RKONDGRDirection of Transactionnvarchar10
26VTBPFHAPOTreasury: Flow Shells19RKONDGRDirection of Transactionnvarchar10
27VTBRATERate for Activity19RKONDGRDirection of Transactionnvarchar10
28VTBTEKALTreasury: Due Date Management7RKONDGRDirection of Transactionnvarchar10
29VTIAFINKOAlternative Conditions Underlying5RKONDGRDirection of Transactionnvarchar10
30VTIFHAPOUnderlying transaction flows18RKONDGRDirection of Transactionnvarchar10
31VTIFHAZUUnderlying transaction status table39RKONDGRDirection of Transactionnvarchar10
32VTIFINKOUnderlying transaction conditions5RKONDGRDirection of Transactionnvarchar10
TOPTreasury and Risk Management
33TREAT_FLOWTreasury: TREA Flows34RKONDGRDirection of Transactionnvarchar10