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

65 columns | Print definition?ERP 6.0  | VALDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AFWKFRA_KB4_HKey Figures: MtM with Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
2AFWKFRA_KB5_HKey Figures: Cashflow (based on Spot Prices)3VALDATEDate: Valid From (Inclusive)nvarchar80
3AFWKFRA_KB6_HKey Figures: Cashflow for Cashflow-at-Risk3VALDATEDate: Valid From (Inclusive)nvarchar80
4AFWKFRA_KBMX_HKey Figures: MtM with Market Data Shift3VALDATEDate: Valid From (Inclusive)nvarchar80
5AFWKFRA_KCFARC_HKey Figures: CfaR by variance/covariance3VALDATEDate: Valid From (Inclusive)nvarchar80
6AFWKFRA_KCFARS_HKey Figures: CfaR from simulation method3VALDATEDate: Valid From (Inclusive)nvarchar80
7AFWKFRA_KCFO_HKey Figures: Cashflow (in original currency)3VALDATEDate: Valid From (Inclusive)nvarchar80
8AFWKFRA_KCFPL_HKey Figures: CfaR - Profit/Loss Distribution3VALDATEDate: Valid From (Inclusive)nvarchar80
9AFWKFRA_KCFP_HKey Figures: CfaR - Risk Factor Positions3VALDATEDate: Valid From (Inclusive)nvarchar80
10AFWKFRA_KGD_HKey Figures: Greeks - Delta3VALDATEDate: Valid From (Inclusive)nvarchar80
11AFWKFRA_KMGD_HKey Figures: MtM, Greeks - Delta3VALDATEDate: Valid From (Inclusive)nvarchar80
TOPAnalyzer
12AFWBM_ASS_BMPHTRM: Assignment of Benchmarks to Portfolio per Variant5VALDATEDate: Valid From (Inclusive)nvarchar80
13AFWBM_BASICTRM: Additional Attributes of a Basic Benchmark3VALDATEDate: Valid From (Inclusive)nvarchar80
14AFWBM_COMPTRM: Additional Attributes of a Composite Benchmark3VALDATEDate: Valid From (Inclusive)nvarchar80
15AFWGO_EPROCKEvaluation Procedure: Key Figure Assignment Transport Table5VALDATEDate: Valid From (Inclusive)nvarchar80
16AFWGO_EPROCK_HEval. Proc.: Key Fig. Assignment / Attribute Table Time-Dep.3VALDATEDate: Valid From (Inclusive)nvarchar80
17AFWGO_EVALPROC1Evaluation Procedure for Single Records: Definition5VALDATEDate: Valid From (Inclusive)nvarchar80
18AFWGO_EVALPROC1HEvaluation Procedure for Single Records: Definition3VALDATEDate: Valid From (Inclusive)nvarchar80
19AFWGO_EVALPROC2Evaluation Procedure Final Results Records: Definition4VALDATEDate: Valid From (Inclusive)nvarchar80
20AFWGO_EVALPROC2HEvaluation Procedure Final Results Records: Definition3VALDATEDate: Valid From (Inclusive)nvarchar80
21AFWGO_EVALPROC2QEvaluation Procedure Fin. Results Records: PH Assignment3VALDATEDate: Valid From (Inclusive)nvarchar80
22AFWKF_AAPOSCC_HKey Figures: Position in Evaluation Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
23AFWKF_AAPOS_HKey Figures: Position in Position Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
24AFWKF_GENPOSCC_HKey Figure: Generic Position Key Figure History3VALDATEDate: Valid From (Inclusive)nvarchar80
25AFWKF_GENPOS_HKey Figure: Generic Position Key Figure History3VALDATEDate: Valid From (Inclusive)nvarchar80
26AFWKF_KB0_HKey Fig. Definition: Attributes for NPV Basis (Attrib.Table)3VALDATEDate: Valid From (Inclusive)nvarchar80
27AFWKF_POSCOMP_HKey Figure: Position Component History4VALDATEDate: Valid From (Inclusive)nvarchar80
TOPCollectionsDisbursements
28IBROSTMHISCD: Broker Report - Header Data28VALDATEValue datenvarchar80
29IBROSTMPISCD: Broker Report - Item Data37VALDATEValue datenvarchar80
TOPDefault Risk and Limit System
30KLREL_LIMIT_ASSAssignment of Relative Limits to Portfolio Hierarchy Nodes3VALDATEValidity Datenvarchar80
TOPInformation System
31GRIXReport Writer: Directory of Stored Data15VALDATEExpiration Datenvarchar80
TOPMarket Risk Analyzer
32AFWKFRA_BCK0_HKey Figures: Backtesting for Profit and Loss - History3VALDATEDate: Valid From (Inclusive)nvarchar80
33AFWKFRA_K00_HKey Figures: Direct Redefinition of Dual Interest Rate Shift3VALDATEDate: Valid From (Inclusive)nvarchar80
34AFWKFRA_K01_HKey Figures: Direct Redefinition of Int. Rate Sensitivities3VALDATEDate: Valid From (Inclusive)nvarchar80
35AFWKFRA_KB00_HKey Figures: NPV in transaction currency3VALDATEDate: Valid From (Inclusive)nvarchar80
36AFWKFRA_KB0_HKey Figures: NPV with Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
37AFWKFRA_KB2_HKey Figures: NPV with Currency - VaR Basis3VALDATEDate: Valid From (Inclusive)nvarchar80
38AFWKFRA_KBE_HKey Figures: Exposure3VALDATEDate: Valid From (Inclusive)nvarchar80
39AFWKFRA_KBX_HKey Figures: NPV with Market Data Shift3VALDATEDate: Valid From (Inclusive)nvarchar80
40AFWKFRA_KD0_HKey Figures: Items in the Risk Hierarchy3VALDATEDate: Valid From (Inclusive)nvarchar80
41AFWKFRA_KG1_HKey Figures: P+L Delta/Gamma3VALDATEDate: Valid From (Inclusive)nvarchar80
42AFWKFRA_KS0_HKey Figures: Direct Redifinition3VALDATEDate: Valid From (Inclusive)nvarchar80
43AFWKFRA_KS1_HKey Figures: Direct Redefinition / AT (for YTM)3VALDATEDate: Valid From (Inclusive)nvarchar80
44AFWKFRA_KS2_HKey Figure: Direct Redefinition / AT3VALDATEDate: Valid From (Inclusive)nvarchar80
45AFWKFRA_KVK1_HKey Figures: Value-at-Risk with Parameters3VALDATEDate: Valid From (Inclusive)nvarchar80
46AFWKFRA_KVK2_HKey Figures: Marginal Value-at-Risk with Parameters / AT3VALDATEDate: Valid From (Inclusive)nvarchar80
47AFWKFRA_KVK_HKey Figures: Value-at-Risk with Parameters3VALDATEDate: Valid From (Inclusive)nvarchar80
48AFWKFRA_KVS1_HKey Figures: Mean Excess Loss Simulated / AT3VALDATEDate: Valid From (Inclusive)nvarchar80
49AFWKFRA_KVS_HKey Figures: Value-at-Risk - Simulated3VALDATEDate: Valid From (Inclusive)nvarchar80
50AFWKFRA_QKF_HKey Figures: Commodity Key Figure for commodity instruments3VALDATEDate: Valid From (Inclusive)nvarchar80
TOPPortfolio Analyzer
51AFWKF_FLWCC_HKey Figures: Flow in Evaluation Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
52AFWKF_FLW_HKey Figures: Flow in Transaction Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
53AFWKF_INFO_HKey Figures: Information Ratio3VALDATEDate: Valid From (Inclusive)nvarchar80
54AFWKF_JENSEN_HKey Figures: Jensen's Alpha3VALDATEDate: Valid From (Inclusive)nvarchar80
55AFWKF_POSCC_HKey Figures: Position in Evaluation Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
56AFWKF_POS_HKey Figures: Position in Position Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
57AFWKF_PRDFLWCC_HKey Figures: Flow for Period in Evaluation Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
58AFWKF_PRDFLW_HKey Figures: Flow for Period in Transaction Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
59AFWKF_SHARPE_HKey Figures: Sharpe Ratio3VALDATEDate: Valid From (Inclusive)nvarchar80
60AFWKF_SORTINO_HKey Figures: Sortino Ratio3VALDATEDate: Valid From (Inclusive)nvarchar80
61AFWKF_TREYNOR_HKey Figures: Treynor's Ratio3VALDATEDate: Valid From (Inclusive)nvarchar80
62AFWKF_YLDCC_HKey Figures: Yield Calculated from Evaluation Currency3VALDATEDate: Valid From (Inclusive)nvarchar80
63AFWKF_YLDSNCCC_HKey Figures: Yield from Evaluation Currency Since CALCSINCE3VALDATEDate: Valid From (Inclusive)nvarchar80
64AFWKF_YLDSNC_HKey Figures: Yield from Transaction Currency Since CALCSINCE3VALDATEDate: Valid From (Inclusive)nvarchar80
65AFWKF_YLD_HKey Figures: Yield Calculated from Transaction Currency3VALDATEDate: Valid From (Inclusive)nvarchar80