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