SAP ABAP Table DBSET (Detail Information for Tax Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	INTTAB	Structure
Structure	DBSET	Table Relationship Diagram
Short Description	Detail Information for Tax Items

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	.INCLUDE	☐				0	0	Tax Data Document Segment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
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	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
8	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
9	TXGRP	☐	TXGRP	NUM03	NUMC	3	0	Group Indicator for Tax Line Items
10	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
11	HWBAS	☐	HWBAS_BSES	WERTV8	CURR	15	2	Tax Base Amount in Local Currency
12	FWBAS	☐	FWBAS_BSES	WERTV8	CURR	15	2	Tax base amount in document currency
13	HWSTE	☐	HWSTE	WERT7	CURR	13	2	Tax Amount in Local Currency
14	FWSTE	☐	FWSTE	WERT7	CURR	13	2	Tax Amount in Document Currency
15	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
16	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
17	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
18	EGBLD	☐	EGBLD	LAND1	CHAR	3	0	Country of Destination for Delivery of Goods	*
19	EGLLD	☐	EGLLD	LAND1	CHAR	3	0	Supplying Country for Delivery of Goods	*
20	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
21	H2STE	☐	H2STE	WERT7	CURR	13	2	Tax Amount in Local Currency 2
22	H3STE	☐	H3STE	WERT7	CURR	13	2	Tax Amount in Local Currency 3
23	H2BAS	☐	H2BAS_BSES	WERTV8	CURR	15	2	Tax Base Amount in Local Currency 2
24	H3BAS	☐	H3BAS_BSES	WERTV8	CURR	15	2	Tax Base Amount in Local Currency 3
25	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	T685
26	STMDT	☐	STMDT_BSET	DATUM	DATS	8	0	Date on Which the Tax Return Was Made
27	STMTI	☐	STMTI_BSET	TIME6	CHAR	6	0	Time of Program Run for the Tax Return
28	MLDDT	☐	MLDDT_BSET	DATUM	DATS	8	0	Reporting Date for Tax Report
29	KBETR	☐	KBETR_TAX	WERTV6	CURR	11	2	Tax Rate
30	STBKZ	☐	STBKZ_007B	STBKZ_007B	CHAR	1	0	Posting indicator
31	LSTML	☐	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	*
32	LWSTE	☐	LWSTE_BSET	WERT7	CURR	13	2	Tax Amount in Country Currency
33	LWBAS	☐	LWBAS_BSET	WERTV8	CURR	15	2	Tax Base in Country Currency
34	TXDAT	☐	TXDAT	DATUM	DATS	8	0	Date for defining tax rates
35	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
36	TXJDP	☐	TXJCD_DEEP	TXJCD	CHAR	15	0	Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax	*
37	TXJLV	☐	TXJCD_LEVEL	CHAR1	CHAR	1	0	Tax jurisdiction code level
38	TAXPS	☐	TAX_POSNR	NUM6	NUMC	6	0	Tax document item number
39	TXMOD	☐	TAX_MOD	TAX_MOD	INT1	3	0	Tax Result Has Been Modified Manually
40	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
41	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
42	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number	*
43	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
44	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
45	XAUTO	☐	XAUTO	XFELD	CHAR	1	0	Indicator: Line item automatically created
46	FWSTR	☐	FWSTR_BSET	WERT7	CURR	13	2	Tax Amount Calculated in FC (for Checking)
47	ANZHL	☐	ANZHL_BSET	INT4	INT4	10	0	Number of Accompanying G/L Account Items
48	FWBASZERO	☐	FWBASZERO	CHAR1	CHAR	1	0	Tax Base in Foreign Currency = 0, in Local Currency <> 0
49	.INCLUDE	☐				0	0	Tax Detail Information for Tax Clearing by Line Item
50	POINT	☐	TAX_POSNR	NUM6	NUMC	6	0	Tax document item number
51	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
52	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
53	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
54	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
55	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
56	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
57	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
58	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
59	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
60	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
61	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
62	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
63	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
64	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
65	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DBSET	BUKRS	T001	BUKRS	KEY	1	CN
2	DBSET	HKONT	SKB1	SAKNR	KEY	1	CN
3	DBSET	KSCHL	T685	KSCHL
4	DBSET	MANDT	T000	MANDT	KEY	1	CN
5	DBSET	MWSKZ	T007A	MWSKZ	REF	C	CN
6	DBSET	TXJCD	TTXJ	TXJCD	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in