total consumption report

hi all

our scenario is as follows

to produce A (fin) we need X Y and Z (semi fin)

now to produce Y we need a b c (raw)

now from a batch say 1234 for material A i want to find out total consumption of all semi fin and raw material

is there any report available or any ABAP development is required

regards

KI