SAP Table KNC1
Customer master (transaction figures)
KNC1 (Customer master (transaction figures)) 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 KNC1 to other SAP tables.
KNC1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||
| BUKRS | Company Code | BUKRS | KNB1 | CHAR | 4 | 0 | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||
| USNAM | User name | USNAM | CHAR | 12 | 0 | |||
| UMSAV | Balance Carried Forward in Local Currency | UMSAV | CURR | 15 | 2 | |||
| UM01S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM01H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM01U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM02S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM02H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM02U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM03S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM03H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM03U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM04S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM04H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM04U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM05S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM05H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM05U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM06S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM06H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM06U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM07S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM07H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM07U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM08S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM08H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM08U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM09S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM09H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM09U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM10S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM10H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM10U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM11S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM11H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM11U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM12S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM12H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM12U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM13S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM13H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM13U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM14S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM14H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM14U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM15S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM15H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM15U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| UM16S | Total of the Debit Postings for the Month | UMXXS | CURR | 15 | 2 | |||
| UM16H | Total of the Credit Postings for the Month | UMXXH | CURR | 15 | 2 | |||
| UM16U | Sales in the Posting Period | UMXXU | CURR | 15 | 2 | |||
| BABZG | Authorized deductions (in local currency) | BABZG | CURR | 15 | 2 | |||
| UABZG | Accepted deductions taken after end of discount period | UABZG | CURR | 15 | 2 | |||
| KZINS | Acc.int.calc.numerator for payment arrears in fiscal year | KZINS | CURR | 15 | 2 | |||
| KUMAG | Accumulated clearing amount in the fiscal year | KUMAG | CURR | 15 | 2 | |||
KNC1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| KNC1 | BUKRS | KNC1 | BUKRS | KNB1 | Customer Master (Company Code) | BUKRS |
| KNC1 | BUKRS | KNC1 | MANDT | KNB1 | Customer Master (Company Code) | MANDT |
| KNC1 | BUKRS | KNC1 | KUNNR | KNB1 | Customer Master (Company Code) | KUNNR |
| KNC1 | KUNNR | KNC1 | MANDT | KNA1 | General Data in Customer Master | MANDT |
| KNC1 | KUNNR | KNC1 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| KNC1 | MANDT | KNC1 | MANDT | T000 | Clients | MANDT |
