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'
⤷ 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 |