topic Re: upload long text in mm02( basic data text ) in Application Development and Automation Discussions

upload long text in mm02( basic data text )

santosh_kumar94 — Mon, 10 Dec 2012 10:45:26 GMT

dear experts,

how to upload long text in basic data text in mm02 using BDC.

after recording it's showing no fields related to that text filed. so how we can upload it using mm02 t-code.

plz help to solve my issue.

Re: upload long text in mm02( basic data text )

Former Member — Mon, 10 Dec 2012 10:53:55 GMT

Upload long text is not possible through bdc.

Use FM ' CREATE_TEXT '....

Regards

Re: upload long text in mm02( basic data text )

Former Member — Mon, 10 Dec 2012 10:58:29 GMT

Hi,

I suggest you to use the SAVE_TEXT function instead.

http://search.sap.com/ui/scn#query=SAVE_TEXT+material+basic&startindex=1&filter=scm_a_site%28scm_v_Site11%29

Regards,

Christian

Re: upload long text in mm02( basic data text )

santosh_kumar94 — Mon, 10 Dec 2012 11:48:11 GMT

dear experts,

using "save_text" fm

how we will come to know that the long text is going to save releted to that material number.

can u explain ?

Re: upload long text in mm02( basic data text )

Former Member — Mon, 10 Dec 2012 12:02:45 GMT

Chaeck this code for ur reference....

TYPES : BEGIN OF TY_MM01,
    MATNR TYPE CHAR6,
LONG TYPE   CHAR250,
        END OF TY_MM01.

TYPES : BEGIN OF TY_LONGTXT,
         TD_FORMAT TYPE TDFORMAT,
         LONG TYPE TLINE-TDLINE,
         END OF TY_LONGTXT.

DATA : IT_LONGTXT TYPE STANDARD TABLE OF TY_LONGTXT,
        WA_LONGTXT TYPE TY_LONGTXT,
        WA_HEADER LIKE THEAD,
        NEW_TEXT TYPE C.

DATA : IT_MM01 TYPE TABLE OF TY_MM01,
        WA_MM01 TYPE TY_MM01,

*&--------------------------------------------------------------------*
* to save long text
*&--------------------------------------------------------------------*

loop at it_mm01 to wa_mm01.

READ TABLE IT_MM01 INTO WA_MM01 INDEX SY-TABIX.

       WA_LONGTXT-TD_FORMAT = 'ST'.
       WA_LONGTXT-LONG = WA_MM01-LONG .
       APPEND WA_LONGTXT TO IT_LONGTXT.
       CLEAR WA_LONGTXT.

      WA_HEADER-TDOBJECT = 'MATERIAL'.
      WA_HEADER-TDNAME = WA_MM01-MATNR.
      WA_HEADER-TDID = 'GRUN'.
      WA_HEADER-TDSPRAS = 'E'.

    CALL FUNCTION 'SAVE_TEXT'
      EXPORTING
*     CLIENT                = SY-MANDT
        HEADER                = WA_HEADER
        SAVEMODE_DIRECT       = 'X '
      TABLES
        LINES                 = IT_LONGTXT
      EXCEPTIONS
        ID                    = 1
        LANGUAGE              = 2
        NAME                  = 3
        OBJECT                = 4
        OTHERS                = 5
          .
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
COMMIT WORK.
REFRESH IT_LONGTXT.
ENDLOOP.

Regards

Re: upload long text in mm02( basic data text )

santosh_kumar94 — Mon, 10 Dec 2012 12:03:52 GMT

dear experts,

i have the following format to upload to basic data text in mm02.

material texts

1. aaaaaaaaaaaa

2. assssssssssssss

3. eeeeeeeeeee

a 4. rttttttttttttttt

5. rtttttttt

6. trerrrrrrrrrrrrr

7. errrrrrrrrrre

8. errrrrrrrrrrrrrrr

9. errrrrrrrrrrrrr

b 10 .errrrrrrrr

11 .dfrrrrrrrrrrr

12. dgffffffffff

13. dfffffffffffffff

how i will update this format in mm02 - basic data text (in that big box) using bdc.

plz provide me some code.

Re: upload long text in mm02( basic data text )

RaymondGiuseppi — Mon, 10 Dec 2012 12:07:30 GMT

Did you try a more up-to-date solution like BAPI BAPI_MATERIAL_SAVEDATA which allows to add long texts ?

Regards,

Raymond

Re: upload long text in mm02( basic data text )

Former Member — Mon, 10 Dec 2012 12:16:19 GMT

Hi,

If you have a proper format then you can go to BDC by recording mm02 but the format is different. So use GUI_UPLOAD to get data from file into internal table and looping through internal table use either BAPI_MATERIAL_SAVEDATA or SAVE_TEXT.

try this method and put the code what you have tried if you are getting any probs..

thanks.

Re: upload long text in mm02( basic data text )

Former Member — Mon, 10 Dec 2012 12:17:49 GMT

Hi Santosh,

How to Know what is a input value for Uploading any Long text into SAP

find below steps.

(Note: Please use BAPI for better performance )

1 . goto Purchase order text viwe screen (MM02)
2 . click on editor icon (at left bottom on the screen , 3rd button from left )
3 . editor open

4 . select 'go-to' --> header from menubar

Text Name == 'Material Number leading with zero's if Internal Number )
Language == 'EN'
Text ID == 'BEST'
Text Object == 'MATERIAL '

BY following the above steps u can find any logtext input value's.

5 . Please use SAP Standard BAPI "BAPI_MATERIAL_SAVEDATA "
performance wise better then BDC

Regard's

Smruti Ranjan

Re: upload long text in mm02( basic data text )

Former Member — Mon, 10 Dec 2012 12:50:38 GMT

Hi Santosh ,

please check sample code using SAP Standard BAPI (

BAPI_MATERIAL_SAVEDATA

DATA: E_ERROR LIKE BDCDATA-FVAL,

MHEADER LIKE BAPIMATHEAD,

             L_MLTX LIKE BAPI_MLTX        OCCURS 0 WITH HEADER LINE.

TYPES: BEGIN OF TYPE_ITB,
      MATNR TYPE MARA-MATNR,
      TEXT_LINE TYPE BAPI_MLTX-TDLINE,
      END OF TYPE_ITB.

      DATA:ITAB TYPE STANDARD TABLE OF TYPE_ITB,
           WA TYPE TYPE_ITB .

*/*            COLLECT ALL Excel sheet value into ITAB */

SORT ITAB BY MATNR .

LOOP AT ITAB INTO WA .

CALL FUNCTION 'CONVERSION_EXIT_MATN1_INPUT'
        EXPORTING
          INPUT        = WA-MATNR
        IMPORTING
          OUTPUT       = WA-MATNR
        EXCEPTIONS
          LENGTH_ERROR = 1
          OTHERS       = 2.
      IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
      ENDIF.

* FILLING MATERIAL HEADER STRUCTURE
MOVE 'X'     TO MHEADER-BASIC_VIEW.
MOVE 'X'     TO MHEADER-PURCHASE_VIEW.

* LONG TEXT BUILD

      MOVE 'MATERIAL'                               TO L_MLTX-APPLOBJECT.
      MOVE WA-MATERIAL                             TO L_MLTX-TEXT_NAME.
      MOVE 'BEST'                                   TO L_MLTX-TEXT_ID.
      MOVE 'EN'                                    TO L_MLTX-LANGU_ISO.
      MOVE '/'                                     TO L_MLTX-FORMAT_COL.
      MOVE WA-TEXT_LINE                            TO L_MLTX-TEXT_LINE.
      APPEND L_MLTX.
      CLEAR L_MLTX.

* CREATING MATERAIL MASTER
CALL FUNCTION 'BAPI_MATERIAL_SAVEDATA'
    EXPORTING
      HEADDATA            = MHEADER
    IMPORTING
      RETURN              = BAPIMSG
    TABLES
        MATERIALLONGTEXT    = L_MLTX .

IF BAPIMSG-TYPE = 'E'.

    CONCATENATE E_ERROR BAPIMSG-MESSAGE INTO E_ERROR SEPARATED BY SPACE.
    EXIT.
ELSE.

    CONCATENATE E_ERROR MAT_NR 'Material Master Record Description Successfully Changed' INTO E_ERROR SEPARATED BY SPACE.
    COMMIT WORK AND WAIT.
ENDIF.

ENDLOOP .

Note : Use Excel sheet Format

Material Number (leading with zero if internal number used ) Long Test (132 character at time )

000000001000000009 aaaaaaaaaaaaaaaaaaaaaaaaaaaa

000000001000000009 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb

000000001000000009 cccccccccccccccccccccccccccccccc

000000001000000010 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh

000000001000000010 uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

000000001000000011 uuuuuuuuuukkkkkkkkkkkkkkkkkkkkkkk

000000001000000011 uuuuuummmmmmmmmmmmmmmmmmm

Regard's

Smruti

Regard's

Smruti

Re: upload long text in mm02( basic data text )

Former Member — Tue, 11 Dec 2012 08:00:32 GMT

Hi,

SAVE_TEXT usage for materials..

data: thead type thead,
       tline type TABLE OF tline WITH HEADER LINE.

thead-TDOBJECT = 'MATERIAL'.
thead-TDNAME = your material no.
thead-tdid = 'GRUN'.      "Basic data text
thead-TDSPRAS = 'EN'.
tline-tdformat = 'E'.
TLINE-tdline = 'Hi this is the material SD TEST'.
append tline.
CALL FUNCTION 'SAVE_TEXT'
   EXPORTING
    CLIENT                = SY-MANDT
     header                = thead
     insert               = 'X'
    SAVEMODE_DIRECT       = 'X'
   tables
     lines                 = tline
EXCEPTIONS
    ID                    = 1
    LANGUAGE              = 2
    NAME                  = 3
    OBJECT                = 4
    OTHERS                = 5

thanks. .