topic Re: sql in Application Development and Automation Discussions

sql

Former Member — Thu, 29 Mar 2007 03:10:21 GMT

hi,

may i know why i got error for this? instead i must have into v_matnr then only is correct. i thought tables mara is already a working area defined, right?

thanks

tables mara.

select single matnr from mara where matnr = p_matnr.

Re: sql

Former Member — Thu, 29 Mar 2007 03:18:20 GMT

tables mara.

select single matnr into mara-matnr from mara where matnr = p_matnr.

yes it is a table work area you have defined but for field selection in which field you want to store the value you have to specifically declare. or you can use

select single * from mara where matnr = p_matnr.

it will fill all the corresponding fields in table work area mara.

regards

shiba dutta

Re: sql

Former Member — Thu, 29 Mar 2007 03:34:36 GMT

Hi,

You can use the following two options:

tables mara.

select single * from mara where matnr = p_matnr.

tables mara.

select sinle matnr from mara into mara-matnr where matnr = p_matnr.

The reason for error is when you are selecting some particular fields from a table you have to explicitly specify the target fields or variables.

You tried to select only the matnr field into the entire work area of table mara.

Reward all useful answers.

Thank you.