topic Re: To Write a Query in Application Development and Automation Discussions

To Write a Query

Former Member — Mon, 08 Mar 2010 07:15:03 GMT

Hello All,

I have a requirement to write a query for the below case:

The query should pick up all the ZD2D item category lines (VBAP-PSTYV=ZD2D) , where either of the below cases are fulfilled.

1.For the combination of VBAP_VBELN and VBAP-POSNR, where VBAP-PSTVY = ZD2D, Please check if VBFA-VBTYP_N = blank, then display the output.

2.If VBFA-VBTYP_N = M , then check for VBUP-GBSTA not equal to C.

If either of the above conditions are fulfilled, the lines should be shown in the report.

My question is , can we use a single query to give two different outputs for the above two cases. I was thinkin of using two different variants. Can this be done in any other way?

Thanks,

Rachana.

Re: To Write a Query

Former Member — Wed, 10 Mar 2010 11:48:42 GMT

Hi,

i hope this will help you

IF vbfa-vbtyp_n = 'M'.

SELECT * FROM <table>

WHERE vbup-gbsta <> 'C'.

ELSEIF vbfa-vbtyp_n IS INITIAL.

SELECT * FROM <table>

WHERE vbap-vbeln = 'Value'

AND vbap-posnr = 'Value'

AND vbap-pstvy = 'ZD2D'.

ENDIF.

Re: To Write a Query

Clemenss — Thu, 11 Mar 2010 21:35:03 GMT

Hi,

this looks like a programming request. This is no ABAP objects question.

Send me some cash and I will think about your request, thanks you.

Regards,

Clemens

Re: To Write a Query

ThomasZloch — Thu, 11 Mar 2010 22:30:45 GMT

vague subject, wrong forum, likely case of "spec dumping", thread locked.

Thomas