validation for data from legacy

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.