SAP ABAP View BKPF_BSID (BW FI: BSID 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_BSID
Short Description	BW FI: BSID Extraction Using CPUDT
Root table	BSID	Accounting: Secondary Index for Customers

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BSID	BSID
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	BSID	MANDT	JR	EQ			AND	0	0
3	BKPF	BUKRS	JL	EQ				0	0
4	BSID	BUKRS	JR	EQ			AND	0	0
5	BKPF	BELNR	JL	EQ				0	0
6	BSID	BELNR	JR	EQ			AND	0	0
7	BKPF	GJAHR	JL	EQ				0	0
8	BSID	GJAHR	JR	EQ			AND	0	0
9	BKPF	CPUDT	JL	EQ				0	0
10	BSID	CPUDT	JR	EQ				0	0

View Fields

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