	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

100 columns | ERP 6.0 | BASEFIGURE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	AFWKFRA_KB4	Key Figures: MtM with Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
2	AFWKFRA_KB4_H	Key Figures: MtM with Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
3	AFWKFRA_KB5	Key Figures: Cashflow (based on Spot Prices)	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
4	AFWKFRA_KB5_H	Key Figures: Cashflow (based on Spot Prices)	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
5	AFWKFRA_KB6	Key Figures: Cashflow for Cashflow-at-Risk	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
6	AFWKFRA_KB6_H	Key Figures: Cashflow for Cashflow-at-Risk	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
7	AFWKFRA_KBMX	Key Figures: MtM with Market Data Shift	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
8	AFWKFRA_KBMX_H	Key Figures: MtM with Market Data Shift	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
9	AFWKFRA_KCFARC	Key Figures: CfaR by variance/covariance	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
10	AFWKFRA_KCFARC_H	Key Figures: CfaR by variance/covariance	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
11	AFWKFRA_KCFARS	Key Figures: CfaR from simulation method	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
12	AFWKFRA_KCFARS_H	Key Figures: CfaR from simulation method	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
13	AFWKFRA_KCFO	Key Figures: Cashflow (in original currency)	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
14	AFWKFRA_KCFO_H	Key Figures: Cashflow (in original currency)	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
15	AFWKFRA_KCFP	Key Figures: CfaR - Risk Factor Positions	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
16	AFWKFRA_KCFPL	Key Figures: CfaR - Profit/Loss Distribution	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
17	AFWKFRA_KCFPL_H	Key Figures: CfaR - Profit/Loss Distribution	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
18	AFWKFRA_KCFP_H	Key Figures: CfaR - Risk Factor Positions	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
19	AFWKFRA_KGD	Key Figures: Greeks - Delta	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
20	AFWKFRA_KGD_H	Key Figures: Greeks - Delta	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
21	AFWKFRA_KMGD	Key Figures: MtM, Greeks - Delta	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
22	AFWKFRA_KMGD_H	Key Figures: MtM, Greeks - Delta	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
TOPAnalyzer
23	AFWKFAA_AAPOS	Key Figures: Position in Position Currency	5	BASEFIGURE	Basic Key Figure	nvarchar	8	0
24	AFWKFAA_AAPOSCC	Key Figures: Position in Evaluation Currency	5	BASEFIGURE	Basic Key Figure	nvarchar	8	0
25	AFWKFAA_GENPOS	Key Figure: Generic Position Key Figure	5	BASEFIGURE	Basic Key Figure	nvarchar	8	0
26	AFWKFAA_GENPOSCC	Key Figure: Generic Position Key Figure in Calculation Curre	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
27	AFWKF_AAPOSCC_H	Key Figures: Position in Evaluation Currency	6	BASEFIGURE	Basic Key Figure	nvarchar	8	0
28	AFWKF_AAPOS_H	Key Figures: Position in Position Currency	6	BASEFIGURE	Basic Key Figure	nvarchar	8	0
29	AFWKF_GENPOSCC_H	Key Figure: Generic Position Key Figure History	5	BASEFIGURE	Basic Key Figure	nvarchar	8	0
30	AFWKF_GENPOS_H	Key Figure: Generic Position Key Figure History	6	BASEFIGURE	Basic Key Figure	nvarchar	8	0
TOPMarket Risk Analyzer
31	AFWKFRA_BCK0	Key Figures: Backtesting for Profit and Loss	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
32	AFWKFRA_BCK0_H	Key Figures: Backtesting for Profit and Loss - History	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
33	AFWKFRA_K00	Key Figures: Direct Redefinition of Dual Interest Rate Shift	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
34	AFWKFRA_K00_H	Key Figures: Direct Redefinition of Dual Interest Rate Shift	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
35	AFWKFRA_K01	Key Figures: Direct Redefinition of Int. Rate Sensitivities	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
36	AFWKFRA_K01_H	Key Figures: Direct Redefinition of Int. Rate Sensitivities	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
37	AFWKFRA_KB0	Key Figures: NPV with Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
38	AFWKFRA_KB00	Key Figures: NPV in transaction currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
39	AFWKFRA_KB00_H	Key Figures: NPV in transaction currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
40	AFWKFRA_KB0_H	Key Figures: NPV with Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
41	AFWKFRA_KB2	Key Figures: Net Present Value with Currency - VaR Basis	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
42	AFWKFRA_KB2_H	Key Figures: NPV with Currency - VaR Basis	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
43	AFWKFRA_KBB	Key Figures: Backtesting	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
44	AFWKFRA_KBE	Key Figures: Exposure	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
45	AFWKFRA_KBE_H	Key Figures: Exposure	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
46	AFWKFRA_KBF	Key Figures: Key Figure Formulas	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
47	AFWKFRA_KBX	Key Figures: NPV with Market Data Shift	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
48	AFWKFRA_KBX_H	Key Figures: NPV with Market Data Shift	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
49	AFWKFRA_KD0	Key Figures: Positions in Risk Hierarchy	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
50	AFWKFRA_KD0_H	Key Figures: Items in the Risk Hierarchy	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
51	AFWKFRA_KG1	Key Figures: P&L Delta/Gamma	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
52	AFWKFRA_KG1_H	Key Figures: P+L Delta/Gamma	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
53	AFWKFRA_KS0	Key Figures: Direct Redefinition	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
54	AFWKFRA_KS0_H	Key Figures: Direct Redifinition	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
55	AFWKFRA_KS1	Key Figure: Direct Redefinition of YTM	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
56	AFWKFRA_KS1_H	Key Figures: Direct Redefinition / AT (for YTM)	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
57	AFWKFRA_KS2	Key Figures: Direct Redefinition (for Modified Duration)	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
58	AFWKFRA_KS2_H	Key Figure: Direct Redefinition / AT	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
59	AFWKFRA_KVK	Key Figures: Value at Risk with Parameters	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
60	AFWKFRA_KVK1	Key Figures: Value at Risk with Parameters	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
61	AFWKFRA_KVK1_H	Key Figures: Value-at-Risk with Parameters	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
62	AFWKFRA_KVK2	Key Figures: Marginal Value at Risk with Parameters	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
63	AFWKFRA_KVK2_H	Key Figures: Marginal Value-at-Risk with Parameters / AT	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
64	AFWKFRA_KVK_H	Key Figures: Value-at-Risk with Parameters	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
65	AFWKFRA_KVS	Key Figures: Value at Risk Simulated	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
66	AFWKFRA_KVS1	Key Figures: Mean Excess Loss Simulated	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
67	AFWKFRA_KVS1_H	Key Figures: Mean Excess Loss Simulated / AT	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
68	AFWKFRA_KVS_H	Key Figures: Value-at-Risk - Simulated	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
69	AFWKFRA_QKF	Key Figures: Quantity Key Figure for commodity instruments	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
70	AFWKFRA_QKF_H	Key Figures: Commodity Key Figure for commodity instruments	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
TOPPortfolio Analyzer
71	AFWKFPA_FLW	Key Figures: Flow in Transaction Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
72	AFWKFPA_FLWCC	Key Figures: Flow in Evaluation Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
73	AFWKFPA_INFO	Key Figures: Information Ratio	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
74	AFWKFPA_JENSEN	Key Figures: Jensen's Alpha	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
75	AFWKFPA_POS	Key Figures: Position in Position Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
76	AFWKFPA_POSCC	Key Figures: Position in Evaluation Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
77	AFWKFPA_PRDFLW	Key Figures: Flow for Period in Transaction Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
78	AFWKFPA_PRDFLWCC	Key Figures: Flow for Period in Evaluation Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
79	AFWKFPA_SHARPE	Key Figures: Sharpe Ratio	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
80	AFWKFPA_SORTINO	Key Figures: Sortino Ratio	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
81	AFWKFPA_TREYNOR	Key Figures: Treynor's Ratio	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
82	AFWKFPA_YLD	Key Figures: Yield Calculated from Transaction Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
83	AFWKFPA_YLDCC	Key Figures: Yield Calculated from Evaluation Currency	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
84	AFWKFPA_YLDSNC	Key Figures: Yield from Transaction Currency Since CALCSINCE	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
85	AFWKFPA_YLDSNCCC	Key Figures: Yield from Evaluation Currency Since CALCSINCE	3	BASEFIGURE	Basic Key Figure	nvarchar	8	0
86	AFWKF_FLWCC_H	Key Figures: Flow in Evaluation Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
87	AFWKF_FLW_H	Key Figures: Flow in Transaction Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
88	AFWKF_INFO_H	Key Figures: Information Ratio	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
89	AFWKF_JENSEN_H	Key Figures: Jensen's Alpha	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
90	AFWKF_POSCC_H	Key Figures: Position in Evaluation Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
91	AFWKF_POS_H	Key Figures: Position in Position Currency	5	BASEFIGURE	Basic Key Figure	nvarchar	8	0
92	AFWKF_PRDFLWCC_H	Key Figures: Flow for Period in Evaluation Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
93	AFWKF_PRDFLW_H	Key Figures: Flow for Period in Transaction Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
94	AFWKF_SHARPE_H	Key Figures: Sharpe Ratio	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
95	AFWKF_SORTINO_H	Key Figures: Sortino Ratio	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
96	AFWKF_TREYNOR_H	Key Figures: Treynor's Ratio	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
97	AFWKF_YLDCC_H	Key Figures: Yield Calculated from Evaluation Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
98	AFWKF_YLDSNCCC_H	Key Figures: Yield from Evaluation Currency Since CALCSINCE	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
99	AFWKF_YLDSNC_H	Key Figures: Yield from Transaction Currency Since CALCSINCE	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0
100	AFWKF_YLD_H	Key Figures: Yield Calculated from Transaction Currency	4	BASEFIGURE	Basic Key Figure	nvarchar	8	0

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

100 columns | ERP 6.0 | BASEFIGURE