SAP table KNKK (Customer master credit management: Control area data)
SAP table KNKK has 3 primary key fields being MANDT,KUNNR,KKBER.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| 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 |
KNKK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KNKK | CASHC | TCURC | Currency Codes | MANDT |
| 0 KNKK | CASHC | TCURC | Currency Codes | WAERS |
| 1 KNKK | CTLPC | T691A | Credit management risk categories | CTLPC |
| 1 KNKK | CTLPC | T691A | Credit management risk categories | KKBER |
| 0 KNKK | DBWAE | TCURC | Currency Codes | MANDT |
| 0 KNKK | DBWAE | TCURC | Currency Codes | WAERS |
| 1 KNKK | GRUPP | T691B | "Credit Management Groups" | GRUPP |
| 1 KNKK | GRUPP | T691B | "Credit Management Groups" | KKBER |
| 0 KNKK | KKBER | T014 | Credit control areas | KKBER |
| 1 KNKK | KNKLI | KNA1 | General Data in Customer Master | MANDT |
| 1 KNKK | KNKLI | KNA1 | General Data in Customer Master | KUNNR |
| 0 KNKK | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 0 KNKK | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 1 KNKK | MANDT | T000 | Clients | MANDT |
| 0 KNKK | SBGRP | T024B | Credit management: Credit representative groups | MANDT |
| 0 KNKK | SBGRP | T024B | Credit management: Credit representative groups | KKBER |