Report Painter and SAP Query

[Former Member]

Can someone explain to me output differences between the above two?

Thanks, n point will be awarded

[Former Member]

Hi,

ABAP Queries are extremely useful: they can retrieve data from tables and logical databases alike. ABAP Queries permit a ‘snapshot' of the current R/3 data.

SAP has made it possible for R/3 users to develop queries using little, if any, ABAP code. However, knowing table and fields (data schema) and some SQL knowledge (outer-joins/inner-joins, etc.) is still required.

ABAP Query reports are typically simple listing and totaling reports (unlike a balance sheet or an income statement requiring complex groupings – for example, a cash or revenue line consisting of several accounts on a financial statement). Such complex groupings require the query to read various tables multiple times to appropriately total and sort the accounts. For complex tasks such as this, the other R/3 tools (such as Report Painter which uses “sets” for these groupings) are better suited for reports with complex and integrated groupings.

Thanks,

Dishant