cancel
Showing results for 
Search instead for 
Did you mean: 

Reimbursement amount based on days interval

Former Member
0 Kudos

Hi All,

I have a requirement that needs to be configured in SAP Travel Management. I have tried but could not get the desired result as I am unable to differentiate rates for day’s intervals.

The requirement is: Client currently has a Reimbursement amount for Business Trip Allowance. This is a fixed rate based on trip duration. The amount per day differs for every 7 days. An example is given below.

This is separate allowance from Meals and Accommodation.

1 - 7 Days

8 - 14 Days

15 - 21 Days

22 - 28 Days

> 28 Days

30

20

15

10

     8

Lets say if an Employee has a Trip for 15 Days: He should get the reimbursement amount as follows

  1. For first 7 days: 30 USD per day :  7 * 30 = 210
  2. For 8 to 14 days: 20 USD per day: 7 * 20 = 140
  3. For 15th day: 15 USD per day:       7 * 15 = 15

Hence: System should calculate reimbursement amount and pay: 365 USD as Business Trip allowance.

Can we do this in SAP. IF yes, please let me know how to achieve this.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hello,

it doesn't matter if you use backend Transactions or web-dynpro. The relevant changes are needed in the settlement process. Sigi is wright- there is no option in standard available.

I have provide two years ago a consultion solution for  DSAG customers and adapt it for  your request

The Intention was to mainupulate the reading of the T706V and T706U now with other criterias

So maybe try this out:

Include RPREX000

Form exb706V

...

Data: counter type i.

If  argu-datv1 >= wa_head-datv1

  counter = argu-datv1 – wa_head-datv1

endif.

If counter >= 1 and

   counter <= 7.

  Anzta = ‘007’.

  Anstd = ‘24’

 

ELSEIf
counter >= 8 and

counter <= 14. 

Anzta = ‘014’.

Anstd = ‘24’

ELSEIF

  Counter >=15 and

  Counter <=21.

Anzta = ‘021’.

Anstd = ‘24’

ELSEIF

  Counter >=22 and

  Counter<=28.

  Anzta = ‘028’.

  Anstd = ‘24’

ENDIF.

Customize
in sm30 V_T706V new entries for

ANZTA (Anzahl Tage = Number of Days)14, 21, 18

ANSTD 24 (Number of Hours)

And you
should have in general an entry

 

ANZTA = 99

ANSTD = 24

(for all other several day trips)

       

You have to
use a similar way for reading accommodation table T706U

Same Include but Routine EXB706U  

The date fields wa_head-datv1 and wa_head-datb1 are available too

So that you can find out the number of days

But in
T706U you will not have a ANZTA field.

So you must use an other criteria:

The Routine has following criterias

 

LNDGR RGION BEREI

ERKLA ERGRU

DATUM.

KZREA= trip type mandatory

KZTKT = activity type

BEREI trip type enterprise specific

Example: create the new trip types enterprise specific

A: short text 1-7 hours

B:   8-14 hours

...

Maintain
additional entries in sm30 V_T706U with your new enterprise trip types

And program in the routine

If argu-datv1 >= wa_head-datv1

counter =
argu-datv1 – wa_head-datv1

endif.

 

If counter >= 1 and 

   Counter <= 7.

  BEREI= ‘A’.

ELSEIF.

…  and so on

This should help.

Best regards

Klaus

kmoore007
Active Contributor
0 Kudos

There is some functionality for Pocket Money you might can research.  It has 'Days' as a setting.

Former Member
0 Kudos

Hi Kenneth,

I have explained the client that it is difficult to accommodate this feature and now client has made it clear with the following changes.

They want to link the Business Trip allowance reimbursement to Travel Advance where the System has to automatically calculate the Advance based on the per day flat rate for Employee grouping. i.e. Employee can not edit the Advance amount and it is auto calculated based trip days.

Any inputs for this case?

Former Member
0 Kudos

Hi,

your new approach is not possible in SAP standard.

A lots of customers are requesting this since years (Per diem calculation in travel request).

Which frontend you are using? If it is WebDynpro for Abap you would be able to calculate what ever you want and fill this into a the advance field. (Set advance field to "no input allowed")

With this the amount will be requested via travel request.

Best regards, Sigi

Former Member
0 Kudos

Hi Sigi,

Yes we are using Web Dynpro for ABAP. Is it possible to make an option to employee request more or additional advance than the automatically calculated one.

Here the requirement is in some cases the employee needs additional advance. If we make the advance field no input allowed. How can we go about requesting additional amount.

Another requirement is: Client wants to have Travel desk to update the ticket details in the SAP when the book the same so that they verify the airline bill and make payment. How can we make it possible for travel desk to access travel request and enter the details in Portal. There is no Travel planning here.