SAP TABLES | Financial Accounting(FI) SAP FI

KNC1 SAP Customer master (transaction figures) Table and data







KNC1 is a standard SAP Table which is used to store Customer master (transaction figures) data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP KNC1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP KNC1 Table fields within data Dictionary




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
KUNNRKUNNRCHAR10KNA1Customer NumberALPHA
BUKRSBUKRSCHAR4KNB1Company Code
GJAHRGJAHRNUMC4Fiscal YearGJAHR
ERDATERDATDATS8Date on Which Record Was Created
USNAMUSNAMCHAR12
*
User name
UMSAVUMSAVCURR15(2)Balance Carried Forward in Local Currency
UM01SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM01HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM01UUMXXUCURR15(2)Sales in the Posting Period
UM02SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM02HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM02UUMXXUCURR15(2)Sales in the Posting Period
UM03SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM03HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM03UUMXXUCURR15(2)Sales in the Posting Period
UM04SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM04HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM04UUMXXUCURR15(2)Sales in the Posting Period
UM05SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM05HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM05UUMXXUCURR15(2)Sales in the Posting Period
UM06SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM06HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM06UUMXXUCURR15(2)Sales in the Posting Period
UM07SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM07HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM07UUMXXUCURR15(2)Sales in the Posting Period
UM08SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM08HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM08UUMXXUCURR15(2)Sales in the Posting Period
UM09SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM09HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM09UUMXXUCURR15(2)Sales in the Posting Period
UM10SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM10HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM10UUMXXUCURR15(2)Sales in the Posting Period
UM11SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM11HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM11UUMXXUCURR15(2)Sales in the Posting Period

UM12SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM12HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM12UUMXXUCURR15(2)Sales in the Posting Period
UM13SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM13HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM13UUMXXUCURR15(2)Sales in the Posting Period
UM14SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM14HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM14UUMXXUCURR15(2)Sales in the Posting Period
UM15SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM15HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM15UUMXXUCURR15(2)Sales in the Posting Period
UM16SUMXXSCURR15(2)Total of the Debit Postings for the Month
UM16HUMXXHCURR15(2)Total of the Credit Postings for the Month
UM16UUMXXUCURR15(2)Sales in the Posting Period
BABZGBABZGCURR15(2)Authorized deductions (in local currency)
UABZGUABZGCURR15(2)Accepted deductions taken after end of discount period
KZINSKZINSCURR15(2)Acc.int.calc.numerator for payment arrears in fiscal year
KUMAGKUMAGCURR15(2)Accumulated clearing amount in the fiscal year



Key field
Non-key field

KNC1 relationships with other tables


BOSG-Uppermost Hierarchy Segment for BRF
     BKPF-Accounting Document Header
          BSEG-Accounting Document Segment
          BSET-Tax Data Document Segment
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
     KNA1-General Data in Customer Master
          KNBK-Customer Master (Bank Details)
          KNB1-Customer Master (Company Code)
               KNB4-Customer Payment History
               KNB5-Customer Master (Dunning Data)
               KNKK-Credit Management Cust. Mstr: Control Area Data
               KNC1-Customer Master (Transaction Figures)
               KNC3-Customer Master (Special G/L Transaction Figures)
     LFA1-Vendor Master (General Section)
          LFBK-Vendor Master (Bank Details)
          LFB1-Vendor Master (Company Code)
               LFB5-Vendor Master (Dunning Data)
               LFC1-Vendor Master (Transaction Figures)
               LFC3-Vendor Master (Transaction Figures) Special Ledger
     SKA1-G/L Account Master Record (Chart of Accounts)
          SKB1-G/L Account Master Record (Company Code)
               SKC1A-G/L Sales Segment Derived from GLDB - Internal
               SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


KNA1-General Data in Customer Master
     ADDR1_VAL-Address Data
     KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
     KNKA-Customer Master Credit Management: Central Data
     KNKK-Credit Management Cust. Mstr: Control Area Data
     KNBK-Customer Master (Bank Details)
     KNB1-Customer Master (Company Code)
          KNB4-Customer Payment History
          KNB5-Customer Master (Dunning Data)
          KNC1-Customer Master (Transaction Figures)
          KNC3-Customer Master (Special G/L Transaction Figures)
          BSID-Accounting: Secondary Index for Customers
               ADMI_FILES-Archive Files
               BSIDEXT-Secondary Index & Additions Section (bsega)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                         GSEG-Offsetting Items for B-Segment in Reporting