Table for taxes

[Former Member]

Hi

Can any please suggest me a table equivalent to BSET (for taxes) which will contains fields accounting document number, fiscal year, company code, material number, tax amount, and base amount for the tax amount

BSET will have all the fields except the material number. I want to know to which material this tax amount has been paid

waiting for your quick reply

regards

srini

[Former Member]

hope you wont get ur required data in one table. u have to link between more than one table...pls try to link below tables...it may give ur requirement...

BSET, BKPF/BSEG, RBKP/RSEG,MKPF/MSEG.

award if helpful

[Former Member]

I have tried all those combinations, but linking is not possible, can you please suggest any suitable table

[Former Member]

Hello

1. select single * from bset where and buzei = '001'

2. select single * from bseg where bukrs = bset-bukrs and belnr = bset-belnr

and gjahr = bset-gjahr and buzei = bset-buzei.

3. bseg-matnr

or

4. select * from vbrp where vbeln = bseg-vbeln

5. vbrp-matnr

[Former Member]

VBRP is not valid as i am looking for accounting docs for MM invoices. and for the BSEG and BSET i have tried all combinations, but i could not able to find a the corresponding tax line item (for tax amount) for a given acc doc number, fiscal yr, company code, material number and cost center (here, the invoice is split accout assigned)

can you please suggest a suitable table for this requirement?