SAP ABAP Table TXI_KNC1 (Customer master (transaction figures))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_KNC1	Table Relationship Diagram
Short Description	Customer master (transaction figures)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Customer master (transaction figures)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	KNB1
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
8	UMSAV	☐	UMSAV	WRTV8	CURR	15	2	Balance Carried Forward in Local Currency
9	UM01S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
10	UM01H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
11	UM01U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
12	UM02S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
13	UM02H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
14	UM02U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
15	UM03S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
16	UM03H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
17	UM03U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
18	UM04S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
19	UM04H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
20	UM04U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
21	UM05S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
22	UM05H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
23	UM05U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
24	UM06S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
25	UM06H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
26	UM06U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
27	UM07S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
28	UM07H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
29	UM07U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
30	UM08S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
31	UM08H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
32	UM08U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
33	UM09S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
34	UM09H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
35	UM09U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
36	UM10S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
37	UM10H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
38	UM10U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
39	UM11S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
40	UM11H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
41	UM11U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
42	UM12S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
43	UM12H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
44	UM12U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
45	UM13S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
46	UM13H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
47	UM13U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
48	UM14S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
49	UM14H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
50	UM14U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
51	UM15S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
52	UM15H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
53	UM15U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
54	UM16S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
55	UM16H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
56	UM16U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
57	BABZG	☐	BABZG	WRTV8	CURR	15	2	Authorized deductions (in local currency)
58	UABZG	☐	UABZG	WRTV8	CURR	15	2	Accepted deductions taken after end of discount period
59	KZINS	☐	KZINS	WRTV8	CURR	15	2	Acc.int.calc.numerator for payment arrears in fiscal year
60	KUMAG	☐	KUMAG	WRTV8	CURR	15	2	Accumulated clearing amount in the fiscal year
61	UMSAV_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
62	UM01S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
63	UM01H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
64	UM01U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
65	UM02S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
66	UM02H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
67	UM02U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
68	UM03S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
69	UM03H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
70	UM03U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
71	UM04S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
72	UM04H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
73	UM04U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
74	UM05S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
75	UM05H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
76	UM05U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
77	UM06S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
78	UM06H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
79	UM06U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
80	UM07S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
81	UM07H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
82	UM07U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
83	UM08S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
84	UM08H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
85	UM08U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
86	UM09S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
87	UM09H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
88	UM09U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
89	UM10S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
90	UM10H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
91	UM10U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
92	UM11S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
93	UM11H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
94	UM11U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
95	UM12S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
96	UM12H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
97	UM12U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
98	UM13S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
99	UM13H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
100	UM13U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
101	UM14S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
102	UM14H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
103	UM14U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
104	UM15S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
105	UM15H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
106	UM15U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
107	UM16S_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
108	UM16H_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
109	UM16U_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
110	BABZG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
111	UABZG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
112	KZINS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
113	KUMAG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_KNC1	BUKRS	KNB1	BUKRS	KEY	1	CN
2	TXI_KNC1	KUNNR	KNA1	KUNNR	KEY	1	CN
3	TXI_KNC1	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in