Hi,
I need to upload the ztable with the data given in the excel file.But before uploading I need to do some validation on the fields given in the file.
For example the first field in the file is plant.I need to check whether the value given for the plant in the file exists in T001W table(check table) or not.Similarly for other fields I need to check with the check tables corresponding to them.If the value doesn't exist in the table then it should give a load error as 'Value &&&& not valid for "field".
Can anyone tell me how can I do this validation?