Regarding ABAP query when using the LDB

[Former Member]

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]

hi,

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

revert back if you need more help.

[Former Member]

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').

or

SELECT SINGLE * FROM VBPA

WHERE VBELN = EKPO-ZZVBELN

AND POSNR = EKPO-ZZPOSNR

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

Rgds,

Sruthi.

[Former Member]

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]

Thank you very much for all.

I got the solution,

Thank you very much

..

Rgds,

Sruthi.