topic Re: problem with SELECT SINGLE in Application Development and Automation Discussions

problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:04:40 GMT

can you find any error in this

select single * from makt where matnr = p_matnr and spras = 'sv'.

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:07:49 GMT

Hi,

Change you code to

select single * from makt where matnr = p_matnr and spras = 'S'. OR

select single * from makt where matnr = p_matnr and spras = sy-langu.

Regards,

Atish

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:30:33 GMT

Hi,

select single * from makt into table <tablename> where matnr = p_matnr and spras = 'S'.

Regards,

Ameet

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:34:09 GMT

Hi,

If u pass values in where field then it should be always capital letter. Anyways i hope ur issue got fixed.

Regards

Sathish:)

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:38:49 GMT

Pass the value SPRAS in Capital letters

or declare variable for the same

Regards

Shiva

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:50:05 GMT

HI.

SEE BELOW CODE PLZ..

data: BEGIN OF it_makt OCCURS 0,

matnr LIKE maKT-matnr,

maktx LIKE makt-maktx,

END OF it_makt.

data: process_tab_struct_tmp like IT_MAKT.

field-symbols: <fs1>.

after downloading file(excel) to excel_tab....code follows

LOOP AT EXCEL_TAB.

assign component excel_tab-col of structure

process_tab_struct_tmp to <fs1>.

<fs1> = excel_tab-value.

at end of row.

move-corresponding: process_tab_struct_tmp to IT_MAKT.

append IT_MAKT.

endat.

ENDLOOP.

if i check with this below statment...it's giving sy-subrc = 4. (but data there in makt)

select single * from MAKT where MATNR = it_makt-MATNR and SPRAS = 'E'.

my clue: any conversion problem with it_makt-matnr ......plz replay fats.

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 05:52:38 GMT

Hi,

yes you are right. You need to convert MATNR.

USe CONVERSION_EXIT_ALPHA_INPUT to convert the material number.

or use CONVERSION_EXIT_MATN1_INPUT

Reward points if useful.

Regards,

Atish

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 06:01:30 GMT

thanks atish

if i use CONVERSION_EXIT_MATN1_INPUT

CALL FUNCTION 'CONVERSION_EXIT_MATN1_INPUT'

EXPORTING

INPUT =

IMPORTING

OUTPUT =

input =???

output=??? according to my code plz suggest will get 6 points:)

Re: problem with SELECT SINGLE

Former Member — Fri, 06 Jul 2007 06:18:17 GMT

Hi,

Use like this.

data: BEGIN OF it_makt OCCURS 0,

matnr LIKE maKT-matnr,

maktx LIKE makt-maktx,

END OF it_makt.

data: process_tab_struct_tmp like IT_MAKT.

field-symbols: <fs1>.

after downloading file(excel) to excel_tab....code follows

LOOP AT EXCEL_TAB.

assign component excel_tab-col of structure

process_tab_struct_tmp to <fs1>.

<fs1> = excel_tab-value.

at end of row.

move-corresponding: process_tab_struct_tmp to IT_MAKT.

CALL FUNCTION 'CONVERSION_EXIT_MATN1_INPUT'

EXPORTING

INPUT = it_makt-matnr

IMPORTING

OUTPUT = it_makt-matnr.

append IT_MAKT.

endat.

ENDLOOP.

Do reward points to useful answers.

Regards,

Atish