topic Re: validation for data from legacy in Application Development and Automation Discussions

validation for data from legacy

Former Member — Sat, 22 Dec 2007 09:20:49 GMT

Is it possible to do the validation of records when records are read from legacy file into an internal table. If yes please give me the event where I have to right the code. I wont have authorization to change the read program.

Re: validation for data from legacy

Former Member — Mon, 24 Dec 2007 04:40:30 GMT

Hi,

Validation needs to be done once the legacy file is uploaded into internal table using FM "GUI_UPLOAD".

Once you get all the data in internal table, validate the data & remove the records which do not meet the validations.

Process the remaining records of internal table & update the db accordingly.

Best regards,

Prashant

Re: validation for data from legacy

Former Member — Mon, 24 Dec 2007 05:09:35 GMT

Hi,

Use 'GUI_UPLOAD' to upload data from legacy system into Internal table. Try to validate the data in internal table.

FM for validations:

DATE : DATE_CHECK_PLAUSIBILITY

Time : TIME_CHECK_PLAUSIBILITY

Numeric : NUMERIC_CHECK

Depending upon the requirement you can delete the invalid records from internal table and process the rest.

Re: validation for data from legacy

Former Member — Sun, 30 Dec 2007 12:04:31 GMT

Dear Sailo,

The conversion rules can be changed so that any validation logic may be inserted. This in turn is then inserted into the generated convertion program when it is next generated.

It is not so much a record validation but rather a field validation as the checks are normally perfromed at the field level. You can then use RECORD and TRANSACTION SKIP commands to ignore the record. You may also use the standard WRITE commands to display an audit of rejected records. See LSMW documentation.

Best Regards,

Rajesh.

Please reward points if found helpful.