SAP ABAP Table BKPF_BSAD (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BKPF_BSAD	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BKPF_BSAD	BTYPE	T8JA	BILIND	REF	C	CN
2	BKPF_BSAD	BUKRS	KNB1	BUKRS	KEY	1	CN
3	BKPF_BSAD	CESSION_KZ	TCESSION	CESSION_KZ
4	BKPF_BSAD	EGRUP	T8JF	EGRUP	REF	C	CN
5	BKPF_BSAD	KKBER	T014	KKBER	REF	1	CN
6	BKPF_BSAD	KUNNR	KNA1	KUNNR	KEY	1	CN
7	BKPF_BSAD	PSWSL	TCURC	WAERS
8	BKPF_BSAD	UZAWE	T042F	UZAWE	REF	C	CN
9	BKPF_BSAD	VNAME	T8JV	VNAME	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in