topic Re: Regarding select in Application Development and Automation Discussions

Regarding select

Former Member — Wed, 07 Nov 2007 10:21:38 GMT

Hai,

I have vbeln,erdat,netwr in itab.

Now i have to get DATA from vbpa table with refering itab-vbeln.

i have to hold all the fields of itab and one field from vbpa table.

how can we write the code for this.

Thanks,

srik

Former Member — Wed, 07 Nov 2007 10:23:42 GMT

Hi,

Loop at itab.

select single fieldname from vbpa into itab-fieldname where vbeln eq itab-vbeln.

modify itab index sy-tabix.

endloop.

former_member188827 — Wed, 07 Nov 2007 10:32:12 GMT

LOOP AT ITAB.

SELECT <FIELD_NAME> FROM VBPA WHERE VBELN EQ ITAB-VBELN.

MODIFY ITAB TRANSPORTING <FIELD_NAME> INDEX SY-TABIX.

ENDSELECT.

ENDLOOP.

Former Member — Wed, 07 Nov 2007 10:35:22 GMT

Hi Jonnakuti,

Suppose you have a field t_field which you need to select form VBPA .Do like this.

Select vbeln t_field form vbpa

into table itab1

for all entries in itab

where vbeln = i_tab-vbeln.

Loop at itab.

read table itab1 with key vbeln = itab-vbeln binary search.

if sy-subrc = 0.

itab-t_field = itab1-t_field.

modify itab.

endif.

endloop.

Hope it helps.

regards

Sourabh Verma