Probel while selecting data from table

[Former Member]

Hi,

As per my below code i want to select data from table AFKO where PLNBEZ = it_mat-matnr, and GETRI IS BLANK , but data is not comingin IT_AFKO

**********************CODE

select AUFNR RSNUM GAMNG PLNBEZ From AFKO into table it_afko for all entries in it_mat

where PLNBEZ = it_mat-matnr

and GETRI = ' '.

****************************

regards,

zafar

[Former Member]

Hi,

Try below code

select AUFNR RSNUM GAMNG PLNBEZ From AFKO into table it_afko for all entries in it_mat
where PLNBEZ = it_mat-matnr
and GETRI = '00000000'.

Hope you need the records for which GETRI is not updated.

Regards

Vinod

[Former Member]

Hi Vinod,

Thanks for reply my problem is solve with your given code, but as = ' ' is also means as spcae byt why data is not coming and when i given 8 zeroz 00000000 data is coming wher that filed is blank.

regards,

zafar