SAP ABAP Table RFDKLI_KNKK (Credit Management: Control Area Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBD (Package) Customers

Basic Data

Table Category	INTTAB	Structure
Structure	RFDKLI_KNKK	Table Relationship Diagram
Short Description	Credit Management: Control Area Data

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	Customer master credit management: Control area data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
4	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
5	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
6	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
7	SAUFT	☐	SAUFT	WRTV8	CURR	15	2	Total of the sales values for the credit limit check
8	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
9	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
10	UEDAT	☐	UEDAT	DATUM	DATS	8	0	Date on which the credit limit was exceeded
11	XCHNG	☐	XCHNG_KNKK	XFELD	CHAR	1	0	Indicator: credit limit must be recreated
12	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
13	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
14	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
15	DTREV	☐	DTREV_CM	DATUM	DATS	8	0	Last internal review
16	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
17	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
18	NXTRV	☐	NXTRV_CM	DATUM	DATS	8	0	Next internal review
19	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
20	PAYDB	☐	PAYDB_CM	NUM02	NUMC	2	0	do not use - replaced by DBPAY_CM
21	DBRAT	☐	DBRAT_CM	CHAR3	CHAR	3	0	do not use - replaced by DBRTG_CM
22	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
23	AEDAT	☐	AEDAT_CM	DATUM	DATS	8	0	Date of Last Change
24	AETXT	☐	AETXT_CM	DATUM	DATS	8	0	Date of Last Text Change
25	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
26	AENAM	☐	AENAM_CM	USNAM	CHAR	12	0	Last changed by
27	SBDAT	☐	SBDAT_CM	DATUM	DATS	8	0	Reference Date
28	KDGRP	☐	KDGRP_CM	CHAR8	CHAR	8	0	Customer Group
29	CASHD	☐	CASHD	DATUM	DATS	8	0	Date of Last Payment
30	CASHA	☐	CASHA	WERT7	CURR	13	2	Amount of Last Payment
31	CASHC	☐	CASHC	WAERS	CUKY	5	0	Currency of Last Payment	TCURC
32	DBPAY	☐	DBPAY_CM	CHAR3	CHAR	3	0	Payment Index
33	DBRTG	☐	DBRTG_CM	CHAR5	CHAR	5	0	Rating
34	DBEKR	☐	DBEKR_CM	WERT8	CURR	15	2	Recommended credit limit
35	DBWAE	☐	DBWAE_CM	WAERS	CUKY	5	0	Currency of recommended credit limit	TCURC
36	DBMON	☐	DBMON_CM	DATUM	DATS	8	0	Date Monitoring
37	ABSBT	☐	ABSBT_SUM	WERTV8	CURR	15	2	Total Secured Receivables
38	.INCLUDE	☐				0	0	Credit Management: Address Data
39	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
40	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
41	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
42	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
43	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
44	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
45	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
46	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
47	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
48	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
49	.INCLUDE	☐				0	0
50	.INCLUDE	☐				0	0	Credit Management: Central Data
51	KLIMG_KNKA	☐	KLIMG	WERT8	CURR	15	2	Credit limit: Total limit across all control areas
52	KLIME_KNKA	☐	KLIME	WERT8	CURR	15	2	Credit limit: Limit for individual control area
53	WAERS_KNKA	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
54	DLAUS_KNKA	☐	DLAUS	DATUM	DATS	8	0	Date of the last general information
55	.INCLUDE	☐				0	0
56	DSOIN	☐	DSOIN_F02L	NUM04	NUMC	4	0	DSO ratio (outstanding receivables in sales days)
57	OBLIG	☐	OBLIG_F02L	WRTV8	CURR	15	2	Credit exposure (for credit limit check)
58	DELTA	☐	DELTA_F02L	WRTV8	CURR	15	2	Over budget amount in credit management
59	KLPRZ	☐	KLPRZ_F02L	PRZ32	DEC	5	2	Credit limit used
60	SFAE1	☐	SFAE1_F035	WRTV8	CURR	15	2	Total of Due Items
61	SFAE2	☐	SFAE2_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 2)
62	SFAE3	☐	SFAE3_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 3)
63	SFAE4	☐	SFAE4_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 4)
64	SFAE5	☐	SFAE5_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 5)
65	SFAE6	☐	SFAE6_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 6)
66	SFAEL	☐	SFAEL_F035	WERTV10	CURR	19	2	Total of Due Items
67	SNFA1	☐	SNFA1_F035	WRTV8	CURR	15	2	Total of Items not Due 1
68	SNFA2	☐	SNFA2_F035	WRTV8	CURR	15	2	Total of Items not Due 2
69	SNFA3	☐	SNFA3_F035	WRTV8	CURR	15	2	Total of Items not Due 3
70	SNFA4	☐	SNFA4_F035	WRTV8	CURR	15	2	Total of Items not Due 4
71	SNFA5	☐	SNFA5_F035	WRTV8	CURR	15	2	Total of Items not Due 5
72	SNFA6	☐	SNFA6_F035	WRTV8	CURR	15	2	Total of Items not Due 6
73	SNFAE	☐	SNFAE_F035	WERTV10	CURR	19	2	Total of Items not Due
74	OLIKW	☐	MC_OLIKW	WERTV10	CURR	19	2	Open delivery credit value
75	OFAKW	☐	MC_OFAKW	WERTV10	CURR	19	2	Open billing document credit value
76	OEIKW	☐	MC_OEIKW	WERTV10	CURR	19	2	Open sales order credit value (schedule lines)
77	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
78	GTEXT	☐	GTEXT_CM	TEXT30	CHAR	30	0	Name of the group
79	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFDKLI_KNKK	CASHC	TCURC	WAERS	REF	C	CN
2	RFDKLI_KNKK	CTLPC	T691A	CTLPC	REF	C	CN
3	RFDKLI_KNKK	DBWAE	TCURC	WAERS
4	RFDKLI_KNKK	GRUPP	T691B	GRUPP	REF	C	CN
5	RFDKLI_KNKK	KKBER	T014	KKBER	KEY	1	CN
6	RFDKLI_KNKK	KNKLI	KNA1	KUNNR	REF	1	CN
7	RFDKLI_KNKK	KUNNR	KNA1	KUNNR	KEY	1	CN
8	RFDKLI_KNKK	MANDT	T000	MANDT	KEY	1	CN
9	RFDKLI_KNKK	SBGRP	T024B	SBGRP	REF	C	CN

History

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