Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Select Query

Dear Experts,

AUSP:

LOAD

ATINN,

ATWRT,

OBJEK;

SQL SELECT ATINN ATWRT OBJEK FROM AUSP

WHERE ATINN = 'MKTG_ACCT_MGR1';

In above SQL Select query 0 lines fetched. In SAP MKTG_ACCT_MGR1 is exists.

However, it shows 0 lines.

Kindly suggest the same.

Thanks and Regards

Amol Khochare

1 Reply
Not applicable
Author

Try loading everything into the QV table - then check in that loaded data whether MKTG_ACCT_MGR1 exists.

If it does copy the output value and use it in the WHERE clause of the SQL query, or, resident load AUSP1 with the criteria to only pull through the MGR1 data.