topic Re: questions in Application Development and Automation Discussions

questions

Former Member — Mon, 24 Sep 2007 06:11:45 GMT

hi experts i have few question..

1. A table is buffered. By select statement i dont want to get the data from table buffer. i want to get the data from database. how?

2. What is the diff b/w start_form and open_form in scripts?.why is it necessary to close a form always once it is opened?

3. What is difference between ON Change of & At New Field?? Select Single * from & select Upto 1 rows

4. Can we create Bar Chart in abap reports and how?

regards,

raman

Re: questions

Former Member — Mon, 24 Sep 2007 06:15:26 GMT

Hi Raman,

2. What is the diff b/w start_form and open_form in scripts?.why is it necessary to close a form always once it is opened?

In a Program we use OPEN_FORM only once (most of the times.)

and we pass the paramter of the FORM (SE71 Script form name) to it.

Where as we can use any number of START_FORMS in aprogram, in a single script output

When you wants to take outputs based on each Sales order loop at the ITAB

for each Sales order you can use a START_FORM and END_FORM.

Open_form used to generates the Spool mainly.

Start_Form to print Individual elements of a Page

3. What is difference between ON Change of & At New Field?? Select Single * from & select Upto 1 rows

if any new field value came to field it AT NEW will get triggers

it considers the left side values also

if left side of the field values will change it will get triggers

we should write this AT NEW with in the loop

ONCHANGE : if any field value get changed it will get triggers it won't go for left side values

on change may or may not be in the loop

Thanks,

Reward If helpful.

Re: questions

Former Member — Mon, 24 Sep 2007 06:20:58 GMT

1. A table is buffered. By select statement i dont want to get the data from table buffer. i want to get the data from database. how?

Ans:

If you delcre the TABLES starement buffre get crated so do not delcre it

Declare the internal table and fetch data directly

2. What is the diff b/w start_form and open_form in scripts?.why is it necessary to close a form always once it is opened?

Ans:

Imagine the close box to put some object inside first you need to open that box

then place your thing in that and close box to send send it some where

Same way Sript we r calling from report so we need to open OPEN_FORM that form then write WRITE_FORM into that form and then close CLOSE_FORM that form. so it is nessasory to close once it is open

3. What is difference between ON Change of & At New Field?? Select Single * from & select Upto 1 rows

Ans : on change and At new Field will have sam functinality to do task at new field value ocuurs but At new only used when it is the first field in internal table

where as On chnge can be used for any field in internal table

4. Can we create Bar Chart in abap reports and how?

Reports

http://www.sapgenie.com/abap/reports.htm

http://www.allsaplinks.com/material.html

http://www.sapdevelopment.co.uk/reporting/reportinghome.htm

http://www.sapfans.com/forums/viewtopic.php?t=58286

http://www.sapfans.com/forums/viewtopic.php?t=76490

http://www.sapfans.com/forums/viewtopic.php?t=20591

http://www.sapfans.com/forums/viewtopic.php?t=66305 - this one discusses which way should you use - ABAP Objects calls or simple function modules.

Rewards if useful.....................

Minal

Message was edited by: Minal Nampalliwar

Minal Nampalliwar

Re: questions

Former Member — Mon, 24 Sep 2007 06:24:27 GMT

hi,

1. use BYPASSING BUFFER aaddition in your select query it will do.

3. goto ABAP in 21 days book you will find

at new will compare the with nothing at first time

where as on change of will compare with zero, read the HIDDEN DANGER of ON CHANGE OF in abap in 21 days book.

4. yes

regards,

Prabhu

reward if it is helpful

Re: questions

kai_gutenkunst — Mon, 01 Oct 2007 07:38:02 GMT

Hi,

4. Use the chart engine to create a bar chart in your ABAP report. Have a look at report GRAPHICS_GUI_CE_DEMO and download the SAP Chart Designer from SDN - Downloads - WebAS.

Regards, Kai