12-10-2012 10:45 AM
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.
12-10-2012 10:53 AM
Hi
Upload long text is not possible through bdc.
Use FM ' CREATE_TEXT '....
Regards
12-10-2012 10:58 AM
Hi,
I suggest you to use the SAVE_TEXT function instead.
Regards,
Christian
12-10-2012 11:48 AM
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 ?
12-10-2012 12:02 PM
Hi
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
12-10-2012 12:17 PM
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
12-11-2012 8:00 AM
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. .
12-10-2012 12:03 PM
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.
12-10-2012 12:16 PM
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.
12-10-2012 12:50 PM
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
12-10-2012 12:07 PM
Did you try a more up-to-date solution like BAPI BAPI_MATERIAL_SAVEDATA which allows to add long texts ?
Regards,
Raymond