Skip to Content
avatar image
Former Member

TAANA: count MANDT field?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2015 at 03: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


    zmand.JPG (21.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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