link between VBRP and KONV

[Former Member]

hello,

any idea for the link between VBRP and KONV tables ?

I am fetching vbeln from vbak and based on that i am getting matnr and quantity details from vbrp now i want to get condition type and tax code details from konv.how to link it?

regards

Soniya.

[Former Member]

you can get it form VBRK table.

[GauthamV]

VBRK-KNUMV = KONV-KNUMV

VBRK-VBELN = VBRP-VBELN.

[Former Member]

Hi Soniya,

For this you have to go through VBRK(Billing Header Data).

VBRK-KNUMV = KONV-KNUMV

VBRK-VBELN = VBRP-VBELN.

Amresh

[Former Member]

Check this:

1. Use SQVI transaction,
2. Create a View
3. Enter title,
4. Choose the Data source as Table Join
5. Now use Insert table option.
6. And insert the tables which you want. It will propose the relation between them.

[Former Member]

This message was moderated.

[Former Member]

KONV (condition table) is linked to VBRK (Billing: Header data) by the following

VBRK-KNUMV = KONV-KNUMV

and VBRK (Billing: Header data) is linked to VBRP (Billing: Item data) by the following

VBRK-VBELN = VBRP-VBELN

I believe you can can fetch data from VBRP using for all entries.

Then fetch the data from KNOV table using the above given link and then modify the required internal table to retrieve the required result.

Hope it helps

[Former Member]

Hi for this u have to link 3 tables

vbrk vbrp and knov.

as bellow.

VBRK-VBELN = VBRP-VBELN.

VBRK-KNUMV = KONV-KNUMV

Regards

[Former Member]

VBRP-VBELN = VBRK-VBELN

THEN

VBRK-KNUMV = KONV-KNUMV

VBRP-POSNR = KONV-KPOSN

IF WANT MOREHELP, PLZ ASK.