10-10-2007 6:51 AM
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..
10-10-2007 6:55 AM
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.
10-10-2007 6:54 AM
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.
10-10-2007 6:55 AM
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.
10-10-2007 6:57 AM
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
10-10-2007 7:01 AM
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