SAP ABAP Table VTG_REP_LEND_SEC_YIELD (Results of SL Reporting)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_LENDING (Package) CFM-TM: Securities Lending

Basic Data

Table Category	INTTAB	Structure
Structure	VTG_REP_LEND_SEC_YIELD	Table Relationship Diagram
Short Description	Results of SL Reporting

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	ICON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
3	VALID	☐	TB_ICON_TEXT	SYCHAR132	CHAR	132	0	Status of Currency Conversion in Display Currency
4	COVER	☐	TB_COVER_IC	CHAR132	CHAR	132	0	Collateral Ratio
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
7	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
8	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
9	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
10	SGSARTTXT	☐	TB_VVSART_TXT	TEXT30	CHAR	30	0	Name of Product Type
11	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
12	SFHAARTTXT	☐	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
13	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
14	XFGZUSTT	☐	TB_XTTEXT	TEXT30	CHAR	30	0	Name of activity category
15	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
16	XLDEPO	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
17	RLDEPO2	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
18	XLDEPO2	☐	XLDEPO	XLDEPO	CHAR	30	0	Securities account ID
19	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
20	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
21	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
22	CRUSER	☐	CRUSER	UNAME	CHAR	12	0	Created by
23	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
24	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
25	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
26	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
27	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
28	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
29	NORDEXT	☐	NORDEXT	CHAR20	CHAR	20	0	External order number
30	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
31	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
32	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
33	REFER	☐	REFER	REFER	CHAR	16	0	Reference
34	MERKM	☐	MERKM	MERKM	CHAR	25	0	Characteristics
35	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
36	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
37	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
38	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
39	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
40	GSART	☐	TB_VVSART	VVSART	CHAR	3	0	Product Type of Security	*
41	GSARTTXT	☐	TB_VVSART_TXT	TEXT30	CHAR	30	0	Name of Product Type
42	SANLF	☐	TB_SANLF2	VVSANLF	NUMC	3	0	Product Category of Security	TZAF
43	BNWHR	☐	TB_BNWHR	WERTV7	CURR	13	2	Nominal amount
44	WPRICE	☐	TB_WPRICE	WAERS	CUKY	5	0	Price currency	*
45	BPPRC	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
46	ASTUECK	☐	TB_ASTUECK	ASTUECK	DEC	15	5	No. of Units for Financial Instruments
47	BUPRC	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
48	SRUNIT	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
49	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
50	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
51	MARKET_PRC	☐	TB_MARKET_PRC	VVPKTKUR	DEC	15	6	Market Price
52	MARKET	☐	TB_MARKET		CURR	21	2	Market Value
53	MARKET_CURR	☐	TB_MARKET_CURR	WAERS	CUKY	5	0	Market Price Currency	*
54	MARKET_DIS	☐	TB_BZBETR_DIS	WERTV7	CURR	13	2	Market Value in Display Currency
55	MARKET_SE_CUM	☐	MARKET_SE_CUM	WERTV7	CURR	13	2	Market Value of Collateral in Display Currency (Cumulative)
56	COVERAGE	☐	TB_COVER	DEC5_2	DEC	7	2	Collateral Ratio in %
57	MARKET_CURR_DIS	☐	TB_WZBETR_DIS	WAERS	CUKY	5	0	Display Currency	*
58	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
59	DCRDAT_ERT	☐	TB_CRDAT	DATUM	DATS	8	0	Entered On
60	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
61	RFHAZB	☐	TB_RFHAZB	T_RFHAZB	NUMC	4	0	Transaction flow
62	SFHAZBA	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
63	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
64	RKOND	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
65	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
66	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
67	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
68	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
69	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
70	WBASIS	☐	TB_WBASIS	WAERS	CUKY	5	0	Currency of calculation basis	*
71	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
72	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
73	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
74	DZTERM	☐	TB_DZTERM	DATUM	DATS	8	0	Payment or Delivery Date
75	BZBETR_ERT	☐	TB_BZBETR_ERT	WERTV7	CURR	13	2	Securities Lending Revenue in Payment Currency
76	ACCR_TAGE	☐	ACCR_TAGE	INT6	NUMC	6	0	Accrual/Deferral Days
77	BZBETR_ERT_AB	☐	TB_BZBETR_ERT_AB	WERTV7	CURR	13	2	Lending Revenue (Accrued/Deferred) in Payment Currency
78	WZBETR_ERT	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
79	BZBETR_ERT_DIS	☐	TB_BZBETR_ERT_DIS	WERTV7	CURR	13	2	Securities Lending Revenue in Display Currency
80	BZBETR_ERT_AB_DIS	☐	TB_BZBETR_ERT_AB_DIS	WERTV7	CURR	13	2	Lending Revenue (Accrued/Deferred) in Display Currency
81	WZBETR_ERT_DIS	☐	TB_WZBETR_DIS	WAERS	CUKY	5	0	Display Currency	*
82	RANL_SE	☐	VVRANLW_SE	WP_RANL	CHAR	13	0	Security ID Number: Collateral	*
83	ASTUECK_SE	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
84	BNWHR_SE	☐	BNWHR_SE	WERTV7	CURR	13	2	Collateral Nominal Amount
85	SNWHR_SE	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	*
86	MARKET_PRC_SE	☐	MTB_MARKET_PRC_SE	VVPKTKUR	DEC	15	6	Market Price of Collateral
87	MARKET_SE	☐	MARKET_SE	WERTV7	CURR	13	2	Market Value of Collateral
88	MARKET_CURR_SE	☐	TB_MARKET_CURR	WAERS	CUKY	5	0	Market Price Currency	*
89	MARKET_SE_DIS	☐	MARKET_SE_DIS	WERTV7	CURR	13	2	Market Value of Collateral in Display Currency
90	MARKET_CURR_SE_DIS	☐	TB_WZBETR_DIS	WAERS	CUKY	5	0	Display Currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTG_REP_LEND_SEC_YIELD	SANLF	TZAF	SANLF	KEY	1	CN
2	VTG_REP_LEND_SEC_YIELD	WGSCHFT	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600