Main Menu Tutorials - Fields in Table BSET
Financials

 

Table BSET contains tax relevant data of table BSEG. Following fields consist table BSET:

MANDT - Client

BUKRS - Company code

BELNR - Document number

GJAHR - Fiscal year

BUZEI - Number of line item within accounting document; The numbering refers to BSET (and is independent of BSEG!).

MWSKZ - Tax on sales/purchases code; Derived from BSEG

HKONT - G/L account for General Ledger Accounting; Dependent on KTOSL, MWSKZ, and KTOPL (the table field T001-KTOPL assigned to the company code); stored in field T030K-KONTS, KONTH

TXGRP - Group code for tax items; All BSEG and BSET items that belong together have the same value (set in function module CREATE_BSET_ITEM)

SHKZG - Debit/credit indicator

HWBAS -Tax base amount in local currency; The amount results from the total of the local currency amounts of all BSEG G/L account items involved (G/L account with same MWSKZ)

FWBAS - Tax base amount in document currency: The amount results from the total of the foreign currency amounts of all BSEG G/L account items involved (G/L account with same MWSKZ)

HWSTE - Tax amount in local currency: Results from the translation of FWSTE with BKPF-KURSF (if BKPF-TXKRS is set, the exchange rate specified there applies)

FWSTE - Tax amount in document currency: In normal case, results from multiplication of FWBAS with KBETR

KTOSL - Transaction key: Determined from table T683S (dependent on KALSM (dependent on country, field T005- KALSM) and KSCHL)

KNUMH -Number of condition record: Connection between tables A003 and KONP from A003-KNUMH dependent on ALAND, MWSKZ and KSCHL

STCEG - VAT registration number

EGBLD - Country of destination for goods delivery

EGLLD - Delivering country for goods delivery

TXJCD - Tax jurisdiction code - jurisdiction code for tax calculation

H2STE - Tax amount in local currency 2

H3STE - Tax amount in local currency 3

H2BAS - Tax base amount in local currency 2

H3BAS - Tax base amount in local currency 3

KSCHL - Condition type Table A003 contains all KSCHL for a country (ALAND) and MWSKZ

STMDT - Date on which tax return was carried out: If RFUMSV00 runs in update mode (field RFPDO2-UMSVBSUD), enter the run date here

STMTI - Time of the program run for the tax return if RFUMSV00 runs in update mode

MLDDT - Reporting date for the tax return

KBETR - Condition amount/percentage rate if no lot: Dependent on MWSKZ from field KONP-KBETR; KNUMH from A003 provides KBETR from KONP

STBKZ - Posting indicator: Defines whether the tax is posted in a separate item (STBKZ = 2) or distributed to the relevant expense/revenue items (STBKZ = 3); depends on KTOSL, from field T007B-STBKZ; If STBKZ = 2 (and KBETR > 0) applies for KTOSL, there is a BSEG item with the same KTOSL and BUZID = T

LSTML - Country for the tax return: Is filled if Plants Abroad is active (T000F-XWIAA); value from field T007A-LSTML (dependent on KALSM and MWSKZ)

LWSTE - Tax amount in national currency Amount in local currency of reporting country (LSTML)

LWBAS - Tax base in national currency Base amount in local currency of reporting country (LSTML)

TXDAT - Date for determination of tax rates

BUPLA - Business place

TXJDP - Tax jurisdiction code - jurisdiction code for tax at lowest level

TXJLV - Level of tax jurisdiction code

TAXPS - Line item number for tax document: Required for the external system

TXMOD - The tax result was modified manually; this means that in the Enjoy transactions, either the local currency tax amount was changed manually or the item was created via the entry of the tax amount on the tax tab page ('Direct tax posting Argentina')

 

Logistics
Human Resources
ABAP
Tutorials
SAP Jobs
Free Downloads
Contact us

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

     
This site is no way affiliated with SAP AG.