1. Home
  2. Resources
  3. SAP Tables
  4. RFDKLI_KNKK - Credit Management: Control Area Data

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
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
X Yes
NULL No
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
X Yes
NULL No
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 KKBER T691A Credit management risk categories KKBER
RFDKLI_KNKK CTLPC RFDKLI_KNKK MANDT T691A Credit management risk categories MANDT
RFDKLI_KNKK CTLPC RFDKLI_KNKK CTLPC T691A Credit management risk categories CTLPC
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 MANDT T014 Credit control areas MANDT
RFDKLI_KNKK KKBER RFDKLI_KNKK KKBER T014 Credit control areas KKBER
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