topic Re: Basic Data Upload to MATERIAL Using LSMW is not working in Application Development and Automation Discussions

Basic Data Upload to MATERIAL Using LSMW is not working

Former Member — Mon, 01 Feb 2010 09:15:16 GMT

HI All,

we are using LSMW /SAPDMC/SAP_LSMW_IMPORT_TEXTS program to upload the basic text of the material, all steps are executed correctly and shows records are transfered correctly , but the in MM03 the text is not uploading..

EPROC_PILOT - MASTER - TEXT_UPLOAD Basic long text 1line

 Field Mapping and Rule

        /SAPDMC/LTXTH                  Long Texts: Header

            Fields

                OBJECT                       Texts: Application Object
                                    Rule :   Constant
                                    Code:    /SAPDMC/LTXTH-OBJECT = 'MATERIAL'.
                NAME                         Name
                                    Source:  LONGTEXT-NAME (Name)
                                    Rule :   Transfer (MOVE)
                                    Code:    /SAPDMC/LTXTH-NAME = LONGTEXT-NAME.
                ID                           Text ID
                                    Source:  LONGTEXT-ID (Text ID)
                                    Rule :   Transfer (MOVE)
                                    Code:    /SAPDMC/LTXTH-ID = LONGTEXT-ID.
                SPRAS                        Language Key
                                    Source:  LONGTEXT-SPRAS (Language Key)
                                    Rule :   Transfer (MOVE)
                                    Code:    /SAPDMC/LTXTH-SPRAS = LONGTEXT-SPRAS.
                                             * Caution: Source field is longer than target field

            /SAPDMC/LTXTL                  Long Texts: Row
            /SAPDMC/LTXTL                  Long Texts: Row

                Fields

                    TEXTFORMAT                   Tag column
                                        Rule :   Constant
                                        Code:    /SAPDMC/LTXTL-TEXTFORMAT = 'L'.
                    TEXTLINE                     Text Line
                                        Source:  LONGTEXT-TEXTLINE (Text Line)
                                        Rule :   Transfer (MOVE)
                                        Code:    /SAPDMC/LTXTL-TEXTLINE = LONGTEXT-TEXTLINE.

and at last it displaying as follws

LSM Workbench: Convert Data For EPROC_PILOT, MASTER, TEXT_UPLOAD

2010/02/01 - 10:14:25

File Read: EPROC_PILOT_MASTER_TEXT_UPLOAD.lsmw.read

File Written: EPROC_PILOT_MASTER_TEXT_UPLOAD.lsmw.conv

Transactions Read: 1

Records Read: 1

Transactions Written: 1

Records Written: 2

can any one tell us what could be problem

Regards

Channappa Sajjanar

Re: Basic Data Upload to MATERIAL Using LSMW is not working

Former Member — Mon, 01 Feb 2010 09:50:15 GMT

Your posting is a bit hard to decipher, but based on your last line it looks as if you're just running the conversion program, but not the actual program that then executes the transactions. Ignore my posting if I'm wrong, but if not, I'd suggest you use once the LSMW transaction directly to execute the conversion step and the the program which does the actual load...

Re: Basic Data Upload to MATERIAL Using LSMW is not working

Former Member — Mon, 01 Feb 2010 10:07:55 GMT

Hi , thanks for your reply,

i run the all the steps .

when i run the program it gives message as follows

Legacy System Migration Workbench

Project:                              EPROC_PILOT     eProcurement Pilot
Subproject:                           MASTER          Master data Upload / Change
Object:                               TEXT_UPLOAD     Basic long text 1line
File :                                EPROC_PILOT_MASTER_TEXT_UPLOAD.lsmw.conv

Long Texts in Total:                  1
Successfully Transferred Long Texts:  1
Non-Transferred Long Texts:           0

Re: Basic Data Upload to MATERIAL Using LSMW is not working

JL23 — Mon, 01 Feb 2010 12:37:31 GMT

a direct input program inserts the text into the table without checking.

if you dont see the text when oyu open the material master, then you just loaded data into STXH and STXL table that does not match with the key of your material.

What content do you have in field

Text name ? it should be the material number. think about leading zeros!!!

Language ? The load program expects a 1 character input e.g. E for english or 1 for chinese.

Text-ID ? for basic data text it should be GRUN

Text objekt ? should be MATERIAL

Re: Basic Data Upload to MATERIAL Using LSMW is not working

Former Member — Mon, 01 Feb 2010 13:59:00 GMT

Hi Jürgen L ,

i have checked all the points u have mentioned .. everything is perfect .. even i have debugged the program .. all the FM used are executing correctly with subrc eq 0.

Regards

Channappa Sajjanar

Re: Basic Data Upload to MATERIAL Using LSMW is not working

Former Member — Mon, 01 Feb 2010 15:51:36 GMT

you can try with small ABAP program using FM CREATE_TEXT and pass below values

Text name

Language

Text-ID

Text object

Re: Basic Data Upload to MATERIAL Using LSMW is not working

JL23 — Tue, 02 Feb 2010 15:18:17 GMT

can you find your LSMW created records with SE16 in table STXH ?

just search with Text id, text object and creator and creation date.

if you found entries that you dont see in MM03, then create a basic data text in MM02.

Then find this new entry in STXH.

Now compare the LSMW created record with the manual created record in all the key fields.

Re: Basic Data Upload to MATERIAL Using LSMW is not working

Former Member — Thu, 20 Jan 2011 18:12:28 GMT

I had the same problem with you and I resolved by enter material number as 18 character as its length.

example: in upload file should enter material number like 000000000000000035 not 35.

Re: Basic Data Upload to MATERIAL Using LSMW is not working

JL23 — Thu, 20 Jan 2011 23:17:42 GMT

if your material number is numeric, then this certainly correct.

but this depends on customizing, If the Lexicographical indicator is set, the system ignores the setting of the Leading zeros indicator.