SAP ABAP View KNC3_AEDAT (BW FI: KNC3 Extraction usign 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	KNC3_AEDAT
Short Description	BW FI: KNC3 Extraction usign AEDAT
Root table	KNC3	Customer master (special G/L transaction figures)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNC3	KNC3
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	KNC3	MANDT	JR	EQ			AND	0	0
3	BWFI_AEDA2	KONTO	JL	EQ				0	0
4	KNC3	KUNNR	JR	EQ			AND	0	0
5	BWFI_AEDA2	BUKRS	JL	EQ				0	0
6	KNC3	BUKRS	JR	EQ			AND	0	0
7	BWFI_AEDA2	GJAHR	JL	EQ				0	0
8	KNC3	GJAHR	JR	EQ			AND	0	0
9	BWFI_AEDA2	TABNAME		EQ	'KNC3'		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	KNC3	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNC3	KUNNR		☐	KUNNR	☐	Customer Number
3	BUKRS	KNC3	BUKRS		☐	BUKRS	☐	Company Code
4	GJAHR	KNC3	GJAHR		☐	GJAHR	☐	Fiscal Year
5	SHBKZ	KNC3	SHBKZ		☐	UMSKZ	☐	Special G/L Indicator
6	TABNAME	BWFI_AEDA2	TABNAME		☐	TABNAME	☐	Table Name
7	GSBER	BWFI_AEDA2	GSBER		☐	GSBER	☐	Business Area
8	SALDV	KNC3	SALDV		☐	SALDV	☐	Balance Carried Forward in Local Currency
9	SOLLL	KNC3	SOLLL		☐	SOLLL	☐	Total of the Debit Postings in the Current Year
10	HABNL	KNC3	HABNL		☐	HABNL	☐	Credit Postings Total in the Current Year
11	AEDAT	BWFI_AEDA2	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
12	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