Skip to Content

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

NEED FMS IN OHEM Absence Table

Hi experts

i need a fms to be attached in OHEM -Absences Table (HEM1).

Date From -  To = Total Days

01/08/2015 - 10/08/2015  = 10 days

to get this 10 days in the Total Days i need a FMS

Regards

replied

Hi Shams,

Try this query

Select datediff(d,$[hem1.fromDate.date] - $[hem1.toDate.date],0) +1

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