SAP ABAP Table VTSL_VTBLSP_ALV (Limit Keys + Business Partner Data + Characteristic Texts)

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	VTSL_VTBLSP_ALV	Table Relationship Diagram
Short Description	Limit Keys + Business Partner Data + Characteristic Texts

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	T000
2	SLA	☐	TB_SLA	T_SLA	CHAR	3	0	Limit Type	ATLA
3	RLV	☐	TB_RLV	T_RLV	NUMC	20	0	Number of Limit Record
4	SLH	☐	TB_SLH	NUMC2	NUMC	2	0	Hierarchy Level of Limit Record
5	.INCLUDE	☐				0	0	Limit Characteristics with Append Structure
6	.INCLUDE	☐				0	0	Limit features
7	.INCLUDE	☐				0	0	direct limit characteristics
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
10	SLPG	☐	TB_SLPG	T_SLPG	CHAR	3	0	Limit Product Group	ATLPG
11	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
12	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
13	WAERS	☐	TB_WCHAR	WAERS	CUKY	5	0	Currency as Limit Characteristic	TCURC
14	CONTROL01	☐	TB_CONTROL	CHAR10	CHAR	10	0	Monitoring Unit
15	INTORG	☐	TB_INTORGUNIT	KL_INTORG	CHAR	10	0	Internal Organizational Unit	KLINTORG
16	RCOUNTRY	☐	TB_RISKCOUNTRY	LAND1	CHAR	3	0	Relevant Country for Country Risk	T005
17	.INCLUDE	☐				0	0
18	.INCLUDE	☐				0	0	derived limit characteristics
19	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
20	SECTOR	☐	TB_INDSECT	BU_INDSECTOR	CHAR	10	0	Industry of Business Partner	TB038A
21	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
22	CRATING	☐	TB_COUNTRYRATING	KL_CRATING	CHAR	5	0	Country Rating	KLLRDEF01
23	.INCLUDE	☐				0	0	Limit characteristics that can be defined by the customer
24	RCID01	☐	TB_RCID01	TB_RCID	CHAR	5	0	Country Group	VTBLMCID
25	RCID02	☐	TB_RCID02	TB_RCID	CHAR	5	0	Maturity Band in Credit Limit	VTBLMCID
26	RCID03	☐	TB_RCID03	TB_RCID	CHAR	5	0	Free Characteristic 03	VTBLMCID
27	RCID04	☐	TB_RCID04	TB_RCID	CHAR	5	0	Free Characteristic 04	VTBLMCID
28	RCID05	☐	TB_RCID05	TB_RCID	CHAR	5	0	Free Characteristic 05	VTBLMCID
29	RCID06	☐	TB_RCID06	TB_RCID	CHAR	5	0	Free Characteristic 06	VTBLMCID
30	RCID07	☐	TB_RCID07	TB_RCID	CHAR	5	0	Free Characteristic 07	VTBLMCID
31	RCID08	☐	TB_RCID08	TB_RCID	CHAR	5	0	Free Characteristic 08	VTBLMCID
32	RCID09	☐	TB_RCID09	TB_RCID	CHAR	5	0	Free Characteristic 09	VTBLMCID
33	RCID10	☐	TB_RCID10	TB_RCID	CHAR	5	0	Free Characteristic 10	VTBLMCID
34	RCID11	☐	TB_RCID11	TB_RCID	CHAR	5	0	Free Characteristic 11	VTBLMCID
35	RCID12	☐	TB_RCID12	TB_RCID	CHAR	5	0	Free Characteristic 12	VTBLMCID
36	RCID13	☐	TB_RCID13	TB_RCID	CHAR	5	0	Free Characteristic 13	VTBLMCID
37	RCID14	☐	TB_RCID14	TB_RCID	CHAR	5	0	Free Characteristic 14	VTBLMCID
38	RCID15	☐	TB_RCID15	TB_RCID	CHAR	5	0	Free Characteristic 15	VTBLMCID
39	.INCLUDE	☐				0	0	Lock Information for Limits
40	LLOCK	☐	TB_LOCK	DATE	DATS	8	0	Lock Date
41	LLUSER	☐	TB_LUSER	XUBNAME	CHAR	12	0	Limit Locked By	USR02
42	NOTES_EXIST	☐	TB_NOTES_EXIST	XFELD	CHAR	1	0	Flag Showing if Notes Exist
43	XLA	☐	TB_XLA	TEXT30	CHAR	30	0	Name of Limit Type
44	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
45	LINEK	☐	LINES	LINES	CHAR	80	0	Address line
46	.INCLUDE	☐				0	0	Texts for Free Characteristic Values
47	XCID01	☐	TB_XCID01	TEXT30	CHAR	30	0	Description of Free Characteristic Value 01
48	XCID02	☐	TB_XCID02	TEXT30	CHAR	30	0	Description of Free Characteristic Value 02
49	XCID03	☐	TB_XCID03	TEXT30	CHAR	30	0	Description of Free Characteristic Value 03
50	XCID04	☐	TB_XCID04	TEXT30	CHAR	30	0	Description of Free Characteristic Value 04
51	XCID05	☐	TB_XCID05	TEXT30	CHAR	30	0	Description of Free Characteristic Value 05
52	XCID06	☐	TB_XCID06	TEXT30	CHAR	30	0	Description of Free Characteristic Value 06
53	XCID07	☐	TB_XCID07	TEXT30	CHAR	30	0	Description of Free Characteristic Value 07
54	XCID08	☐	TB_XCID08	TEXT30	CHAR	30	0	Description of Free Characteristic Value 08
55	XCID09	☐	TB_XCID09	TEXT30	CHAR	30	0	Description of Free Characteristic Value 09
56	XCID10	☐	TB_XCID10	TEXT30	CHAR	30	0	Description of Free Characteristic Value 10
57	XCID11	☐	TB_XCID11	TEXT30	CHAR	30	0	Description of Free Characteristic Value 11
58	XCID12	☐	TB_XCID12	TEXT30	CHAR	30	0	Description of Free Characteristic Value 12
59	XCID13	☐	TB_XCID13	TEXT30	CHAR	30	0	Description of Free Characteristic Value 13
60	XCID14	☐	TB_XCID14	TEXT30	CHAR	30	0	Description of Free Characteristic Value 14
61	XCID15	☐	TB_XCID15	TEXT30	CHAR	30	0	Description of Free Characteristic Value 15
62	NOTE_FLAG_H	☐	TB_NOTE_FLAG_H	ICON	CHAR	4	0	Indicator: Time-Independent Note Exists	*
63	LOCK_FLAG_H	☐	TB_LOCK_FLAG_H	ICON	CHAR	4	0	Indicator Showing that Limits are Locked	*
64	SLDFIL	☐	TB_SLDFIL	CHAR20	CHAR	20	0	Display Filter	ATLSF

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTSL_VTBLSP_ALV	BUKRS	T001	BUKRS		1	N
2	VTSL_VTBLSP_ALV	COUNTRY	T005	LAND1		1	N
3	VTSL_VTBLSP_ALV	CRATING	KLLRDEF01	CRATING
4	VTSL_VTBLSP_ALV	INTORG	KLINTORG	INTORG
5	VTSL_VTBLSP_ALV	LLUSER	USR02	BNAME		C	CN
6	VTSL_VTBLSP_ALV	MANDT	T000	MANDT		1	N
7	VTSL_VTBLSP_ALV	PARTNR	BUT000	PARTNER
8	VTSL_VTBLSP_ALV	RATING	TP06	RATING		1	N
9	VTSL_VTBLSP_ALV	RCID01	VTBLMCID	RCID		1	N
10	VTSL_VTBLSP_ALV	RCID02	VTBLMCID	RCID		1	N
11	VTSL_VTBLSP_ALV	RCID03	VTBLMCID	RCID		1	N
12	VTSL_VTBLSP_ALV	RCID04	VTBLMCID	RCID		1	N
13	VTSL_VTBLSP_ALV	RCID05	VTBLMCID	RCID		1	N
14	VTSL_VTBLSP_ALV	RCID06	VTBLMCID	RCID		1	N
15	VTSL_VTBLSP_ALV	RCID07	VTBLMCID	RCID		1	N
16	VTSL_VTBLSP_ALV	RCID08	VTBLMCID	RCID		1	N
17	VTSL_VTBLSP_ALV	RCID09	VTBLMCID	RCID		1	N
18	VTSL_VTBLSP_ALV	RCID10	VTBLMCID	RCID		1	N
19	VTSL_VTBLSP_ALV	RCID11	VTBLMCID	RCID		1	N
20	VTSL_VTBLSP_ALV	RCID12	VTBLMCID	RCID		1	N
21	VTSL_VTBLSP_ALV	RCID13	VTBLMCID	RCID		1	N
22	VTSL_VTBLSP_ALV	RCID14	VTBLMCID	RCID		1	N
23	VTSL_VTBLSP_ALV	RCID15	VTBLMCID	RCID		1	N
24	VTSL_VTBLSP_ALV	RCOUNTRY	T005	LAND1		1	N
25	VTSL_VTBLSP_ALV	RDEALER	TZDEA	RDEALER		1	N
26	VTSL_VTBLSP_ALV	RPORTB	TWPOB	RPORTB		1	N
27	VTSL_VTBLSP_ALV	SECTOR	TB038A	IND_SECTOR		1	N
28	VTSL_VTBLSP_ALV	SLA	ATLA	SLA	KEY	1	N
29	VTSL_VTBLSP_ALV	SLDFIL	ATLSF	SLDFIL		1	N
30	VTSL_VTBLSP_ALV	SLPG	ATLPG	SLPG		1	N
31	VTSL_VTBLSP_ALV	WAERS	TCURC	WAERS		1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in	462_10