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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	AT10	58	1	Transaction Types	Transaction Manager

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	SGSART	Product Type	nvarchar	3	Allow NULL?
3	SFHAART	Financial Transaction Type	nvarchar	3	Allow NULL?
4	SFGTYP	Transaction Category	nvarchar	3	Allow NULL?
5	NUMKR	Number Range for Transactions	nvarchar	2	Allow NULL?
6	NUMKRANG	Number Range for Offers/Quotations	nvarchar	2	Allow NULL?
7	NUMKRSIM	Number Range for Simulated Transactions	nvarchar	2	Allow NULL?
8	ABWTYP	Processing Category	nvarchar	5	Allow NULL?
9	SAUTOBUCH	Automatic Posting Release	char	1	Allow NULL?
10	UNUMKR	Number Range for Underlying	nvarchar	2	Allow NULL?
11	SLPG	Limit Product Group	nvarchar	3	Allow NULL?
12	SROUND	Rounding Type	char	1	Allow NULL?
13	RROUND	Rounding unit	tinyint	3
14	SBSTDCP	Basic Principle of Commercial Paper Position	char	1	Allow NULL?
15	SCOMPCP	Exponential discounting for term over 1 year	char	1	Allow NULL?
16	AHJFA	Number of Half-Years for Generating Cash Flow	nvarchar	2	Allow NULL?
17	SREALGE	Treasury: Flow Type for Realized Gains	nvarchar	4	Allow NULL?
18	SREALVE	Treasury: Flow Type for Realized Losses	nvarchar	4	Allow NULL?
19	SBESTABT	Treasury: Flow type for position writedowns	nvarchar	4	Allow NULL?
20	SBESTZUT	Treasury: Flow type for position writeups	nvarchar	4	Allow NULL?
21	SBESTAB	Treasury: Flow type for position writedowns	nvarchar	4	Allow NULL?
22	SBESTZU	Treasury: Flow type for position writeups	nvarchar	4	Allow NULL?
23	SRUEBIL	Treasury: Flow type for provisions to be created	nvarchar	4	Allow NULL?
24	SRUEAUF	Treasury: Flow type for reversing provisions	nvarchar	4	Allow NULL?
25	SGEWBIL	Treasury: Flow type for unrealized gains to be disclosed	nvarchar	4	Allow NULL?
26	SGEWAUF	Treasury: Flow type for writing back unrealized gains	nvarchar	4	Allow NULL?
27	SSWAPERT	Treasury: flow type for accrued/deferred forex swap revenue	nvarchar	4	Allow NULL?
28	SSWAPERAUF	Treasury: Flow type for writing back accrd/defd fx swap rev.	nvarchar	4	Allow NULL?
29	SSWAPAUF	Treasury: flow type for accrued/deferred forex swap expenses	nvarchar	4	Allow NULL?
30	SSWAPAUAUF	Treasury: Flow type f. writing back accrd/defrd fx swap exp.	nvarchar	4	Allow NULL?
31	SRUESWP	Treasury: Flow type for creating provisions - swap	nvarchar	4	Allow NULL?
32	SRUEAUFSWP	Treasury: Flow type for writing back provisons - swap	nvarchar	4	Allow NULL?
33	SGEWSWP	Treasury: Flow type for disclosing unrealized gains - swap	nvarchar	4	Allow NULL?
34	SGEWAUFSWP	Treasury: Flow type for writing back unrealized swap gains	nvarchar	4	Allow NULL?
35	SSWPUMBAUF	Treasury: Transfer flow for forex swap expenses	nvarchar	4	Allow NULL?
36	SSWPUMBERT	Treasury: Transfer flow for foreign exchange swap revenue	nvarchar	4	Allow NULL?
37	RANTYP	Contract Type	char	1	Allow NULL?
38	STSMA	Status Profile	nvarchar	8	Allow NULL?
39	DATE_RULE	Date Rule to Determine Due Date	nvarchar	10	Allow NULL?
40	SREALGET	Treasury: Flow Type for Realized Gains	nvarchar	4	Allow NULL?
41	SREALVET	Treasury: Flow Type for Realized Losses	nvarchar	4	Allow NULL?
42	FLAG_FLAT	Indicator: Traded Flat	char	1	Allow NULL?
43	SNOMPAY	Difference Between Payment Amount and Nominal Amount	char	1	Allow NULL?
44	FLG_INIT_MARGIN	Indicator: Generate Initial Margin Flow	char	1	Allow NULL?
45	POS_LOCK_CAT	Type of Position Lock	char	1	Allow NULL?
46	USGSART	Product type of underlying	nvarchar	3	Allow NULL?
47	USFHAART	Transaction Type of Underlying	nvarchar	3	Allow NULL?
48	LOCK_REASON	Block type for restraint on disposal	nvarchar	3	Allow NULL?
49	AUTOSETTLE	Automatic Settlement on Counterconfirmation	char	1	Allow NULL?
50	PHYSICALDEL	Consider physical delivery	char	1	Allow NULL?
51	USENETTING	Use Netting	char	1	Allow NULL?
52	LOC_CURR_RULE	Exchange rate for translation to local currency	char	1	Allow NULL?
53	SIDE_CAT_IN	Side Category for the Incoming Side of a Swap	char	1	Allow NULL?
54	SIDE_CAT_OUT	Side Category for the Outgoing Side of a Swap	char	1	Allow NULL?
55	SWAP_SYMMETRY	Indicates How Swap Symmetry Is Handled	char	1	Allow NULL?
56	SWAP_CAPTURE_BEH	Activates Multiple Flow Generation for Commodity Swaps	char	1	Allow NULL?
57	COM_PRICE_DETERM	Determination of Commodity Price	char	1	Allow NULL?
58	COM_AVG_CAPT_CAT	Average Price Capture Category for Commodity Forward	char	1	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

58 COLUMNS | 1 INDEXES | ERP 6.0 | AT10 TABLE

TOP ERP 6.0 | AT10 COLUMNS

TOP ERP 6.0 | AT10 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

58 COLUMNS | 1 INDEXES | ERP 6.0 | AT10 TABLE

TOPERP 6.0 | AT10 COLUMNS

TOPERP 6.0 | AT10 INDEXES

TOP ERP 6.0 | AT10 COLUMNS

TOP ERP 6.0 | AT10 INDEXES