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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transfer to Financial Accounting
1	ERP EHP7	6.0	TRLT_INIT_SUB_SE	78	1	Init.Hedging Relationship for Securities with Subpositions	Transfer to Financial Accounting

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	COMPANY_CODE	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
3	HITEM_NUMBER	Hedged Item Number	nvarchar	10	0	CHAR	(N' ')	No		TPM_HITEM_NUMBER	Allow NULL?
4	HINST_NUMBER	Hedging Instrument Number	nvarchar	10	0	CHAR	(N' ')	No		TPM_HINST_NUMBER	Allow NULL?
5	FISCAL_YEAR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
6	ASSG_UNITS	Units	decimal	22	6	DEC	((0))	Yes		TPM_UNITS
7	ASSG_NOM_AMT	Nominal Amount	decimal	21	2	CURR	((0))	Yes		TPM_NOMINAL_AMT
8	ASSG_NOM_ORG_AMT	Original Nominal Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_NOMINAL_ORG_AMT
9	NOMINAL_CURR	Nominal Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_NOMINAL_CURR	Allow NULL?
10	POSITION_CURR	Position Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_POSITION_CURR	Allow NULL?
11	VALUATION_CURR	Valuation Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_VALUATION_CURR	Allow NULL?
12	ACTIVE_PASSIVE	Indicator: Assets/Liabilities Position	char	1	0	CHAR	(N' ')	Yes		TPM_ACTIVE_PASSIVE	Allow NULL?
13	VAL_TI_PC	Security Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_PC
14	VAL_TI_VC	Security Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_VC
15	VAL_TI_IDX_CLEAN	Security Valuation, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_IDX_CLEAN
16	VAL_FX_VC	Foreign Currency Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_FX_VC
17	VAL_IDX_PC	Index Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_PC
18	VAL_IDX_VC	Index Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_VC
19	VAL_CH_TI_PC	Valuation of Cap. Costs, Security, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_PC
20	VAL_CH_TI_VC	Valuation of Cap. Costs, Security, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_VC
21	VAL_CH_TI_IDXCL	Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_IDX_CLEAN
22	VAL_CH_FX_VC	Valuation of Capitalized Costs, FX, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_FX_VC
23	VAL_AAV_FX_VC	FX Valuation of Amort.Acquisition Value in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_AAV_FX_VC
24	IMPAIRMENT_PC	Impairment in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_PC
25	IMPAIRMENT_VC	Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_VC
26	IMPMT_IDX_CLEAN	Impairment in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_IDX_CLEAN
27	IMPAIRMENT_FX_VC	FX Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_FX_VC
28	AMORT_PC	Amortization in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_PC
29	AMORT_VC	Amortization in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_VC
30	AMORT_IDX_CLEAN	Amortization, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_IDX_CLEAN
31	AMORT_NEG_SPR_PC	Amortization of Negotiation Spread in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_PC
32	AMORT_NEG_SPR_VC	Amortization of Negotiation Spread in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_VC
33	AM_NEG_SPR_IDXCL	Amortiz. of Negotiation Spread in Position Crcy Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_IDX_CLEAN
34	DISAGIO_PC	Discount/Premium in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_PC
35	DISAGIO_VC	Discount/Premium in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_VC
36	DISAGIO_IDXCL	Index-Clean Discount/Premium in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_IDX_CLEAN
37	VAL_TI_PC_NPL	Securities Valuation Not Affecting P/L in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_PC_NPL
38	VAL_TI_VC_NPL	Securities Valuation Not Affecting P/L in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_VC_NPL
39	VAL_IT_IDXCL_NPL	Securities Val. Not Affecting P/L in Pos. Crcy Index Clean	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_IDXCL_NPL
40	VAL_FX_VC_NPL	Forex Valuation Not Affecting P/L in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_FX_VC_NPL
41	VAL_IDX_PC_NPL	Index Valuation Not Affecting P/L in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_PC_NPL
42	VAL_IDX_VC_NPL	Index Valuation Not Affecting P/L in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_VC_NPL
43	VAL_CH_TI_PC_NPL	Security Costs Valuation Not Affecting P/L in Position Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_PC_NPL
44	VAL_CH_TI_VC_NPL	Security Costs Valuation Not Affecting P/L in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_VC_NPL
45	VAL_CHTIIDXCLNPL	Security Costs Val. Not Affecting P/L in PosCrcy Index Clean	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_IDXCL_NPL
46	VAL_CH_FX_VC_NPL	Forex Costs Valuation Not Affecting P/L in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_FX_VC_NPL
47	ACC_INT_PC	Accrued Interest in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_PC
48	ACC_INT_VC	Accrued Interest in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_VC
49	ACC_INT_IDXCL	Accrued Interest in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_IDX_CLEAN
50	NGSPR_PC	Negotiation Spread in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_PC
51	NGSPR_VC	Negotiation Spread in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_VC
52	NGSPR_IDXCL	Negotiation Spread Index Clean	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_IDXCL
53	HADJ_PC	Hedge Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_PC
54	HADJ_IDXCL_PC	Hedge Adjustment in Position Currency, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_INDX_PC
55	HADJ_VC	Hedge Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_VC
56	EFF_PC	Effective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_PC
57	EFF_VC	Effective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_VC
58	EFF_IDXCL_PC	Effective Amount in Position Currency, Index Clean	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_IDXCL_PC
59	INEFF_PC	Ineffective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_PC
60	INEFF_VC	Ineffective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_VC
61	INEFF_IDXCL_PC	Ineffective Amount in Position Currency, Index Clean	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_IDXCL_PC
62	EFFD_PC	Effective Amount (Dormant) in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_PC
63	EFFD_VC	Effective Amount (Dormant) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_VC
64	EFFD_IDXCL_PC	Effective Amount (Dormant) in Position Currency, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_IDXCL_PC
65	INEFFD_PC	Ineffective Amount (Dormant) in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_DORMANT_PC
66	INEFFD_VC	Ineffective Amount (Dormant) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_DORMANT_VC
67	INEFFD_IDXCL_PC	Ineffective Amount (Dormant) in Position Currency, Index-Cln	decimal	21	2	CURR	((0))	Yes		FTI_INEFF_DORMANT_IDXCL_PC
68	PURCH_PC	Purchase Value in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_PURCH_PC
69	PURCH_VC	Purchase Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_PURCH_VC
70	PURCH_IDX_CLEAN	Purchase Value, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_PURCH_IDX_CLEAN
71	CHARGE_PC	Costs in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_CHARGE_PC
72	CHARGE_VC	Costs in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_CHARGE_VC
73	CHARGE_IDX_CLEAN	Costs, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_CHARGE_IDX_CLEAN
74	REPAYMENT_PC	Cumulative Repayment in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_REPAYMENT_PC
75	REPAYMENT_VC	Cumulative Repayment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_REPAYMENT_VC
76	REPAYMENT_IDXCL	Cumulative Repayment in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_REPAYMENT_IDX_CLEAN
77	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0	RAW		Yes		TPM_BUSTRANSID
78	STATE	Flag: Legacy Data Transferred	char	1	0	CHAR	(N' ')	Yes		TPM_TRDT_TRANS_FLG	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

78 COLUMNS | 1 INDEXES | ERP 6.0 | TRLT_INIT_SUB_SE TABLE

TOP ERP 6.0 | TRLT_INIT_SUB_SE COLUMNS

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

78 COLUMNS | 1 INDEXES | ERP 6.0 | TRLT_INIT_SUB_SE TABLE

TOPERP 6.0 | TRLT_INIT_SUB_SE COLUMNS

TOPERP 6.0 | TRLT_INIT_SUB_SE INDEXES

TOP ERP 6.0 | TRLT_INIT_SUB_SE COLUMNS

TOP ERP 6.0 | TRLT_INIT_SUB_SE INDEXES