i need write select statement for smartform

[Former Member]

hi all

i added one field into smartform ie vbap-kdmat.

i need to check conditions VBAK-AUART=ZTB and VBAK-VBELN = VBAP-VBELN

that to tables and fiels are not there in my driver program

now tel me how to write select statemnet in my smartform program lines how to retrive data??????

[Former Member]

Hi,

Create the PROGRAM LINES in the smart form(in that particular window) and write your code. You can write your own select statements. But declare the data/structrues in the top.

Regards,

Anji

[amit_khare]

Check these helpful links -

http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Build_SMARTFORMS/How_To_Build_SMARTFORMS.h...

Regards,

Amit

[Former Member]

Hi Sivaram,

This is Simple task...

In your smart form you can add one more FLOW logic ... through righ clicking create TAB .

where you can write your select query.

Hope this will help.. For more details write back to me.

DARSHAN

• to MOTIVATE us please reward points to HELPFUL answers

[Former Member]

hi can u help me with code???

[Former Member]

Hi..

Declare the data in the Global Data area. Here you define the Variables which u want to use in your program for select query.

For selecting the data, you need to include the Program code. To do this, Right click on any window button and in Flow logic tab- select Program lines.

Here You can do your Abap coding. The data which you are about to use in your program Code should be declared in the input and output parameter Fields.

Hope this would solve your problem.

Thanks and Regards,

Sharma NSK

[Former Member]

Hi

You can write what ever abap code you want in the program lines including select queries.

Regards

Haritha.

[Former Member]

Now in the Improt of that Code u have to write... WA_VBAP (or your stucture containing VBAP) and in output of that code... U have to write VA_KDMAT ( define thi VA_KDMAT in your global data with type VBAP-KDMAT) also On the screen display &VA_KDMAT&

SELECT KDMAT FROM VBAK into VA_KDMAT

where AUART = 'ZTB'

and VBELN = WA_VBAP-VBELN.

Hope this is enough...

Or give me ur smart form code in .xml format after downloading it... I will do required changes and will send back to u.

DARSHAN

• Reward POINTS please.