topic Re: Query vs Z Program in Application Development and Automation Discussions

Query vs Z Program

Former Member — Mon, 20 Apr 2009 11:27:55 GMT

Hi Experts,

Could you tell the difference in creating report in Query and Z Program....

Thanks in Advance

Regards

Vijai Jain

Re: Query vs Z Program

Former Member — Mon, 20 Apr 2009 11:30:46 GMT

hi,

Query will be useful for less number of records as well as the performance also will be less compared to the standard zprogram u write.

Re: Query vs Z Program

Former Member — Mon, 20 Apr 2009 11:32:21 GMT

Hi Vijai,

The main difference with the select queries.

in the Query the all the select querys will be internally generateda as the SELECT.......ENDSELECT....

which is most performce issue.

but in the Z-Programs we usually write the selct queries as SELECT......

hope this small info will helps you.

Thanks

Re: Query vs Z Program

Former Member — Mon, 20 Apr 2009 11:33:28 GMT

Vijai,

In Zprogram you can handle complex logic, while Query helps you to create report by joining multiple tables. In query also you can add your logic under Infosets --> Extra --> Code, by selecting code section as DATA, START-OF-SELECTION, TOP-OF-PAGE etc.

Re: Query vs Z Program

Former Member — Mon, 20 Apr 2009 11:40:31 GMT

SAP Reports are Programmes which are used to fetch data from SAP database under specified selection criteria and show in list viewer

ABAP QUERY: These are the report which users can prepare without knowledge of the ABAP programming language to define and execute their own reports. Normally Functional Consultants use these ABAP query tool to create and run simple reports by themselves instead of coding by ABAPer. Its flexible and convinent. However you should be well thorough with different tables to map query and fetch data.

Re: Query vs Z Program

Former Member — Mon, 20 Apr 2009 11:53:17 GMT

ABAP query is for functional consultants andrequires no ABAP knowledge.

Also, It is very easy and quick.