Get Errors in LSMW session

Former Member — Thu, 09 Aug 2007 13:51:46 GMT

Hi gurus,

I have a serious problem and I hope you will help me.

I need to update business partners that are listed in flat file. (It contains their numbers) I created LSMW project on the base of Batch input recording. It works suitable for me, but now I need to record the results of project execution. I want to get file like this:

Busness partners - Sucess/Error

1000000 - Sucess

1000001 - Error

....

But I don't now how to do such a check for each record in the file.

Thak in advance,

Ekaterina

Re: Get Errors in LSMW session

Former Member — Thu, 09 Aug 2007 14:19:21 GMT

Hi,

1) Just go through this which one is understandable go for that

Hi,

In the field mappings and conversion rules,

in the global section,define an internal table.

data : begin of it_errors occurs 0,

desc type string,

end of it_errors.

and where ever you have wrong or empty values for the fields,populate error there to the internal table.

for example, if Material no is blank,i have to give err msg

IF NOT MATMAS_MRPVIEW-MATNR IS INITIAL.

BMM00-MATNR = MATMAS_MRPVIEW-MATNR.

else.

IT_ERROR-DESC = 'Material no is empty'.

append it_error.

SKIP_RECORD. "to skip further processing of this error record.

ENDIF.

like this you populate all the error records to that IT_ERRORS internal table.

and finally download it using GUI_DOWNLOAD in the event

'__END_OF_PROCESSING__'

SAP generated messages can't be handled in LSMW. We can check/Analyze the logs by T.Code: SLG1.

In case they are errors that you can/ want to capture before proceeding to the session. you can capture it in the end_of_record area for each record and move it to an internal table which can then be downloaded in the end_of_processing.

Example : You have a loaded material master with the legacy material number in BISMT field in MARA. Let's say you now want to load your inventory. In the LSMW for the inventory load you can do a select and get teh SAP material number for the legacy material number provided to you. In this select if you do not find the SAP material number for one material(may be it errored out during material master load for instance) you can move this record to an internal table and in the processing block when all such errrors have been collected in the internal table then you can download it to your presentation server so you can report it to your business users to fix. This is my preferred method of loading data. Sure it will error out int eh batch session as a valid SAP material number is not provided but then you can never fix it automatically. you will have to process tem in the foreground or in errors mode and this invoves a lot of time and developers intervention. In my way developers intervention is limited. A report is generated and then business will fix the data and the delta loades will have to be loaded.

Here's the sample code :

Material Number

BINS-MATNR ()

RLBES-MATNR = BINS-MATNR.

clear RLBES-MATNR.

select single matnr into RLBES-MATNR from MARA

where BISMT = BINS-MATNR.

IF SY-SUBRC <> 0.

RLBES-matnr = BINS-MATNR.

MOVE-CORRESPONDING BINS TO err_file.

MOVE 'Material not created' TO err_file-error.

APPEND err_file.

WRITE : 'NO MATERIAL'.

skip_record.

endif.

__END_OF_PROCESSING__

FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = error_file_name

TABLES

DATA_TAB = err_file.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

This example used GUI_DOWNLOAD . Ofcourse this is now not recommended so you can use the latest FMs for download.

Reward if it worthful/ useful to u

Thanks

Naveen Khan

topic Re: Get Errors in LSMW session in Application Development and Automation Discussions

Get Errors in LSMW session

Re: Get Errors in LSMW session