‎2007 Oct 03 3:42 PM
Hello Guru's,
Can anyone tell me how we can put validations check to internal table fields with corresponding tables.
i know how to up load flat file to intenal table now i have to put validations as shown below .
Details is :
· validate reporting distribution channel (WWRPT) against table T2519
· validate product group (WWPG1) against table T2509
· validate product line (WWPG2) against table T2510
Thanks in advance for helping...
‎2007 Oct 03 3:46 PM
HI,
After getting the Data into the Internal table, then Loop through the Internal table and look at the Field distribution channel (WWRPT) is existed in t2519 table, if this is not existed then delete the row from that table, do the same for all the remaining entries
Regards
Sudheer
‎2007 Oct 03 3:51 PM
Hello Sudheer,
This logic is clear to me.
But problem is how to put this in code.Can you just give me sample code for help.
thanks in advance
‎2007 Oct 03 3:53 PM
Hi,
Just start the code, you will get the answers for these question your self,
After getting the data into the Internal table, jsut write the selects with those tables and check whether the data is presnt in the Internal table or not, if the data is not there then delete it from internal table
Reward if helpful
Regards
Sudheer