Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

correcting erroneous records in BI session

Former Member
0 Kudos

after processing the batch input session if any erroneous records exists then how to correct the records in the same session and reprocess the session

please help?

1 REPLY 1

Former Member
0 Kudos

Hi Sami,

if u run in error display mode , transaction will stop when there is error record, manually we can change that and run it,

r else gather all records in a flat file , and do changes to that records and run lsmw again with those errorfree file. For these we have to write code in mapping step.

For eg:

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.

***********************

if there are any error records how to download those error records , can any one give the logic to download the error records while handling LSMW with predefined programmes or

bapis .

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__'

Reward for helpful answers.

Thanks

Naveen khan