Being not sure whether this question is easy or hard to complete, basically having a simple query
Count(DISTINCT AP.LFB1.BUKRS) AS TotalCCs
which results a single value 17 (so many Company codes exist in SAP)
I would like to use this value in the later queries, could you please advise about the best method regarding that?
Should be maybe assigned to a variable somehow and applying in the formulas?
Thanks in advance,