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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
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	TEMT_VERSEXPOS	45	3	Versioned Exposure	Transaction Manager

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PROFILE_ID	Planning Profile	nvarchar	10	0	Allow NULL?
3	VERSION_NO	Version	nvarchar	6	0	Allow NULL?
4	EXPOSURE_ID	Exposure ID	nvarchar	32	0	Allow NULL?
5	EXPOSURE_ORIGIN	Exposure Origin	nvarchar	5	0	Allow NULL?
6	LOG_SYSTEM	Logical system	nvarchar	10	0	Allow NULL?
7	PLANNING_PERIOD	Planning Period	nvarchar	3	0	Allow NULL?
8	PLANNING_YEAR	Plan Year	nvarchar	4	0	Allow NULL?
9	DUE_DATE	Date to Which Exposure Refers	nvarchar	8	0	Allow NULL?
10	PERIOD_END_DATE	End of Planning Period	nvarchar	8	0	Allow NULL?
11	TRANSACTION_CAT	Transaction Category (E-HA)	nvarchar	2	0	Allow NULL?
12	SIGN	Direction of flow	char	1	0	Allow NULL?
13	COMPANY_CODE	Company Code	nvarchar	4	0	Allow NULL?
14	COUNTRY	Country Key	nvarchar	3	0	Allow NULL?
15	ATTRIBUTE_01	Value of a Free Attribute	nvarchar	20	0	Allow NULL?
16	ATTRIBUTE_02	Value of a Free Attribute	nvarchar	20	0	Allow NULL?
17	ATTRIBUTE_03	Value of a Free Attribute	nvarchar	20	0	Allow NULL?
18	ATTRIBUTE_04	Value of a Free Attribute	nvarchar	20	0	Allow NULL?
19	ATTRIBUTE_05	Value of a Free Attribute	nvarchar	20	0	Allow NULL?
20	ATTRIBUTE_06	Value of a Free Attribute	nvarchar	20	0	Allow NULL?
21	FOREIGN_AMT	Foreign Currency Amount of Exposure	decimal	17	2
22	FOREIGN_CURR	Exposure Currency	nvarchar	5	0	Allow NULL?
23	PERCENTAGE	Maximum Percentage to Be Hedged	decimal	5	2
24	PERCENTAGE_MIN	Minimum Percentage to Be Hedged	decimal	5	2
25	MINIMUM_AMT	Trivial Amount Limit for Hedge (Absolute Amount)	decimal	17	2
26	HED_COMPANY_CODE	Company Code	nvarchar	4	0	Allow NULL?
27	HEDGE_PLAN_ID	Hedge Plan ID	nvarchar	13	0	Allow NULL?
28	HED_EXPOSURE_ID	Exposure ID	nvarchar	5	0	Allow NULL?
29	TRANSACTION_ID	E-HA: Transaction	nvarchar	11	0	Allow NULL?
30	TRANSACTION_ACT	Transaction Activity (E-HA)	nvarchar	2	0	Allow NULL?
31	STATE	Exposure Status	char	1	0	Allow NULL?
32	EXPOSURE_CAT	Exposure Category	char	1	0	Allow NULL?
33	TRANSFER_CAT	Type of Transfer to Hedge Accounting for Exposures	char	1	0	Allow NULL?
34	TOT_EXPOSURE_ID	Exposure ID	nvarchar	32	0	Allow NULL?
35	LAST_VERSION_HED	Version	nvarchar	6	0	Allow NULL?
36	DESCRIPTION	Description of the Exposure Transaction	nvarchar	50	0	Allow NULL?
37	REFERENCE	Reference (E-HA)	nvarchar	16	0	Allow NULL?
38	CREATION_DATE	First Entered on	nvarchar	8	0	Allow NULL?
39	CREATION_TIME	Time of Initial Entry	nvarchar	6	0	Allow NULL?
40	CREATION_USER	Entered by	nvarchar	12	0	Allow NULL?
41	CREATION_TCODE	Transaction Code	nvarchar	20	0	Allow NULL?
42	LASTCHANGE_DATE	Last Edited on	nvarchar	8	0	Allow NULL?
43	LASTCHANGE_TIME	Last Edited at	nvarchar	6	0	Allow NULL?
44	LASTCHANGE_USER	Employee ID	nvarchar	12	0	Allow NULL?
45	LASTCHANGE_TCODE	Transaction Code	nvarchar	20	0	Allow NULL?

Name	Primary	Unique	Type	Columns
TEMT_VERSEXPOS~0	Yes	Yes	CLUSTERED	MANDT, PROFILE_ID, VERSION_NO, EXPOSURE_ID, EXPOSURE_ORIGIN, LOG_SYSTEM
TEMT_VERSEXPOS~EXP	No	No	NONCLUSTERED	MANDT, EXPOSURE_ID, EXPOSURE_ORIGIN, LOG_SYSTEM
TEMT_VERSEXPOS~HMT	No	No	NONCLUSTERED	MANDT, HED_COMPANY_CODE, HEDGE_PLAN_ID, HED_EXPOSURE_ID, TRANSACTION_ID

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

45 COLUMNS | 3 INDEXES | ERP 6.0 | TEMT_VERSEXPOS TABLE

TOP ERP 6.0 | TEMT_VERSEXPOS COLUMNS

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

45 COLUMNS | 3 INDEXES | ERP 6.0 | TEMT_VERSEXPOS TABLE

TOPERP 6.0 | TEMT_VERSEXPOS COLUMNS

TOPERP 6.0 | TEMT_VERSEXPOS INDEXES

TOP ERP 6.0 | TEMT_VERSEXPOS COLUMNS

TOP ERP 6.0 | TEMT_VERSEXPOS INDEXES