topic Re: Regarding ABAP query when using the LDB in Application Development and Automation Discussions

Regarding ABAP query when using the LDB

Former Member — Thu, 23 Jul 2009 09:04:02 GMT

Hi Experts,

Iam preparing one ABAP query by using LDB.

And i added two more table VBPA and KNA1.

When i add the VBPA table the system will automatically generate

the sql query and we need to pass the where condition to thet query.

system generated like this..

SELECT SINGLE * FROM VBPA

WHERE VBELN =

AND POSNR =

AND PARVW =

but in the above query i need to pass the values to PARVW as 'AG' or 'SP'.

how can i pass the two values to that query?

rgds,

Sruthi.

Former Member — Thu, 23 Jul 2009 09:16:10 GMT

hi,

just simply write the select statement as you do it in the normal abap.

revert back if you need more help.

Former Member — Thu, 23 Jul 2009 09:22:36 GMT

HI,

It is system generated....just we need to pass the values to where condition.

in normal ABAP we can do like this...

SELECT SINGLE * FROM VBPA

WHERE VBELN = EKPO-ZZVBELN

AND POSNR = EKPO-ZZPOSNR

AND PARVW in ( 'AG' , 'SP').

SELECT SINGLE * FROM VBPA

WHERE VBELN = EKPO-ZZVBELN

AND POSNR = EKPO-ZZPOSNR

AND ( PARVW = 'AG' or PARVW = 'SP' ).

Rgds,

Sruthi.

Former Member — Thu, 23 Jul 2009 09:37:07 GMT

Hi,

Yes,you can declare them as it is and it will give th desiered output . Few days i had also worked on the logical databases for this concept.

If you have doubt then do tell me about it.

Former Member — Sun, 16 Aug 2009 16:05:58 GMT

Thank you very much for all.

I got the solution,

Thank you very much

Rgds,

Sruthi.