SAP TABLES | Financial Accounting(FI) SAP FI

KNC3 SAP Customer master (special G/L transaction figures) Table and data







KNC3 is a standard SAP Table which is used to store Customer master (special G/L 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 KNC3 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 KNC3 Table fields within data Dictionary






FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
BUKRSBUKRSCHAR4 T001Company Code
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
SHBKZUMSKZCHAR1
*
Special G/L Indicator
SALDVSALDVCURR15(2) Balance Carried Forward in Local Currency
SOLLLSOLLLCURR15(2) Total of the Debit Postings in the Current Year
HABNLHABNLCURR15(2) Credit Postings Total in the Current Year



Key field
Non-key field

KNC3 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