topic Re: loading messages... in Application Development and Automation Discussions

loading messages...

Former Member — Mon, 18 Aug 2008 13:47:25 GMT

hi,

I have a message class created in ECC 6.0.

I have an excel sheet with 100s of messages. Can I upload it by any means for this message class , rather than typing each one of them ??

the excel sheet has language, ApprAr MsgNo and Message text as 4 columns.

thnks

Re: loading messages...

bpawanchand — Mon, 18 Aug 2008 13:49:15 GMT

Yes by using ALSM_EXCEL_TO_INTERNAL_TABLE function module you can upload the data .

all you have to do is create a INternal table witht the four fieids you have mentioned and use the above function module

[Sample Code|;

Regards

Pavan

Re: loading messages...

Former Member — Mon, 18 Aug 2008 13:49:29 GMT

Hi,

Try to create one BDC for this..

Re: loading messages...

Former Member — Mon, 18 Aug 2008 13:52:40 GMT

How do u think this list would have been downloaded ?? Is there any menu option in SE91 to download the list into an excel sheet ?

thks

Re: loading messages...

bpawanchand — Mon, 18 Aug 2008 13:56:30 GMT

By using the FM SAP_CONVERT_TO_XLS_FORMAT

Regards

Pavan

Re: loading messages...

Former Member — Mon, 18 Aug 2008 13:58:14 GMT

i think, it has been simply downloaded in se16 ... table is T100..

Re: loading messages...

bpawanchand — Mon, 18 Aug 2008 14:00:49 GMT

Can you be more clear on the query you have

Regards

pavan

Re: loading messages...

Former Member — Mon, 18 Aug 2008 14:06:06 GMT

hey pavan,

I just need to upload the messages for a message class from my excel sheet to SAP. I have like 150 message numbers and i want a simplest method to do that.

Do u suggest me to do a BDC on SE91 ??

or if anyone has already got the code to do this, great..pl share..thks