I have records from VBRK, KONA and KONV tables, how do I link with KONP and

[aris_hidalgo]

Hello Experts,

How do I get data from KONP and KONW tables if I have records from VBRK, KONA and KONV.

I know I can link KONV and KONP by KNUMH and also for KONW but my records from KONV doesnt

have a value in its KNUMH field. Hope you can help guys.

Thank you and take care!

[Former Member]

Hi

Take the VBAK-KNUMV field for the Sales order and pass to KONV-KNUMV field and VBAP-POSNR FIELD TO konv-kposn AND FETCH THE DATA FROM konv(PRICING TABLES)

take the KNUMH field from KONV and pass to KONP table and fetch the data

or take the VBAP-KNUMH and pass to KONP and fetch the data

REGARDS

ANJI

Message was edited by:

Anji Reddy Vangala

[Former Member]

Hi,

simply KNUMH from KONW and KNUMV from KONV.

regs

[Former Member]

Dear ,

In some organisations it happens that KONV table's KNUMH field populate.

For this search for a table having VBELN, POSNR and KNUMH fields in A0* series, here you will definately find a matching table with similar record and you will get KNUMH and then go to KONP.

Just search for KNUMH where use list.

and then check tables A0* ( check A089 may be it will work) or some other.

i Have done the same before.

Reward if useful.

Amit Singla