SAP ABAP Table KNC1 (Customer master (transaction figures))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FBAS (Package) Financial accounting 'Basis'
Basic Data
Table Category TRANSP    Transparent table 
Transparent table KNC1   Table Relationship Diagram
Short Description Customer master (transaction figures)    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code KNB1
4 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
5 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
6 USNAM USNAM XUBNAME CHAR 12   0   User name *
7 UMSAV UMSAV WRTV8 CURR 15   2   Balance Carried Forward in Local Currency  
8 UM01S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
9 UM01H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
10 UM01U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
11 UM02S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
12 UM02H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
13 UM02U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
14 UM03S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
15 UM03H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
16 UM03U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
17 UM04S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
18 UM04H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
19 UM04U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
20 UM05S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
21 UM05H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
22 UM05U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
23 UM06S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
24 UM06H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
25 UM06U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
26 UM07S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
27 UM07H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
28 UM07U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
29 UM08S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
30 UM08H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
31 UM08U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
32 UM09S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
33 UM09H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
34 UM09U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
35 UM10S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
36 UM10H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
37 UM10U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
38 UM11S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
39 UM11H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
40 UM11U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
41 UM12S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
42 UM12H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
43 UM12U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
44 UM13S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
45 UM13H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
46 UM13U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
47 UM14S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
48 UM14H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
49 UM14U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
50 UM15S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
51 UM15H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
52 UM15U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
53 UM16S UMXXS WRTV8 CURR 15   2   Total of the Debit Postings for the Month  
54 UM16H UMXXH WRTV8 CURR 15   2   Total of the Credit Postings for the Month  
55 UM16U UMXXU UMXXX CURR 15   2   Sales in the Posting Period  
56 BABZG BABZG WRTV8 CURR 15   2   Authorized deductions (in local currency)  
57 UABZG UABZG WRTV8 CURR 15   2   Accepted deductions taken after end of discount period  
58 KZINS KZINS WRTV8 CURR 15   2   Acc.int.calc.numerator for payment arrears in fiscal year  
59 KUMAG KUMAG WRTV8 CURR 15   2   Accumulated clearing amount in the fiscal year  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 KNC1 BUKRS KNB1 BUKRS KEY 1 CN
2 KNC1 KUNNR KNA1 KUNNR KEY 1 CN
3 KNC1 MANDT T000 MANDT KEY 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in