Hi all,
I am writing a program that takes in an Excel file of Orders and Assets (based off of transaction KO02). What is the best way to validate the two?
1. Order?
2. Asset?
Currently, I am planning on doing a select on COAS for AUFNR, and then COBL for ANLN1. Is there a better and more efficient way to do this?
That is, if I have
excel_tab
, I was planning on:
select * from coas into table it_coas for all entries in excel_tab where aufnr = excel_tab-aufnr. *... additional processing ... * sort it_coas by aufnr. loop at excel_tab into wa. read table it_coas where aufnr = wa-aufnr. check sy-subrc = 0. *... etc ...* endloop.
I would do the same for COBL.