Skip to Content
0
Former Member
Jun 06, 2008 at 07:18 AM

Select Query Problem

57 Views

Hi Experts,

I have one query. I am trying to fetch the records from VBAK & VBAP table based on some condition as below

SELECT AVBELN AKUNNR B~POSNR

BMATNR BWERKS B~LGORT INTO TABLE ITAB FROM VBAP AS A

INNER JOIN VBAP AS B ON AVBELN = BVBELN

WHERE A~VKORG IN S_VKORG

AND A~AUART = 'OR'.

But here I am not getting any value in my internal table ITAB.

This is due to reason that order type AUART having 4 length & I am passing in my select query as 'OR'.

Even I tried to pass as '00OR' but still I am not getting value in ITAB.

The database table having records for this selection.

Any suggestion to resolve this issue i.e. What I need to do for order type in where clause??