SAP Table KNKK
Customer master credit management: Control area data
KNKK (Customer master credit management: Control area data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNKK to other SAP tables.
KNKK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||
|
KKBER
Credit control area
|
KKBER | T014 |
CHAR
|
4 | 0 | |||||||
|
KLIMK
Customer's credit limit
|
KLIMK |
CURR
|
15 | 2 | ||||||||
|
KNKLI
Customer's account number with credit limit reference
|
KNKLI | KNA1 |
CHAR
|
10 | 0 | |||||||
|
SAUFT
Total of the sales values for the credit limit check
|
SAUFT |
CURR
|
15 | 2 | ||||||||
|
SKFOR
Total receivables (for credit limit check)
|
SKFOR |
CURR
|
15 | 2 | ||||||||
|
SSOBL
Relevant special liabilities for credit limit check
|
SSOBL |
CURR
|
15 | 2 | ||||||||
|
UEDAT
Date on which the credit limit was exceeded
|
UEDAT |
DATS
|
8 | 0 | ||||||||
|
XCHNG
Indicator: credit limit must be recreated
|
XCHNG_KNKK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM_RF |
CHAR
|
12 | 0 | ||||||||
|
ERDAT
Date on which the Record Was Created
|
ERDAT_RF |
DATS
|
8 | 0 | ||||||||
|
CTLPC
Credit management: Risk category
|
CTLPC_CM | T691A |
CHAR
|
3 | 0 | |||||||
|
DTREV
Last internal review
|
DTREV_CM |
DATS
|
8 | 0 | ||||||||
|
CRBLB
Indicator: Blocked by credit management ?
|
CRBLB_CM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SBGRP
Credit representative group for credit management
|
SBGRP_CM | T024B |
CHAR
|
3 | 0 | |||||||
|
NXTRV
Next internal review
|
NXTRV_CM |
DATS
|
8 | 0 | ||||||||
|
KRAUS
Credit information number
|
KRAUS_CM |
CHAR
|
11 | 0 | ||||||||
|
PAYDB
do not use - replaced by DBPAY_CM
|
PAYDB_CM |
NUMC
|
2 | 0 | ||||||||
|
DBRAT
do not use - replaced by DBRTG_CM
|
DBRAT_CM |
CHAR
|
3 | 0 | ||||||||
|
REVDB
Last review (external)
|
REVDB_CM |
DATS
|
8 | 0 | ||||||||
|
AEDAT
Date of Last Change
|
AEDAT_CM |
DATS
|
8 | 0 | ||||||||
|
AETXT
Date of Last Text Change
|
AETXT_CM |
DATS
|
8 | 0 | ||||||||
|
GRUPP
Customer Credit Group
|
GRUPP_CM | T691B |
CHAR
|
4 | 0 | |||||||
|
AENAM
Last changed by
|
AENAM_CM |
CHAR
|
12 | 0 | ||||||||
|
SBDAT
Reference Date
|
SBDAT_CM |
DATS
|
8 | 0 | ||||||||
|
KDGRP
Customer Group
|
KDGRP_CM |
CHAR
|
8 | 0 | ||||||||
|
CASHD
Date of Last Payment
|
CASHD |
DATS
|
8 | 0 | ||||||||
|
CASHA
Amount of Last Payment
|
CASHA |
CURR
|
13 | 2 | ||||||||
|
CASHC
Currency of Last Payment
|
CASHC | TCURC |
CUKY
|
5 | 0 | |||||||
|
DBPAY
Payment Index
|
DBPAY_CM |
CHAR
|
3 | 0 | ||||||||
|
DBRTG
Rating
|
DBRTG_CM |
CHAR
|
5 | 0 | ||||||||
|
DBEKR
Recommended credit limit
|
DBEKR_CM |
CURR
|
15 | 2 | ||||||||
|
DBWAE
Currency of recommended credit limit
|
DBWAE_CM | TCURC |
CUKY
|
5 | 0 | |||||||
|
DBMON
Date Monitoring
|
DBMON_CM |
DATS
|
8 | 0 | ||||||||
|
ABSBT
Total Secured Receivables
|
ABSBT_SUM |
CURR
|
15 | 2 | ||||||||
KNKK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNKK | CASHC | KNKK | MANDT |
TCURC
Currency Codes
|
MANDT |
| KNKK | CASHC | KNKK | CASHC |
TCURC
Currency Codes
|
WAERS |
| KNKK | CTLPC | KNKK | CTLPC |
T691A
Credit management risk categories
|
CTLPC |
| KNKK | CTLPC | KNKK | KKBER |
T691A
Credit management risk categories
|
KKBER |
| KNKK | CTLPC | KNKK | MANDT |
T691A
Credit management risk categories
|
MANDT |
| KNKK | DBWAE | KNKK | MANDT |
TCURC
Currency Codes
|
MANDT |
| KNKK | DBWAE | KNKK | DBWAE |
TCURC
Currency Codes
|
WAERS |
| KNKK | GRUPP | KNKK | MANDT |
T691B
"Credit Management Groups"
|
MANDT |
| KNKK | GRUPP | KNKK | GRUPP |
T691B
"Credit Management Groups"
|
GRUPP |
| KNKK | GRUPP | KNKK | KKBER |
T691B
"Credit Management Groups"
|
KKBER |
| KNKK | KKBER | KNKK | KKBER |
T014
Credit control areas
|
KKBER |
| KNKK | KKBER | KNKK | MANDT |
T014
Credit control areas
|
MANDT |
| KNKK | KNKLI | KNKK | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNKK | KNKLI | KNKK | KNKLI |
KNA1
General Data in Customer Master
|
KUNNR |
| KNKK | KUNNR | KNKK | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNKK | KUNNR | KNKK | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNKK | MANDT | KNKK | MANDT |
T000
Clients
|
MANDT |
| KNKK | SBGRP | KNKK | MANDT |
T024B
Credit management: Credit representative groups
|
MANDT |
| KNKK | SBGRP | KNKK | SBGRP |
T024B
Credit management: Credit representative groups
|
SBGRP |
| KNKK | SBGRP | KNKK | KKBER |
T024B
Credit management: Credit representative groups
|
KKBER |