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 | Possible values |
|---|---|---|---|---|---|---|
|
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 | MANDT |
KNB1
Customer Master (Company Code)
|
MANDT |
| KNC1 | BUKRS | KNC1 | KUNNR |
KNB1
Customer Master (Company Code)
|
KUNNR |
| KNC1 | BUKRS | KNC1 | BUKRS |
KNB1
Customer Master (Company Code)
|
BUKRS |
| 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 |