Question:
Hi all BW gurus,
We have made an enhance to a BW extractor to get the value of field AFRU-ISDZ. The problem is we only have the order number to access the AFRU table and performance is very poor.
Does anyone know of a table that will provide the key values of AFRU. The key fields are AFRU-RUECK and AFRU-RMZHL.
By the way, we are processing maintenance orders from PM module.
Any help greatly appreciated.
thanks,
David
Answer:
Create an index on AUFNR ( Order #) in AFRU table.
Or create a view between AFKO and AFRU ( May be techie can help you)
AFKO has aufnr ( order no )
AFRU has RUECK + RMZHL
Or
Ask ABAP programer to write a view abap code for you.
hope this helps