SAP ABAP Table KLCOLSEC (Securities Collateral)

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	INTTAB	Structure
Structure	KLCOLSEC	Table Relationship Diagram
Short Description	Securities Collateral

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	General Information on Collateral
2	.INCLUDE	☐				0	0	Internal/External Identifier for Collateral
3	SID	☐	KL_SID	CHAR20	CHAR	20	0	Identifier for Collateral Provision
4	SIDEXT	☐	KL_SIDEXT	CHAR20	CHAR	20	0	External Identifier for Collateral Provision
5	.INCLUDE	☐				0	0	Header for Single-Transaction-Related Collateral
6	DOBJNR	☐	KL_OBJNR_EG	J_OBJNR	CHAR	22	0	Object Number for Financial Transactions	*
7	BESITYP	☐	KL_BESITYP	KL_BESITYP	NUMC	2	0	Value Type of Collateral
8	SIART	☐	KL_SIART	NUMC4	NUMC	4	0	Type of Collateral
9	SIPRIO	☐	KL_SIPRIO	NUMC2	NUMC	2	0	Identifier for Collateral Priority
10	.INCLUDE	☐				0	0	Risk Line Items
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
12	OBJNR	☐	JBOBJNR	J_OBJNR	CHAR	22	0	Object number for financial transactions	ONR00
13	.INCLUDE	☐				0	0	Limit Characteristics
14	.INCLUDE	☐				0	0	direct and derived limit characteristics
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
31	.INCLUDE	☐				0	0	Control Parameters for Attributable Amount Determination
32	RRFIND	☐	KL_RRFIND	KLCHAR5	CHAR	5	0	Recovery Rate
33	CEQCLASS	☐	KL_CEQCLASS	KL_CEQCLASS	CHAR	5	0	CEQ Class	*
34	LEQCLASS	☐	KL_LEQCLASS	KL_LEQCLASS	CHAR	5	0	Loss Equivalent Class	*
35	.INCLUDE	☐				0	0	Attribution Control Parameters (Aggregation)
36	SKE	☐	KL_SKE	KL_SKE	CHAR	2	0	Selection of Counterparty - Issuer Risk
37	SPS	☐	KL_SPS	KL_SPS	CHAR	2	0	Primary - Secondary Risk
38	.INCLUDE	☐				0	0	Attribution Control Parameters (Risk Effect)
39	LRB	☐	KL_LRB	KL_LRB	NUMC	2	0	Country Risk Area	*
40	SRE	☐	KL_RISK_EFFECT	KL_RISK_EFFECT	CHAR	1	0	Transaction is Risk-Reducing
41	SARAKT	☐	KL_ARAKT	JBSJANEIN	CHAR	1	0	Indicator: Counterparty/Issuer Risk Active
42	SLRAKT	☐	KL_LRAKT	JBSJANEIN	CHAR	1	0	Indicator: Country Risk Active
43	.INCLUDE	☐				0	0	Structure for DRR and Date for Deadlines
44	ARR	☐	KL_DEFRIRE	KL_DEFRIRE	CHAR	10	0	Default Risk Rule	KLARRC
45	.INCLUDE	☐				0	0	Base Dates for MVC, RCP, Fiction and Original Term
46	DFIKT	☐	KL_DFIKT	SYDATS	DATS	8	0	Base Date for Fiction
47	SKALID	☐	KL_SKALID	WFCID	CHAR	2	0	Factory Calendar	TFACD
48	DMWAE	☐	KL_DMWAE	SYDATS	DATS	8	0	Base Date for Calculating Market Value Change Period
49	DRBD	☐	KL_DRBD	SYDATS	DATS	8	0	Base Date for Calculating the Risk Commitment Period
50	DBLFZ	☐	KL_DBLFZ	SYDATS	DATS	8	0	Term Start (Original Term)
51	DELFZ	☐	KL_DELFZ	SYDATS	DATS	8	0	Term End (Original Term)
52	DBMWAE	☐	KL_DMWAE	SYDATS	DATS	8	0	Base Date for Calculating Market Value Change Period
53	DFIKTVGL	☐	KL_DFIKT	SYDATS	DATS	8	0	Base Date for Fiction
54	.INCLUDE	☐				0	0	Securities Collateral: Master Data
55	RANL	☐	JBRRANL	WP_RANL	CHAR	13	0	Security	*
56	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
57	.INCLUDE	☐				0	0	Collateral: Amounts
58	BSIWHR	☐	KL_BSIWHR	KL_AMOUNT_POS	CURR	17	2	Amount of Collateral (Economic)
59	BSIWHRP	☐	KL_BSIWHRP	KL_AMOUNT_POS	CURR	17	2	Amount of Collateral (Political)
60	SSIWHR	☐	KL_SSIWHR	WAERS	CUKY	5	0	Currency of Collateral	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KLCOLSEC	ARR	KLARRC	ARR		1	CN
2	KLCOLSEC	BUKRS	T001	BUKRS		1	N
3	KLCOLSEC	COUNTRY	T005	LAND1		1	N
4	KLCOLSEC	INTORG	KLINTORG	INTORG
5	KLCOLSEC	MANDT	T000	MANDT		1	CN
6	KLCOLSEC	OBJNR	ONR00	OBJNR		C	C
7	KLCOLSEC	PARTNR	BUT000	PARTNER
8	KLCOLSEC	RATING	TP06	RATING		1	N
9	KLCOLSEC	RCOUNTRY	T005	LAND1		1	N
10	KLCOLSEC	RDEALER	TZDEA	RDEALER		1	N
11	KLCOLSEC	RPORTB	TWPOB	RPORTB		1	N
12	KLCOLSEC	SECTOR	TB038A	IND_SECTOR		1	N
13	KLCOLSEC	SKALID	TFACD	IDENT		1	CN
14	KLCOLSEC	SLPG	ATLPG	SLPG		1	N
15	KLCOLSEC	WAERS	TCURC	WAERS		1	N

History

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