SAP ABAP View BKPF_BSIK (BW FI: BSIK Extraction Using CPUDT)

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_BSIK
Short Description	BW FI: BSIK Extraction Using CPUDT
Root table	BSIK	Accounting: Secondary Index for Vendors

Table

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

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	BSIK	MANDT	JR	EQ			AND	0	0
3	BKPF	BUKRS	JL	EQ				0	0
4	BSIK	BUKRS	JR	EQ			AND	0	0
5	BKPF	BELNR	JL	EQ				0	0
6	BSIK	BELNR	JR	EQ			AND	0	0
7	BKPF	GJAHR	JL	EQ				0	0
8	BSIK	GJAHR	JR	EQ			AND	0	0
9	BKPF	CPUDT	JL	EQ				0	0
10	BSIK	CPUDT	JR	EQ				0	0

View Fields

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