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

82 columns | Print definition?ERP 6.0  | SICHTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAnalyzer
1AFWBM_ASSTRM: Assignment of Benchmarks to Portfolio per Variant2SICHTIDView of an Analysis Structurenvarchar30
2AFWBM_ASS_BMPHTRM: Assignment of Benchmarks to Portfolio per Variant2SICHTIDView of an Analysis Structurenvarchar30
3AFWBM_ASS_TTRM: Text Table for Assignment Variants2SICHTIDView of an Analysis Structurenvarchar30
4AFWBM_PH_EVALPTRM: Definition of Exception Handling for PH Variant2SICHTIDView of an Analysis Structurenvarchar30
5AFWCH_FLAFWCH: Filter List13SICHTIDView of an Analysis Structurenvarchar30
6AFWCH_FL_BKAFWCH: Header Data for Filter History7SICHTIDView of an Analysis Structurenvarchar30
7AFWCH_PHDEFALTAlternative Portfolio Hierarchy Definition2SICHTIDView of an Analysis Structurenvarchar30
8AFWGO_EPROCKEvaluation Procedure: Key Figure Assignment Transport Table7SICHTIDView of an Analysis Structurenvarchar30
9AFWGO_EPROCK_HEval. Proc.: Key Fig. Assignment / Attribute Table Time-Dep.7SICHTIDView of an Analysis Structurenvarchar30
10AFWGO_EVALPROC1Evaluation Procedure for Single Records: Definition3SICHTIDView of an Analysis Structurenvarchar30
11JBRHISPHBAUMSTree Structure for Deactivated Portfolio Hierarchies2SICHTIDView of an Analysis Structurenvarchar30
12JBRHISPHTEXTRM: Portfolio Texts for Deactivated Portfolio Hierachy2SICHTIDView of an Analysis Structurenvarchar30
13JBRHISPHZUORDNRM Deactivated PH: Assign Base Portfolios to End Nodes2SICHTIDView of an Analysis Structurenvarchar30
TOPAssetLiability Management
14JBAMPGPARALM Market Price Weighting: Parameters3SICHTIDView of an Analysis Structurenvarchar30
15JBAPHKMERKALM Assignment of Characteristics to PH Nodes3SICHTIDView of an Analysis Structurenvarchar30
16JBAPLANPARALM Assignment of Planning Parameters to Planning Variant3SICHTIDView of an Analysis Structurenvarchar30
17JBAPLANPARLZBALM Assignment of Planning Parameters to Planning Variant3SICHTIDView of an Analysis Structurenvarchar30
18JBAPLANVALM Planning Variant3SICHTIDView of an Analysis Structurenvarchar30
19JBAPLANVTALM Planning Variant: Text Table4SICHTIDView of an Analysis Structurenvarchar30
20JBASIMPARASAVEDBALM: Additional Information when Saving Sim. Transactions15SICHTIDView of an Analysis Structurenvarchar30
21JBRALMPARASAVEALM: Evaluation Parameters4SICHTIDView of an Analysis Structurenvarchar30
22JBRSVGAPHDRM: Header Data (Saved Gap Evaluation Results)5SICHTIDView of an Analysis Structurenvarchar30
23JBRSVGAPHEADRM: Header Data (Saved Gap Evaluation Results)5SICHTIDView of an Analysis Structurenvarchar30
24JBRSVGAPRESRM: Saved Gap Evaluation Results3SICHTIDView of an Analysis Structurenvarchar30
TOPMarket Risk Analysis
25I74TRMTreasury Standard2SICHTIDSicht einer Analysestrukturnvarchar30
TOPPortfolio Analyzer
26BMA_BMLAYEROLD CFM Benchmarking: Benchmark Layer3SICHTIDView of an Analysis Structurenvarchar30
27BMA_BMLAYERDETOLD CFM Benchmarking: Benchmark Layer3SICHTIDView of an Analysis Structurenvarchar30
28BMA_BMLAYERTOLD CFM Benchmarking: Benchmark Layer (TEXTS)2SICHTIDView of an Analysis Structurenvarchar30
TOPRisk Analysis
29I9AMBPKIS-B: RM Model/Include DBTab Base Portfolio Determination2SICHTIDView of an Analysis Structurenvarchar30
30JBRAMOUNTRM: Account Balance Summarization in Base Portfolio2SICHTIDView of an Analysis Structurenvarchar30
31JBRBPBase Portfolio Definition2SICHTIDView of an Analysis Structurenvarchar30
32JBRBPCFKNRM: Aggregated Capital Commitment Cash Flows2SICHTIDView of an Analysis Structurenvarchar30
33JBRBPCFVRM: BP Update Administration for Cash Flows2SICHTIDView of an Analysis Structurenvarchar30
34JBRBPCFVNRM: BP Update Management for Cash Flows2SICHTIDView of an Analysis Structurenvarchar30
35JBRBPCFZNRM: Aggregated Interest Commitment Cash Flows2SICHTIDView of an Analysis Structurenvarchar30
36JBRBPFARTRM: Update Type for Objects per View3SICHTIDView of an Analysis Structurenvarchar30
37JBRBPGENUEGenerated Views for an RM Area2SICHTIDView of an Analysis Structurenvarchar30
38JBRBPKSVRM BP Update Administration for Account Balances2SICHTIDView of an Analysis Structurenvarchar30
39JBRBPTBase Portfolio Definition: Text3SICHTIDView of an Analysis Structurenvarchar30
40JBRBPWPVRM: BP Update Administration for Positions/Securities2SICHTIDView of an Analysis Structurenvarchar30
41JBRBSTDRM: Base Portfolios - Single Positions (until F3.03)2SICHTIDView of an Analysis Structurenvarchar30
42JBRBSTVRM: Base Portfolio for Position Management3SICHTIDView of an Analysis Structurenvarchar30
43JBRCFKAPRM: Aggregated Capital Commitment Cash Flows per BP2SICHTIDView of an Analysis Structurenvarchar30
44JBRCFZINSRM: Aggregated Fixed-Interest Cash Flows per BP2SICHTIDView of an Analysis Structurenvarchar30
45JBREGSHRM Base Portfolio for Single Transactions2SICHTIDView of an Analysis Structurenvarchar30
46JBRKONRM: Account Balance Summarization in Base Portfolio2SICHTIDView of an Analysis Structurenvarchar30
47JBRMZBGRM: Assignment of Transactions to Business Partners2SICHTIDView of an Analysis Structurenvarchar30
48JBRNODETXTAll Information for Display of Hierarchies2SICHTIDView of an Analysis Structurenvarchar30
49JBRPHPortfolio hierarchy2SICHTIDView of an Analysis Structurenvarchar30
50JBRPHARCRM: Archiving Data for Portfolio Hierarchies2SICHTIDView of an Analysis Structurenvarchar30
51JBRPHBAUMSStorage of Portfolio Hierarchy2SICHTIDView of an Analysis Structurenvarchar30
52JBRPHDEFDefinitions Used to Derive Portfolio Hierarchy2SICHTIDView of an Analysis Structurenvarchar30
53JBRPHDEFBKRM: Backup for Table JBRPHDEF2SICHTIDView of an Analysis Structurenvarchar30
54JBRPHGERM: Portfolio Hierarchy: Generation Data2SICHTIDView of an Analysis Structurenvarchar30
55JBRPHTPortfolio hierarchy2SICHTIDView of an Analysis Structurenvarchar30
56JBRSHBAUMTree Structure of Nodes in a Portfolio Hierarchy2SICHTIDView of an Analysis Structurenvarchar30
57JBRSHKNNodes in Portfolio Hierarchy2SICHTIDView of an Analysis Structurenvarchar30
58JBRSIViews2SICHTIDView of an Analysis Structurenvarchar30
59JBRSICRITRestrictions for Subviews3SICHTIDView of an Analysis Structurenvarchar30
60JBRSIHIMHierarchy of Characteristics2SICHTIDView of an Analysis Structurenvarchar30
61JBRSIMAssign Characteristics to Views2SICHTIDView of an Analysis Structurenvarchar30
62JBRSITDims texts3SICHTIDView of an Analysis Structurenvarchar30
63JBRSPHDefinition of Portfolio Hierarchy (Check Table)2SICHTIDView of an Analysis Structurenvarchar30
64JBRSPHTDefinition of Portfolio Hierarchy (Text Table)2SICHTIDView of an Analysis Structurenvarchar30
65JBRSVABESTRM: Header Table SDTFT (Additional Info.) for Saved Datasets4SICHTIDView of an Analysis Structurenvarchar30
66JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)5SICHTIDView of an Analysis Structurenvarchar30
67JBRSVGAPRES2RM: Saved Gap Evaluation Results3SICHTIDView of an Analysis Structurenvarchar30
68JBRSVKORM: Header Table of SDTFT for Saved Datasets14SICHTIDView of an Analysis Structurenvarchar30
69JBRSVPHBAUMRM: Portfolio Hierarchy for Saved Datasets (Backtesting)3SICHTIDView of an Analysis Structurenvarchar30
70JBRSVPHZUORDNRM: Assignment of PH->BP for Saved Datasets (Backtesting)7SICHTIDView of an Analysis Structurenvarchar30
71JBRSVRBRAssignment of View and Summarization Rule to Valuation Rule2SICHTIDView of an Analysis Structurenvarchar30
72JBRSVRCFKAssignment of View and Summarization Rule to Cash Flow Ind.2SICHTIDView of an Analysis Structurenvarchar30
73JBRSVSTATERM: Administration Table for Saved Datasets (Backtesting)4SICHTIDView of an Analysis Structurenvarchar30
74JBRTKCHABKRM: Backup Table for Characteristic Hierarchies2SICHTIDView of an Analysis Structurenvarchar30
75JBRUBSTVRM: Base Portfolio - Management of Non-Int-Bearing Positions3SICHTIDView of an Analysis Structurenvarchar30
76JBRVBRDEFRM: Default Setting for Summarization (with Valuation Rule)2SICHTIDView of an Analysis Structurenvarchar30
77JBRVBRSARM: Summarization for Balances (with Valuation Rule)2SICHTIDView of an Analysis Structurenvarchar30
78JBRVBRSPEZRM: Specific Settings for Summarization(with Valuation Rule)2SICHTIDView of an Analysis Structurenvarchar30
79JBRVRCAAssignment of Flow Type to RM Cash Flow Type2SICHTIDView of an Analysis Structurenvarchar30
80JBRVRDEFSummarization Rule - Default Setting2SICHTIDView of an Analysis Structurenvarchar30
81JBRVRSAAssignment of Summarization Rule to Balance Type2SICHTIDView of an Analysis Structurenvarchar30
82JBRZUORDNTRM: Assignment of Base Portfolios to PH End Nodes2SICHTIDView of an Analysis Structurenvarchar30