Skip to Content

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

Cost of a service call

Hi all!

Can i caculate cost of a service call when i enter expence as Items, labors , travels.

I need a report about cost of service call.

thank you.

replied

It will be difficult to created any Generic queries to meet your specific requirement. Try start from here:

SELECT T1.Customer, Sum(T2.Doctotal) 'Delivery', 
- Sum(T3.Doctotal) 'Return' from scl4 T0
Inner Join OSCL T1 On T1.CallID = T0.SrcvCallID
Left Join ODLN T2 on T2.DocNum = T0.DocNumber and T0.Object = '15'
Left Join ORDN T3 on T3.DocNum = T0.DocNumber and T0.Object = '16'
Group By T1.customer
Order By T1.customer

You can add more columns later.

Thanks,

Gordon

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