invoice smart form

[Former Member]

i have to display 'description of goods(vbrp-arktx)','total quantity(vbrp-fkimg)','selling rate(komv-kbetr)','total duty payable(komv-ksch)'.how to extract this data which exists in different tables based on invoice no(vbrk-vbeln).i have to take data from vbrk,vbrp,komv.what are the common fields existing between them.please give me solution.

[Former Member · Accepted solution]

You can get consider the logic below:

SELECT fkimg arkts

FROM vbrp

INTO int_tab1

WHERE vbeln = vbrk-vbeln .

SELECT knumv kposn kschl kbetr

FROM konv

INTO int_tab2

WHERE knumv = vbrk-vbeln .

Now read this table int_table using the following logic

READ TABLE int_tab2 WITH KEY knumv = vbrk-knumv

kposn = <item-number>

kschl = <condition-type>.

Reward Points to helpful answers.

Thanks.

[dev_parbutteea]

HI

common field between vbrk,vbrp is vbeln

common field between vbrk,komv is knumv

Regards,

Sooness