SAP ABAP View LFC1_AEDAT (BW FI: LFC1 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	LFC1_AEDAT
Short Description	BW FI: LFC1 Extraction usign AEDAT
Root table	LFC1	Vendor master (transaction figures)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LFC1	LFC1
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	LFC1	MANDT	JR	EQ			AND	0	0
3	BWFI_AEDA2	KONTO	JL	EQ				0	0
4	LFC1	LIFNR	JR	EQ			AND	0	0
5	BWFI_AEDA2	BUKRS	JL	EQ				0	0
6	LFC1	BUKRS	JR	EQ			AND	0	0
7	BWFI_AEDA2	GJAHR	JL	EQ				0	0
8	LFC1	GJAHR	JR	EQ			AND	0	0
9	BWFI_AEDA2	TABNAME		EQ	'LFC1'		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	LFC1	MANDT		☐	MANDT	☐	Client
2	LIFNR	LFC1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
3	BUKRS	LFC1	BUKRS		☐	BUKRS	☐	Company Code
4	GJAHR	LFC1	GJAHR		☐	GJAHR	☐	Fiscal Year
5	TABNAME	BWFI_AEDA2	TABNAME		☐	TABNAME	☐	Table Name
6	GSBER	BWFI_AEDA2	GSBER		☐	GSBER	☐	Business Area
7	ERDAT	LFC1	ERDAT		☐	ERDAT	☐	Date on which the record was created
8	USNAM	LFC1	USNAM		☐	USNAM	☐	User name
9	UMSAV	LFC1	UMSAV		☐	UMSAV	☐	Balance Carried Forward in Local Currency
10	UM01S	LFC1	UM01S		☐	UMXXS	☐	Total of the Debit Postings for the Month
11	UM01H	LFC1	UM01H		☐	UMXXH	☐	Total of the Credit Postings for the Month
12	UM01U	LFC1	UM01U		☐	UMXXU	☐	Sales in the Posting Period
13	UM02S	LFC1	UM02S		☐	UMXXS	☐	Total of the Debit Postings for the Month
14	UM02H	LFC1	UM02H		☐	UMXXH	☐	Total of the Credit Postings for the Month
15	UM02U	LFC1	UM02U		☐	UMXXU	☐	Sales in the Posting Period
16	UM03S	LFC1	UM03S		☐	UMXXS	☐	Total of the Debit Postings for the Month
17	UM03H	LFC1	UM03H		☐	UMXXH	☐	Total of the Credit Postings for the Month
18	UM03U	LFC1	UM03U		☐	UMXXU	☐	Sales in the Posting Period
19	UM04S	LFC1	UM04S		☐	UMXXS	☐	Total of the Debit Postings for the Month
20	UM04H	LFC1	UM04H		☐	UMXXH	☐	Total of the Credit Postings for the Month
21	UM04U	LFC1	UM04U		☐	UMXXU	☐	Sales in the Posting Period
22	UM05S	LFC1	UM05S		☐	UMXXS	☐	Total of the Debit Postings for the Month
23	UM05H	LFC1	UM05H		☐	UMXXH	☐	Total of the Credit Postings for the Month
24	UM05U	LFC1	UM05U		☐	UMXXU	☐	Sales in the Posting Period
25	UM06S	LFC1	UM06S		☐	UMXXS	☐	Total of the Debit Postings for the Month
26	UM06H	LFC1	UM06H		☐	UMXXH	☐	Total of the Credit Postings for the Month
27	UM06U	LFC1	UM06U		☐	UMXXU	☐	Sales in the Posting Period
28	UM07S	LFC1	UM07S		☐	UMXXS	☐	Total of the Debit Postings for the Month
29	UM07H	LFC1	UM07H		☐	UMXXH	☐	Total of the Credit Postings for the Month
30	UM07U	LFC1	UM07U		☐	UMXXU	☐	Sales in the Posting Period
31	UM08S	LFC1	UM08S		☐	UMXXS	☐	Total of the Debit Postings for the Month
32	UM08H	LFC1	UM08H		☐	UMXXH	☐	Total of the Credit Postings for the Month
33	UM08U	LFC1	UM08U		☐	UMXXU	☐	Sales in the Posting Period
34	UM09S	LFC1	UM09S		☐	UMXXS	☐	Total of the Debit Postings for the Month
35	UM09H	LFC1	UM09H		☐	UMXXH	☐	Total of the Credit Postings for the Month
36	UM09U	LFC1	UM09U		☐	UMXXU	☐	Sales in the Posting Period
37	UM10S	LFC1	UM10S		☐	UMXXS	☐	Total of the Debit Postings for the Month
38	UM10H	LFC1	UM10H		☐	UMXXH	☐	Total of the Credit Postings for the Month
39	UM10U	LFC1	UM10U		☐	UMXXU	☐	Sales in the Posting Period
40	UM11S	LFC1	UM11S		☐	UMXXS	☐	Total of the Debit Postings for the Month
41	UM11H	LFC1	UM11H		☐	UMXXH	☐	Total of the Credit Postings for the Month
42	UM11U	LFC1	UM11U		☐	UMXXU	☐	Sales in the Posting Period
43	UM12S	LFC1	UM12S		☐	UMXXS	☐	Total of the Debit Postings for the Month
44	UM12H	LFC1	UM12H		☐	UMXXH	☐	Total of the Credit Postings for the Month
45	UM12U	LFC1	UM12U		☐	UMXXU	☐	Sales in the Posting Period
46	UM13S	LFC1	UM13S		☐	UMXXS	☐	Total of the Debit Postings for the Month
47	UM13H	LFC1	UM13H		☐	UMXXH	☐	Total of the Credit Postings for the Month
48	UM13U	LFC1	UM13U		☐	UMXXU	☐	Sales in the Posting Period
49	UM14S	LFC1	UM14S		☐	UMXXS	☐	Total of the Debit Postings for the Month
50	UM14H	LFC1	UM14H		☐	UMXXH	☐	Total of the Credit Postings for the Month
51	UM14U	LFC1	UM14U		☐	UMXXU	☐	Sales in the Posting Period
52	UM15S	LFC1	UM15S		☐	UMXXS	☐	Total of the Debit Postings for the Month
53	UM15H	LFC1	UM15H		☐	UMXXH	☐	Total of the Credit Postings for the Month
54	UM15U	LFC1	UM15U		☐	UMXXU	☐	Sales in the Posting Period
55	UM16S	LFC1	UM16S		☐	UMXXS	☐	Total of the Debit Postings for the Month
56	UM16H	LFC1	UM16H		☐	UMXXH	☐	Total of the Credit Postings for the Month
57	UM16U	LFC1	UM16U		☐	UMXXU	☐	Sales in the Posting Period
58	AEDAT	BWFI_AEDA2	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
59	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