SAP ABAP Table STR_BW_LIMIT_EXP (Structure: Limits and Utilizations)

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	STR_BW_LIMIT_EXP	Table Relationship Diagram
Short Description	Structure: Limits and Utilizations

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	Structure: Limits and Utilizations
2	SLA	☐	TB_SLA	T_SLA	CHAR	3	0	Limit Type	*
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	DLVB	☐	TB_DLVB	DATUM	DATS	8	0	Limit Valid From
6	DLVE	☐	TB_DLVE	DATUM	DATS	8	0	Limit Valid To
7	BLIMIT	☐	TB_BLIMIT	T_BLV	CURR	17	2	Internal Limit Amount
8	ELIMIT	☐	TB_ELIMIT	T_BLV	CURR	17	2	External Limit Amount
9	WLIMIT	☐	TB_WLIMIT	WAERS	CUKY	5	0	Limit Currency	*
10	PROZLIMIT	☐	TB_PROZLIMIT	DEC3_2	DEC	5	2	Critical Limit Utilization in Percent
11	COMPERD	☐	TB_COMPERD	NUMC4	NUMC	4	0	Maximum Risk Commitment Period in Months
12	VLO	☐	TB_VLO	TB_VLO	NUMC	1	0	Origin of Limit
13	RELSTATE	☐	TB_RELSTATE	TB_RELSTATE	CHAR	1	0	Release Status of a Limit
14	RELUSER	☐	TB_RELUSER	XUBNAME	CHAR	12	0	Last User to Change the Release Status of a Limit	*
15	RESUBDATE	☐	TB_RESUBDATE	DATUM	DATS	8	0	Review Date for Limit
16	RESUBUSER	☐	TB_RESUBUSER	XUBNAME	CHAR	12	0	User who is to review the limit	*
17	ARSMD	☐	TB_ARSMD	XFELD	CHAR	1	0	Flag for Automatically-Determined Review Date
18	NOTES_EXIST	☐	TB_NOTES_EXIST	XFELD	CHAR	1	0	Flag Showing if Notes Exist
19	INFINITE	☐	TB_LIMIT_INFINITE	TB_LIMIT_INFINITE	CHAR	1	0	Indicator: Do Not Check Limit
20	EDLVE	☐	TB_EDLVE	DATUM	DATS	8	0	External Validity End Date of Limit
21	LLOCK	☐	TB_LOCK	DATE	DATS	8	0	Lock Date
22	LLUSER	☐	TB_LUSER	XUBNAME	CHAR	12	0	Limit Locked By	*
23	SLI	☐	TB_SLI	T_SLI	NUMC	1	0	Limit Utilization Status	*
24	DLI	☐	TB_DLI	DATUM	DATS	8	0	Base Date for Determining Limit Utilization
25	VLI	☐	TB_VLI	DATUM	DATS	8	0	'Valid From' Date of the Limit Utilization
26	CLI	☐	TB_CLI_SUM	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record
27	BLI	☐	TB_BLI_SUM	WERTV9	CURR	17	2	Limit Amount Utilized: Totals Record
28	BLS	☐	TB_BLSS	WERTV9	CURR	17	2	Global Collateral Amount: Totals Record
29	CLI_VW	☐	TB_CLI_SUM_VW	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record in LC/EC
30	BLI_VW	☐	TB_BLI_SUM_VW	WERTV9	CURR	17	2	Limit Utilization Amount: Totals Record in Limit/Displ. Crcy
31	BLS_VW	☐	TB_BLSS_VW	WERTV9	CURR	17	2	Total Global Collateral Amount: Totals Record in LC/EC
32	WLI	☐	TB_WLIS	WAERS	CUKY	5	0	Currency of Utilization (Total)	*
33	COMPERD_DEC	☐	TB_COMPERD_DEC	DEC4	DEC	4	0	Maximum Risk Commitment Period in Months
34	FLI	☐	TB_BDELTA	WERTV9	CURR	17	2	Available Limit Amount
35	QLI	☐	TB_QLI	DEC8_2	DEC	10	2	Limit Utilization in Percent
36	LIMIT_TYPE_TXT	☐	TB_XLA	TEXT30	CHAR	30	0	Name of Limit Type
37	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
38	LINEK	☐	DTE_REP_BW_ADDR60		CHAR	60	0	Address Line
39	NOTE_FLAG_H	☐	TB_NOTE_FLAG_H	ICON	CHAR	4	0	Indicator: Time-Independent Note Exists	*
40	LOCK_FLAG_H	☐	TB_LOCK_FLAG_H	ICON	CHAR	4	0	Indicator Showing that Limits are Locked	*
41	DETERM_METH	☐	TB_SLE	KL_DETPROC	NUMC	2	0	Determination Procedure for Limit Utilizations	*
42	LIGHT	☐	DTE_REP_BW_LIGHT	ICON	CHAR	4	0	Traffic Light Icon	*
43	RELTEXT	☐	TB_RELTEXT	CHAR12	CHAR	12	0	Text for Release Status
44	CONSEXC	☐	TB_CONSEXC	XFELD	CHAR	1	0	Red Traffic Light When Limit Exceeded
45	CONSRBD	☐	TB_CONSRBD	XFELD	CHAR	1	0	Red Traffic Light When Risk Commitment Period Exceeded
46	EMPTYLI	☐	TB_EMPTYLI	XFELD	CHAR	1	0	Limits Without Utilizations
47	DATEEMPTY	☐	TB_DATEEMPTY	DATUM	DATS	8	0	Start of Validity Period for Limits w/o Utilizations
48	ACTDATE	☐	TB_ACTDATE	XFELD	CHAR	1	0	Latest Determination Date per Limit Type
49	CALCHECK	☐	TB_CALCHECK	XFELD	CHAR	1	0	Compare with Factory Calendar
50	ROUND	☐	TB_ROUND	ROUND	CHAR	1	0	Rounding Control for Amount Fields
51	EXONLY	☐	TB_EXONLY	XFELD	CHAR	1	0	Only Exceeded Limits
52	EXPLUS	☐	TB_EXPLUS	XFELD	CHAR	1	0	Exceeded Limits and Analagous Characteristic Combinations
53	DISP_CURR	☐	TB_DISP_CURR	WAERS	CUKY	5	0	Display Currency	TCURC
54	.INCLUDE	☐				0	0	Limit Characteristics with Append Structure
55	.INCLUDE	☐				0	0	Limit features
56	.INCLUDE	☐				0	0	direct limit characteristics
57	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
58	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
59	SLPG	☐	TB_SLPG	T_SLPG	CHAR	3	0	Limit Product Group	ATLPG
60	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
61	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
62	WAERS	☐	TB_WCHAR	WAERS	CUKY	5	0	Currency as Limit Characteristic	TCURC
63	CONTROL01	☐	TB_CONTROL	CHAR10	CHAR	10	0	Monitoring Unit
64	INTORG	☐	TB_INTORGUNIT	KL_INTORG	CHAR	10	0	Internal Organizational Unit	KLINTORG
65	RCOUNTRY	☐	TB_RISKCOUNTRY	LAND1	CHAR	3	0	Relevant Country for Country Risk	T005
66	.INCLUDE	☐				0	0
67	.INCLUDE	☐				0	0	derived limit characteristics
68	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
69	SECTOR	☐	TB_INDSECT	BU_INDSECTOR	CHAR	10	0	Industry of Business Partner	TB038A
70	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
71	CRATING	☐	TB_COUNTRYRATING	KL_CRATING	CHAR	5	0	Country Rating	KLLRDEF01
72	.INCLUDE	☐				0	0	Limit characteristics that can be defined by the customer
73	RCID01	☐	TB_RCID01	TB_RCID	CHAR	5	0	Country Group	VTBLMCID
74	RCID02	☐	TB_RCID02	TB_RCID	CHAR	5	0	Maturity Band in Credit Limit	VTBLMCID
75	RCID03	☐	TB_RCID03	TB_RCID	CHAR	5	0	Free Characteristic 03	VTBLMCID
76	RCID04	☐	TB_RCID04	TB_RCID	CHAR	5	0	Free Characteristic 04	VTBLMCID
77	RCID05	☐	TB_RCID05	TB_RCID	CHAR	5	0	Free Characteristic 05	VTBLMCID
78	RCID06	☐	TB_RCID06	TB_RCID	CHAR	5	0	Free Characteristic 06	VTBLMCID
79	RCID07	☐	TB_RCID07	TB_RCID	CHAR	5	0	Free Characteristic 07	VTBLMCID
80	RCID08	☐	TB_RCID08	TB_RCID	CHAR	5	0	Free Characteristic 08	VTBLMCID
81	RCID09	☐	TB_RCID09	TB_RCID	CHAR	5	0	Free Characteristic 09	VTBLMCID
82	RCID10	☐	TB_RCID10	TB_RCID	CHAR	5	0	Free Characteristic 10	VTBLMCID
83	RCID11	☐	TB_RCID11	TB_RCID	CHAR	5	0	Free Characteristic 11	VTBLMCID
84	RCID12	☐	TB_RCID12	TB_RCID	CHAR	5	0	Free Characteristic 12	VTBLMCID
85	RCID13	☐	TB_RCID13	TB_RCID	CHAR	5	0	Free Characteristic 13	VTBLMCID
86	RCID14	☐	TB_RCID14	TB_RCID	CHAR	5	0	Free Characteristic 14	VTBLMCID
87	RCID15	☐	TB_RCID15	TB_RCID	CHAR	5	0	Free Characteristic 15	VTBLMCID

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	500