Bex Query on Mpro
Facing a strange issue in a query over a Multiprovider, seeking advive to hadle, below is the Mpro data looks lik
Now as eveident from the InfoProvider the upper 4 records are from a diferent DSO & last 7 rows are from separate DSO.
Now Now I want a report SHIFTPB & CALWEEK wise & rest other characteristics as free chars . Now in the out put we should have key figures as 0ROWCOUNT1 & TGTVALUE.
Now the issue is I have created the report with putting TGTVALUE (with constant selection of SHIFTPB since SHIFTPB is coming as from different infoprovider .(also I have added in constant sleection other characteristics too which are not coming from the same InfoProvider as the TGTVALUE.
But When I drag in TARGETID, it shows # value also the values of TGTVALUE goes off, Ideally the output should be like