SAP ABAP View BKPF_BSAK_AEDAT (BW FI: BSAK 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_BSAK_AEDAT
Short Description	BW FI: BSAK Extraction using AEDAT
Root table	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BKPF	MANDT	JL	EQ				0	0
2	BSAK	MANDT	JR	EQ			AND	0	0
3	BKPF	BUKRS	JL	EQ				0	0
4	BSAK	BUKRS	JR	EQ			AND	0	0
5	BKPF	BELNR	JL	EQ				0	0
6	BSAK	BELNR	JR	EQ			AND	0	0
7	BKPF	GJAHR	JL	EQ				0	0
8	BSAK	GJAHR	JR	EQ			AND	0	0
9	BWFI_AEDAT	MANDT	JL	EQ				0	0
10	BSAK	MANDT	JR	EQ			AND	0	0
11	BWFI_AEDAT	BUKRS	JL	EQ				0	0
12	BSAK	BUKRS	JR	EQ			AND	0	0
13	BWFI_AEDAT	BELNR	JL	EQ				0	0
14	BSAK	BELNR	JR	EQ			AND	0	0
15	BWFI_AEDAT	GJAHR	JL	EQ				0	0
16	BSAK	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	*	BSAK	*		☐		☐
10	-	BSAK	MANDT		☐	MANDT	☐	Client
11	-	BSAK	BUKRS		☐	BUKRS	☐	Company Code
12	LIFNR	BSAK	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
13	UMSKS	BSAK	UMSKS		☐	UMSKS	☐	Special G/L Transaction Type
14	UMSKZ	BSAK	UMSKZ		☐	UMSKZ	☐	Special G/L Indicator
15	AUGDT	BSAK	AUGDT		☐	AUGDT	☐	Clearing Date
16	AUGBL	BSAK	AUGBL		☐	AUGBL	☐	Document Number of the Clearing Document
17	ZUONR	BSAK	ZUONR		☐	DZUONR	☐	Assignment number
18	-	BSAK	GJAHR		☐	GJAHR	☐	Fiscal Year
19	-	BSAK	BELNR		☐	BELNR_D	☐	Accounting Document Number
20	BUZEI	BSAK	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
21	BUDAT	BSAK	BUDAT		☐	BUDAT	☐	Posting Date in the Document
22	BLDAT	BSAK	BLDAT		☐	BLDAT	☐	Document Date in Document
23	CPUDT	BSAK	CPUDT		☐	CPUDT	☐	Accounting document entry date
24	WAERS	BSAK	WAERS		☐	WAERS	☐	Currency Key
25	XBLNR	BSAK	XBLNR		☐	XBLNR1	☐	Reference Document Number
26	BLART	BSAK	BLART		☐	BLART	☐	Document type
27	MONAT	BSAK	MONAT		☐	MONAT	☐	Fiscal period
28	BSCHL	BSAK	BSCHL		☐	BSCHL	☐	Posting Key
29	ZUMSK	BSAK	ZUMSK		☐	DZUMSK	☐	Target Special G/L Indicator
30	SHKZG	BSAK	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
31	GSBER	BSAK	GSBER		☐	GSBER	☐	Business Area
32	MWSKZ	BSAK	MWSKZ		☐	MWSKZ	☐	Tax on sales/purchases code
33	DMBTR	BSAK	DMBTR		☐	DMBTR	☐	Amount in local currency
34	WRBTR	BSAK	WRBTR		☐	WRBTR	☐	Amount in document currency
35	MWSTS	BSAK	MWSTS		☐	MWSTS	☐	Tax Amount in Local Currency
36	WMWST	BSAK	WMWST		☐	WMWST	☐	Tax amount in document currency
37	BDIFF	BSAK	BDIFF		☐	BDIFF	☐	Valuation Difference
38	BDIF2	BSAK	BDIF2		☐	BDIF2	☐	Valuation Difference for the Second Local Currency
39	SGTXT	BSAK	SGTXT		☐	SGTXT	☐	Item Text
40	PROJN	BSAK	PROJN		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
41	AUFNR	BSAK	AUFNR		☐	AUFNR	☐	Order Number
42	ANLN1	BSAK	ANLN1		☐	ANLN1	☐	Main Asset Number
43	ANLN2	BSAK	ANLN2		☐	ANLN2	☐	Asset Subnumber
44	EBELN	BSAK	EBELN		☐	EBELN	☐	Purchasing Document Number
45	EBELP	BSAK	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
46	SAKNR	BSAK	SAKNR		☐	SAKNR	☐	G/L Account Number
47	HKONT	BSAK	HKONT		☐	HKONT	☐	General Ledger Account
48	FKONT	BSAK	FKONT		☐	FIPLS	☐	Financial Budget Item
49	FILKD	BSAK	FILKD		☐	FILKD	☐	Account Number of the Branch
50	ZFBDT	BSAK	ZFBDT		☐	DZFBDT	☐	Baseline date for due date calculation
51	ZTERM	BSAK	ZTERM		☐	DZTERM	☐	Terms of payment key
52	ZBD1T	BSAK	ZBD1T		☐	DZBD1T	☐	Cash discount days 1
53	ZBD2T	BSAK	ZBD2T		☐	DZBD2T	☐	Cash discount days 2
54	ZBD3T	BSAK	ZBD3T		☐	DZBD3T	☐	Net Payment Terms Period
55	ZBD1P	BSAK	ZBD1P		☐	DZBD1P	☐	Cash discount percentage 1
56	ZBD2P	BSAK	ZBD2P		☐	DZBD2P	☐	Cash Discount Percentage 2
57	SKFBT	BSAK	SKFBT		☐	SKFBT	☐	Amount Eligible for Cash Discount in Document Currency
58	SKNTO	BSAK	SKNTO		☐	SKNTO	☐	Cash discount amount in local currency
59	WSKTO	BSAK	WSKTO		☐	WSKTO	☐	Cash Discount Amount in Document Currency
60	ZLSCH	BSAK	ZLSCH		☐	DZLSCH	☐	Payment method
61	ZLSPR	BSAK	ZLSPR		☐	DZLSPR	☐	Payment Block Key
62	ZBFIX	BSAK	ZBFIX		☐	DZBFIX	☐	Fixed Payment Terms
63	HBKID	BSAK	HBKID		☐	HBKID	☐	Short key for a house bank
64	BVTYP	BSAK	BVTYP		☐	BVTYP	☐	Partner bank type
65	REBZG	BSAK	REBZG		☐	REBZG	☐	Number of the Invoice the Transaction Belongs to
66	REBZJ	BSAK	REBZJ		☐	REBZJ	☐	Fiscal Year of the Relevant Invoice (for Credit Memo)
67	REBZZ	BSAK	REBZZ		☐	REBZZ	☐	Line Item in the Relevant Invoice
68	SAMNR	BSAK	SAMNR		☐	SAMNR	☐	Invoice List Number
69	ZOLLT	BSAK	ZOLLT		☐	DZOLLT	☐	Customs Tariff Number
70	ZOLLD	BSAK	ZOLLD		☐	DZOLLD	☐	Customs Date
71	LZBKZ	BSAK	LZBKZ		☐	LZBKZ	☐	State central bank indicator
72	LANDL	BSAK	LANDL		☐	LANDL	☐	Supplying Country
73	DIEKZ	BSAK	DIEKZ		☐	DIEKZ	☐	Service indicator (foreign payment)
74	MANSP	BSAK	MANSP		☐	MANSP	☐	Dunning block
75	MSCHL	BSAK	MSCHL		☐	MSCHL	☐	Dunning key
76	MADAT	BSAK	MADAT		☐	MADAT	☐	Date of Last Dunning Notice
77	MANST	BSAK	MANST		☐	MAHNS_D	☐	Dunning Level
78	MABER	BSAK	MABER		☐	MABER	☐	Dunning Area
79	XNETB	BSAK	XNETB		☐	XNETB	☐	Indicator: Document posted net ?
80	XANET	BSAK	XANET		☐	XANET	☐	Indicator: Down Payment in Net Procedure?
81	XCPDD	BSAK	XCPDD		☐	XCPDD	☐	Indicator: Address and Bank Data Set Individually
82	XESRD	BSAK	XESRD		☐	XESRD	☐	Indicator: Is any ISR data set in the document ?
83	XZAHL	BSAK	XZAHL		☐	XZAHL	☐	Indicator: Is Posting Key Used in a Payment Transaction?
84	MWSK1	BSAK	MWSK1		☐	MWSKX	☐	Tax Code for Distribution
85	DMBT1	BSAK	DMBT1		☐	DMBTX	☐	Amount in Local Currency for Tax Distribution
86	WRBT1	BSAK	WRBT1		☐	WRBTX	☐	Amount in foreign currency for tax breakdown
87	MWSK2	BSAK	MWSK2		☐	MWSKX	☐	Tax Code for Distribution
88	DMBT2	BSAK	DMBT2		☐	DMBTX	☐	Amount in Local Currency for Tax Distribution
89	WRBT2	BSAK	WRBT2		☐	WRBTX	☐	Amount in foreign currency for tax breakdown
90	MWSK3	BSAK	MWSK3		☐	MWSKX	☐	Tax Code for Distribution
91	DMBT3	BSAK	DMBT3		☐	DMBTX	☐	Amount in Local Currency for Tax Distribution
92	WRBT3	BSAK	WRBT3		☐	WRBTX	☐	Amount in foreign currency for tax breakdown
93	QSSKZ	BSAK	QSSKZ		☐	QSSKZ	☐	Withholding Tax Code
94	QSSHB	BSAK	QSSHB		☐	QSSHB	☐	Withholding Tax Base Amount
95	QBSHB	BSAK	QBSHB		☐	QBSHB	☐	Withholding Tax Amount (in Document Currency)
96	BSTAT	BSAK	BSTAT		☐	BSTAT_D	☐	Document Status
97	ANFBN	BSAK	ANFBN		☐	ANFBN	☐	Document Number of the Bill of Exchange Payment Request
98	ANFBJ	BSAK	ANFBJ		☐	ANFBJ	☐	Fiscal Year of the Bill of Exchange Payment Request Document
99	ANFBU	BSAK	ANFBU		☐	ANFBU	☐	Company Code in Which Bill of Exch.Payment Request Is Posted
100	VBUND	BSAK	VBUND		☐	RASSC	☐	Company ID of trading partner
101	REBZT	BSAK	REBZT		☐	REBZT	☐	Follow-On Document Type
102	STCEG	BSAK	STCEG		☐	STCEG	☐	VAT Registration Number
103	EGBLD	BSAK	EGBLD		☐	EGBLD	☐	Country of Destination for Delivery of Goods
104	EGLLD	BSAK	EGLLD		☐	EGLLD	☐	Supplying Country for Delivery of Goods
105	QSZNR	BSAK	QSZNR		☐	QSZNR	☐	Certificate Number of the Withholding Tax Exemption
106	QSFBT	BSAK	QSFBT		☐	QSFBT	☐	Withholding Tax-Exempt Amount (in Document Currency)
107	XINVE	BSAK	XINVE		☐	XINVE	☐	Indicator: Capital Goods Affected?
108	PROJK	BSAK	PROJK		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
109	FIPOS	BSAK	FIPOS		☐	FIPOS	☐	Commitment Item
110	NPLNR	BSAK	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
111	AUFPL	BSAK	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
112	APLZL	BSAK	APLZL		☐	CIM_COUNT	☐	Internal counter
113	XEGDR	BSAK	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
114	DMBE2	BSAK	DMBE2		☐	DMBE2	☐	Amount in Second Local Currency
115	DMBE3	BSAK	DMBE3		☐	DMBE3	☐	Amount in Third Local Currency
116	DMB21	BSAK	DMB21		☐	DMB2X	☐	Amount in Second Local Currency for Tax Breakdown
117	DMB22	BSAK	DMB22		☐	DMB2X	☐	Amount in Second Local Currency for Tax Breakdown
118	DMB23	BSAK	DMB23		☐	DMB2X	☐	Amount in Second Local Currency for Tax Breakdown
119	DMB31	BSAK	DMB31		☐	DMB3X	☐	Amount in Third Local Currency for Tax Breakdown
120	DMB32	BSAK	DMB32		☐	DMB3X	☐	Amount in Third Local Currency for Tax Breakdown
121	DMB33	BSAK	DMB33		☐	DMB3X	☐	Amount in Third Local Currency for Tax Breakdown
122	MWST2	BSAK	MWST2		☐	MWST2	☐	Tax Amount in Second Local Currency
123	MWST3	BSAK	MWST3		☐	MWST3	☐	Tax Amount in Third Local Currency
124	SKNT2	BSAK	SKNT2		☐	SKNT2	☐	Cash Discount Amount in Second Local Currency
125	SKNT3	BSAK	SKNT3		☐	SKNT3	☐	Cash Discount Amount in Third Local Currency
126	BDIF3	BSAK	BDIF3		☐	BDIF3	☐	Valuation Difference for the Third Local Currency
127	XRAGL	BSAK	XRAGL		☐	XRAGL	☐	Indicator: Clearing was Reversed
128	RSTGR	BSAK	RSTGR		☐	RSTGR	☐	Reason Code for Payments
129	UZAWE	BSAK	UZAWE		☐	UZAWE	☐	Payment method supplement
130	KOSTL	BSAK	KOSTL		☐	KOSTL	☐	Cost Center
131	LNRAN	BSAK	LNRAN		☐	LNRAN	☐	Sequence Number of Asset Line Items in Fiscal Year
132	XSTOV	BSAK	XSTOV		☐	XSTOV	☐	Indicator: Document is flagged for reversal
133	KZBTR	BSAK	KZBTR		☐	KZBTR_FI	☐	Original Reduction Amount in Local Currency
134	XREF1	BSAK	XREF1		☐	XREF1	☐	Business partner reference key
135	XREF2	BSAK	XREF2		☐	XREF2	☐	Business partner reference key
136	XARCH	BSAK	XARCH		☐	XARCH	☐	Indicator: Document already archived ?
137	PSWSL	BSAK	PSWSL		☐	PSWSL	☐	Update Currency for General Ledger Transaction Figures
138	PSWBT	BSAK	PSWBT		☐	PSWBT	☐	Amount for Updating in General Ledger
139	IMKEY	BSAK	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
140	ZEKKN	BSAK	ZEKKN		☐	DZEKKN	☐	Sequential Number of Account Assignment
141	FISTL	BSAK	FISTL		☐	FISTL	☐	Funds Center
142	GEBER	BSAK	GEBER		☐	BP_GEBER	☐	Fund
143	DABRZ	BSAK	DABRZ		☐	DABRBEZ	☐	Reference date for settlement
144	XNEGP	BSAK	XNEGP		☐	XNEGP	☐	Indicator: Negative posting
145	EMPFB	BSAK	EMPFB		☐	EMPFB	☐	Payee/Payer
146	PRCTR	BSAK	PRCTR		☐	PRCTR	☐	Profit Center
147	XREF3	BSAK	XREF3		☐	XREF3	☐	Reference key for line item
148	DTWS1	BSAK	DTWS1		☐	DTAT16	☐	Instruction key 1
149	DTWS2	BSAK	DTWS2		☐	DTAT17	☐	Instruction key 2
150	DTWS3	BSAK	DTWS3		☐	DTAT18	☐	Instruction key 3
151	DTWS4	BSAK	DTWS4		☐	DTAT19	☐	Instruction key 4
152	XPYPR	BSAK	XPYPR		☐	XPYPR	☐	Indicator: Items from Payment Program Blocked
153	KIDNO	BSAK	KIDNO		☐	KIDNO	☐	Payment Reference
154	PYCUR	BSAK	PYCUR		☐	PYCUR	☐	Currency for Automatic Payment
155	PYAMT	BSAK	PYAMT		☐	PYAMT	☐	Amount in Payment Currency
156	BUPLA	BSAK	BUPLA		☐	BUPLA	☐	Business Place
157	SECCO	BSAK	SECCO		☐	SECCO	☐	Section Code
158	PPDIFF	BSAK	PPDIFF		☐	PPDIFF	☐	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
159	PPDIF2	BSAK	PPDIF2		☐	PPDIF2	☐	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
160	PPDIF3	BSAK	PPDIF3		☐	PPDIF3	☐	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
161	PENLC1	BSAK	PENLC1		☐	PENALTY1	☐	Penalty Charge Amount in First Local Currency
162	PENLC2	BSAK	PENLC2		☐	PENALTY2	☐	Penalty Charge Amount in Second Local Currency
163	PENLC3	BSAK	PENLC3		☐	PENALTY3	☐	Penalty Charge Amount in Third Local Currency
164	PENFC	BSAK	PENFC		☐	PENALTY	☐	Penalty Charge Amount in Document Currency
165	PENDAYS	BSAK	PENDAYS		☐	PDAYS	☐	Number of Days for Penalty Charge Calculation
166	PENRC	BSAK	PENRC		☐	PENRC	☐	Reason for Late Payment
167	VERTT	BSAK	VERTT		☐	RANTYP	☐	Contract Type
168	VERTN	BSAK	VERTN		☐	RANL	☐	Contract Number
169	VBEWA	BSAK	VBEWA		☐	SBEWART	☐	Flow Type
170	KBLNR	BSAK	KBLNR		☐	KBLNR_FI	☐	Document number for earmarked funds
171	KBLPOS	BSAK	KBLPOS		☐	KBLPOS	☐	Earmarked Funds: Document Item
172	GRANT_NBR	BSAK	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
173	GMVKZ	BSAK	GMVKZ		☐	FM_GMVKZ	☐	Item is in Execution
174	SRTYPE	BSAK	SRTYPE		☐	FM_SRTYPE	☐	Type of Additional Receivable
175	LOTKZ	BSAK	LOTKZ		☐	PSO_LOTKZ	☐	Lot Number for Requests
176	ZINKZ	BSAK	ZINKZ		☐	DZINKZ	☐	Exempted from Interest Calculation
177	FKBER	BSAK	FKBER		☐	FKBER	☐	Functional Area
178	INTRENO	BSAK	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
179	PPRCT	BSAK	PPRCT		☐	PPRCTR	☐	Partner Profit Center
180	BUZID	BSAK	BUZID		☐	BUZID	☐	Identification of the Line Item
181	AUGGJ	BSAK	AUGGJ		☐	AUGGJ	☐	Fiscal Year of Clearing Document
182	HKTID	BSAK	HKTID		☐	HKTID	☐	ID for account details
183	BUDGET_PD	BSAK	BUDGET_PD		☐	FM_BUDGET_PERIOD	☐	FM: Budget Period
184	KONTT	BSAK	KONTT		☐	KONTT_FI	☐	Account Assignment Category for Industry Solution
185	KONTL	BSAK	KONTL		☐	KONTL_FI	☐	Acct assignment string for industry-specific acct assignmnts
186	UEBGDAT	BSAK	UEBGDAT		☐	UEBGDAT	☐	Transfer date of an item to legal dunning proceeding
187	VNAME	BSAK	VNAME		☐	JV_NAME	☐	Joint venture
188	EGRUP	BSAK	EGRUP		☐	JV_EGROUP	☐	Equity group
189	BTYPE	BSAK	BTYPE		☐	JV_BILIND	☐	Payroll Type
190	PROPMANO	BSAK	PROPMANO		☐	REHORECNNRM	☐	Mandate, Mandate-Opening Contract
191	AWSYS	BKPF	AWSYS		☐	LOGSYSTEM	☐	Logical System
192	AWTYP	BKPF	AWTYP		☐	AWTYP	☐	Reference procedure
193	AWKEY	BKPF	AWKEY		☐	AWKEY	☐	Object key

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