ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Bank Components :: Risk Analysis
1	ERP EHP7	6.0	ATRMO	91	1	Valuation control	Risk Analysis

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RMBEWREG	Valuation Rule	nvarchar	8	0	Allow NULL?
3	AUSWT	Evaluation type in Risk Management	nvarchar	4	0	Allow NULL?
4	KURSTG	Exchange rate type bid	nvarchar	4	0	Allow NULL?
5	KURSTB	Exchange rate type ask	nvarchar	4	0	Allow NULL?
6	BCURVE	Bid valuation curve type for mark-to-market	nvarchar	4	0	Allow NULL?
7	BCURVEB	Ask Valuation Curve: Mark-to-Market	nvarchar	4	0	Allow NULL?
8	WPKURSART	Security price type for evaluations	nvarchar	2	0	Allow NULL?
9	IDXART	Index Type	nvarchar	2	0	Allow NULL?
10	DVOLARTG	Volatility Type "Bid Rates" for Foreign Exchange	nvarchar	3	0	Allow NULL?
11	DVOLARTB	Volatility Type "Ask Rates" for Foreign Exchange	nvarchar	3	0	Allow NULL?
12	ZVOLARTG	Volatility Type 'Bid' for Interest Rates	nvarchar	3	0	Allow NULL?
13	ZVOLARTB	Volatility Type 'Ask' for Interest Rates	nvarchar	3	0	Allow NULL?
14	WVOLARTG	Volatility Type 'Bid' for Securities	nvarchar	3	0	Allow NULL?
15	WVOLARTB	Volatility Type 'Ask' for Securities	nvarchar	3	0	Allow NULL?
16	IXVOLARTG	Volatility Type for Security Indexes; Bid Rates	nvarchar	3	0	Allow NULL?
17	IXVOLARTB	Volatility Type for Security Indexes; Ask Rates	nvarchar	3	0	Allow NULL?
18	HWVOLARTG	Volatility Type for Yield Curve Model, Bid Rate	nvarchar	3	0	Allow NULL?
19	HWVOLARTB	Volatility Type for Yield Curve Model, Ask Rate	nvarchar	3	0	Allow NULL?
20	KORRARTG	'Bid' Correlation Type	nvarchar	3	0	Allow NULL?
21	KORRARTB	'Ask' Correlation Type	nvarchar	3	0	Allow NULL?
22	VNAME	Volatility Name	nvarchar	15	0	Allow NULL?
23	COVOLTYPB	Volitility Type "Bid" for Commodity Transactions	nvarchar	3	0	Allow NULL?
24	COVOLTYPA	Volitility Type "Ask" for Commodity Transactions	nvarchar	3	0	Allow NULL?
25	COPRTYPE	Commodity Quotation Type	nvarchar	5	0	Allow NULL?
26	BCURVE_RF	Bid Valuation Curve : Risk Free	nvarchar	4	0	Allow NULL?
27	BCURVEB_RF	Ask Valuation Curve : Risk Free	nvarchar	4	0	Allow NULL?
28	BSP_CURVE_B	Basis Spread Curve Type	nvarchar	4	0	Allow NULL?
29	BSP_CURVE_A	Basis Spread Curve Type	nvarchar	4	0	Allow NULL?
30	KURSTM	Exchange rate type middle	nvarchar	4	0	Allow NULL?
31	BCURVEM	Middle valuation curve: Mark-to-market	nvarchar	4	0	Allow NULL?
32	DVOLARTM	Volatility Type Middle Rates for Foreign Exchange	nvarchar	3	0	Allow NULL?
33	ZVOLARTM	Volatility Type Middle Rates for Interest	nvarchar	3	0	Allow NULL?
34	WVOLARTM	Volatility Type Middle Rates for Securities	nvarchar	3	0	Allow NULL?
35	IXVOLARTM	Volatility Type for Security Indexes; Middle Rates	nvarchar	3	0	Allow NULL?
36	HWVOLARTM	Volatility Type for Yield Curve Model, Middle Rate	nvarchar	3	0	Allow NULL?
37	KORRARTM	'Middle' Correlation Type	nvarchar	3	0	Allow NULL?
38	COVOLTYPM	Volatility Type 'Middle Rate' for Commodities	nvarchar	3	0	Allow NULL?
39	BCURVEM_RF	Middle Valuation Curve : Risk Free	nvarchar	4	0	Allow NULL?
40	BSP_CURVE_M	Basis Spread Curve Type	nvarchar	4	0	Allow NULL?
41	XREAL_CASHF	Include Real Cash Flows	char	1	0	Allow NULL?
42	CALCVERF	Calculation Routines	nvarchar	4	0	Allow NULL?
43	WPPVART	Calculate Theoretical NPV	char	1	0	Allow NULL?
44	WKTAGE	Maximum age of historical price in days	decimal	3	0
45	SVOLART	Volatility Type for Convexity Adjustment	nvarchar	3	0	Allow NULL?
46	XHOR_CASHF	Is cash flow at horizon included in NPV?	char	1	0	Allow NULL?
47	XINTOPT	Value Swaptions as Interest Rate Options	char	1	0	Allow NULL?
48	XIMPLOPT	Break Down Implied Options	char	1	0	Allow NULL?
49	NAMEAUS	Disbursement Procedure (Loan)	nvarchar	10	0	Allow NULL?
50	SET_NAME	Redemption Schedule Set	nvarchar	15	0	Allow NULL?
51	STUECKZINS	Include the Horizon when Calculating Accrued Interest	char	1	0	Allow NULL?
52	FLG_ACCR_INT	Calculate Accrued Interest	char	1	0	Allow NULL?
53	DISB_START	Start of Disbursement Procedure	char	1	0	Allow NULL?
54	DISB_CAL	Calendar for Disbursement Procedure	nvarchar	2	0	Allow NULL?
55	VALUATION_MODEL	Valuation Model for Financial Transactions	nvarchar	4	0	Allow NULL?
56	NUMBER_OF_STEPS	Default Number of Steps for Discretization Method	int	10	0	Allow NULL?
57	MAX_STEPLENGTH	Maximum Permitted Time Step for Discretization Method	decimal	12	6
58	PREPAYMENT	Prepayment	char	1	0	Allow NULL?
59	X_PREPAYMENT	Indicator for Prepayment - Point Effect	char	1	0	Allow NULL?
60	FLG_WITH_COMPENS	Select FX Offsetting Transactions	char	1	0	Allow NULL?
61	FLG_TERMINATED_D	Select Transaction on Day of Cancellation/Settlement	char	1	0	Allow NULL?
62	COMAXAGEPR	Maximum Age of Historical Commodity Price in Days	decimal	3	0
63	X_INTVAL	Intrinsic Value Indicator	char	1	0	Allow NULL?
64	COEXPVALTYP	Commodity Exposure - NPV Valuation Type	char	1	0	Allow NULL?
65	XCREDITSPREAD	Use Credit Spreads at Discounting	char	1	0	Allow NULL?
66	CSPREAD_TYPE	Credit Spread Type	nvarchar	2	0	Allow NULL?
67	CTY_CURVE_B	Commodity Curve Type Bid	nvarchar	3	0	Allow NULL?
68	CTY_CURVE_M	Commodity Curve Type Middle	nvarchar	3	0	Allow NULL?
69	CTY_CURVE_A	Commodity Curve Type Ask	nvarchar	3	0	Allow NULL?
70	XDDELIVERY	Delayed Delivery Option Usage Flag	char	1	0	Allow NULL?
71	DD_DAYS	Number of Days to consider for Delayed Delivery	decimal	3	0
72	XCSP_USE_VAR_RT	Use Credit Spread when Calculating Forward Interest Rates	char	1	0	Allow NULL?
73	CSP_FWD_RT_TYPE	Credit Spread Type	nvarchar	2	0	Allow NULL?
74	DISPUOM	Display Unit of Measure	char	1	0	Allow NULL?
75	QTYCALMETH	Quantity Calculation Method	char	1	0	Allow NULL?
76	FUTCALMETH	Calculation Method for Futures	char	1	0	Allow NULL?
77	BSP_DERI_EVAL	Basis Spread Curve Derivation for Evaluation Curves	nvarchar	4	0	Allow NULL?
78	BSP_DERI_FWD	Basis Spread Curve Derivation ID for Forward Curves	nvarchar	4	0	Allow NULL?
79	CSP_DERIVE_BP	Reference Entity Derivation for Business Partners	nvarchar	4	0	Allow NULL?
80	CSP_DERIVE_OWN	Reference Entity Derivation for Your Own Companies	nvarchar	4	0	Allow NULL?
81	BP_RELTYP	Relationship Category of Business Partner	nvarchar	6	0	Allow NULL?
82	OWN_BUKRS	Own Default Company Code	nvarchar	4	0	Allow NULL?
83	MAX_AGE_CS_REDEF	Use Different Maximum Age for Credit Spreads	char	1	0	Allow NULL?
84	MAX_AGE_CS	Maximum Age for Credit Spreads	int	10	0	Allow NULL?
85	XEXTBW	Indicator for External Valuation	char	1	0	Allow NULL?
86	XDEST_T1	RM RFC: Destination in SAP Banking RM	nvarchar	32	0	Allow NULL?
87	XFUNC_T1	RM RFC: Function Name in SAP Banking RM	nvarchar	30	0	Allow NULL?
88	XDEST_T2	RM RFC: Destination in SAP Banking RM	nvarchar	32	0	Allow NULL?
89	XFUNC_T2	RM RFC: Function Name in SAP Banking RM	nvarchar	30	0	Allow NULL?
90	CONVADJ_VR	Control convexity adjustment valuation rule specific	char	1	0	Allow NULL?
91	CSC_VALRULE_REDEF	Redefine Settings	char	1	0	Allow NULL?

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

91 COLUMNS | 1 INDEXES | ERP 6.0 | ATRMO TABLE

TOP ERP 6.0 | ATRMO COLUMNS

TOP ERP 6.0 | ATRMO INDEXES

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

91 COLUMNS | 1 INDEXES | ERP 6.0 | ATRMO TABLE

TOPERP 6.0 | ATRMO COLUMNS

TOPERP 6.0 | ATRMO INDEXES

TOP ERP 6.0 | ATRMO COLUMNS

TOP ERP 6.0 | ATRMO INDEXES