SAP ABAP View BKPF_BSAD_AEDAT (BW FI: BSAD 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_BSAD_AEDAT
Short Description	BW FI: BSAD Extraction using AEDAT
Root table	BSAD	Accounting: Secondary Index for Customers (Cleared Items)

Table

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