works in sqvi but not work in code

[Former Member]

select-options :zu_vbeln for vbak-vbeln no intervals.

select MAKT_{MAKTX MAKT}MATNR

into (ITAB-MAKTX , ITAB-MATNR)

from ( MAKT

inner join VBAP

on VBAP_{MATNR = MAKT}MATNR )

where MAKT~SPRAS = 'HE'

and VBAP~VBELN in zu_vbeln.

MODIFY ITAB.

ENDSELECT.

any idea?

thanks.

[former_member181962]

HI Yehiel,

can you explain what exactly is the problem?

Ravi

[Former Member]

i took this select from sqvi, and there i get data

but when i put it in the code

i donot get data whit the same paramaters

[Former Member]

Yehiel,

Then go with <b>'H'</b> !!!

Make changes in ur Query stated in BOLD .

select MAKT_{MAKTX MAKT}MATNR

into (ITAB-MAKTX , ITAB-MATNR)

from ( MAKT

inner join VBAP

on VBAP_{MATNR = MAKT}MATNR )

where <b>MAKT~SPRAS = 'H'</b>

and VBAP~VBELN in zu_vbeln.

MODIFY ITAB.

ENDSELECT.

Thanks

Kam

Note: Allot points for all worthful postings

Message was edited by: Kam

[Former Member]

i need 'he' not en

[former_member181962]

HI Yehiel,

Try passing 'B' in place of 'HE".

For hebrew, it is internally stored a 'B'.

It will work.

Regards,

Ravi

Try the follwing code

select MAKT_{MAKTX MAKT}MATNR

into (ITAB-MAKTX , ITAB-MATNR)

from ( MAKT

inner join VBAP

on VBAP_{MATNR = MAKT}MATNR )

<b>where MAKT~SPRAS = 'B'</b>

and VBAP~VBELN in zu_vbeln.

MODIFY ITAB.

ENDSELECT.

[Former Member]

thank ravi

[Former Member]

select B_{MAKTX B}MATNR

into (ITAB-MAKTX , ITAB-MATNR)

from ( VBAP as A

inner join MAKT as B

on A_{MATNR = B}MATNR )

where B~SPRAS = 'HE'

and A~VBELN in zu_vbeln.

MODIFY ITAB.

ENDSELECT.

it should work

reward points if it helps you.

thanks

Message was edited by: Anid

[Former Member]

Hi,

Have you already checked that zu_vbeln is a correct interval and will give data?

Cheers,

Mireia