Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Basic Data Upload to MATERIAL Using LSMW is not working

Former Member
0 Likes
1,450

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

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

8 REPLIES 8
Read only

Former Member
0 Likes
1,237

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...

Read only

0 Likes
1,237

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

Read only

JL23
Active Contributor
0 Likes
1,237

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

Read only

0 Likes
1,237

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

Read only

0 Likes
1,237

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

Text name

Language

Text-ID

Text object

Read only

JL23
Active Contributor
0 Likes
1,237

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.

Read only

Former Member
0 Likes
1,237

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.

Read only

JL23
Active Contributor
0 Likes
1,237

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.