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

67 columns | Print definition?ERP 6.0  | TCRTIM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAssetLiability Management
1JBRSVGAPHDRM: Header Data (Saved Gap Evaluation Results)41TCRTIMEntry Timenvarchar60
2JBRSVGAPHEADRM: Header Data (Saved Gap Evaluation Results)41TCRTIMEntry Timenvarchar60
TOPBack Office
3TRFT_CLASS_POSTreasury: TRF Class Position16TCRTIMEntry Timenvarchar60
4TRST_NOM_CORRTreasury: Nominal Adjustment17TCRTIMEntry Timenvarchar60
TOPBasic Functions
5FDT1CMF Line Items for Forex, Money Market, Derivatives6TCRTIMEntry Timenvarchar60
TOPBusiness Partner
6VTBSTA1Allocation of Payment Details as Standing Instructions12TCRTIMEntry Timenvarchar60
7VTBSTA2Standing Instructions for Correspondence10TCRTIMEntry Timenvarchar60
8VTBSTA3SI for Business Partner: Transaction Authorizations9TCRTIMEntry Timenvarchar60
9VTBSTA4SI for Business Partner: Derived Flows9TCRTIMEntry Timenvarchar60
10VTBSTC1Components of Payment Details for Standing Instruction20TCRTIMEntry Timenvarchar60
TOPDefault Risk and Limit System
11KLARPDefault Risk Line Items40TCRTIMEntry Timenvarchar60
12KLSDCPROT0Log Generation for Single Transaction Check: Meta Data6TCRTIMEntry Timenvarchar60
13KLZUEXTOBJAssignment of External Administration Key to Object Number16TCRTIMEntry Timenvarchar60
TOPLoans Management
14VDZVPayment Details for the Loan10TCRTIMEntry Timenvarchar60
TOPRisk Analysis
15JBRBDSLFNSRM-BDS: Run Number Status6TCRTIMEntry Timenvarchar60
16JBRBPGENUEGenerated Views for an RM Area9TCRTIMEntry Timenvarchar60
17JBRDBKORM: DB Table Header Information Extended Risk Object22TCRTIMEntry Timenvarchar60
18JBRHKORM: Version Table: Header Information: Extended Risk Object23TCRTIMEntry Timenvarchar60
19JBRKNZRM: External Key Figures for Financial Object16TCRTIMEntry Timenvarchar60
20JBRMZBGRM: Assignment of Transactions to Business Partners10TCRTIMEntry Timenvarchar60
21JBROBJ1RM: Definition of Fields/Characteristics Specific to RM13TCRTIMEntry Timenvarchar60
22JBROZPROTKOPFRM Gap: Log Information from OI Determination (Header)7TCRTIMEntry Timenvarchar60
23JBRPHPortfolio hierarchy12TCRTIMEntry Timenvarchar60
24JBRRMBBFAnalysis Structure21TCRTIMEntry Timenvarchar60
25JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)41TCRTIMEntry Timenvarchar60
TOPTransaction Data Pool
26JBDOBJ1Object Table for Financial Transactions, General Part31TCRTIMEntry Timenvarchar60
27JBDVTMDVariable transaction - master data15TCRTIMEntry Timenvarchar60
TOPTransaction Manager
28BCKVTBFHAPOBackup: Transaction Flows6TCRTIMEntry Timenvarchar60
29BCK_VTIFHAPOBackup for Currency Changeover of Bond Underlying5TCRTIMEntry Timenvarchar60
30OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions14TCRTIMEntry Timenvarchar60
31OTC_CONV_FHAPOBackup Table for Financial Transaction Flows6TCRTIMEntry Timenvarchar60
32OTC_CONV_FHAZUBackup Table for Financial Transaction Activities7TCRTIMEntry Timenvarchar60
33OTC_CONV_FINKOBackup Table for Financial Transaction Conditions12TCRTIMEntry Timenvarchar60
34OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions13TCRTIMEntry Timenvarchar60
35OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows5TCRTIMEntry Timenvarchar60
36OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions11TCRTIMEntry Timenvarchar60
37REFCCReferences between CO object numbers, currency differences8TCRTIMEntry Timenvarchar60
38REFHReferences between CO object numbers, header table7TCRTIMEntry Timenvarchar60
39REFONReferences between object numbers (CO object no.)8TCRTIMEntry Timenvarchar60
40TCORT_COCorrespondence Administrative Data42TCRTIMEntry Timenvarchar60
41TCORT_CONOTESTreasury correspondence object: Notes7TCRTIMEntry Timenvarchar60
42TPMTVMFLPosition management variation margin flows at sec. account6TCRTIMEntry Timenvarchar60
43VTB2TRDLink Between Financial Transaction Flow and Distributor Flow6TCRTIMEntry Timenvarchar60
44VTBAFINKOAlternative Conditions14TCRTIMEntry Timenvarchar60
45VTBFASGTAccount Assignment of a Financial Transaction Flow14TCRTIMEntry Timenvarchar60
46VTBFATHDAcct Assmt Templates for PS Mult. Acct Assmts: Header Info.7TCRTIMEntry Timenvarchar60
47VTBFHATransaction6TCRTIMEntry Timenvarchar60
48VTBFHAPOTransaction Flow6TCRTIMEntry Timenvarchar60
49VTBFHAPO_MIGRMigrated Financial Flows6TCRTIMEntry Timenvarchar60
50VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows6TCRTIMEntry Timenvarchar60
51VTBFHAZUTransaction Activity7TCRTIMEntry Timenvarchar60
52VTBFINKOTransaction Condition12TCRTIMEntry Timenvarchar60
53VTBFSECSecurities Collateral11TCRTIMEntry Timenvarchar60
54VTBPFHAPOTreasury: Flow Shells6TCRTIMEntry Timenvarchar60
55VTBRATERate for Activity8TCRTIMEntry Timenvarchar60
56VTBSIHedges25TCRTIMEntry timenvarchar60
57VTBSIANF**Caution! Do not use. Will be deleted!!5TCRTIMEntry Timenvarchar60
58VTBSIZUHedge Allocation18TCRTIMEntry timenvarchar60
59VTBTRA1Transaction Authoriz. for Traders9TCRTIMEntry Timenvarchar60
60VTBZVPayment Details for Transaction10TCRTIMEntry Timenvarchar60
61VTB_TRADER_AUTHTransparent Table for Trader Authorizations9TCRTIMEntry Timenvarchar60
62VTIAFINKOAlternative Conditions Underlying13TCRTIMEntry Timenvarchar60
63VTIFHAUnderlying transaction5TCRTIMEntry Timenvarchar60
64VTIFHAPOUnderlying transaction flows5TCRTIMEntry Timenvarchar60
65VTIFHAZUUnderlying transaction status table6TCRTIMEntry Timenvarchar60
66VTIFINKOUnderlying transaction conditions11TCRTIMEntry Timenvarchar60
TOPTreasury
67FLQITEMT1_FCLiquidity Calculation: Forecast Line Items from TR Trans.6TCRTIMEntry Timenvarchar60