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_VAL_SE	95	3	Initialization Values for TRL Positions: Securities	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	T000	MANDT	Allow NULL?
2	KEY_DATE	System Date	nvarchar	8	0	DATS	(N'00000000')	No		SYDATUM	Allow NULL?
3	SRC_VAL_AREA	Source Valuation Area for Initializing Another Val. Area	nvarchar	3	0	CHAR	(N' ')	No	*	TPM_SRC_VAL_AREA	Allow NULL?
4	COMPANY_CODE	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
5	VALUATION_AREA	Valuation Area	nvarchar	3	0	CHAR	(N' ')	No	TRGC_VAL_AREA	TPM_VAL_AREA	Allow NULL?
6	VALUATION_CLASS	Valuation Class	nvarchar	4	0	NUMC	(N'0000')	No	TRGC_VAL_CLASS	TPM_VAL_CLASS	Allow NULL?
7	SECURITY_ID	Security ID Number	nvarchar	13	0	CHAR	(N' ')	No	VWPANLA	VVRANLW	Allow NULL?
8	LOT_ID	Identifier of the Lot	varbinary	16	0	RAW		No		TPM_LOT_ID
9	SECURITY_ACCOUNT	Securities Account	nvarchar	10	0	CHAR	(N' ')	No	TWD01	RLDEPO	Allow NULL?
10	ACCOUNT_GROUP	Securities Account Group	nvarchar	10	0	CHAR	(N' ')	No	TRGT_SECACCGRP	TPM_SEC_ACCT_GRP	Allow NULL?
11	PORTFOLIO	Portfolio	nvarchar	10	0	CHAR	(N' ')	No	*	RPORTB	Allow NULL?
12	FUND	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	FM_FUND	Allow NULL?
13	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	No		GM_GRANT_NBR	Allow NULL?
14	POSITION_CURR	Position Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_POSITION_CURR	Allow NULL?
15	VALUATION_CURR	Valuation Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_VALUATION_CURR	Allow NULL?
16	ACTIVE_PASSIVE	Indicator: Assets/Liabilities Position	char	1	0	CHAR	(N' ')	Yes		TPM_ACTIVE_PASSIVE	Allow NULL?
17	UNITS	Units	decimal	22	6	DEC	((0))	Yes		TPM_UNITS
18	NOMINAL_AMT	Nominal Amount	decimal	21	2	CURR	((0))	Yes		TPM_NOMINAL_AMT
19	NOMINAL_ORG_AMT	Original Nominal Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_NOMINAL_ORG_AMT
20	NOMINAL_CURR	Nominal Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_NOMINAL_CURR	Allow NULL?
21	PURCH_PC	Purchase Value in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_PURCH_PC
22	PURCH_VC	Purchase Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_PURCH_VC
23	PURCH_IDX_CLEAN	Purchase Value, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_PURCH_IDX_CLEAN
24	CHARGE_PC	Costs in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_CHARGE_PC
25	CHARGE_VC	Costs in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_CHARGE_VC
26	CHARGE_IDX_CLEAN	Costs, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_CHARGE_IDX_CLEAN
27	VAL_TI_PC	Security Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_PC
28	VAL_TI_VC	Security Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_VC
29	VAL_TI_IDX_CLEAN	Security Valuation, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_IDX_CLEAN
30	VAL_FX_VC	Foreign Currency Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_FX_VC
31	VAL_IDX_PC	Index Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_PC
32	VAL_IDX_VC	Index Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_VC
33	VAL_CH_TI_PC	Valuation of Cap. Costs, Security, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_PC
34	VAL_CH_TI_VC	Valuation of Cap. Costs, Security, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_VC
35	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
36	VAL_CH_FX_VC	Valuation of Capitalized Costs, FX, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_FX_VC
37	VAL_AAV_FX_VC	FX Valuation of Amort.Acquisition Value in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_AAV_FX_VC
38	IMPAIRMENT_PC	Impairment in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_PC
39	IMPAIRMENT_VC	Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_VC
40	IMPAIRMENT_FX_VC	FX Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_FX_VC
41	IMPMT_IDX_CLEAN	Impairment in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_IDX_CLEAN
42	AMORT_PC	Amortization in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_PC
43	AMORT_VC	Amortization in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_VC
44	AMORT_IDX_CLEAN	Amortization, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_IDX_CLEAN
45	AMORT_NEG_SPR_PC	Amortization of Negotiation Spread in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_PC
46	AMORT_NEG_SPR_VC	Amortization of Negotiation Spread in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_VC
47	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
48	DISAGIO_PC	Discount/Premium in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_PC
49	DISAGIO_VC	Discount/Premium in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_VC
50	DISAGIO_IDXCL	Index-Clean Discount/Premium in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_IDX_CLEAN
51	VAL_TI_PC_NPL	Security Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_PC
52	VAL_TI_VC_NPL	Security Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_VC
53	VAL_IT_IDXCL_NPL	Security Valuation, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_IDX_CLEAN
54	VAL_FX_VC_NPL	Foreign Currency Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_FX_VC
55	VAL_IDX_PC_NPL	Index Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_PC
56	VAL_IDX_VC_NPL	Index Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_VC
57	VAL_CH_TI_PC_NPL	Valuation of Cap. Costs, Security, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_PC
58	VAL_CH_TI_VC_NPL	Valuation of Cap. Costs, Security, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_VC
59	VAL_CHTIIDXCLNPL	Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_IDX_CLEAN
60	VAL_CH_FX_VC_NPL	Valuation of Capitalized Costs, FX, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_FX_VC
61	ACC_INT_PC	Accrued Interest in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_PC
62	ACC_INT_VC	Accrued Interest in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_VC
63	ACC_INT_IDXCL	Accrued Interest in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_IDX_CLEAN
64	NGSPR_PC	Negotiation Spread in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_PC
65	NGSPR_VC	Negotiation Spread in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_VC
66	NGSPR_IDXCL	Negotiation Spread Index Clean	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_IDXCL
67	REPAYMENT_PC	Cumulative Repayment in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_REPAYMENT_PC
68	REPAYMENT_VC	Cumulative Repayment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_REPAYMENT_VC
69	REPAYMENT_IDXCL	Cumulative Repayment in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_REPAYMENT_IDX_CLEAN
70	VAD_GAIN_PC	Value Adjustment of Gains in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAD_GAIN_PC
71	VAD_GAIN_VC	Value Adjustment of Gains in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAD_GAIN_VC
72	VAD_LOSS_PC	Value Adjustment of Losses in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAD_LOSS_PC
73	VAD_LOSS_VC	Value Adjustment of Losses in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAD_LOSS_VC
74	ORIG_VAD_PC	Original Value Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ORIG_VAD_PC
75	ORIG_VAD_VC	Original Value Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_ORIG_VAD_VC
76	FLG_TRANS	Status of Flow Related to Migration to CFM 1.0	char	1	0	CHAR	(N' ')	Yes		TPM_MIGR_CFM10	Allow NULL?
77	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0	RAW		Yes		TPM_BUSTRANSID
78	HAMORT_PC	Hedge Amortization in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_HAMORT_PC
79	HAMORT_IDXCL_PC	Hedge Amortization in Position Crcy, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_HAMORT_INDX_PC
80	HAMORT_VC	Hedge Amortization in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_HAMORT_VC
81	HADJ_PC	Hedge Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_PC
82	HADJ_IDXCL_PC	Hedge Adjustment in Position Currency, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_INDX_PC
83	HADJ_VC	Hedge Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_VC
84	EFF_PC	Effective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_PC
85	EFF_VC	Effective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_VC
86	EFF_IDXCL_PC	Effective Amount in Position Currency, Index Clean	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_IDXCL_PC
87	INEFF_PC	Ineffective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_PC
88	INEFF_VC	Ineffective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_VC
89	INEFF_IDXCL_PC	Ineffective Amount in Position Currency, Index Clean	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_IDXCL_PC
90	EFFD_PC	Effective Amount (Dormant) in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_PC
91	EFFD_VC	Effective Amount (Dormant) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_VC
92	EFFD_IDXCL_PC	Effective Amount (Dormant) in Position Currency, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_IDXCL_PC
93	INEFFD_PC	Ineffective Amount (Dormant) in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_DORMANT_PC
94	INEFFD_VC	Ineffective Amount (Dormant) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_DORMANT_VC
95	INEFFD_IDXCL_PC	Ineffective Amount (Dormant) in Position Currency, Index-Cln	decimal	21	2	CURR	((0))	Yes		FTI_INEFF_DORMANT_IDXCL_PC

Name	Primary	Unique	Type	Columns
TRLT_INIT_VAL_SE00	No	No	NONCLUSTERED	MANDT, BUSTRANSID
TRLT_INIT_VAL_SE10	No	No	NONCLUSTERED	MANDT, COMPANY_CODE, VALUATION_AREA
TRLT_INIT_VAL_SE~0	Yes	Yes	CLUSTERED	MANDT, KEY_DATE, SRC_VAL_AREA, COMPANY_CODE, VALUATION_AREA, VALUATION_CLASS, SECURITY_ID, LOT_ID, SECURITY_ACCOUNT, ACCOUNT_GROUP, PORTFOLIO, FUND, GRANT_NBR

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

95 COLUMNS | 3 INDEXES | ERP 6.0 | TRLT_INIT_VAL_SE TABLE

TOP ERP 6.0 | TRLT_INIT_VAL_SE COLUMNS

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

95 COLUMNS | 3 INDEXES | ERP 6.0 | TRLT_INIT_VAL_SE TABLE

TOPERP 6.0 | TRLT_INIT_VAL_SE COLUMNS

TOPERP 6.0 | TRLT_INIT_VAL_SE INDEXES

TOP ERP 6.0 | TRLT_INIT_VAL_SE COLUMNS

TOP ERP 6.0 | TRLT_INIT_VAL_SE INDEXES