Code Required for SQ01

[Former Member]

Hi Experts,

I am trying to create a SAP Query through SQ01. In the infoset, i would like to have a ABAP code to restrict the retrieval of data.

Here my scenario would be - I have a list of service orders with different status. I would like to omit the service orders which has a particular status. For this scenario i required ABAP code to have a better report. Please let me know what code i need to enter in the Data area and Start of selection as well as other areas.

Thanks,

Panneer

Moderator Message: Please do NOT ask your work to be done by others. Put some effort of your own first.

Edited by: kishan P on Mar 29, 2011 10:54 AM

[Rushikesh_Yeole]

please explain in detail.

You can set company code, so number and status field on selection screen.

Create a variant and omit the so status (not equal to) and set this variant as a default for info set and query.

report will take all so without particular status. as per situation, no need to write a code.

let me know any problems.