Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

TAANA: count MANDT field?

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

egenoves
Participant
0 Kudos

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

2 REPLIES 2

egenoves
Participant
0 Kudos

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

Former Member
0 Kudos

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