Validating some fields like Co Code & Bus Area
I am uploading Co Codes & Bus Area from excel sheets into the Ztable. Now I want to check if the Co Codes & Bus Area are not existing in the table T001 & TGSB then those values should not be uploaded in the zTable & should throw the error.
Plz help me in doing this.
Waiting for ur responses.
Thanks & Reg,
Satesh R replied
after the call to FM ALSM_EXCEL_TO_INTERNAL_TABLE the table t_excel has the fields
the value is stroerd in the corresponding field of itab for a given row and column ..
if you want to do a check on two of these fields with T001 .. then as said above just do a loop at t_excel at required columns and do a select on the tables.. find the column numbers before that
loop at t_excel where col = '0002' and col = '0003'.
*do a select with itab-value in the where condition..
*then throw an error mesage if it fails..