SAP table RFDKLI_KNKK (Credit Management: Control Area Data)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
KKBER Credit control area CHAR 4 0 T014 KKBER
KLIMK Customer's credit limit CURR 23 2 KLIMK
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNA1 KNKLI
SAUFT Total of the Sales Values for the Credit Limit Check CURR 23 2 SAUFT
SKFOR Total Receivables (for Credit Limit Check) CURR 23 2 SKFOR
SSOBL Relevant Special Liabilities for Credit Limit Check CURR 23 2 SSOBL
UEDAT Date on Which the Credit Limit Was Exceeded DATS 8 0 UEDAT
XCHNG Indicator: Credit Limit Must Be Recreated CHAR 1 0 XCHNG_KNKK
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
CTLPC Credit Management: Risk Category CHAR 3 0 T691A CTLPC_CM
DTREV Last Internal Review DATS 8 0 DTREV_CM
CRBLB Indicator: Blocked by Credit Management? CHAR 1 0 CRBLB_CM
SBGRP Credit Representative Group for Credit Management CHAR 3 0 T024B SBGRP_CM
NXTRV Next Review DATS 8 0 NXTRV_CM
KRAUS Credit Information Number CHAR 11 0 KRAUS_CM
PAYDB Do Not Use - Replaced by Data Element DBPAY_CM NUMC 2 0 PAYDB_CM
DBRAT Do Not Use - Replaced by DBRTG_CM CHAR 3 0 DBRAT_CM
REVDB Last External Review DATS 8 0 REVDB_CM
AEDAT Date of Last Change DATS 8 0 AEDAT_CM
AETXT Date of Last Text Change DATS 8 0 AETXT_CM
GRUPP Customer Credit Group CHAR 4 0 T691B GRUPP_CM
AENAM Last Changed By CHAR 12 0 AENAM_CM
SBDAT Reference Date DATS 8 0 SBDAT_CM
KDGRP Customer Group CHAR 8 0 KDGRP_CM
CASHD Date of Last Payment DATS 8 0 CASHD
CASHA Amount of Last Payment CURR 23 2 CASHA
CASHC Currency of Last Payment CUKY 5 0 TCURC CASHC
DBPAY Payment Index CHAR 3 0 DBPAY_CM
DBRTG Rating CHAR 5 0 DBRTG_CM
DBEKR Recommended Credit Limit CURR 23 2 DBEKR_CM
DBWAE Currency of Recommended Credit Limit CUKY 5 0 TCURC DBWAE_CM
DBMON Date Monitoring DATS 8 0 DBMON_CM
ABSBT Total Secured Receivables CURR 23 2 ABSBT_SUM
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
REGIO Region (State, Province, County) CHAR 3 0 * REGIO
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
TELF1 First telephone number CHAR 16 0 TELF1
TELFX Fax Number CHAR 31 0 TELFX
LAND1 Country/Region Key CHAR 3 0 LAND1_GP
KLIMG_KNKA Credit limit: Total limit across all control areas CURR 23 2 KLIMG
KLIME_KNKA Credit limit: Limit for individual control area CURR 23 2 KLIME
WAERS_KNKA Currency Key CUKY 5 0 * WAERS
DLAUS_KNKA Date of the Last General Information DATS 8 0 DLAUS
DSOIN DSO Ratio (Outstanding Receivables in Sales Days) NUMC 4 0 DSOIN_F02L
OBLIG Credit exposure (for credit limit check) CURR 23 2 OBLIG_F02L
DELTA Over Budget Amount in Credit Management CURR 23 2 DELTA_F02L
KLPRZ Credit limit used DEC 5 2 KLPRZ_F02L
SFAE1 Total of Due Items CURR 23 2 SFAE1_F035
SFAE2 Total of Due Items (Interval 2) CURR 23 2 SFAE2_F035
SFAE3 Total of Due Items (Interval 3) CURR 23 2 SFAE3_F035
SFAE4 Total of Due Items (Interval 4) CURR 23 2 SFAE4_F035
SFAE5 Total of Due Items (Interval 5) CURR 23 2 SFAE5_F035
SFAE6 Total of Due Items (Interval 6) CURR 23 2 SFAE6_F035
SFAEL Total of Due Items CURR 23 2 SFAEL_F035
SNFA1 Total of Items Not Due 1 CURR 23 2 SNFA1_F035
SNFA2 Total of Items Not Due 2 CURR 23 2 SNFA2_F035
SNFA3 Total of Items Not Due 3 CURR 23 2 SNFA3_F035
SNFA4 Total of Items Not Due 4 CURR 23 2 SNFA4_F035
SNFA5 Total of Items Not Due 5 CURR 23 2 SNFA5_F035
SNFA6 Total of Items Not Due 6 CURR 23 2 SNFA6_F035
SNFAE Total of Items Not Due CURR 23 2 SNFAE_F035
OLIKW Open delivery credit value CURR 19 2 MC_OLIKW
OFAKW Open billing document credit value CURR 19 2 MC_OFAKW
OEIKW Open sales order credit value (schedule lines) CURR 19 2 MC_OEIKW
WAERS Currency Key CUKY 5 0 WAERS
GTEXT Name of the Group CHAR 30 0 GTEXT_CM

RFDKLI_KNKK foreign key relationships

Table Field Check Table Check Field
0 RFDKLI_KNKK CASHC TCURC Currency Codes MANDT
0 RFDKLI_KNKK CASHC TCURC Currency Codes WAERS
1 RFDKLI_KNKK CTLPC T691A Credit management risk categories CTLPC
1 RFDKLI_KNKK CTLPC T691A Credit management risk categories KKBER
0 RFDKLI_KNKK DBWAE TCURC Currency Codes MANDT
0 RFDKLI_KNKK DBWAE TCURC Currency Codes WAERS
1 RFDKLI_KNKK GRUPP T691B "Credit Management Groups" GRUPP
1 RFDKLI_KNKK GRUPP T691B "Credit Management Groups" KKBER
0 RFDKLI_KNKK KKBER T014 Credit control areas KKBER
1 RFDKLI_KNKK KNKLI KNA1 General Data in Customer Master MANDT
1 RFDKLI_KNKK KNKLI KNA1 General Data in Customer Master KUNNR
0 RFDKLI_KNKK KUNNR KNA1 General Data in Customer Master MANDT
0 RFDKLI_KNKK KUNNR KNA1 General Data in Customer Master KUNNR
1 RFDKLI_KNKK SBGRP T024B Credit management: Credit representative groups MANDT
1 RFDKLI_KNKK SBGRP T024B Credit management: Credit representative groups KKBER