SAP ABAP Table BKPF_BSAD_AEDAT (Generated Table for View)

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in