KNKKF1 SAP (Credit Management: FI Status Data) Table details
Dictionary Type: Table
Description: Credit Management: FI Status Data
Description: Credit Management: FI Status Data
Table field list including key, data, relationships and ABAP select examples
KNKKF1 is a standard SAP Table which is used to store Credit Management: FI Status Data data and is available within R/3 SAP systems depending on the version and release level.
The KNKKF1 table consists of various fields, each holding specific information or linking keys about Credit Management: FI Status Data data available in SAP. These include LOGSYS (Logical system), KUNNR (Customer Numbers), KKBER (Credit control area), REGUL (FI checks only against current payer).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP KNKKF1 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
REGUL | FI checks only against current payer | REGUL_CM | CHAR | 1 | XFELD | ||||
TMSTMP | Time at which data was created (date and time) | TMSTMP | CHAR | 14 | CHAR14 | ||||
SFAEL | A/R Summary: Open Items Total | CV_SFAEL | CURR | 15(2) | WRTV8 | ||||
WAERS | A/R Summary: Currency Key (Total Open Items) | CV_WAERS_OP | CUKY | 5 | TCURC | WAERS | |||
BUKRSM | A/R Summary: Company Code (Highest Dunning Level) | CV_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
KUNNRM | A/R Summary: Customer Number (Highest Dunning Level) | CV_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
MABER | A/R Summary: Dunning Area (Highest Dunning Level) | CV_MABER | CHAR | 2 | Assigned to domain | MABER | |||
MAHNS | A/R Summary: Dunning Level (Highest Dunning Level) | CV_MAHNS | NUMC | 1 | MAHNS | ||||
BELNR | A/R Summary: Document Number of Oldest Open Item | CV_BELNR | CHAR | 10 | ALPHA | BELNR | |||
BUKRSOOI | A/R Summary: Company Code (Oldest Open Item) | CV_BUKRS_OOI | CHAR | 4 | Assigned to domain | BUKRS | |||
FAEDT | A/R Summary: Net Due Date (Oldest Open Item) | CV_FAEDT | DATS | 8 | DATUM | ||||
GJAHR | A/R Summary: Fiscal Year (Oldest Open Item) | CV_GJAHR | NUMC | 4 | GJAHR | GJAHR | |||
INFAE | A/R Summary: Inverted Net Due Date (Oldest Open Item) | CV_INFAE | CHAR | 8 | CHAR08 | ||||
KUNNROOI | A/R Summary: Customer Number (Oldest Open Item) | CV_KUNNR_OOI | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
VERZN | A/R Summary: Days in Arrears after Net Due Date (Old. OI) | CV_VERZN | DEC | 5 | WRTV3 | ||||
WAERSOOI | A/R Summary: Currency Key (Oldest Open Item) | CV_WAERS_OOI | CUKY | 5 | Assigned to domain | WAERS | |||
WRBTR | A/R Summary: Amount in Document Currency | CV_WRBTR | CURR | 13(2) | WERT7 | ||||
KLIMK | A/R Summary: Customer Credit Limit | CV_KLIMK | CURR | 15(2) | WERT8 | ||||
KNKLI | A/R Summary: Credit Account | CV_KNKLI | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
SKFOR | A/R Summary: Total Receivables | CV_SKFOR | CURR | 15(2) | WRTV8 | ||||
SSOBL | A/R Summary: Special Debts | CV_SSOBL | CURR | 15(2) | WRTV8 | ||||
WAERS_KNKK | A/R Summary: Currency Key (Control Area) | CV_WAERS_MD | CUKY | 5 | TCURC | WAERS | |||
CTLPC | A/R Summary: Risk Category | CV_CTLPC | CHAR | 3 | Assigned to domain | CTLPC_CM | |||
CRBLB | A/R Summary: Block | CV_CRBLB | CHAR | 1 | XFELD | ||||
NXTRV | A/R Summary: Date of Next Check | CV_NXTRV | DATS | 8 | DATUM | ||||
ABSBT | Total Secured Receivables | ABSBT_SUM | CURR | 15(2) | WERTV8 |
Key field | Non-key field |
How do I retrieve data from SAP table KNKKF1 using ABAP code
The following ABAP code Example will allow you to do a basic selection on KNKKF1 to SELECT all data from the tableDATA: WA_KNKKF1 TYPE KNKKF1.
SELECT SINGLE *
FROM KNKKF1
INTO CORRESPONDING FIELDS OF WA_KNKKF1
WHERE...
How to access SAP table KNKKF1
Within an ECC or HANA version of SAP you can also view further information about KNKKF1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects