topic Re: i need write select statement for smartform in Application Development and Automation Discussions

i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 13:26:19 GMT

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??????

Re: i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 13:30:00 GMT

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

Re: i need write select statement for smartform

amit_khare — Fri, 16 Mar 2007 13:30:58 GMT

Check these helpful links -

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

Regards,

Amit

Re: i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 13:31:42 GMT

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

Re: i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 13:42:37 GMT

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

Re: i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 13:44:41 GMT

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

Regards

Haritha.

Re: i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 14:14:32 GMT

hi can u help me with code???

Re: i need write select statement for smartform

Former Member — Fri, 16 Mar 2007 14:19:23 GMT

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.