DBSET SAP (Detail Information for Tax Items) Structure details
Description: Detail Information for Tax Items
Structure field list including key, data, relationships and ABAP select examples
DBSET is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Detail Information for Tax Items" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_DBSET TYPE DBSET.
The DBSET table consists of various fields, each holding specific information or linking keys about Detail Information for Tax Items data available in SAP. These include MANDT (Client), BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DBSET structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
TXGRP | Group Indicator for Tax Line Items | TXGRP | NUMC | 3 | NUM03 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
HWBAS | Tax Base Amount in Local Currency | HWBAS_BSES | CURR | 15(2) | WERTV8 | ||||
FWBAS | Tax base amount in document currency | FWBAS_BSES | CURR | 15(2) | WERTV8 | ||||
HWSTE | Tax Amount in Local Currency | HWSTE | CURR | 13(2) | WERT7 | ||||
FWSTE | Tax Amount in Document Currency | FWSTE | CURR | 13(2) | WERT7 | ||||
KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
KNUMH | Condition record number | KNUMH | CHAR | 10 | KNUMB | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
EGBLD | Country of Destination for Delivery of Goods | EGBLD | CHAR | 3 | Assigned to domain | LAND1 | |||
EGLLD | Supplying Country for Delivery of Goods | EGLLD | CHAR | 3 | Assigned to domain | LAND1 | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
H2STE | Tax Amount in Local Currency 2 | H2STE | CURR | 13(2) | WERT7 | ||||
H3STE | Tax Amount in Local Currency 3 | H3STE | CURR | 13(2) | WERT7 | ||||
H2BAS | Tax Base Amount in Local Currency 2 | H2BAS_BSES | CURR | 15(2) | WERTV8 | ||||
H3BAS | Tax Base Amount in Local Currency 3 | H3BAS_BSES | CURR | 15(2) | WERTV8 | ||||
KSCHL | Condition Type | KSCHL | CHAR | 4 | T685 | KSCHL | VKS | ||
STMDT | Date on Which the Tax Return Was Made | STMDT_BSET | DATS | 8 | DATUM | ||||
STMTI | Time of Program Run for the Tax Return | STMTI_BSET | CHAR | 6 | TIME6 | ||||
MLDDT | Reporting Date for Tax Report | MLDDT_BSET | DATS | 8 | DATUM | ||||
KBETR | Tax Rate | KBETR_TAX | CURR | 11(2) | WERTV6 | ||||
STBKZ | Posting indicator | STBKZ_007B | CHAR | 1 | STBKZ_007B | ||||
LSTML | Country for Tax Return | LAND1_STML | CHAR | 3 | Assigned to domain | LAND1 | |||
LWSTE | Tax Amount in Country Currency | LWSTE_BSET | CURR | 13(2) | WERT7 | ||||
LWBAS | Tax Base in Country Currency | LWBAS_BSET | CURR | 15(2) | WERTV8 | ||||
TXDAT | Date for defining tax rates | TXDAT | DATS | 8 | DATUM | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
TXJDP | Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax | TXJCD_DEEP | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXJLV | Tax jurisdiction code level | TXJCD_LEVEL | CHAR | 1 | CHAR1 | ||||
TAXPS | Tax document item number | TAX_POSNR | NUMC | 6 | NUM6 | ||||
TXMOD | Tax Result Has Been Modified Manually | TAX_MOD | INT1 | 3 | TAX_MOD | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
KPOSN | Condition item number | KPOSN | NUMC | 6 | NUM6 | ||||
STUNR | Step number | STUNR | NUMC | 3 | Assigned to domain | STUNR | |||
KNTYP | Condition category (examples: tax, freight, price, cost) | KNTYP | CHAR | 1 | KNTYP | ||||
KRECH | Calculation type for condition | KRECH | CHAR | 1 | KRECH | ||||
XAUTO | Indicator: Line item automatically created | XAUTO | CHAR | 1 | XFELD | ||||
FWSTR | Tax Amount Calculated in FC (for Checking) | FWSTR_BSET | CURR | 13(2) | WERT7 | ||||
ANZHL | Number of Accompanying G/L Account Items | ANZHL_BSET | INT4 | 10 | INT4 | ||||
FWBASZERO | Tax Base in Foreign Currency = 0, in Local Currency <> 0 | FWBASZERO | CHAR | 1 | CHAR1 | ||||
POINT | Tax document item number | TAX_POSNR | NUMC | 6 | NUM6 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG |
Key field | Non-key field |
How do I retrieve data from SAP structure DBSET using ABAP code?
As DBSET is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DBSET as there is no data to select.How to access SAP table DBSET
Within an ECC or HANA version of SAP you can also view further information about DBSET and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects