invoice sales

[Former Member]

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

[Former Member]

Hi!

Based on whether you want to display the details of Ship-to party or payer, VBRK-KUNRG or VBRK-KUNAG = KNA1-KUNNR.

Cheers!

[Former Member]

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.

[Former Member]

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.