2008 Nov 21 12:06 PM
hello,
i am working on a report to get invoice sales and amount grouped by party name.
i have got all billing details from vbrk table but need to display customer details from kna1 table.
how to link bet these two.pls help me out.
regards,
madhavi
2008 Nov 21 12:18 PM
VBRK-KUNWE will have the KUNNR value. Otherwise take the VGBEL and VGPOS value from VBRK and use that in LIKP as VBELN = VGBEL, select the KUNNR number. Use that in KNA1.
2008 Nov 21 12:10 PM
Hi!
Based on whether you want to display the details of Ship-to party or payer, VBRK-KUNRG or VBRK-KUNAG = KNA1-KUNNR.
Cheers!
2008 Nov 21 12:10 PM
Look for the field value KUNAG in VBRK and with the value picked up hit the table KNA1. The field KUNAG contains the cutomer code. Go for KUNNR field in KNA1 for cutomer number.
2008 Nov 21 12:18 PM
VBRK-KUNWE will have the KUNNR value. Otherwise take the VGBEL and VGPOS value from VBRK and use that in LIKP as VBELN = VGBEL, select the KUNNR number. Use that in KNA1.