Skip to Content
0
Former Member
Dec 07, 2006 at 02:56 PM

Order and Asset Validation

92 Views

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.