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

56 columns | Print definition?ERP 6.0  | DUPDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAssetLiability Management
1JBRSVGAPHDRM: Header Data (Saved Gap Evaluation Results)43DUPDATChanged onnvarchar80
2JBRSVGAPHEADRM: Header Data (Saved Gap Evaluation Results)43DUPDATChanged onnvarchar80
TOPBack Office
3TRFT_CLASS_POSTreasury: TRF Class Position18DUPDATChanged onnvarchar80
4TRST_NOM_CORRTreasury: Nominal Adjustment19DUPDATChanged onnvarchar80
TOPBusiness Partner
5VTBSTA1Allocation of Payment Details as Standing Instructions14DUPDATChanged onnvarchar80
6VTBSTA2Standing Instructions for Correspondence12DUPDATChanged onnvarchar80
7VTBSTA3SI for Business Partner: Transaction Authorizations11DUPDATChanged onnvarchar80
8VTBSTA4SI for Business Partner: Derived Flows11DUPDATChanged onnvarchar80
9VTBSTC1Components of Payment Details for Standing Instruction22DUPDATChanged onnvarchar80
TOPLoans Management
10VDZVPayment Details for the Loan12DUPDATChanged onnvarchar80
TOPRisk Analysis
11JBRBDSLFNSRM-BDS: Run Number Status8DUPDATChanged onnvarchar80
12JBRDBKORM: DB Table Header Information Extended Risk Object24DUPDATChanged onnvarchar80
13JBRHKORM: Version Table: Header Information: Extended Risk Object25DUPDATChanged onnvarchar80
14JBRPHPortfolio hierarchy6DUPDATChanged onnvarchar80
15JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)43DUPDATChanged onnvarchar80
TOPTransaction Data Pool
16JBDGSCHIS-B: Transaction Master Data33DUPDATChanged onnvarchar80
17JBDKKOF_BACKUPBackup Table for the Conversion of JBDKKOF10DUPDATChanged onnvarchar80
18JBDOBJ1Object Table for Financial Transactions, General Part27DUPDATChanged onnvarchar80
19JBDVTMDVariable transaction - master data17DUPDATChanged onnvarchar80
TOPTransaction Manager
20OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions16DUPDATChanged onnvarchar80
21OTC_CONV_FHAPOBackup Table for Financial Transaction Flows10DUPDATChanged onnvarchar80
22OTC_CONV_FHAZUBackup Table for Financial Transaction Activities9DUPDATChanged onnvarchar80
23OTC_CONV_FINKOBackup Table for Financial Transaction Conditions14DUPDATChanged onnvarchar80
24OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions15DUPDATChanged onnvarchar80
25OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows9DUPDATChanged onnvarchar80
26OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions13DUPDATChanged onnvarchar80
27REFCCReferences between CO object numbers, currency differences10DUPDATChanged onnvarchar80
28REFHReferences between CO object numbers, header table9DUPDATChanged onnvarchar80
29REFONReferences between object numbers (CO object no.)10DUPDATChanged onnvarchar80
30TCORT_COCorrespondence Administrative Data44DUPDATChanged onnvarchar80
31TPMTVMFLPosition management variation margin flows at sec. account26DUPDATChanged onnvarchar80
32VTBAFINKOAlternative Conditions16DUPDATChanged onnvarchar80
33VTBFASGTAccount Assignment of a Financial Transaction Flow16DUPDATChanged onnvarchar80
34VTBFATHDAcct Assmt Templates for PS Mult. Acct Assmts: Header Info.9DUPDATChanged onnvarchar80
35VTBFHATransaction8DUPDATChanged onnvarchar80
36VTBFHAPOTransaction Flow10DUPDATChanged onnvarchar80
37VTBFHAPO_MIGRMigrated Financial Flows10DUPDATChanged onnvarchar80
38VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows10DUPDATChanged onnvarchar80
39VTBFHAZUTransaction Activity9DUPDATChanged onnvarchar80
40VTBFINKOTransaction Condition14DUPDATChanged onnvarchar80
41VTBFSECSecurities Collateral13DUPDATChanged onnvarchar80
42VTBKORESCorrespondence Data38DUPDATChanged onnvarchar80
43VTBMAMaster Agreement7DUPDATChanged onnvarchar80
44VTBPFHAPOTreasury: Flow Shells10DUPDATChanged onnvarchar80
45VTBRATERate for Activity10DUPDATChanged onnvarchar80
46VTBSIHedges27DUPDATChanged onnvarchar80
47VTBSIANF**Caution! Do not use. Will be deleted!!18DUPDATChanged onnvarchar80
48VTBSIZUHedge Allocation20DUPDATChanged onnvarchar80
49VTBTRA1Transaction Authoriz. for Traders11DUPDATChanged onnvarchar80
50VTBZVPayment Details for Transaction12DUPDATChanged onnvarchar80
51VTB_TRADER_AUTHTransparent Table for Trader Authorizations11DUPDATChanged onnvarchar80
52VTIAFINKOAlternative Conditions Underlying15DUPDATChanged onnvarchar80
53VTIFHAUnderlying transaction7DUPDATChanged onnvarchar80
54VTIFHAPOUnderlying transaction flows9DUPDATChanged onnvarchar80
55VTIFHAZUUnderlying transaction status table8DUPDATChanged onnvarchar80
56VTIFINKOUnderlying transaction conditions13DUPDATChanged onnvarchar80