topic Re: Probel while selecting data from table in Application Development and Automation Discussions

Probel while selecting data from table

Former Member — Wed, 19 May 2010 06:21:09 GMT

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

Re: Probel while selecting data from table

Former Member — Wed, 19 May 2010 06:28:41 GMT

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

Re: Probel while selecting data from table

Former Member — Wed, 19 May 2010 06:34:16 GMT

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