topic picking data in Application Development and Automation Discussions

picking data

Former Member — Wed, 18 Oct 2006 12:25:05 GMT

Hi There,

Can any one tell me how to pick data from structure in to the internal.

The parameter is defined like this:

PARAMETERS : p_vbeln TYPE vbrk-vbeln.

Thanx in advance,

Former Member — Wed, 18 Oct 2006 12:28:52 GMT

HI Venu,

Can you more specific on your question.

Regards,

Manish

Former Member — Wed, 18 Oct 2006 12:31:08 GMT

Venu, if you mean to select data from database table based on selection parameter p_vbeln just use 'select' command.

Former Member — Wed, 18 Oct 2006 12:31:14 GMT

Hi Venu,

if it a parameter u can get a single value into the parameter as follows that too from the database table.

initialization.

select vbeln up to 1 rows

from vbrk

into p_vbeln.

endselect.

if at all u want to get the structure for the given parameter...

select * from

vbrk

where vbeln = p_vbeln.

in the tables declare vbrk table.

-Anu

Message was edited by: Anupama Reddy

Former Member — Wed, 18 Oct 2006 12:32:41 GMT

hi Venu,

If i have understood your question correctly this is how you have to do ..


select vbeln from vbrk into table itab where vbeln = p_vbeln.

Regards,

Santosh

Former Member — Wed, 18 Oct 2006 12:35:20 GMT

good

mention like this

if you have declared the structure, than declare it like this

DATA : structure like internal table.

thanks

mrutyun^