SAP ABAP Table VTVES_LI (Limits & Limit Utilizations: Single Records)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-RA-CL (Application Component) Default Risk and Limit System
     ⤷ FTLM (Package) Financial Services: Limit Management

Basic Data

Table Category	INTTAB	Structure
Structure	VTVES_LI	Table Relationship Diagram
Short Description	Limits & Limit Utilizations: Single Records

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	.INCLUDE	☐				0	0	Limit Management: SAP Fields
2	.INCLUDE	☐				0	0	Limits
3	.INCLUDE	☐				0	0	Limits: Key Fields
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	.INCLUDE	☐				0	0	Limit Record Key
6	SLA	☐	TB_SLA	T_SLA	CHAR	3	0	Limit Type	ATLA
7	RLV	☐	TB_RLV	T_RLV	NUMC	20	0	Number of Limit Record	VTBLS
8	SLH	☐	TB_SLH	NUMC2	NUMC	2	0	Hierarchy Level of Limit Record	VTBLS
9	DLVB	☐	TB_DLVB	DATUM	DATS	8	0	Limit Valid From
10	DLVE	☐	TB_DLVE	DATUM	DATS	8	0	Limit Valid To
11	BLIMIT	☐	TB_BLIMIT	T_BLV	CURR	17	2	Internal Limit Amount
12	ELIMIT	☐	TB_ELIMIT	T_BLV	CURR	17	2	External Limit Amount
13	WLIMIT	☐	TB_WLIMIT	WAERS	CUKY	5	0	Limit Currency	TCURC
14	PROZLIMIT	☐	TB_PROZLIMIT	DEC3_2	DEC	5	2	Critical Limit Utilization in Percent
15	COMPERD	☐	TB_COMPERD	NUMC4	NUMC	4	0	Maximum Risk Commitment Period in Months
16	VLO	☐	TB_VLO	TB_VLO	NUMC	1	0	Origin of Limit
17	RELSTATE	☐	TB_RELSTATE	TB_RELSTATE	CHAR	1	0	Release Status of a Limit
18	RELUSER	☐	TB_RELUSER	XUBNAME	CHAR	12	0	Last User to Change the Release Status of a Limit	USR02
19	RESUBDATE	☐	TB_RESUBDATE	DATUM	DATS	8	0	Review Date for Limit
20	RESUBUSER	☐	TB_RESUBUSER	XUBNAME	CHAR	12	0	User who is to review the limit	USR02
21	ARSMD	☐	TB_ARSMD	XFELD	CHAR	1	0	Flag for Automatically-Determined Review Date
22	NOTES_EXIST	☐	TB_NOTES_EXIST	XFELD	CHAR	1	0	Flag Showing if Notes Exist
23	INFINITE	☐	TB_LIMIT_INFINITE	TB_LIMIT_INFINITE	CHAR	1	0	Indicator: Do Not Check Limit
24	EDLVE	☐	TB_EDLVE	DATUM	DATS	8	0	External Validity End Date of Limit
25	.INCLUDE	☐				0	0	direct limit characteristics
26	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
27	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
28	SLPG	☐	TB_SLPG	T_SLPG	CHAR	3	0	Limit Product Group	ATLPG
29	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
30	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
31	WAERS	☐	TB_WCHAR	WAERS	CUKY	5	0	Currency as Limit Characteristic	TCURC
32	CONTROL01	☐	TB_CONTROL	CHAR10	CHAR	10	0	Monitoring Unit
33	INTORG	☐	TB_INTORGUNIT	KL_INTORG	CHAR	10	0	Internal Organizational Unit	KLINTORG
34	RCOUNTRY	☐	TB_RISKCOUNTRY	LAND1	CHAR	3	0	Relevant Country for Country Risk	T005
35	.INCLUDE	☐				0	0
36	.INCLUDE	☐				0	0	derived limit characteristics
37	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
38	SECTOR	☐	TB_INDSECT	BU_INDSECTOR	CHAR	10	0	Industry of Business Partner	TB038A
39	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
40	CRATING	☐	TB_COUNTRYRATING	KL_CRATING	CHAR	5	0	Country Rating	KLLRDEF01
41	.INCLUDE	☐				0	0	Lock Information for Limits
42	LLOCK	☐	TB_LOCK	DATE	DATS	8	0	Lock Date
43	LLUSER	☐	TB_LUSER	XUBNAME	CHAR	12	0	Limit Locked By	USR02
44	SLI	☐	TB_SLI	T_SLI	NUMC	1	0	Limit Utilization Status	ATLSLI
45	VLI	☐	TB_VLI	DATUM	DATS	8	0	'Valid From' Date of the Limit Utilization
46	BLI	☐	TB_BLI_SUM	WERTV9	CURR	17	2	Limit Amount Utilized: Totals Record
47	CLI	☐	TB_CLI_SUM	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record
48	BLS	☐	TB_BLSS	WERTV9	CURR	17	2	Global Collateral Amount: Totals Record
49	WLI	☐	TB_WLIS	WAERS	CUKY	5	0	Currency of Utilization (Total)	TCURC
50	COMPERD_DEC	☐	TB_COMPERD_DEC	DEC4	DEC	4	0	Maximum Risk Commitment Period in Months
51	.INCLUDE	☐				0	0	Limit Management: SAP Single Record Fields
52	SLE	☐	TB_SLE	KL_DETPROC	NUMC	2	0	Determination Procedure for Limit Utilizations	KLEVDEF
53	TLI	☐	TB_TLI	TB_TLI	CHAR	2	0	Object Number Category in Limit Management
54	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
55	BLI_IE	☐	TB_BLIE	WERTV9	CURR	17	2	Limit Utilization Amount: Single Record
56	CLI_IE	☐	TB_CLI	WERTV9	CURR	17	2	Single Transaction Commitment Amount
57	BLS_IE	☐	TB_BLSE	WERTV9	CURR	17	2	Global Collateral Amount: Single Record
58	WLI_IE	☐	TB_WLIE	WAERS	CUKY	5	0	Transaction Currency	TCURC
59	SLP_IE	☐	TB_SLP	DEC3_7	DEC	10	7	Percentage of Attribution
60	RLI_IE	☐	TB_RLI	NUMC4	NUMC	4	0	Risk Commitment Period in Months
61	RLI_IE_DEC	☐	TB_RLI_DEC	DEC4	DEC	4	0	Risk Commitment Period in Months
62	COLI_IE	☐	TB_COLI	WERTV9	CURR	17	2	Collateral Amount For Single Transaction
63	.INCLUDE	☐				0	0	Limit characteristics that can be defined by the customer
64	RCID01	☐	TB_RCID01	TB_RCID	CHAR	5	0	Country Group	VTBLMCID
65	RCID02	☐	TB_RCID02	TB_RCID	CHAR	5	0	Maturity Band in Credit Limit	VTBLMCID
66	RCID03	☐	TB_RCID03	TB_RCID	CHAR	5	0	Free Characteristic 03	VTBLMCID
67	RCID04	☐	TB_RCID04	TB_RCID	CHAR	5	0	Free Characteristic 04	VTBLMCID
68	RCID05	☐	TB_RCID05	TB_RCID	CHAR	5	0	Free Characteristic 05	VTBLMCID
69	RCID06	☐	TB_RCID06	TB_RCID	CHAR	5	0	Free Characteristic 06	VTBLMCID
70	RCID07	☐	TB_RCID07	TB_RCID	CHAR	5	0	Free Characteristic 07	VTBLMCID
71	RCID08	☐	TB_RCID08	TB_RCID	CHAR	5	0	Free Characteristic 08	VTBLMCID
72	RCID09	☐	TB_RCID09	TB_RCID	CHAR	5	0	Free Characteristic 09	VTBLMCID
73	RCID10	☐	TB_RCID10	TB_RCID	CHAR	5	0	Free Characteristic 10	VTBLMCID
74	RCID11	☐	TB_RCID11	TB_RCID	CHAR	5	0	Free Characteristic 11	VTBLMCID
75	RCID12	☐	TB_RCID12	TB_RCID	CHAR	5	0	Free Characteristic 12	*
76	RCID13	☐	TB_RCID13	TB_RCID	CHAR	5	0	Free Characteristic 13	*
77	RCID14	☐	TB_RCID14	TB_RCID	CHAR	5	0	Free Characteristic 14	*
78	RCID15	☐	TB_RCID15	TB_RCID	CHAR	5	0	Free Characteristic 15	*
79	ACID01	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
80	ACID02	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
81	ACID03	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
82	ACID04	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
83	ACID05	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
84	ACID06	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
85	ACID07	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
86	ACID08	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
87	ACID09	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
88	ACID10	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	VTBLMCID0
89	ACID11	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	*
90	ACID12	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	*
91	ACID13	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	*
92	ACID14	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	*
93	ACID15	☐	TB_ACID	TB_ACID	NUMC	2	0	Customer characteristic ID	*
94	DLI	☐	TB_DLI	DATUM	DATS	8	0	Base Date for Determining Limit Utilization
95	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
96	.INCLUDE	☐				0	0	Key Figures for Limit Management in Display Currency
97	BLI_IE_AW	☐	FTLI_BLIE	WERTV9	CURR	17	2	Limit Utilization for Transaction in Display Currency
98	BLI_AW	☐	FTLI_BLI	WERTV9	CURR	17	2	Limit Utilization in Display Currency
99	BLIMIT_AW	☐	FTLI_BLIMIT	T_BLV	CURR	17	2	Internal Limit Amount in Display Currency
100	ELIMIT_AW	☐	FTLI_ELIMIT	T_BLV	CURR	17	2	External Limit Amount in Display Currency
101	CLI_IE_AW	☐	FTLI_CLIE	WERTV9	CURR	17	2	Single Transaction Commitment Amount in Display Currency
102	BLS_IE_AW	☐	FTLI_BLSE	WERTV9	CURR	17	2	Global Collateral Amount in Single Record in Display Crcy
103	CLI_AW	☐	FTLI_CLI	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record in DC
104	BLS_AW	☐	FTLI_BLS	WERTV9	CURR	17	2	Global Collateral Amount: Totals Record in Display Currency
105	COLI_IE_AW	☐	FTLI_COLIE	WERTV9	CURR	17	2	Collateral Amount for Single Transaction in Display Currency
106	.INCLUDE	☐				0	0	Limit Management: Additional Selections
107	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	*
108	SLDFIL	☐	TB_SLDFIL	CHAR20	CHAR	20	0	Display Filter

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVES_LI	ACID01	VTBLMCID0	ACID		C	CN
2	VTVES_LI	ACID02	VTBLMCID0	ACID		C	CN
3	VTVES_LI	ACID03	VTBLMCID0	ACID		C	CN
4	VTVES_LI	ACID04	VTBLMCID0	ACID		C	CN
5	VTVES_LI	ACID05	VTBLMCID0	ACID		C	CN
6	VTVES_LI	ACID06	VTBLMCID0	ACID		C	CN
7	VTVES_LI	ACID07	VTBLMCID0	ACID		C	CN
8	VTVES_LI	ACID08	VTBLMCID0	ACID		C	CN
9	VTVES_LI	ACID09	VTBLMCID0	ACID		C	CN
10	VTVES_LI	ACID10	VTBLMCID0	ACID		C	CN
11	VTVES_LI	ANZGW	TCURC	WAERS		C	CN
12	VTVES_LI	BUKRS	T001	BUKRS		1	N
13	VTVES_LI	COUNTRY	T005	LAND1		1	N
14	VTVES_LI	CRATING	KLLRDEF01	CRATING		1	N
15	VTVES_LI	INTORG	KLINTORG	INTORG
16	VTVES_LI	LLUSER	USR02	BNAME		C	CN
17	VTVES_LI	MANDT	T000	MANDT		1	N
18	VTVES_LI	PARTNR	BUT000	PARTNER
19	VTVES_LI	RATING	TP06	RATING		1	N
20	VTVES_LI	RCID01	VTBLMCID	RCID		C	CN
21	VTVES_LI	RCID02	VTBLMCID	RCID		C	CN
22	VTVES_LI	RCID03	VTBLMCID	RCID		C	CN
23	VTVES_LI	RCID04	VTBLMCID	RCID		C	CN
24	VTVES_LI	RCID05	VTBLMCID	RCID		C	CN
25	VTVES_LI	RCID06	VTBLMCID	RCID		C	CN
26	VTVES_LI	RCID07	VTBLMCID	RCID		C	CN
27	VTVES_LI	RCID08	VTBLMCID	RCID		C	CN
28	VTVES_LI	RCID09	VTBLMCID	RCID
29	VTVES_LI	RCID10	VTBLMCID	RCID		C	CN
30	VTVES_LI	RCID11	VTBLMCID	RCID		C	CN
31	VTVES_LI	RCOUNTRY	T005	LAND1		1	N
32	VTVES_LI	RDEALER	TZDEA	RDEALER		1	N
33	VTVES_LI	RELUSER	USR02	BNAME		C	CN
34	VTVES_LI	RESUBUSER	USR02	BNAME
35	VTVES_LI	RLV	VTBLS	SLA		1	N
36	VTVES_LI	RPORTB	TWPOB	RPORTB		1	N
37	VTVES_LI	SECTOR	TB038A	IND_SECTOR		1	N
38	VTVES_LI	SLA	ATLA	SLA		1	N
39	VTVES_LI	SLE	KLEVDEF	ERMVERF		C	CN
40	VTVES_LI	SLH	VTBLS	RLV		1	N
41	VTVES_LI	SLI	ATLSLI	SLI
42	VTVES_LI	SLPG	ATLPG	SLPG		1	N
43	VTVES_LI	WAERS	TCURC	WAERS		1	N
44	VTVES_LI	WLI	TCURC	WAERS		C	CN
45	VTVES_LI	WLIMIT	TCURC	WAERS		1	N
46	VTVES_LI	WLI_IE	TCURC	WAERS		C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in