How to Change the Language in Purchase Info Record (ME12) and Add Purchase Order Text in ALV Report

Managing language settings in SAP purchase info records and adding purchase order text to reports are crucial tasks for maintaining accurate procurement data. 

Changing the Language in Purchase Info Record (ME12)

Issue:

When trying to change the language in the Purchase Info Record (ME12), you might encounter the message: "No short text maintained in language DE (please re-maintain material)." Even after updating the language via Edit → Text → Other Languages → Save, the message remains unchanged.

Steps to Change the Language in ME12:

  1. Access the Info Record: 
    • Navigate to ME12 (Change Info Record).
    • Enter the following details: 
      • Vendor: 299999999
      • Material: XXXXXXXX
      • Purchase Organization: XXX
      • Plant: 9999
      • Info Record Number: 5000000000
      • Info Category: Standard
    • Click Enter.
  2. Modify the Language in the Info Record: 
    • In the Info Record General Data screen, click the 'Texts' button.
    • Go to Edit → Texts → Other Languages.
    • In the popup window, select the desired Next Language (e.g., 'EN' for English).
    • Enter the required text in the field and click Save.
  3. Check Vendor Master Data (If Language Change Fails): 
    • If the language update is not reflected, first update the language in the Vendor Master Data using transaction XK02.
    • Change the language to EN and save.
    • Retry updating the language in the Info Record (ME12).

Adding Purchase Order Text in ALV Report

Requirement:

A new column "Purchase Order Text" needs to be added to an ALV report. This column should display the text entered in the MM03 Purchase Order Text view in a specific language.

Solution Using the 'READ_TEXT' Function Module

SAP stores purchase order texts using the Read_Text function module. This function retrieves text entries stored in Material Master (MM03) or Purchase Orders.

ABAP Code to Retrieve Purchase Order Text:

DATA: i_potxt TYPE TABLE OF tline WITH HEADER LINE,
      w_thead TYPE thead.

w_thead-tdname   = wa_final-ebeln.  "PO Number
w_thead-tdspras  = 'EN'.            "Language
w_thead-tdid     = 'F03'.           "Text ID
w_thead-tdobject = 'EKPO'.          "Text Object

CALL FUNCTION 'READ_TEXT'
  EXPORTING
    id                      = w_thead-tdid
    language                = w_thead-tdspras
    name                    = w_thead-tdname  
    object                  = w_thead-tdobject
  TABLES
    lines                   = i_potxt
  EXCEPTIONS
    id                      = 1
    language                = 2
    name                    = 3
    not_found               = 4
    object                  = 5
    reference_check         = 6
    wrong_access_to_archive = 7
    OTHERS                  = 8.

Explanation of Parameters:

Parameter Description
tdname Purchase Order Number (EBELN)
tdspras Language Code (e.g., 'EN')
tdid Text ID (e.g., 'F03' for PO texts)
tdobject Text Object (EKPO for Purchase Order Item)
i_potxt Table to store retrieved text

Integration into ALV Report:

LOOP AT i_potxt INTO wa_potxt.
  CONCATENATE wa_output-po_text wa_potxt-tdline INTO wa_output-po_text SEPARATED BY space.
ENDLOOP.

Final Output:

Once integrated, your ALV report will now display the Purchase Order Text in the required language.

Conclusion

  • Changing the language in ME12 requires updating vendor master data if changes do not reflect.
  • Adding the "Purchase Order Text" column in ALV can be achieved using the READ_TEXT function module.
  • Ensure proper parameter values (tdid, tdobject, tdspras) for accurate text retrieval.
By following these steps, you can efficiently manage language settings in purchase info records and enhance ALV reports with detailed purchase order texts.

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.