SAP Table RFDKLI_KNKK
Credit Management: Control Area Data
RFDKLI_KNKK (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 RFDKLI_KNKK to other SAP tables.
RFDKLI_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 | ||||||||
|
NAME1
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||
|
NAME2
Name 2
|
NAME2_GP |
CHAR
|
35 | 0 | ||||||||
|
PSTLZ
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||||||||
|
REGIO
Region (State, Province, County)
|
REGIO |
CHAR
|
3 | 0 | ||||||||
|
ORT01
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||||||||
|
ORT02
District
|
ORT02_GP |
CHAR
|
35 | 0 | ||||||||
|
STRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||
|
TELF1
First telephone number
|
TELF1 |
CHAR
|
16 | 0 | ||||||||
|
TELFX
Fax Number
|
TELFX |
CHAR
|
31 | 0 | ||||||||
|
LAND1
Country Key
|
LAND1_GP |
CHAR
|
3 | 0 | ||||||||
|
KLIMG_KNKA
Credit limit: Total limit across all control areas
|
KLIMG |
CURR
|
15 | 2 | ||||||||
|
KLIME_KNKA
Credit limit: Limit for individual control area
|
KLIME |
CURR
|
15 | 2 | ||||||||
|
WAERS_KNKA
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||
|
DLAUS_KNKA
Date of the last general information
|
DLAUS |
DATS
|
8 | 0 | ||||||||
|
DSOIN
DSO ratio (outstanding receivables in sales days)
|
DSOIN_F02L |
NUMC
|
4 | 0 | ||||||||
|
OBLIG
Credit exposure (for credit limit check)
|
OBLIG_F02L |
CURR
|
15 | 2 | ||||||||
|
DELTA
Over budget amount in credit management
|
DELTA_F02L |
CURR
|
15 | 2 | ||||||||
|
KLPRZ
Credit limit used
|
KLPRZ_F02L |
DEC
|
5 | 2 | ||||||||
|
SFAE1
Total of Due Items
|
SFAE1_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE2
Total of Due Items (Interval 2)
|
SFAE2_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE3
Total of Due Items (Interval 3)
|
SFAE3_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE4
Total of Due Items (Interval 4)
|
SFAE4_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE5
Total of Due Items (Interval 5)
|
SFAE5_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE6
Total of Due Items (Interval 6)
|
SFAE6_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAEL
Total of Due Items
|
SFAEL_F035 |
CURR
|
19 | 2 | ||||||||
|
SNFA1
Total of Items not Due 1
|
SNFA1_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA2
Total of Items not Due 2
|
SNFA2_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA3
Total of Items not Due 3
|
SNFA3_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA4
Total of Items not Due 4
|
SNFA4_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA5
Total of Items not Due 5
|
SNFA5_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA6
Total of Items not Due 6
|
SNFA6_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFAE
Total of Items not Due
|
SNFAE_F035 |
CURR
|
19 | 2 | ||||||||
|
OLIKW
Open delivery credit value
|
MC_OLIKW |
CURR
|
19 | 2 | ||||||||
|
OFAKW
Open billing document credit value
|
MC_OFAKW |
CURR
|
19 | 2 | ||||||||
|
OEIKW
Open sales order credit value (schedule lines)
|
MC_OEIKW |
CURR
|
19 | 2 | ||||||||
|
WAERS
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||
|
GTEXT
Name of the group
|
GTEXT_CM |
CHAR
|
30 | 0 | ||||||||
RFDKLI_KNKK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| RFDKLI_KNKK | CASHC | RFDKLI_KNKK | MANDT |
TCURC
Currency Codes
|
MANDT |
| RFDKLI_KNKK | CASHC | RFDKLI_KNKK | CASHC |
TCURC
Currency Codes
|
WAERS |
| RFDKLI_KNKK | CTLPC | RFDKLI_KNKK | CTLPC |
T691A
Credit management risk categories
|
CTLPC |
| RFDKLI_KNKK | CTLPC | RFDKLI_KNKK | KKBER |
T691A
Credit management risk categories
|
KKBER |
| RFDKLI_KNKK | CTLPC | RFDKLI_KNKK | MANDT |
T691A
Credit management risk categories
|
MANDT |
| RFDKLI_KNKK | DBWAE | RFDKLI_KNKK | MANDT |
TCURC
Currency Codes
|
MANDT |
| RFDKLI_KNKK | DBWAE | RFDKLI_KNKK | DBWAE |
TCURC
Currency Codes
|
WAERS |
| RFDKLI_KNKK | GRUPP | RFDKLI_KNKK | MANDT |
T691B
"Credit Management Groups"
|
MANDT |
| RFDKLI_KNKK | GRUPP | RFDKLI_KNKK | GRUPP |
T691B
"Credit Management Groups"
|
GRUPP |
| RFDKLI_KNKK | GRUPP | RFDKLI_KNKK | KKBER |
T691B
"Credit Management Groups"
|
KKBER |
| RFDKLI_KNKK | KKBER | RFDKLI_KNKK | KKBER |
T014
Credit control areas
|
KKBER |
| RFDKLI_KNKK | KKBER | RFDKLI_KNKK | MANDT |
T014
Credit control areas
|
MANDT |
| RFDKLI_KNKK | KNKLI | RFDKLI_KNKK | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| RFDKLI_KNKK | KNKLI | RFDKLI_KNKK | KNKLI |
KNA1
General Data in Customer Master
|
KUNNR |
| RFDKLI_KNKK | KUNNR | RFDKLI_KNKK | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| RFDKLI_KNKK | KUNNR | RFDKLI_KNKK | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| RFDKLI_KNKK | MANDT | RFDKLI_KNKK | MANDT |
T000
Clients
|
MANDT |
| RFDKLI_KNKK | SBGRP | RFDKLI_KNKK | MANDT |
T024B
Credit management: Credit representative groups
|
MANDT |
| RFDKLI_KNKK | SBGRP | RFDKLI_KNKK | SBGRP |
T024B
Credit management: Credit representative groups
|
SBGRP |
| RFDKLI_KNKK | SBGRP | RFDKLI_KNKK | KKBER |
T024B
Credit management: Credit representative groups
|
KKBER |