SAP ABAP Table KNKK (Customer master 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	TRANSP	Transparent table
Transparent table	KNKK	Table Relationship Diagram
Short Description	Customer master credit management: Control area data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	KKBER	☑	KKBER	KKBER	CHAR	4	0	Credit control area	T014
4	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
5	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
6	SAUFT	☐	SAUFT	WRTV8	CURR	15	2	Total of the sales values for the credit limit check
7	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
8	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
9	UEDAT	☐	UEDAT	DATUM	DATS	8	0	Date on which the credit limit was exceeded
10	XCHNG	☐	XCHNG_KNKK	XFELD	CHAR	1	0	Indicator: credit limit must be recreated
11	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
13	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
14	DTREV	☐	DTREV_CM	DATUM	DATS	8	0	Last internal review
15	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
16	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
17	NXTRV	☐	NXTRV_CM	DATUM	DATS	8	0	Next internal review
18	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
19	PAYDB	☐	PAYDB_CM	NUM02	NUMC	2	0	do not use - replaced by DBPAY_CM
20	DBRAT	☐	DBRAT_CM	CHAR3	CHAR	3	0	do not use - replaced by DBRTG_CM
21	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
22	AEDAT	☐	AEDAT_CM	DATUM	DATS	8	0	Date of Last Change
23	AETXT	☐	AETXT_CM	DATUM	DATS	8	0	Date of Last Text Change
24	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
25	AENAM	☐	AENAM_CM	USNAM	CHAR	12	0	Last changed by
26	SBDAT	☐	SBDAT_CM	DATUM	DATS	8	0	Reference Date
27	KDGRP	☐	KDGRP_CM	CHAR8	CHAR	8	0	Customer Group
28	CASHD	☐	CASHD	DATUM	DATS	8	0	Date of Last Payment
29	CASHA	☐	CASHA	WERT7	CURR	13	2	Amount of Last Payment
30	CASHC	☐	CASHC	WAERS	CUKY	5	0	Currency of Last Payment	TCURC
31	DBPAY	☐	DBPAY_CM	CHAR3	CHAR	3	0	Payment Index
32	DBRTG	☐	DBRTG_CM	CHAR5	CHAR	5	0	Rating
33	DBEKR	☐	DBEKR_CM	WERT8	CURR	15	2	Recommended credit limit
34	DBWAE	☐	DBWAE_CM	WAERS	CUKY	5	0	Currency of recommended credit limit	TCURC
35	DBMON	☐	DBMON_CM	DATUM	DATS	8	0	Date Monitoring
36	ABSBT	☐	ABSBT_SUM	WERTV8	CURR	15	2	Total Secured Receivables

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in