SAP table KNKKF2 (Credit Management: Open Items by Days in Arrears)
SAP table KNKKF2 has 6 primary key fields being MANDT,LOGSYS,KUNNR,KKBER,REGUL,VERZN.
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 | |
| LOGSYS | Logical system | CHAR | 10 | 0 | LOGSYS | ||
| KUNNR | Customer Number | CHAR | 10 | 0 | KNA1 | KUNNR | |
| KKBER | Credit control area | CHAR | 4 | 0 | T014 | KKBER | |
| REGUL | FI checks only against current payer | CHAR | 1 | 0 | REGUL_CM | ||
| VERZN | Days in Arrears by Net Due Date | DEC | 5 | 0 | VERZN_CM | ||
| TMSTMP | Time at Which Data Was Created (Date and Time) | CHAR | 14 | 0 | TMSTMP | ||
| SUMOP | A/R Summary: Open Items Total (by Days in Arrears) | CURR | 23 | 2 | SUMOP_CM | ||
| WAERS | Credit Vector: Currency Key (Open Item Total) | CUKY | 5 | 0 | TCURC | WAERS_CM_OP |
KNKKF2 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KNKKF2 | KKBER | T014 | Credit control areas | KKBER |
| 1 KNKKF2 | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 1 KNKKF2 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 KNKKF2 | MANDT | T000 | Clients | MANDT |
| 1 KNKKF2 | WAERS | TCURC | Currency Codes | MANDT |
| 1 KNKKF2 | WAERS | TCURC | Currency Codes | WAERS |