SAP ABAP Table KNC1_AEDAT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	KNC1_AEDAT	Table Relationship Diagram
Short Description	Generated Table for View

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	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	TABNAME	☑	TABNAME	AS4TAB	CHAR	30	0	Table Name
6	GSBER	☑	GSBER	GSBER	CHAR	4	0	Business Area
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name
9	UMSAV	☐	UMSAV	WRTV8	CURR	15	2	Balance Carried Forward in Local Currency
10	UM01S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
11	UM01H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
12	UM01U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
13	UM02S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
14	UM02H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
15	UM02U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
16	UM03S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
17	UM03H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
18	UM03U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
19	UM04S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
20	UM04H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
21	UM04U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
22	UM05S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
23	UM05H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
24	UM05U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
25	UM06S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
26	UM06H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
27	UM06U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
28	UM07S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
29	UM07H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
30	UM07U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
31	UM08S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
32	UM08H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
33	UM08U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
34	UM09S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
35	UM09H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
36	UM09U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
37	UM10S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
38	UM10H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
39	UM10U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
40	UM11S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
41	UM11H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
42	UM11U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
43	UM12S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
44	UM12H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
45	UM12U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
46	UM13S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
47	UM13H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
48	UM13U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
49	UM14S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
50	UM14H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
51	UM14U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
52	UM15S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
53	UM15H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
54	UM15U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
55	UM16S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
56	UM16H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
57	UM16U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
58	BABZG	☐	BABZG	WRTV8	CURR	15	2	Authorized deductions (in local currency)
59	UABZG	☐	UABZG	WRTV8	CURR	15	2	Accepted deductions taken after end of discount period
60	KZINS	☐	KZINS	WRTV8	CURR	15	2	Acc.int.calc.numerator for payment arrears in fiscal year
61	KUMAG	☐	KUMAG	WRTV8	CURR	15	2	Accumulated clearing amount in the fiscal year
62	AEDAT	☐	AEDAT_BKPF	DATUM	DATS	8	0	Date of the Last Document Change by Transaction
63	AETIM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in