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

107 columns | Print definition?ERP 6.0  | UPUSER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDBRA_NSUM_CFARRA: Final Results for Cash Flow at Risk15UPUSERLast Changed Bynvarchar120
2RDBRA_NSUM_CFPRA: Final Results Positions (Delta/Gamma) of Cashflows15UPUSERLast Changed Bynvarchar120
3RDBRA_NSUM_CFPLRA: Final Results for P&L Distributions of Cashflows25UPUSERLast Changed Bynvarchar120
4RDBRA_SUM_CFRA RDB: Final Results for Cashflows in Evaluation Currency12UPUSERLast Changed Bynvarchar120
TOPAnalyzer
5AFWBM_ASS_BMPHTRM: Assignment of Benchmarks to Portfolio per Variant10UPUSERLast Changed Bynvarchar120
6AFWBM_ATT_BMTRM: Key Table for Benchmark Master Data(General Attributes)12UPUSERLast Changed Bynvarchar120
7AFWBM_BASICTRM: Additional Attributes of a Basic Benchmark6UPUSERLast Changed Bynvarchar120
8AFWBM_CHVALTRM: Benchmark: Assignment of Characteristics and Values9UPUSERLast Changed Bynvarchar120
9AFWBM_COMPTRM: Additional Attributes of a Composite Benchmark6UPUSERLast Changed Bynvarchar120
10AFWBM_PH_EVALPTRM: Definition of Exception Handling for PH Variant7UPUSERLast Changed Bynvarchar120
11AFWCH_FLAFWCH: Filter List11UPUSERLast Changed Bynvarchar120
12AFWCH_FL_BKAFWCH: Header Data for Filter History17UPUSERLast Changed Bynvarchar120
13AFWGO_EVALPROC1Evaluation Procedure for Single Records: Definition9UPUSERLast Changed Bynvarchar120
14AFWGO_EVALPROC2Evaluation Procedure Final Results Records: Definition7UPUSERLast Changed Bynvarchar120
15AFWKF_DEFINKey Figure Definition (General Part)8UPUSERLast Changed Bynvarchar120
16RDBAA_REC_HEADERSingle Record Header for Accounting Analyzer14UPUSERLast Changed Bynvarchar120
17RDBAA_SUM_CURRFinal Results for Additive Key Figures in Currency: TRM-AA12UPUSERLast Changed Bynvarchar120
18RDBAA_SUM_GENFinal Results for Additive Generic Key Figures: TRM-AA11UPUSERLast Changed Bynvarchar120
19RDB_NSUM_CURRFinal Results for Non-Add. Key Figures in Crcy (Template)13UPUSERLast Changed Bynvarchar120
20RDB_NSUM_GENFinal Results for Non-Add. Generic Key Figures (Template)12UPUSERLast Changed Bynvarchar120
21RDB_REC_HEADERSingle Record Header (Template)14UPUSERLast Changed Bynvarchar120
22RDB_SUM_CURRFinal Results: Additive Key Figures in Currency (Template)12UPUSERLast Changed Bynvarchar120
23RDB_SUM_GENFinal Results: Additive Generic Key Figures (Template)11UPUSERLast Changed Bynvarchar120
24RDB_SUM_NSUM_TEMSpecific Final Results (Template)14UPUSERLast Changed Bynvarchar120
TOPAssetLiability Management
25JBRSVGAPHDRM: Header Data (Saved Gap Evaluation Results)42UPUSERLast Changed bynvarchar120
26JBRSVGAPHEADRM: Header Data (Saved Gap Evaluation Results)42UPUSERLast Changed bynvarchar120
TOPBack Office
27TRFT_CLASS_POSTreasury: TRF Class Position17UPUSERLast Changed bynvarchar120
28TRST_NOM_CORRTreasury: Nominal Adjustment18UPUSERLast Changed bynvarchar120
TOPBusiness Partner
29VTBSTA1Allocation of Payment Details as Standing Instructions16UPUSERLast Changed bynvarchar120
30VTBSTA2Standing Instructions for Correspondence14UPUSERLast Changed bynvarchar120
31VTBSTA3SI for Business Partner: Transaction Authorizations13UPUSERLast Changed bynvarchar120
32VTBSTA4SI for Business Partner: Derived Flows13UPUSERLast Changed bynvarchar120
33VTBSTC1Components of Payment Details for Standing Instruction24UPUSERLast Changed bynvarchar120
TOPClinical System
34N1PRERRORIS-H*MED: PATREG: Nicht verbuchbare Pat.Reg.-Datensätze17UPUSERIS-H: Degistiren sorumlunun adinvarchar120
TOPLoans Management
35VDZVPayment Details for the Loan11UPUSERLast Changed bynvarchar120
TOPMarket Risk Analyzer
36RDBRA_NSUM_CURRCFM-RA: Final Results for Non-Additive Key Figures in Crcy13UPUSERLast Changed Bynvarchar120
37RDBRA_NSUM_GENCFM-RA: Final Results for Non-Additive Generic Key Figures12UPUSERLast Changed Bynvarchar120
38RDBRA_NSUM_TBGRA: Final Results for P&L Distributions23UPUSERLast Changed Bynvarchar120
39RDBRA_NSUM_TBPRA: Final Results Positions (Delta/Gamma)14UPUSERLast Changed Bynvarchar120
40RDBRA_NSUM_TVKRA: Final Results for Value at Risk13UPUSERLast Changed Bynvarchar120
41RDBRA_REC_HEADERRA RDB: Single Record Header Table14UPUSERLast Changed Bynvarchar120
42RDBRA_SUM_CURRCFM-RA: Final Results for Additive Key Figures in Currency12UPUSERLast Changed Bynvarchar120
43RDBRA_SUM_GENCFM-RA: Final Results for Additive Generic Key Figures11UPUSERLast Changed Bynvarchar120
44RDBRA_SUM_TBERA RDB: Final Results for Key Figure Category BE13UPUSERLast Changed Bynvarchar120
TOPPortfolio Analyzer
45BMA_BMOLD CFM Benchmarking: BM Central Master Data8UPUSERLast Changed Bynvarchar120
46BMA_BMBMOLD CFM Benchmarking: Benchmark Relationships10UPUSERLast Changed Bynvarchar120
47BMA_CHOLD CFM Benchmarking: Characteristics4UPUSERLast Changed Bynvarchar120
48BMA_CHVALOLD CFM Benchmarking: Characteristic Values5UPUSERLast Changed Bynvarchar120
49RDBPA_NSUM_CURRFinal Results for Non-Additive Key Figures in Crcy: TRM-PA13UPUSERLast Changed Bynvarchar120
50RDBPA_NSUM_GENFinal Results for Non-Additive Generic Key Figures: TRM-PA12UPUSERLast Changed Bynvarchar120
51RDBPA_NSUM_GEN_RFinal Results for Ratio BM Key Figures: TRM-PA14UPUSERLast Changed Bynvarchar120
52RDBPA_REC_HEADERSingle Record Header14UPUSERLast Changed Bynvarchar120
53RDBPA_SUM_CURRFinal Results for Additive Key Figures in Currency: TRM-PA12UPUSERLast Changed Bynvarchar120
54RDBPA_SUM_FLWKey Figure Values FLW: Totals Records with Currency13UPUSERLast Changed Bynvarchar120
55RDBPA_SUM_FLWCCKey Figure Values FLW: Totals Records w/o Currency12UPUSERLast Changed Bynvarchar120
56RDBPA_SUM_GENFinal Results for Additive Generic Key Figures: TRM-PA11UPUSERLast Changed Bynvarchar120
TOPRisk Analysis
57JBRBDSLFNSRM-BDS: Run Number Status7UPUSERLast Changed bynvarchar120
58JBRDBKORM: DB Table Header Information Extended Risk Object23UPUSERLast Changed bynvarchar120
59JBRHKORM: Version Table: Header Information: Extended Risk Object24UPUSERLast Changed bynvarchar120
60JBRPHPortfolio hierarchy5UPUSERLast Changed bynvarchar120
61JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)42UPUSERLast Changed bynvarchar120
TOPTransaction Data Pool
62JBDGSCHIS-B: Transaction Master Data32UPUSERLast Changed bynvarchar120
63JBDKKOF_BACKUPBackup Table for the Conversion of JBDKKOF9UPUSERLast Changed bynvarchar120
64JBDOBJ1Object Table for Financial Transactions, General Part26UPUSERLast Changed bynvarchar120
65JBDVTMDVariable transaction - master data16UPUSERLast Changed bynvarchar120
TOPTransaction Manager
66OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions15UPUSERLast Changed bynvarchar120
67OTC_CONV_FHAPOBackup Table for Financial Transaction Flows9UPUSERLast Changed bynvarchar120
68OTC_CONV_FHAZUBackup Table for Financial Transaction Activities8UPUSERLast Changed bynvarchar120
69OTC_CONV_FINKOBackup Table for Financial Transaction Conditions13UPUSERLast Changed bynvarchar120
70OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions14UPUSERLast Changed bynvarchar120
71OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows8UPUSERLast Changed bynvarchar120
72OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions12UPUSERLast Changed bynvarchar120
73REFCCReferences between CO object numbers, currency differences9UPUSERLast Changed bynvarchar120
74REFHReferences between CO object numbers, header table8UPUSERLast Changed bynvarchar120
75REFONReferences between object numbers (CO object no.)9UPUSERLast Changed bynvarchar120
76TCORT_COCorrespondence Administrative Data43UPUSERLast Changed bynvarchar120
77THMEXT_LOGLog: External Exposure Data Applied to E-HA10UPUSERLast Changed bynvarchar120
78THMEXT_PLANNERE-HA: Hedge Plan10UPUSERLast Changed bynvarchar120
79THMHRT_HRHedge Relationship12UPUSERLast Changed bynvarchar120
80THMHRT_HR_VALValuation details for the hedging relationship13UPUSERLast Changed bynvarchar120
81THMT_HEDGE_ITEMHedged Item6UPUSERLast Changed bynvarchar120
82TPMTVMFLPosition management variation margin flows at sec. account25UPUSERLast Changed bynvarchar120
83VTBAFINKOAlternative Conditions15UPUSERLast Changed bynvarchar120
84VTBFASGTAccount Assignment of a Financial Transaction Flow15UPUSERLast Changed bynvarchar120
85VTBFATHDAcct Assmt Templates for PS Mult. Acct Assmts: Header Info.8UPUSERLast Changed bynvarchar120
86VTBFHATransaction7UPUSERLast Changed bynvarchar120
87VTBFHAPOTransaction Flow9UPUSERLast Changed bynvarchar120
88VTBFHAPO_MIGRMigrated Financial Flows9UPUSERLast Changed bynvarchar120
89VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows9UPUSERLast Changed bynvarchar120
90VTBFHAZUTransaction Activity8UPUSERLast Changed bynvarchar120
91VTBFINKOTransaction Condition13UPUSERLast Changed bynvarchar120
92VTBFSECSecurities Collateral12UPUSERLast Changed bynvarchar120
93VTBKORESCorrespondence Data37UPUSERLast Changed bynvarchar120
94VTBMAMaster Agreement6UPUSERLast Changed bynvarchar120
95VTBPFHAPOTreasury: Flow Shells9UPUSERLast Changed bynvarchar120
96VTBRATERate for Activity9UPUSERLast Changed bynvarchar120
97VTBSIHedges26UPUSERLast changed bynvarchar120
98VTBSIANF**Caution! Do not use. Will be deleted!!17UPUSERLast Changed bynvarchar120
99VTBSIZUHedge Allocation19UPUSERLast changed bynvarchar120
100VTBTRA1Transaction Authoriz. for Traders13UPUSERLast Changed bynvarchar120
101VTBZVPayment Details for Transaction11UPUSERLast Changed bynvarchar120
102VTB_TRADER_AUTHTransparent Table for Trader Authorizations13UPUSERLast Changed bynvarchar120
103VTIAFINKOAlternative Conditions Underlying14UPUSERLast Changed bynvarchar120
104VTIFHAUnderlying transaction6UPUSERLast Changed bynvarchar120
105VTIFHAPOUnderlying transaction flows8UPUSERLast Changed bynvarchar120
106VTIFHAZUUnderlying transaction status table7UPUSERLast Changed bynvarchar120
107VTIFINKOUnderlying transaction conditions12UPUSERLast Changed bynvarchar120