Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Routine

hi Bw gurus,

I am having Material, Component characteristics and a KPI GI Quantity,GR Qty in my report. I am explaning my requirement with a example.

In order to produce this material 300201001 these are the components required and the relevant GI Qty,GR

Report output getting like this:

Material<<<<<<<<<<<Component<<<<<<<<<<<<<<<<<GI Qty<<<<<<<<<GR qty

300201001 <<< >>> 1004001 <<< >>> 1656KG <<< >>> 6780KG

300201001 <<< >>> 1006001 <<< >>> 5600KG

300201001 <<< >>> 1018007 <<< >>> 15KG

300201001 <<< >>> 300201001 <<< >>> 6780KG

300201001 <<< >>> 301511002 <<< >>> 460KG

300201001 <<< >>> 40020100101112 <<< >>> 30KG

My requirement is

If Material NO = Component NO then GI Qty = GI Qty - GR Qty

Desired Output should be like this

Material<<<<<<<<<<Component<<<<<<<<<<<<<<<<<GI Qty<<<<<<<<<GR qty

300201001 <<< >>> 1004001 <<< >>> 1656KG <<< >>> 6780KG

300201001 <<< >>> 1006001 <<< >>> 5600KG

300201001 <<< >>> 1018007 <<< >>> 15KG

300201001 <<< >>> 300201001 <<< >>> 0KG

300201001 <<< >>> 301511002 <<< >>> 460KG

300201001 <<< >>> 40020100101112 <<< >>> 30KG

share u r thoughts of how to achieve this task.

Full points will be assigned

Regards,

Syed

Not what you were looking for? View more on this topic or Ask a question