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.

[Former Member]

Hi,

To start with you can test this on a single window eg Main window.

Under main window you can add a program line

ie Right click Create -> Flow logic -> Program line.

Now in this program line you can use a join query as per your condition.

Then create a loop under main window

ie Right click Create -> Flow logic -> Loop

In this mention the input and output parameters

Eg input para as v_matnr

output para as w_mara, t_mara.

Then create a text component under loop.

ie Right click Create -> Text

and in this you can display your fields

Note : you need to declare the input parameters in the form interface

and outparameters under global definition.

Hope this would hep you.

Regards,

Ranjith N

[Former Member]

First make sure if u r getting the data in the interface coz most data is already present in the structure tht comes into smartform thru interface if u sure its not present thr. then u cud include the code

in either initialization or as suggested above by amit.