SAP ABAP View KNC1_AEDAT (BW FI: KNC1 Extraction using AEDAT)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ BWFI (Package) BW: Delta Process for Data Extraction in FI

Basic Data

View Type	D	Database View
Database View	KNC1_AEDAT
Short Description	BW FI: KNC1 Extraction using AEDAT
Root table	KNC1	Customer master (transaction figures)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNC1	KNC1
2	BWFI_AEDA2

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BWFI_AEDA2	MANDT	JL	EQ				0	0
2	KNC1	MANDT	JR	EQ			AND	0	0
3	BWFI_AEDA2	KONTO	JL	EQ				0	0
4	KNC1	KUNNR	JR	EQ			AND	0	0
5	BWFI_AEDA2	BUKRS	JL	EQ				0	0
6	KNC1	BUKRS	JR	EQ			AND	0	0
7	BWFI_AEDA2	GJAHR	JL	EQ				0	0
8	KNC1	GJAHR	JR	EQ			AND	0	0
9	BWFI_AEDA2	TABNAME		EQ	'KNC1'		AND	0	0
10	BWFI_AEDA2	GSBER		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNC1	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNC1	KUNNR		☐	KUNNR	☐	Customer Number
3	BUKRS	KNC1	BUKRS		☐	BUKRS	☐	Company Code
4	GJAHR	KNC1	GJAHR		☐	GJAHR	☐	Fiscal Year
5	TABNAME	BWFI_AEDA2	TABNAME		☐	TABNAME	☐	Table Name
6	GSBER	BWFI_AEDA2	GSBER		☐	GSBER	☐	Business Area
7	ERDAT	KNC1	ERDAT		☐	ERDAT	☐	Date on which the record was created
8	USNAM	KNC1	USNAM		☐	USNAM	☐	User name
9	UMSAV	KNC1	UMSAV		☐	UMSAV	☐	Balance Carried Forward in Local Currency
10	UM01S	KNC1	UM01S		☐	UMXXS	☐	Total of the Debit Postings for the Month
11	UM01H	KNC1	UM01H		☐	UMXXH	☐	Total of the Credit Postings for the Month
12	UM01U	KNC1	UM01U		☐	UMXXU	☐	Sales in the Posting Period
13	UM02S	KNC1	UM02S		☐	UMXXS	☐	Total of the Debit Postings for the Month
14	UM02H	KNC1	UM02H		☐	UMXXH	☐	Total of the Credit Postings for the Month
15	UM02U	KNC1	UM02U		☐	UMXXU	☐	Sales in the Posting Period
16	UM03S	KNC1	UM03S		☐	UMXXS	☐	Total of the Debit Postings for the Month
17	UM03H	KNC1	UM03H		☐	UMXXH	☐	Total of the Credit Postings for the Month
18	UM03U	KNC1	UM03U		☐	UMXXU	☐	Sales in the Posting Period
19	UM04S	KNC1	UM04S		☐	UMXXS	☐	Total of the Debit Postings for the Month
20	UM04H	KNC1	UM04H		☐	UMXXH	☐	Total of the Credit Postings for the Month
21	UM04U	KNC1	UM04U		☐	UMXXU	☐	Sales in the Posting Period
22	UM05S	KNC1	UM05S		☐	UMXXS	☐	Total of the Debit Postings for the Month
23	UM05H	KNC1	UM05H		☐	UMXXH	☐	Total of the Credit Postings for the Month
24	UM05U	KNC1	UM05U		☐	UMXXU	☐	Sales in the Posting Period
25	UM06S	KNC1	UM06S		☐	UMXXS	☐	Total of the Debit Postings for the Month
26	UM06H	KNC1	UM06H		☐	UMXXH	☐	Total of the Credit Postings for the Month
27	UM06U	KNC1	UM06U		☐	UMXXU	☐	Sales in the Posting Period
28	UM07S	KNC1	UM07S		☐	UMXXS	☐	Total of the Debit Postings for the Month
29	UM07H	KNC1	UM07H		☐	UMXXH	☐	Total of the Credit Postings for the Month
30	UM07U	KNC1	UM07U		☐	UMXXU	☐	Sales in the Posting Period
31	UM08S	KNC1	UM08S		☐	UMXXS	☐	Total of the Debit Postings for the Month
32	UM08H	KNC1	UM08H		☐	UMXXH	☐	Total of the Credit Postings for the Month
33	UM08U	KNC1	UM08U		☐	UMXXU	☐	Sales in the Posting Period
34	UM09S	KNC1	UM09S		☐	UMXXS	☐	Total of the Debit Postings for the Month
35	UM09H	KNC1	UM09H		☐	UMXXH	☐	Total of the Credit Postings for the Month
36	UM09U	KNC1	UM09U		☐	UMXXU	☐	Sales in the Posting Period
37	UM10S	KNC1	UM10S		☐	UMXXS	☐	Total of the Debit Postings for the Month
38	UM10H	KNC1	UM10H		☐	UMXXH	☐	Total of the Credit Postings for the Month
39	UM10U	KNC1	UM10U		☐	UMXXU	☐	Sales in the Posting Period
40	UM11S	KNC1	UM11S		☐	UMXXS	☐	Total of the Debit Postings for the Month
41	UM11H	KNC1	UM11H		☐	UMXXH	☐	Total of the Credit Postings for the Month
42	UM11U	KNC1	UM11U		☐	UMXXU	☐	Sales in the Posting Period
43	UM12S	KNC1	UM12S		☐	UMXXS	☐	Total of the Debit Postings for the Month
44	UM12H	KNC1	UM12H		☐	UMXXH	☐	Total of the Credit Postings for the Month
45	UM12U	KNC1	UM12U		☐	UMXXU	☐	Sales in the Posting Period
46	UM13S	KNC1	UM13S		☐	UMXXS	☐	Total of the Debit Postings for the Month
47	UM13H	KNC1	UM13H		☐	UMXXH	☐	Total of the Credit Postings for the Month
48	UM13U	KNC1	UM13U		☐	UMXXU	☐	Sales in the Posting Period
49	UM14S	KNC1	UM14S		☐	UMXXS	☐	Total of the Debit Postings for the Month
50	UM14H	KNC1	UM14H		☐	UMXXH	☐	Total of the Credit Postings for the Month
51	UM14U	KNC1	UM14U		☐	UMXXU	☐	Sales in the Posting Period
52	UM15S	KNC1	UM15S		☐	UMXXS	☐	Total of the Debit Postings for the Month
53	UM15H	KNC1	UM15H		☐	UMXXH	☐	Total of the Credit Postings for the Month
54	UM15U	KNC1	UM15U		☐	UMXXU	☐	Sales in the Posting Period
55	UM16S	KNC1	UM16S		☐	UMXXS	☐	Total of the Debit Postings for the Month
56	UM16H	KNC1	UM16H		☐	UMXXH	☐	Total of the Credit Postings for the Month
57	UM16U	KNC1	UM16U		☐	UMXXU	☐	Sales in the Posting Period
58	BABZG	KNC1	BABZG		☐	BABZG	☐	Authorized deductions (in local currency)
59	UABZG	KNC1	UABZG		☐	UABZG	☐	Accepted deductions taken after end of discount period
60	KZINS	KNC1	KZINS		☐	KZINS	☐	Acc.int.calc.numerator for payment arrears in fiscal year
61	KUMAG	KNC1	KUMAG		☐	KUMAG	☐	Accumulated clearing amount in the fiscal year
62	AEDAT	BWFI_AEDA2	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
63	AETIM	BWFI_AEDA2	AETIM		☐	CPUTM	☐	Time of data entry

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in