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
1	ERP EHP7	6.0	TRDTT_VADATA_SEC	92	1	Valuation-Area-Dependent Data for Securities	Transaction Manager

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	KEY_DATE	Position Value Date	nvarchar	8	0	DATS	(N'00000000')	No		TPM_POSITION_DATE	Allow NULL?
3	COMPANY_CODE	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
4	COM_VAL_CLASS	General Valuation Class	nvarchar	4	0	NUMC	(N'0000')	No	TRGC_COM_VALCL	TPM_COM_VAL_CLASS	Allow NULL?
5	VALUATION_AREA	Valuation Area	nvarchar	3	0	CHAR	(N' ')	No	*	TPM_VAL_AREA	Allow NULL?
6	SECURITY_ID	Security ID Number	nvarchar	13	0	CHAR	(N' ')	No	*	VVRANLW	Allow NULL?
7	SECURITY_ACCOUNT	Securities Account	nvarchar	10	0	CHAR	(N' ')	No	*	RLDEPO	Allow NULL?
8	PORTFOLIO	Portfolio	nvarchar	10	0	CHAR	(N' ')	No	*	RPORTB	Allow NULL?
9	FUND	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	FM_FUND	Allow NULL?
10	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	No		GM_GRANT_NBR	Allow NULL?
11	POSNR	Item Number Legacy Data Transfer	nvarchar	8	0	NUMC	(N'00000000')	No		TPM_TRDT_POSNR	Allow NULL?
12	POSITION_CURR	Position Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TPM_POSITION_CURR	Allow NULL?
13	VALUATION_CURR	Valuation Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TPM_VALUATION_CURR	Allow NULL?
14	ACTIVE_PASSIVE	Indicator: Assets/Liabilities Position	char	1	0	CHAR	(N' ')	Yes		TPM_ACTIVE_PASSIVE	Allow NULL?
15	VAL_TI_PC	Security Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_PC
16	VAL_TI_VC	Security Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_VC
17	VAL_TI_IDX_CLEAN	Security Valuation, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_IDX_CLEAN
18	VAL_FX_VC	Foreign Currency Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_FX_VC
19	VAL_IDX_PC	Index Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_PC
20	VAL_IDX_VC	Index Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_VC
21	VAL_CH_TI_PC	Valuation of Cap. Costs, Security, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_PC
22	VAL_CH_TI_VC	Valuation of Cap. Costs, Security, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_TI_VC
23	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
24	VAL_CH_FX_VC	Valuation of Capitalized Costs, FX, in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_CH_FX_VC
25	VAL_AAV_FX_VC	FX Valuation of Amort.Acquisition Value in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		TPM_VAL_AAV_FX_VC
26	IMPAIRMENT_PC	Impairment in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_PC
27	IMPAIRMENT_VC	Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_VC
28	IMPMT_IDX_CLEAN	Impairment in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_IDX_CLEAN
29	IMPAIRMENT_FX_VC	FX Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_IMPAIRMENT_FX_VC
30	AMORT_PC	Amortization in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_PC
31	AMORT_VC	Amortization in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_VC
32	AMORT_IDX_CLEAN	Amortization, Index-Clean, in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_IDX_CLEAN
33	AMORT_NEG_SPR_PC	Amortization of Negotiation Spread in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_PC
34	AMORT_NEG_SPR_VC	Amortization of Negotiation Spread in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_AMORT_NEG_SPREAD_VC
35	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
36	DISAGIO_PC	Discount/Premium in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_PC
37	DISAGIO_VC	Discount/Premium in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_VC
38	DISAGIO_IDXCL	Index-Clean Discount/Premium in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_DISAGIO_IDX_CLEAN
39	VAL_TI_PC_NPL	Securities Valuation Not Affecting P/L in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_PC_NPL
40	VAL_TI_VC_NPL	Securities Valuation Not Affecting P/L in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_TI_VC_NPL
41	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
42	VAL_FX_VC_NPL	Forex Valuation Not Affecting P/L in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_FX_VC_NPL
43	VAL_IDX_PC_NPL	Index Valuation Not Affecting P/L in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_PC_NPL
44	VAL_IDX_VC_NPL	Index Valuation Not Affecting P/L in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_VAL_IDX_VC_NPL
45	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
46	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
47	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
48	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
49	ACC_INT_PC	Accrued Interest in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_PC
50	ACC_INT_VC	Accrued Interest in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_VC
51	ACC_INT_IDXCL	Accrued Interest in Position Currency Index-Clean	decimal	21	2	CURR	((0))	Yes		TPM_ACC_INTEREST_IDX_CLEAN
52	NGSPR_PC	Negotiation Spread in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_PC
53	NGSPR_VC	Negotiation Spread in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_VC
54	NGSPR_IDXCL	Negotiation Spread Index Clean	decimal	21	2	CURR	((0))	Yes		TPM_NGSPR_IDXCL
55	ACCR_PC	Accrual/Deferral in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACCR_PC
56	ACCR_VC	Accrual/Deferral in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACCR_VC
57	ACCR_IDX_CLEAN	Accrual/Deferral (1) Index Clean in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACCR_IDX_CLEAN
58	ACCR2_PC	Accrual/Deferral (2) in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACCR2_PC
59	ACCR2_VC	Accrual/Deferral (2) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACCR2_VC
60	ACCR2_IDX_CLEAN	Accrual/Deferral (2) Index Clean in Position Currency	decimal	21	2	CURR	((0))	Yes		TPM_ACCR2_IDX_CLEAN
61	RESET_VAL	Valuation with Reset	char	1	0	CHAR	(N' ')	Yes		TPM_TRDT_RESET_VAL	Allow NULL?
62	RESET_AMORT	Amortization with Reset	char	1	0	CHAR	(N' ')	Yes		TPM_TRDT_RESET_AMORT	Allow NULL?
63	RESET_ACCR	Accrual/Deferral with Reset	char	1	0	CHAR	(N' ')	Yes		TPM_TRDT_RESET_ACCR	Allow NULL?
64	RESET_KEY_DATE	Key Date for Reset within Legacy Data Transfer	nvarchar	8	0	DATS	(N'00000000')	Yes		TPM_TRDT_RESET_KEYDATE	Allow NULL?
65	RESET_IMP	Impairment with Reset	char	1	0	CHAR	(N' ')	Yes		TPM_TRDT_RESET_IMP	Allow NULL?
66	DEAL_NUMBER	Financial Transaction	nvarchar	13	0	CHAR	(N' ')	Yes	*	TB_RFHA	Allow NULL?
67	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0	RAW		Yes		TPM_BUSTRANSID
68	TRANS_FLG	Flag: Legacy Data Transferred	char	1	0	CHAR	(N' ')	Yes		TPM_TRDT_TRANS_FLG	Allow NULL?
69	HAMORT_PC	Hedge Amortization in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_HAMORT_PC
70	HAMORT_IDXCL_PC	Hedge Amortization in Position Crcy, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_HAMORT_INDX_PC
71	HAMORT_VC	Hedge Amortization in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_HAMORT_VC
72	HADJ_PC	Hedge Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_PC
73	HADJ_IDXCL_PC	Hedge Adjustment in Position Currency, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_INDX_PC
74	HADJ_VC	Hedge Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_HADJ_VC
75	EFF_PC	Effective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_PC
76	EFF_VC	Effective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_VC
77	EFF_IDXCL_PC	Effective Amount in Position Currency, Index Clean	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_IDXCL_PC
78	INEFF_PC	Ineffective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_PC
79	INEFF_VC	Ineffective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_VC
80	INEFF_IDXCL_PC	Ineffective Amount in Position Currency, Index Clean	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_IDXCL_PC
81	EFFD_PC	Effective Amount (Dormant) in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_PC
82	EFFD_VC	Effective Amount (Dormant) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_VC
83	EFFD_IDXCL_PC	Effective Amount (Dormant) in Position Currency, Index-Clean	decimal	21	2	CURR	((0))	Yes		FTI_EFFECTIVE_DORMANT_IDXCL_PC
84	INEFFD_PC	Ineffective Amount (Dormant) in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_DORMANT_PC
85	INEFFD_VC	Ineffective Amount (Dormant) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_INEFFECTIVE_DORMANT_VC
86	INEFFD_IDXCL_PC	Ineffective Amount (Dormant) in Position Currency, Index-Cln	decimal	21	2	CURR	((0))	Yes		FTI_INEFF_DORMANT_IDXCL_PC
87	ORIG_VAD_PC	Original Value Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_ORIG_VAD_PC
88	ORIG_VAD_VC	Original Value Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_ORIG_VAD_VC
89	VAD_GAIN_PC	Value Adjustment of Gains in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_VAD_GAIN_PC
90	VAD_GAIN_VC	Value Adjustment of Gains in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_VAD_GAIN_VC
91	VAD_LOSS_PC	Value Adjustment of Losses in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_VAD_LOSS_PC
92	VAD_LOSS_VC	Value Adjustment of Losses in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_VAD_LOSS_VC

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

92 COLUMNS | 1 INDEXES | ERP 6.0 | TRDTT_VADATA_SEC TABLE

TOP ERP 6.0 | TRDTT_VADATA_SEC COLUMNS

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

92 COLUMNS | 1 INDEXES | ERP 6.0 | TRDTT_VADATA_SEC TABLE

TOPERP 6.0 | TRDTT_VADATA_SEC COLUMNS

TOPERP 6.0 | TRDTT_VADATA_SEC INDEXES

TOP ERP 6.0 | TRDTT_VADATA_SEC COLUMNS

TOP ERP 6.0 | TRDTT_VADATA_SEC INDEXES