‎2007 Mar 22 5:16 AM
hi i need to do some validation! actually in my program the delivering country and the import code works as the key. so i need to check that the delivering country and the import code is present in a table t604.(i am updating data from presentation server to an internal table)
and also i need to check that whether the country of origin is in the table t005 or not.
if the validations are success then put those into a log file and dsiplay otherwise put the error record in a log file and display and also the total; no of error records and the no of records!!
can u people plss help me!!
‎2007 Mar 22 5:31 AM
hello,
first get the valid values into one internal table then after use for all entries ............
‎2007 Mar 22 5:36 AM
After uploading data from presentation server to internal table.
loop the internal table.
ex:
tables: t604.
loop at itab.
select single * from t604 where land1 = itab-land1 and
stawn = itab-stawn.
if sy-subrc = 0.
**same way check for t005.
select single * from t005 where
if sy-subrc = 0.
g_suc = g_suc + 1.
***here move the success records to one more internal table to create log file
endif
else.
g_fail = g_fail + 1.
***here move the failure records to one more internal table to creater error file.
endif.
endloop.
write:/ 'No.of success rec', g_suc.
write:/ 'No.of failure rec', g_fail.