cancel
Showing results for 
Search instead for 
Did you mean: 

Alternate table for BSEG

Former Member
0 Kudos

Hi,

I want to display the tax details from KONV table for all billing documents in VBRK table based on the business area( which is in BSEG ).

So, can u please suggest the alternative way to fetch the data.

It is Urgent.

Thanks

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Why you require business area to fetch the Taxes from KONV?

To fetch the data from KONV, just KNUMV field from VBRK is enough.

Pass that and based on the respective condition type of that Taxes you take the KBETR or KWERT fields.

Sometimes all the taxes dat will not be found in KONV table.

You first findou the condition record for the definition of the Taxes.

(Like SOLD TO,material,Plant etc)

Based on This condition data, the TAX related condition types are stored in some A* tables (like A051,A038 etc).

so from those tables take the KNUMH field for the respective condition record of the billing Doc, and pass it to the KONP table and get the Tax related prices.

reward if useful

regards,

Anji

Former Member
0 Kudos

You have to use BKPF....

Reward if helpful

Former Member
0 Kudos

i dont think u have to link KONV with Business area ?

KONV will be based on the Condition Types.

If u want to get Business area then u have to check Customer open/close items in

tables: bsid,

bsad.

as i feel , u are missing something.

Regards

Prabhu

Former Member
0 Kudos

Hi,

Look at the below thread ..

Regards

Sudheer