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