SAP ABAP View BKPF_AEDAT (BW FI: BKPF 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	BKPF_AEDAT
Short Description	BW FI: BKPF Extraction Using AEDAT
Root table	BKPF	Accounting Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BKPF	BKPF
2	BWFI_AEDAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BWFI_AEDAT	MANDT	JL	EQ				0	0
2	BKPF	MANDT	JR	EQ			AND	0	0
3	BWFI_AEDAT	BUKRS	JL	EQ				0	0
4	BKPF	BUKRS	JR	EQ			AND	0	0
5	BWFI_AEDAT	BELNR	JL	EQ				0	0
6	BKPF	BELNR	JR	EQ			AND	0	0
7	BWFI_AEDAT	GJAHR	JL	EQ				0	0
8	BKPF	GJAHR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	BWFI_AEDAT	*		☐		☐
2	MANDT	BWFI_AEDAT	MANDT		☐	MANDT	☐	Client
3	BUKRS	BWFI_AEDAT	BUKRS		☐	BUKRS	☐	Company Code
4	BELNR	BWFI_AEDAT	BELNR		☐	BELNR_D	☐	Accounting Document Number
5	GJAHR	BWFI_AEDAT	GJAHR		☐	GJAHR	☐	Fiscal Year
6	AEDAT	BWFI_AEDAT	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
7	AETIM	BWFI_AEDAT	AETIM		☐	CPUTM	☐	Time of data entry
8	TIMEST	BWFI_AEDAT	TIMEST		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	*	BKPF	*		☐		☐
10	-	BKPF	MANDT		☐	MANDT	☐	Client
11	-	BKPF	BUKRS		☐	BUKRS	☐	Company Code
12	-	BKPF	BELNR		☐	BELNR_D	☐	Accounting Document Number
13	-	BKPF	GJAHR		☐	GJAHR	☐	Fiscal Year
14	BLART	BKPF	BLART		☐	BLART	☐	Document type
15	BLDAT	BKPF	BLDAT		☐	BLDAT	☐	Document Date in Document
16	BUDAT	BKPF	BUDAT		☐	BUDAT	☐	Posting Date in the Document
17	MONAT	BKPF	MONAT		☐	MONAT	☐	Fiscal period
18	CPUDT	BKPF	CPUDT		☐	CPUDT	☐	Accounting document entry date
19	CPUTM	BKPF	CPUTM		☐	CPUTM	☐	Time of data entry
20	-	BKPF	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
21	UPDDT	BKPF	UPDDT		☐	UPDDT	☐	Date of the Last Document Update
22	WWERT	BKPF	WWERT		☐	WWERT_D	☐	Translation date
23	USNAM	BKPF	USNAM		☐	USNAM	☐	User name
24	TCODE	BKPF	TCODE		☐	TCODE	☐	Transaction Code
25	BVORG	BKPF	BVORG		☐	BVORG	☐	Number of Cross-Company Code Posting Transaction
26	XBLNR	BKPF	XBLNR		☐	XBLNR1	☐	Reference Document Number
27	DBBLG	BKPF	DBBLG		☐	DBBLG	☐	Recurring Entry Document Number
28	STBLG	BKPF	STBLG		☐	STBLG	☐	Reverse Document Number
29	STJAH	BKPF	STJAH		☐	STJAH	☐	Reverse document fiscal year
30	BKTXT	BKPF	BKTXT		☐	BKTXT	☐	Document Header Text
31	WAERS	BKPF	WAERS		☐	WAERS	☐	Currency Key
32	KURSF	BKPF	KURSF		☐	KURSF	☐	Exchange rate
33	KZWRS	BKPF	KZWRS		☐	KZWRS	☐	Currency Key for the Group Currency
34	KZKRS	BKPF	KZKRS		☐	KZKRS	☐	Group Currency Exchange Rate
35	BSTAT	BKPF	BSTAT		☐	BSTAT_D	☐	Document Status
36	XNETB	BKPF	XNETB		☐	XNETB	☐	Indicator: Document posted net ?
37	FRATH	BKPF	FRATH		☐	FRATH	☐	Unplanned Delivery Costs
38	XRUEB	BKPF	XRUEB		☐	XRUEB	☐	Indicator: Document is posted to a previous period
39	GLVOR	BKPF	GLVOR		☐	GLVOR	☐	Business Transaction
40	GRPID	BKPF	GRPID		☐	GRPID_BKPF	☐	Batch Input Session Name
41	DOKID	BKPF	DOKID		☐	DOKID_BKPF	☐	Document Name in the Archive System
42	ARCID	BKPF	ARCID		☐	EXTID_BKPF	☐	Extract ID Document Header
43	IBLAR	BKPF	IBLAR		☐	IBLAR	☐	Internal Document Type for Document Control
44	AWTYP	BKPF	AWTYP		☐	AWTYP	☐	Reference procedure
45	AWKEY	BKPF	AWKEY		☐	AWKEY	☐	Object key
46	FIKRS	BKPF	FIKRS		☐	FIKRS	☐	Financial Management Area
47	HWAER	BKPF	HWAER		☐	HWAER	☐	Local Currency
48	HWAE2	BKPF	HWAE2		☐	HWAE2	☐	Currency Key of Second Local Currency
49	HWAE3	BKPF	HWAE3		☐	HWAE3	☐	Currency Key of Third Local Currency
50	KURS2	BKPF	KURS2		☐	KURS2	☐	Exchange Rate for the Second Local Currency
51	KURS3	BKPF	KURS3		☐	KURS3	☐	Exchange Rate for the Third Local Currency
52	BASW2	BKPF	BASW2		☐	CURSR	☐	Source Currency for Currency Translation
53	BASW3	BKPF	BASW3		☐	CURSR	☐	Source Currency for Currency Translation
54	UMRD2	BKPF	UMRD2		☐	UMRD2	☐	Translation Date Type for Second Local Currency
55	UMRD3	BKPF	UMRD3		☐	UMRD3	☐	Translation Date Type for Third Local Currency
56	XSTOV	BKPF	XSTOV		☐	XSTOV	☐	Indicator: Document is flagged for reversal
57	STODT	BKPF	STODT		☐	STODT	☐	Planned Date for the Reverse Posting
58	XMWST	BKPF	XMWST		☐	XMWST	☐	Calculate tax automatically
59	CURT2	BKPF	CURT2		☐	CURT2	☐	Currency Type of Second Local Currency
60	CURT3	BKPF	CURT3		☐	CURT3	☐	Currency Type of Third Local Currency
61	KUTY2	BKPF	KUTY2		☐	KURST	☐	Exchange Rate Type
62	KUTY3	BKPF	KUTY3		☐	KURST	☐	Exchange Rate Type
63	XSNET	BKPF	XSNET		☐	XSNET	☐	G/L account amounts entered exclude tax
64	AUSBK	BKPF	AUSBK		☐	AUSBK	☐	Source Company Code
65	XUSVR	BKPF	XUSVR		☐	XUSVR_BKPF	☐	Indicator: US taxes changed at detail level ?
66	DUEFL	BKPF	DUEFL		☐	DUEFL_BKPF	☐	Status of Data Transfer into Subsequent Release
67	AWSYS	BKPF	AWSYS		☐	LOGSYSTEM	☐	Logical System
68	TXKRS	BKPF	TXKRS		☐	TXKRS_BKPF	☐	Exchange Rate for Taxes
69	LOTKZ	BKPF	LOTKZ		☐	PSO_LOTKZ	☐	Lot Number for Requests
70	XWVOF	BKPF	XWVOF		☐	XWVOF	☐	Indicator: Customer bill of exchange payment before due date
71	STGRD	BKPF	STGRD		☐	STGRD	☐	Reason for Reversal
72	PPNAM	BKPF	PPNAM		☐	PPNAM	☐	Name of User Who Parked this Document
73	BRNCH	BKPF	BRNCH		☐	J_1ABRNCH	☐	Branch number
74	NUMPG	BKPF	NUMPG		☐	J_1ANOPG	☐	Number of pages of invoice
75	ADISC	BKPF	ADISC		☐	J_1ADISC	☐	Indicator: entry represents a discount document
76	XREF1_HD	BKPF	XREF1_HD		☐	XREF1_HD	☐	Reference Key 1 Internal for Document Header
77	XREF2_HD	BKPF	XREF2_HD		☐	XREF2_HD	☐	Reference Key 2 Internal for Document Header
78	XREVERSAL	BKPF	XREVERSAL		☐	XREVERSAL	☐	Specifies whether doc. is reversal doc. or reversed doc.
79	REINDAT	BKPF	REINDAT		☐	REINDAT	☐	Invoice Receipt Date
80	RLDNR	BKPF	RLDNR		☐	FAGL_RLDNR	☐	Ledger in General Ledger Accounting
81	LDGRP	BKPF	LDGRP		☐	FAGL_LDGRP	☐	Ledger Group
82	PROPMANO	BKPF	PROPMANO		☐	RE_MANDAT	☐	Real Estate Management Mandate
83	XBLNR_ALT	BKPF	XBLNR_ALT		☐	XBLNR_ALT	☐	Alternative Reference Number
84	VATDATE	BKPF	VATDATE		☐	VATDATE	☐	Tax Reporting Date
85	DOCCAT	BKPF	DOCCAT		☐	DOCUMENT_CATEGORY	☐	Classification of an FI Document
86	XSPLIT	BKPF	XSPLIT		☐	SPLIT_POSTING	☐	FI Document Originates from Split Posting (Indicator)
87	CASH_ALLOC	BKPF	CASH_ALLOC		☐	FAGL_CASH_ALLOC	☐	Cash-Relevant Document
88	FOLLOW_ON	BKPF	FOLLOW_ON		☐	FAGL_FOLLOW_ON	☐	Follow-on document indicator
89	XREORG	BKPF	XREORG		☐	FAGL_R_XDOC_REORG	☐	Doc. Contains Open Item that Was Transferred During Reorg.
90	SUBSET	BKPF	SUBSET		☐	ACC_SUBSET	☐	Defines subset of components for the FI/CO interface
91	KURST	BKPF	KURST		☐	KURST	☐	Exchange Rate Type
92	KURSX	BKPF	KURSX		☐	GLE_FXR_DTE_RATEX28	☐	Market Data Exchange Rate
93	KUR2X	BKPF	KUR2X		☐	GLE_FXR_DTE_RATE2X28	☐	Market Data Exchange Rate 2
94	KUR3X	BKPF	KUR3X		☐	GLE_FXR_DTE_RATE3X28	☐	Market Data Exchange Rate 3
95	XMCA	BKPF	XMCA		☐	GLE_DTE_MCA_XMCA	☐	Document Originates from Multi Currency Accounting
96	/SAPF15/STATUS	BKPF	/SAPF15/STATUS		☐	/SAPF15/STATUS	☐	Document Status
97	PSOTY	BKPF	PSOTY		☐	PSOTY_D	☐	Document category payment requests
98	PSOAK	BKPF	PSOAK		☐	PSOAK	☐	Reason
99	PSOKS	BKPF	PSOKS		☐	PSOKS	☐	Region
100	PSOSG	BKPF	PSOSG		☐	PSOSG	☐	Reason for reversal - IS-PS requests
101	PSOFN	BKPF	PSOFN		☐	PSOFN	☐	IS-PS: File number
102	INTFORM	BKPF	INTFORM		☐	FM_INTFORM	☐	Interest Formula
103	INTDATE	BKPF	INTDATE		☐	FM_INTDATE	☐	Interest Calc. Date
104	PSOBT	BKPF	PSOBT		☐	PSOBT	☐	Posting Day
105	PSOZL	BKPF	PSOZL		☐	PSOZL	☐	Actual posting
106	PSODT	BKPF	PSODT		☐	AEDAT	☐	Last Changed On
107	PSOTM	BKPF	PSOTM		☐	PSOTM	☐	Last changed at
108	FM_UMART	BKPF	FM_UMART		☐	FM_UMART	☐	Type of Payment Transfer
109	CCINS	BKPF	CCINS		☐	CCINS_30F	☐	Payment cards: Card type
110	CCNUM	BKPF	CCNUM		☐	CCNUM_30F	☐	Payment cards: Card number
111	SSBLK	BKPF	SSBLK		☐	SSBLK	☐	Payment Statistical Sampling Block
112	BATCH	BKPF	BATCH		☐	LOTKZ	☐	Lot Number for Documents
113	SNAME	BKPF	SNAME		☐	UNAME	☐	User Name
114	SAMPLED	BKPF	SAMPLED		☐	SAMPLED	☐	Sampled Invoice by Payment Certification
115	EXCLUDE_FLAG	BKPF	EXCLUDE_FLAG		☐	EXCLUDE_FLG	☐	PPA Exclude Indicator
116	BLIND	BKPF	BLIND		☐	FM_BLIND	☐	Budgetary Ledger Indicator
117	OFFSET_STATUS	BKPF	OFFSET_STATUS		☐	FMFG_OFFSET_STATUS	☐	Treasury Offset Status
118	OFFSET_REFER_DAT	BKPF	OFFSET_REFER_DAT		☐	FMFG_REFERRED_OFFSET_DAT	☐	Date Record Referred to Treasury
119	PENRC	BKPF	PENRC		☐	PENRC	☐	Reason for Late Payment
120	KNUMV	BKPF	KNUMV		☐	KNUMV	☐	Number of the document condition

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	20140121
SAP Release Created in