AdHoc Query Issue

[Former Member]

Hi Gurus,

I am running 1 Adhoc Query.We are getting an error in Job description.

We are passing Job code as input.For that job code it is not displaying Corresponding Job description.

Ex : Job Code - - - - 1126

This is the Data avilable in table M_PLOMC.

Required Output : YOUTH SERVICE SPECIALIST OTYPE2 = C

Current Output : ELEM TEACHER OTYPE2 = S

I specified OTYPE2 as C in the Infostet Code to identify the Job description . SAVE and Generate

i created new quey i can see the change code.

If i run the Program behind the Query from SE38 it is displaying output Correctly.

But if i run Query directly from SQ01 no Output.

Bcaz of this Adhoc query also displaying No output.

Please help me...

What is this the difference in running program behind the Query and Running directly the Query?

Here C specifies JOB.

S specifies POSITION.

[Former Member]

Hi

The program name is decided at the runtime...

Might be you have taken the program name before doing some modifications to the adhoc query..

Please check if the program name generated cuurently and the program name you are using the same...

Thanks

Sushmitha

[Former Member]

Issue is resolved.