10-15-2015 4:14 PM
how do I cound the MANDT field?
I tried transaction TAANA
as per Creating an Ad hoc Analysis Variant - Table Analysis - SAP Library
but at point 6 I cannot chose the mandt(client) field.
What I need to know is something like
MANDT
001 100 Million Datasets
002 200 Million Datasets
...
TIA
10-15-2015 4:45 PM
Hi Armin,
I've tried it just to be curious, and i've seen you cannot select the MANDT field in the ad-hoc variant because it doesn't appear.
But i've achieved it creating a virtual field and referencing it to MANDT field, then reference the virtual field to a table analisys...
see screnshot,
hope it helps
10-15-2015 4:45 PM
Hi Armin,
I've tried it just to be curious, and i've seen you cannot select the MANDT field in the ad-hoc variant because it doesn't appear.
But i've achieved it creating a virtual field and referencing it to MANDT field, then reference the virtual field to a table analisys...
see screnshot,
hope it helps
10-16-2015 8:18 AM
almost 😉
I used the suggestion with a virtual field in a test system.
taana made this Select (as found per st04, cursor cache)
>>
SELECT "CLIENT"
FROM "ADRC"
WHERE "CLIENT"=:A0
<<
(where "CLIENT" is the MANDT field in DB-table ADRC)
=>
Thus taana only counts lines of the current Client/Mandt.
So I tried db05:
db05 made this Select:
>>
SELECT "CLIENT"
FROM "ADRC"
ORDER BY "CLIENT"
<<
at least it gives a vague idea about the number of different clients,
and the selectivity/distribution of Client/Mandt.
HTH