Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Validating some fields like Co Code & Bus Area

Dear Friends,

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,

Nishu

Tags:
Former Member
Former Member replied

Hi Nishu,

after the call to FM ALSM_EXCEL_TO_INTERNAL_TABLE the table t_excel has the fields

row|col|value

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..

endloop.

regards

satesh

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question