How to get tax value for material line item wise from BSET table

[Former Member]

Dear Experts,

I am into ABAP Development. I am preparing a report for Purchase. In this i want to display the tax value for each line item in the PO.

Now in the table KONP tax values are showing ZERO value. But in the table BSET it is showing the correct tax value. Now the problem with BSET even though i know the tax amount for every material charged (line item wise), how can i get to display it in my report. Because BSET does not contain any of the following which can be linked with PO line item i.e. MATNR for Material and EBELP for Line Item.

Now is there any other way with i can get the tax value displayed in BSET table against the PO Material Line Items.

This is an critical requirement. So if any of you experts can help.

Any clarifications ask.

Regards,

Jitesh M Nair

[Former Member]

combined both

[sridevi_p]

Hi,

The only way to link is through the accounting document.

Fetch the accounting document for the corresponding material document number. With this accounting document, you can fetch data from the BSET table.

Regards,

sridevi

[Former Member]

Hi There,

But then i will be getting only the value. i want to link that against the particular material of the Purchase Order.

Like for ex:

PO No.  Material Code        Line Item        Basic        Excise       Tax       Inv Value

0000001 5000251                010               100           16         4.64      120.64
0000001 5000252                020               200           32         9.28      241.28

Can u help me on this?

Regards,

Jitesh

[Former Member]

Hi,

You get Accounting document no. in BSET table, take this BELNR to BKPF table and get the AWKEY(Reference key) and in this reference key you will get the INVOICE no. and this invoice no. is material document no. with this invoice no. you can go to MM tables and get whatever data you want to get.

hope this helps you!!

Regards,

SAPFICO