Skip to Content
0
Former Member
Jul 06, 2011 at 06:50 AM

recipe's detail data query report

26 Views

dear experts:

can anyone tell me how i can retrive the all detail recipe data by query report?

i tried to use the query report and draw the data from tables MAPL PLKO PLAS PLPO.

but the result is not good.

it can not fully show all the standard value and unit in the recipe.

it seems that the report can only show the first line of the "Operation/Activity Number".

while in the recipe, it may contains more than one lines.

e.g.

Operation/ActivityNumber sup.opertion resource 1st standard value standard unit activity type

1 A 1 min man_H

2 1 B 2 min Mach_H

and i tried to make the Operation/Activity Number as the selection field, but it doesn't work.

can anyone supply some tips?

by the way, is there any existed sap transaction for recipe report?

thanks a lot.

Edited by: JiQing Zhao on Jul 6, 2011 2:59 PM