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??