topic Re: material multiple languages - find and delete in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300416#M502668 <HTML><HEAD></HEAD><BODY><P>makt will work.</P><P>how would you find that this is stored in makt from inside of MM03?</P></BODY></HTML> Thu, 24 May 2007 16:23:09 GMT Former Member 2007-05-24T16:23:09Z material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300412#M502664 <HTML><HEAD></HEAD><BODY><P>Various materials were setup with more than one description line. The first line uses the EN language and the second, third, etc use various languages to fit ridiculously long descriptions that should have gone into sales or purchasing text. Is there a way a query would pull down all language descriptions for a material?</P></BODY></HTML> Thu, 24 May 2007 16:11:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300412#M502664 Former Member 2007-05-24T16:11:58Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300413#M502665 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can get the material description from MAKT table.</P><P></P><P>SELECT MAKTX INTO TABLE ITAB</P><P>FROM MAKT</P><P>WHERE MATNR = P_MATNR.</P><P></P><P>As mentioned above, if you do not specify the language then it will fetch all the descriptions in all languages.</P></BODY></HTML> Thu, 24 May 2007 16:15:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300413#M502665 Former Member 2007-05-24T16:15:58Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300414#M502666 <HTML><HEAD></HEAD><BODY><P>use MAKT Table and it has material #,Description and Language</P></BODY></HTML> Thu, 24 May 2007 16:16:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300414#M502666 Former Member 2007-05-24T16:16:45Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300415#M502667 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please try this FM MARA_READ.</P><P></P><P></P><P>Regards,</P><P>Ferry Lianto</P></BODY></HTML> Thu, 24 May 2007 16:19:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300415#M502667 Former Member 2007-05-24T16:19:37Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300416#M502668 <HTML><HEAD></HEAD><BODY><P>makt will work.</P><P>how would you find that this is stored in makt from inside of MM03?</P></BODY></HTML> Thu, 24 May 2007 16:23:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300416#M502668 Former Member 2007-05-24T16:23:09Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300417#M502669 <HTML><HEAD></HEAD><BODY><P>You can't see all the descriptions in MM03.</P><P></P><P>SAP checks your logon language (sy-langu) and gets material desc from MAKT table on the basis of your logon language.</P></BODY></HTML> Thu, 24 May 2007 16:32:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300417#M502669 Former Member 2007-05-24T16:32:10Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300418#M502670 <HTML><HEAD></HEAD><BODY><P>goto material description field and Press F1 on that field and see what is field name and table name</P></BODY></HTML> Thu, 24 May 2007 16:33:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300418#M502670 Former Member 2007-05-24T16:33:34Z Re: material multiple languages - find and delete https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300419#M502671 <HTML><HEAD></HEAD><BODY><P>i was simply choosing the wrong area (under Descriptions) and i couldn't figure out where/why MAKT was not coming up. time for coffee. over 3k records w/ various multiple languages; what a mess</P></BODY></HTML> Thu, 24 May 2007 16:43:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-multiple-languages-find-and-delete/m-p/2300419#M502671 Former Member 2007-05-24T16:43:20Z