topic Re: MAKTX -pls help in Application Development and Automation Discussions

MAKTX -pls help

Former Member — Wed, 10 Oct 2007 05:51:22 GMT

Hi,

I'm selecting matnr and maktx(material decription) from makt into an internal table i_maktx where spras = sy-langu.

When log on language is EN- it will give all the material decriptions for the materials.

When log on language is german(DE) or spanish(es), it may give material decription for some materials or will not give for any materials..

So in case where materials do not have material decription in other languages(DE or es), the internal table has to be populated with the material decription from the default English language.

So do we implement that..

Re: MAKTX -pls help

Former Member — Wed, 10 Oct 2007 05:54:57 GMT

HI,

You can write the select querry like,

SELECT MAKTR  FROM  MAKT INTO TABLE I_MAKTX  WHERE spras = sy-langu AND MAKTR LIKE '%EN%'.

Thanks.

Re: MAKTX -pls help

varma_narayana — Wed, 10 Oct 2007 05:55:44 GMT

Hi Abhsihek..

Sample code: Just try...

SELECT MATNR MAKTX FROM MAKT INTO TABLE ITAB WHERE SPRAS = SY-LANGU.

loop at itab INTO WA where MAKTX = SPACE.

SELECT SINGLE MATNR MAKTX FROM MAKT INTO WA WHERE MATNR = WA-MATNR AND SPRAS = 'EN'.

IF SY-SUBRC = 0.

MODIFY ITAB FROM WA.

ENDIF.

ENDLOOP.

reward if Helpful.

Re: MAKTX -pls help

former_member404244 — Wed, 10 Oct 2007 05:57:47 GMT

Hi,

try like this..

select matnr maktx from makt into table i_makt

where matnr = <material number>

and langu = sy-langu.

LOOP at i_makt where MAKTX = SPACE.

SELECT SINGLE MATNR MAKTX FROM MAKT INTO WA WHERE MATNR = i_makt-MATNR AND SPRAS = 'EN'.

IF SY-SUBRC = 0.

MODIFY I_makt.

ENDIF.

ENDLOOP.

Reward if helpful.

Regards,

Nagaraj

Re: MAKTX -pls help

Former Member — Wed, 10 Oct 2007 06:01:57 GMT

Hi Kumar,

If this is ur business need.

If sy-subrc fails to get the data based on the log in language, then fetch without, SPRAS....

If the hint is useful… Say thanks by reward….

Regards,

Prabhu Rajesh