This website is not affiliated with, sponsored by, or approved by SAP AG.

How to find out Material Memo Table?

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

How to find out Material Memo Table?

Postby srvenkat5 » Mon Jan 12, 2004 10:44 am

Hi

any one help to find out the material memo table .
Got T. Code MM01 OR MM02 then MRP4. There meterial memo wil be there. If click this will call sapscript editor. there we wcan enter whatever we want. I want to know where it is getting stored(table and field name ?


Urgent Please.

Thanks
Venkat
srvenkat5
 

Postby JLG_odesse » Mon Jan 12, 2004 12:05 pm

Use the SQL trace tool : ST05

1°) Active the trace (trace on)
2°) Run your transaction
2°) Desactive the trace (trace off)
3°) Display the trace (list trace)

It will display the accessed tables, their structure, the abap code, ...

Best Regards.
JLG
JLG_odesse
 

Postby Guest » Tue Jan 13, 2004 2:37 am

Hi ,

You have to use READ_TEXT function module to get the material memo. Once u go to sapscript editor go to HEADER. Here you can see the parameters

TEXT NAME = material + storage location
language
text id
textobject.

You have to pass all these to read_text function module to retreive the information.

Hope this helps.

regards,

Kannan
Guest
 

Postby carolyip » Tue Jan 13, 2004 4:58 am

I think table STXH is also ok for checking the existence of the text!
carolyip
 
Posts: 74
Joined: Tue Oct 22, 2002 1:40 am
Location: Hong Kong

Postby Guest » Wed Jan 14, 2004 9:26 am

Hi

I have gone through the read_text. But i could not found where the message was stored. Can you help me please.
tell me the table where the message is stored. i checked up stxh stxl,stxb
nowhere the message not there.


Thanks
Venkat
Guest
 

Postby carolyip » Wed Jan 14, 2004 8:36 pm

Hi,

First, in your program, define the internal table to store the data of the text like below. Also, define a variable to store the textname for searching text.

DATA: BEGIN OF T_TLINE OCCURS 1,
TDFORMAT LIKE TLINE-TDFORMAT,
TDLINE LIKE TLINE-TDLINE,
END OF T_TLINE.
DATA: TEXTNAME(70).

Second, call the function to read the text just like below.

CALL FUNCTION 'READ_TEXT'
EXPORTING
ID = 'S002'
LANGUAGE = 'M'
NAME = TEXTNAME
OBJECT = 'VBBK'
TABLES
LINES = T_TLINE
EXCEPTIONS
ID = 1
LANGUAGE = 2
NAME = 3
NOT_FOUND = 4
OBJECT = 5
REFERENCE_CHECK = 6
WRONG_ACCESS_TO_ARCHIVE = 7
OTHER = 8.
LOOP AT T_TLINE.
IF SY-TABIX = 1.
WRITE: T_TLINE-TDLINE+0(20) TO ZTEXT1.
ELSEIF SY-TABIX = 2.
WRITE: T_TLINE-TDLINE+0(20) TO ZTEXT2.
ENDIF.
ENDLOOP.

Pls note that ID, OBJECT and NAME is reference to the key that can find the text. Look into table STXH to have some ideas on the values of them.

P.S.: Text is not stored in table. You must go to table STXH to check the existence of the text. Then, use the function READ_TEXT to read the text content into your internal table. Finally, you output the values stored in your internal table will do. This is the coding for ABAP pogram only.

Hope it helps!

Regards,
Carol
carolyip
 
Posts: 74
Joined: Tue Oct 22, 2002 1:40 am
Location: Hong Kong

Postby Guest » Thu Jan 15, 2004 7:06 am

Hi
Thanks a lot for your reply. But first i need to insert or update some information in memo field. That's the my requirement. How it is possible.

Thanks
Venkat
Guest
 

Postby Guest » Thu Jan 15, 2004 7:06 am

Hi
Thanks a lot for your reply. But first i need to insert or update some information in memo field. That's the my requirement. How it is possible.

Thanks
Venkat
Guest
 

Postby RosieBrent » Thu Jan 15, 2004 7:19 am

Well - Look at FMs, CREATE_TEXT / SAVE_TEXT. They should be all you need to complete your requirement.

You'll find them in the same function group as READ_TEXT..... so you could have worked this out for yourself fairly easily.
Kind Regards

Rosie Brent

Please remember to search the forum and check the FAQ before posting questions, thank you.

Tuly Idiot most of the time, part-time Guru Image
RosieBrent
 
Posts: 6197
Joined: Mon Oct 21, 2002 3:04 am
Location: Darlington

Postby carolyip » Thu Jan 15, 2004 8:20 pm

Hi Venkat,

Why don't u just simply insert the memo using the function itself. For example, MM01......

Regards,
Carol
carolyip
 
Posts: 74
Joined: Tue Oct 22, 2002 1:40 am
Location: Hong Kong


Return to ABAP

Who is online

Users browsing this forum: Yahoo [Bot] and 14 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.