Skip to Content
avatar image
Former Member

Approver Limit Report

Hi Experts,

I have requirement to extract SRM data to BW and build a approver report. The reporting requirement is to see in an org unit there could be multiple org units n each of those can have multiple positions and under each position there will be only one central person.

Each central person has a limit assigned and can approve only upto those values which are assigned , but if the value is greater than the CPs assigned value then the one above that CP will approve, it has find the right CP who has the correct approval limit within that org unit.

In the selection will be a cost centre.

Bus Seg, Cost centre Org Unit personA (value)PersonB (value) and personC( value).

I have multiple challenges here.

Org unit, position, person and values are available in SRM tables Hrp1001 and HRP5503.

but there is no cost centre in SRM rather i have to use cost centre from ECC.

So my 1st question is How do i link SRM Org unit data with ECC cost centre?.

2nd question in the report how do i show list of approvers(one approver) in each column, because it could vary from org unit to unit and cost centre to cost centre.

How do i acheive the above in BW?

I hope i was clear in my details.

Your help is appreciated.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers