SAP ABAP Table KLSDCPROT3 (Log Gen. for Single Transaction Check: Result in ALV Format)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-RA-CL (Application Component) Default Risk and Limit System
     ⤷ FTBK (Package) Risk Management Counterparty/Issuer Risks

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	KLSDCPROT3	Table Relationship Diagram
Short Description	Log Gen. for Single Transaction Check: Result in ALV Format

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	CALLIDX	☑	KL_CALLIDX	KL_CALLIDX	NUMC	10	0	Run Number for Single Transaction Check Log
3	POSIDX	☑	KL_POSIDX	KL_POSIDX	NUMC	4	0	Item Index for Default Risk Items
4	.INCLUDE	☐				0	0	Credit Limit: Result of Single Transaction Check for ALV
5	.INCLUDE	☐				0	0	Credit Limit: Sing. Trans. Check Result: ALV Header + Char.
6	.INCLUDE	☐				0	0	Limit Record Key
7	SLA	☐	TB_SLA	T_SLA	CHAR	3	0	Limit Type	ATLA
8	RLV	☐	TB_RLV	T_RLV	NUMC	20	0	Number of Limit Record
9	SLH	☐	TB_SLH	NUMC2	NUMC	2	0	Hierarchy Level of Limit Record
10	.INCLUDE	☐				0	0	Lock Information for Limits
11	LLOCK	☐	TB_LOCK	DATE	DATS	8	0	Lock Date
12	LLUSER	☐	TB_LUSER	XUBNAME	CHAR	12	0	Limit Locked By	USR02
13	.INCLUDE	☐				0	0	Limit features
14	.INCLUDE	☐				0	0	direct limit characteristics
15	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
17	SLPG	☐	TB_SLPG	T_SLPG	CHAR	3	0	Limit Product Group	ATLPG
18	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
19	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
20	WAERS	☐	TB_WCHAR	WAERS	CUKY	5	0	Currency as Limit Characteristic	TCURC
21	CONTROL01	☐	TB_CONTROL	CHAR10	CHAR	10	0	Monitoring Unit
22	INTORG	☐	TB_INTORGUNIT	KL_INTORG	CHAR	10	0	Internal Organizational Unit	KLINTORG
23	RCOUNTRY	☐	TB_RISKCOUNTRY	LAND1	CHAR	3	0	Relevant Country for Country Risk	T005
24	.INCLUDE	☐				0	0
25	.INCLUDE	☐				0	0	derived limit characteristics
26	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
27	SECTOR	☐	TB_INDSECT	BU_INDSECTOR	CHAR	10	0	Industry of Business Partner	TB038A
28	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
29	CRATING	☐	TB_COUNTRYRATING	KL_CRATING	CHAR	5	0	Country Rating	KLLRDEF01
30	.INCLUDE	☐				0	0	Limit characteristics that can be defined by the customer
31	RCID01	☐	TB_RCID01	TB_RCID	CHAR	5	0	Country Group	VTBLMCID
32	RCID02	☐	TB_RCID02	TB_RCID	CHAR	5	0	Maturity Band in Credit Limit	VTBLMCID
33	RCID03	☐	TB_RCID03	TB_RCID	CHAR	5	0	Free Characteristic 03	VTBLMCID
34	RCID04	☐	TB_RCID04	TB_RCID	CHAR	5	0	Free Characteristic 04	VTBLMCID
35	RCID05	☐	TB_RCID05	TB_RCID	CHAR	5	0	Free Characteristic 05	VTBLMCID
36	RCID06	☐	TB_RCID06	TB_RCID	CHAR	5	0	Free Characteristic 06	VTBLMCID
37	RCID07	☐	TB_RCID07	TB_RCID	CHAR	5	0	Free Characteristic 07	VTBLMCID
38	RCID08	☐	TB_RCID08	TB_RCID	CHAR	5	0	Free Characteristic 08	VTBLMCID
39	RCID09	☐	TB_RCID09	TB_RCID	CHAR	5	0	Free Characteristic 09	VTBLMCID
40	RCID10	☐	TB_RCID10	TB_RCID	CHAR	5	0	Free Characteristic 10	VTBLMCID
41	RCID11	☐	TB_RCID11	TB_RCID	CHAR	5	0	Free Characteristic 11	VTBLMCID
42	RCID12	☐	TB_RCID12	TB_RCID	CHAR	5	0	Free Characteristic 12	VTBLMCID
43	RCID13	☐	TB_RCID13	TB_RCID	CHAR	5	0	Free Characteristic 13	VTBLMCID
44	RCID14	☐	TB_RCID14	TB_RCID	CHAR	5	0	Free Characteristic 14	VTBLMCID
45	RCID15	☐	TB_RCID15	TB_RCID	CHAR	5	0	Free Characteristic 15	VTBLMCID
46	.INCLUDE	☐				0	0	Credit Limit Single Transaction Check: Join Limits <-> Util.
47	RESULT_DETAIL	☐	TB_LIGHTS_DETAIL	TB_LIGHTS	CHAR	1	0	Single Transaction Check Result as Traffic Light (Detailed)
48	DLVB	☐	TB_DLVB	DATUM	DATS	8	0	Limit Valid From
49	DLVE	☐	TB_DLVE	DATUM	DATS	8	0	Limit Valid To
50	BLIMIT	☐	TB_BLIMIT	T_BLV	CURR	17	2	Internal Limit Amount
51	ELIMIT	☐	TB_ELIMIT	T_BLV	CURR	17	2	External Limit Amount
52	WLIMIT	☐	TB_WLIMIT	WAERS	CUKY	5	0	Limit Currency	*
53	COMPERD	☐	TB_COMPERD	NUMC4	NUMC	4	0	Maximum Risk Commitment Period in Months
54	RELTEXT	☐	TB_RELTEXT	CHAR12	CHAR	12	0	Text for Release Status
55	RELSTATE	☐	TB_RELSTATE	TB_RELSTATE	CHAR	1	0	Release Status of a Limit
56	SLI	☐	TB_SLI	T_SLI	NUMC	1	0	Limit Utilization Status	ATLSLI
57	DLI	☐	TB_DLI	DATUM	DATS	8	0	Base Date for Determining Limit Utilization
58	VLI	☐	TB_VLI	DATUM	DATS	8	0	'Valid From' Date of the Limit Utilization
59	BLI	☐	TB_BLI_SUM	WERTV9	CURR	17	2	Limit Amount Utilized: Totals Record
60	CLI	☐	TB_CLI_SUM	WERTV9	CURR	17	2	Single Transaction Commitment Amount: Totals Record
61	BLS	☐	TB_BLSS	WERTV9	CURR	17	2	Global Collateral Amount: Totals Record
62	WLI	☐	TB_WLIZ	WAERS	CUKY	5	0	Target Currency for Conversion of Limit Amount Utilized	*
63	SLP	☐	TB_SLP	DEC3_7	DEC	10	7	Percentage of Attribution
64	DIFF_I	☐	TB_DIFF_I	T_BLV	CURR	17	2	Difference Between Internal Limit and Amount Utilized
65	DIFF_E	☐	TB_DIFF_E	T_BLV	CURR	17	2	Difference Between External Limit and Amount Utilized
66	RLI_NEW	☐	TB_RLI	NUMC4	NUMC	4	0	Risk Commitment Period in Months
67	BLI_NEW	☐	TB_BLI_NEW	WERTV9	CURR	17	2	Limit Utilization Amount for Single Transaction
68	CLI_NEW	☐	TB_CLI_NEW	WERTV9	CURR	17	2	Single Transaction Commitment Amount
69	WLI_NEW	☐	TB_WLIE	WAERS	CUKY	5	0	Transaction Currency	*
70	QLI	☐	TB_QLI	DEC8_2	DEC	10	2	Limit Utilization in Percent
71	BLI_OLD	☐	TB_BLI_OLD	WERTV9	CURR	17	2	Limit Utilization Amount from Single Transaction (Old)
72	CLI_OLD	☐	TB_CLI_OLD	WERTV9	CURR	17	2	Single Transaction Commitment (Old)
73	WLI_OLD	☐	TB_WLIE	WAERS	CUKY	5	0	Transaction Currency	*
74	INFINITE	☐	TB_LIMIT_INFINITE	TB_LIMIT_INFINITE	CHAR	1	0	Indicator: Do Not Check Limit
75	PROZLIMIT	☐	TB_PROZLIMIT	DEC3_2	DEC	5	2	Critical Limit Utilization in Percent
76	TLI	☐	TB_TLI	TB_TLI	CHAR	2	0	Object Number Category in Limit Management
77	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
78	EDLVE	☐	TB_EDLVE	DATUM	DATS	8	0	External Validity End Date of Limit

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in