How to read two more tables in smartfroms

[Former Member]

Hi experts,

I am working in smartforms, i am having sales order no, using this sales order i have get customer name.

I am not familar with smart forms.

How to put this logic in smartfroms .

already i am having vbeln.

using vbeln I have go to vbpa and get vbpa-kunnr

using kunnr I have go to kna1 and get kna1-name1

where I should define and how to define, (form interface or global defination)

where should write select stmt.

please advice.

Thanks,

Mahame.

[former_member181995 · Accepted solution]

Window
---Right Click
-----Flow logic
--------Program Lines

Write here your select query

Give input parameter vbeln(variable in which you have value of Vbeln)

Give the variable in Output parameter which need to print in form.