Skip to Content
0
Apr 09, 2014 at 07:20 PM

How can I write this given native sql into open sql in abap

74 Views

Hi,

can any one tell me how can i write the below mentioned native sql query in open sql query in abap?

select * from table1_name z

where STATUS='C'

and (menge <>0 or res_menge<>0)

and z.LGNUM='101'

and z.LGTYP in ('Y02','Y03', 'Y04', 'Y05', 'Y26', 'Y27')

and not exists

(select 1 from table2_name q

where z.LGNUM=q.LGNUM

and z.MATNR=q.MATNR

and z.LGTYP=q.LGTYP

and z.LGPLA=q.LGPLA

and z.CHARG=q.CHARG

and (substr(q.SONUM,13,4))=(substr(z.ZZPALLET_CODE,15,4))

);

Regards