FM / CODE get top most parent material from child material in any stage

[sivakumar_subramaniam2]

hi gurus.,

i had to display a report that contains production quantity,rejection quantity and defects in various stages of material ...but i hv to sum all the defects at various stages of a material as a whole .. how can i achieve this ...

eg.,,

FOR MATERIAL M11220-0200:

THESE ARE SUB-MATERIALS :

PART NUMBER DEFECTS:

SD MB MM

M11220-0200-071 1 3 6

M11220-061 1 5 5

M11220-051

M11220-041

M11220-031

M11220-021

RM211701530 3 3

RM111701630

My report should display outptut as:

PART NUMBER PROD REJ SD MB MM

QTY QTY

M11220-0200 200 28 6 11 11

PLZ HELP ME .. ITS REALLY URGENT

[sivakumar_subramaniam2]

solved