Query from query?

[Former Member]

Hello gurus,

I had a request for a report that seem to be easy to implement in ABAP and I am not sure that it is also easy in the Query Designer, but as I am quite new in SAP BW reporting I am surely mistaken.

So assuming I have a Purchase Order items ODS with the following data:

- PO number

- PO item

- PO date

- material group

- [counter]

... I want to have a report that presents the following data for a given period:

- material group

- number of purchase oprders (not po items!)

If it was possible to create a query from a query, it would be easy. Is it easy anyway?

Cheers,

Michal

[Former Member · Accepted solution]

Michal,

One way is to see update a new counter on the posibility of PO Number 1st record as 1 and Other line items as 0. and use this counter in the reports..

Option 2: Not sure that this will work..

1. Create a new Formula/selection on Count and in the properties..select 'caliculate result as first value..'

regards,

Hari

[Former Member]

To refolmulate my requirement:

If I put a material group and a document number as characteristic and 1 as a key figure, the subtotals for material groups are exactly what I need. If I only could suppress document numbers same way as I can suppress result rows...

[edwin_harpino]

hi Michal,

if i understand your question correctly,

it should not difficult to achieve this,

take a look this thread

hope this helps.