Query vs Z Program

[Former Member]

Hi Experts,

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

Thanks in Advance

Regards

Vijai Jain

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

ABAP query is for functional consultants andrequires no ABAP knowledge.

Also, It is very easy and quick.