SAP ABAP Table VTBLMISIE (Limit: Single and Totals Recs: Charac., Util. and Glob.Coll.)

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	VTBLMISIE	Table Relationship Diagram
Short Description	Limit: Single and Totals Recs: Charac., Util. and Glob.Coll.

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 Utilization: Summarization per Limit Amount
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SLA	☐	TB_SLA	T_SLA	CHAR	3	0	Limit Type	ATLA
4	RLV	☐	TB_RLV	T_RLV	NUMC	20	0	Number of Limit Record
5	SLH	☐	TB_SLH	NUMC2	NUMC	2	0	Hierarchy Level of Limit Record
6	SLI	☐	TB_SLI	T_SLI	NUMC	1	0	Limit Utilization Status	ATLSLI
7	DLI	☐	TB_DLI	DATUM	DATS	8	0	Base Date for Determining Limit Utilization
8	VLI	☐	TB_VLI	DATUM	DATS	8	0	'Valid From' Date of the Limit Utilization
9	BLI	☐	TB_BLI_SUM	WERTV9	CURR	17	2	Limit Amount Utilized: Totals Record
10	CLI	☐	TB_CLI_SUM	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record
11	BLS	☐	TB_BLSS	WERTV9	CURR	17	2	Global Collateral Amount: Totals Record
12	WLI	☐	TB_WLIS	WAERS	CUKY	5	0	Currency of Utilization (Total)	TCURC
13	.INCLUDE	☐				0	0	Limit Characteristics with Append Structure
14	.INCLUDE	☐				0	0	Limit features
15	.INCLUDE	☐				0	0	direct limit characteristics
16	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
17	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
18	SLPG	☐	TB_SLPG	T_SLPG	CHAR	3	0	Limit Product Group	ATLPG
19	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
20	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
21	WAERS	☐	TB_WCHAR	WAERS	CUKY	5	0	Currency as Limit Characteristic	TCURC
22	CONTROL01	☐	TB_CONTROL	CHAR10	CHAR	10	0	Monitoring Unit
23	INTORG	☐	TB_INTORGUNIT	KL_INTORG	CHAR	10	0	Internal Organizational Unit	KLINTORG
24	RCOUNTRY	☐	TB_RISKCOUNTRY	LAND1	CHAR	3	0	Relevant Country for Country Risk	T005
25	.INCLUDE	☐				0	0
26	.INCLUDE	☐				0	0	derived limit characteristics
27	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
28	SECTOR	☐	TB_INDSECT	BU_INDSECTOR	CHAR	10	0	Industry of Business Partner	TB038A
29	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
30	CRATING	☐	TB_COUNTRYRATING	KL_CRATING	CHAR	5	0	Country Rating	KLLRDEF01
31	.INCLUDE	☐				0	0	Limit characteristics that can be defined by the customer
32	RCID01	☐	TB_RCID01	TB_RCID	CHAR	5	0	Country Group	VTBLMCID
33	RCID02	☐	TB_RCID02	TB_RCID	CHAR	5	0	Maturity Band in Credit Limit	VTBLMCID
34	RCID03	☐	TB_RCID03	TB_RCID	CHAR	5	0	Free Characteristic 03	VTBLMCID
35	RCID04	☐	TB_RCID04	TB_RCID	CHAR	5	0	Free Characteristic 04	VTBLMCID
36	RCID05	☐	TB_RCID05	TB_RCID	CHAR	5	0	Free Characteristic 05	VTBLMCID
37	RCID06	☐	TB_RCID06	TB_RCID	CHAR	5	0	Free Characteristic 06	VTBLMCID
38	RCID07	☐	TB_RCID07	TB_RCID	CHAR	5	0	Free Characteristic 07	VTBLMCID
39	RCID08	☐	TB_RCID08	TB_RCID	CHAR	5	0	Free Characteristic 08	VTBLMCID
40	RCID09	☐	TB_RCID09	TB_RCID	CHAR	5	0	Free Characteristic 09	VTBLMCID
41	RCID10	☐	TB_RCID10	TB_RCID	CHAR	5	0	Free Characteristic 10	VTBLMCID
42	RCID11	☐	TB_RCID11	TB_RCID	CHAR	5	0	Free Characteristic 11	VTBLMCID
43	RCID12	☐	TB_RCID12	TB_RCID	CHAR	5	0	Free Characteristic 12	VTBLMCID
44	RCID13	☐	TB_RCID13	TB_RCID	CHAR	5	0	Free Characteristic 13	VTBLMCID
45	RCID14	☐	TB_RCID14	TB_RCID	CHAR	5	0	Free Characteristic 14	VTBLMCID
46	RCID15	☐	TB_RCID15	TB_RCID	CHAR	5	0	Free Characteristic 15	VTBLMCID
47	.INCLUDE	☐				0	0	Object ID with Append Structure
48	TLI	☐	TB_TLI	TB_TLI	CHAR	2	0	Object Number Category in Limit Management
49	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
50	OBJTXT	☐	TB_OBJTXT	TEXT80	CHAR	80	0	Transaction description
51	CLI_IE	☐	TB_CLI	WERTV9	CURR	17	2	Single Transaction Commitment Amount
52	BLI_IE	☐	TB_BLIE	WERTV9	CURR	17	2	Limit Utilization Amount: Single Record
53	BLS_IE	☐	TB_BLSE	WERTV9	CURR	17	2	Global Collateral Amount: Single Record
54	COLI_IE	☐	TB_COLI	WERTV9	CURR	17	2	Collateral Amount For Single Transaction
55	WLI_IE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
56	KLI	☐	TB_KLI	UKURS	DEC	9	5	Exchange Rate for Limit Utilization
57	CLI_IE_VW	☐	TB_CLI_VW	WERTV9	CURR	17	2	Single Transaction Commitment Amount in Limit/Displ.Currency
58	BLI_IE_VW	☐	TB_BLI_VW	WERTV9	CURR	17	2	Limit Utilization Amount in Limit/Display Currency
59	BLS_IE_VW	☐	TB_BLSE_VW	WERTV9	CURR	17	2	Global Collateral Amount: Single Record in Limit/Eval. Crcy
60	COLI_IE_VW	☐	TB_COLI_VW	WERTV9	CURR	17	2	Collateral Amount for Single Trans. in Limit/Eval. Currency
61	WLI_IE_VW	☐	TB_WLIE_VW	WAERS	CUKY	5	0	Display Currency (Single Record)	*
62	SLP	☐	TB_SLP	DEC3_7	DEC	10	7	Percentage of Attribution
63	RLI	☐	TB_RLI	NUMC4	NUMC	4	0	Risk Commitment Period in Months
64	SLI_IE	☐	TB_SLI	T_SLI	NUMC	1	0	Limit Utilization Status	*
65	SLE	☐	TB_SLE	KL_DETPROC	NUMC	2	0	Determination Procedure for Limit Utilizations	*
66	DLIL	☐	TB_DLIL	DATUM	DATS	8	0	Evaluation Date for Limit Utilizations
67	TLIL	☐	TB_TLIL	UZEIT	TIMS	6	0	Time of Determination of Limit Utilizations

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in