topic Re: validating Input file in LSMW in Application Development and Automation Discussions

validating Input file in LSMW

Former Member — Sat, 06 May 2006 10:47:49 GMT

Hi All,

I am doing an initial stock upload using LSMW. I am

passing a file in .CSV format . How do i validate the

entries in CSV files in LSMW, so that incorrect entries

do not get processed at all.

Thanks

Nishant

Former Member — Sat, 06 May 2006 10:58:11 GMT

You should insert the abap code you need in the MAPPING step.

There's a std MACRO to allow to skip the transaction: SKIP_TRANSACTION.

So for example:

SELECT SINGLE * FROM T001 WHERE BUKRS = FILE-COMPANY.

IF SY-SUBRC <> 0.

WRITE: / 'Company code is wrong'.

SKIP_TRANSACTION.

ENDIF.

In this way you can read a log after upolaading the file and the LSMW'll load only the correct record.

Max

Former Member — Sat, 06 May 2006 11:03:30 GMT

Hi Max,

I am new to LSMW and dont have much idea as to where this piece of coding should be done and how to read a log.Can you please elaborate on this.

Thanks in advance

Nishant

Former Member — Sat, 06 May 2006 11:11:42 GMT

In the MAPPING step, you link the file fields to structures SAP fields.

After linking the fields, do a doubleclick on the field you need to check, now the system'll open and editor where you write your code.

So insert here your validation and write a log if it's wrong, use the global data G_SKIP_RECORD to skip the record (not SKIP_TRANSACTION).

All data you insert in this step, they'll be used in CONVERTION step by the system.

So:

IF ......

WRITE 'ERROR'.

G_SKIP_RECORD = 'X'.

ENDIF

Max

Former Member — Sat, 06 May 2006 11:14:23 GMT

thanks MAx, that solved my problem...

i have given u full points for this....