SAP ABAP Table BSET_BW_EXTRAKT (Structure for Tax Data Extraction into BW)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ BWFI (Package) BW: Delta Process for Data Extraction in FI

Basic Data

Table Category	INTTAB	Structure
Structure	BSET_BW_EXTRAKT	Table Relationship Diagram
Short Description	Structure for Tax Data Extraction into BW

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	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
4	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
7	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
8	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
9	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
10	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
11	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
13	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
14	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
15	HWBAS	☐	HWBAS_BSES	WERTV8	CURR	15	2	Tax Base Amount in Local Currency
16	FWBAS	☐	FWBAS_BSES	WERTV8	CURR	15	2	Tax base amount in document currency
17	HWSTE	☐	HWSTE	WERT7	CURR	13	2	Tax Amount in Local Currency
18	FWSTE	☐	FWSTE	WERT7	CURR	13	2	Tax Amount in Document Currency
19	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
20	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
21	KBETR	☐	KBETR_KOND	WERTV6	CURR	11	2	Rate (condition amount or percentage) where no scale exists
22	LSTML	☐	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	*
23	LWSTE	☐	LWSTE_BSET	WERT7	CURR	13	2	Tax Amount in Country Currency
24	LWBAS	☐	LWBAS_BSET	WERTV8	CURR	15	2	Tax Base in Country Currency

History

Last changed by/on	SAP	20130529
SAP Release Created in