Skip to Content

Uploading long text for Customer Master through LSMW

Requirement: Loading the long text for Customer Master data in SAP.

The flat file in our example contains the long text for General Data tab in  Customer Master Data. The same LSMW can be used to upload the texts in Company Code Data and also in the Sales Area Data tabs. The header record contains the Customer information (Table name, Customer Number and Text ID) and is identified by the starting character ‘H’. The item records contain the long text to be uploaded for the Customer and the starting character ‘I’ identifies the record. See the screenshot below: 

  /wp-content/uploads/2014/02/1_398260.png

Enter the T code LSMW and press Enter.

On the Screen “Legacy System Migration Workbench” click on create icon  /wp-content/uploads/2014/02/2_398409.pngor Press (Shift + F1)

Enter the  Project, Subproject and Object and their descriptions as shown in the below screen shot and press Execute icon /wp-content/uploads/2014/02/3_398410.png    or F8.

/wp-content/uploads/2014/02/4_398411.png

/wp-content/uploads/2014/02/5_398412.png

Once executed we will reach the below screen and we need to follow the below steps:


/wp-content/uploads/2014/02/6_398413.png

  1. 1. Maintain Object Attributes

Now select the Maintain Object Attributes radio button and press execute /wp-content/uploads/2014/02/3_398410.png.

On the screen LSMW Workbench: Display Object Attributes click on the icon  /wp-content/uploads/2014/02/7_398424.pngand select the Standard Batch/Direct Input.

On the field Object Enter “2000” (SAP script Texts) and Method as “0000” or you can select from the drop down menu.


/wp-content/uploads/2014/02/8_398426.png

After selecting the

Object : 2000

Method : 0000 (Defaults to 0000 automatically), save the changes  and press back icon  or F3.

You will reach the below screen with radio button selected on “Maintain Source Structures”, now click on execute.


/wp-content/uploads/2014/02/11_398427.png

  1. 2.      Maintain Source Structures

Create two structures one for Header and one for Item. The item structure will be at lower level for the Header and save. Press back and select the radio button “Maintain Source Fields”.

  /wp-content/uploads/2014/02/12_398428.png

Press back button and select the radio button “Maintain Source Fields” and click on Execute.

  1. 3.      Maintain Source Fields

Define the fields as per the flat file structure. In both the structures the first field must be identifier. Create the identifier field of character 1 and specify the identifying field content ‘H’ for header structure and ‘I’ for item stricture as shown below. 

/wp-content/uploads/2014/02/13_398432.png

 

Header Structure

  /wp-content/uploads/2014/02/14_398433.png

Item Level Structure.

/wp-content/uploads/2014/02/15_398434.png

Here the Field LINE of item structure is char 132, so each text line from the input file must be less than or equal to the length 132.  Save the changes and press back button. Now we have to maintain the Structure Relations.

Select the radio button “Maintain Structure Relations” and click on execute


  1. 4. Maintain Structure Relations

Assign the header source structures to all the Header target structure and Item source structure to all Item target structure.

Select the header texts and click on the icon “Relationships”  and select the header structure as shown below.

/wp-content/uploads/2014/02/17_398438.png

Your screen should look like the below screen shot after assigning all the header and Item structures.

/wp-content/uploads/2014/02/18_398439.png

Save the changes and go back by pressing F3 or the Back icon.

Now select the radio button “ Maintain Field Mapping and Conversion Rules ” and press execute.

  1. 5.      Maintain Field Mapping and Conversion Rules

Map the source fields to the target fields


Header mapping

  /wp-content/uploads/2014/02/19_398440.png

Item mapping

 

/wp-content/uploads/2014/02/20_398444.png

Save the changes and press the back button.

Now we need to specify the files. Select the radio button “Specify Files” and press execute.

  1. 6.      Specify Files

Place the cursor on Legacy data On the PC Front end and click create button

Enter the input file details

  /wp-content/uploads/2014/02/21_398445.png

Select the delimiter ‘Tabulator’, if the fields in the input file are separated by tab. Save the changes and press back button.

  1. 7. Assign Files

Select the Assign files and click on execute

Now we need Assign the input file to both the structures, Select the header structure and click on Assignment icon  and also select the Item structure and click on Assignment icon . See the below screen shot which should look like this after assigning the files both at header and item level.

/wp-content/uploads/2014/02/22_398446.png

  Save the changes and press the back button.

  1. 8.      Read Data

Execute the Read data.

/wp-content/uploads/2014/02/23_398447.png

Once again execute to show the read data as below.

/wp-content/uploads/2014/02/24_398448.png

Press back twice to reach the below screen and now we need to execute the “Display Read Data”

/wp-content/uploads/2014/02/25_398449.png

  1. 9. Display Read Data

Execute the Display Read Data and click continue on the Popup.

/wp-content/uploads/2014/02/26_398450.png

The system displays the read data from the flat file as shown in the below screen shot.

/wp-content/uploads/2014/02/27_398451.png

Press back to reach the main screen.

  1. 10.  Convert Data – Execute the convert data

Now execute the Convert data step. Once again click on execute, So that the system shows the converted data as in the below screenshot.


/wp-content/uploads/2014/02/28_398452.png

Press the back button twice to reach the LSMW menu in order to execute the next step i.e., Display Converted Data.

  1. 11.  Display Converted Data.

Press execute on the Display Converted Data and on the popup select continue,

/wp-content/uploads/2014/02/29_398456.png

So, that the system displays the converted data as below.

/wp-content/uploads/2014/02/30_398457.png

Press back to reach the LSMW menu and execute the last step ” Start Direct Input Program”

  1. 12.  Start Direct Input Program

Click on Execute, once again click on execute

/wp-content/uploads/2014/02/31_398458.png

 

Result: The Long text will be updated for the selected customers. 

Transaction XD03 to view the Customer text uploaded through LSMW.

/wp-content/uploads/2014/02/32_398459.png

Double click on the text line to display the uploaded text in the editor mode.



End of LSMW for Customer Master Texts.

To report this post you need to login first.

20 Comments

You must be Logged on to comment or reply to a post.

  1. Ravi Sankar

    Good document and very well presented.

    Nice to see you again active on SCN. Hope you will continue posting more content like this.

    Best Regards,

    Ravi Sankar

    (0) 
    1. Ankit Agarwal

      Thanks for the document.

      I did the same steps and I am trying to upload text in Sales area data.

      I am using object as KNVV and I suppose in Name i am suppose to enter combination of Customer number + Sales org + Distribution Channel + Division.

      Everything is working good. except when i start ” Start Direct Input Program”

      I keep  “test Import without saving” as blank.

      On execution, I am getting error as

      OBJECT        KNVV

      NAME          UK2000206044001011

      ID                 Y001

      LANGUAGE EN

      Object KNVV and ID Y001 are not defined in table TTXID

      ERROR – ITF object cannot be imported

      END OF TEST IMPORT – imported data was not saved

      I checked in the table TTXID and the text ID is available.

      Can you please help.

      (0) 
  2. prashanth gaddam Post author

    Hi Ankit,

    Please check whether you did the Text determination for Customer Master.

    Assign the text determination procedure to your Account group and then check in the Customer Master texts whether the TEXT Id is displaying.

    Try once again and let me know if you have any issues.

    Prashanth

    (0) 
  3. Giuseppe Simone

    Hi experts, can anyone help me to understand how to create the company code data for a customer (vendor) already existing as general data,  using LSMW – Standard Batch input/Direct input (RFBIDE00).

    What i want to do is to deal separately the following steps (if possible, otherwise in a single step could be ok):

    1. create general data for customer (vendor, GL account).

    2. create company code data for that customer (vendor, GL account).

    Thank you for you help!

    Giuseppe

    (0) 
  4. Venkatesh Babu

    I had executed the transaction LSMW on Uploading Customer Master Texts through LSMW. I had faced in the last step “Start Direct Input Program” as Logical file name “RSTX_FILE_LOCATION” does not exist.I am executing it in test system.Please let me know how to rectify it? Do you want to implement any SAP notes 1497003 on this?

    (0) 
    1. Chand Zainabdin

      We were able to fix the issue by creating the logical name using the transaction code FILE.

      Create the new entry in Logical file name definition for the missing logical name.

      (0) 

Leave a Reply