HRUS_D2 Entries for Substitution

[Former Member]

Hi All,

I have a strange problem in hrus_d2 table.

There is a user who created substitution (Environment is Production) and the table contained the Start Date as 08/02/2007 and End Date as 07/11/2007.

Can anyone tell me how has this happened? Is there any way to find out that the table has been updated by someone?

I tried to replicate this but the system doesnot allow me to enter an End Date less than the Start Date.

Thanks in Advance,

Pathanjali Reddy.

[Former Member · Accepted solution]

yaa that can be a case but you can also change this is debug mode no matter whatever security roles you apply to.

<b>Please reward points if useful</b>

[martin_nooteboom · Accepted solution]

But you need authorization to debug plus authorization to change in debug and normally the second is prohibited.

Regards,

Martin

[Former Member]

Hi,

Create a custom maintenance view for HRUS_D2 and create entries using that view. It will allow you to create entries with start date greater than end date. You can even create entries for user ids which does not exist in the system.

If your system has a custom maintenance view for this table then there are chances that the table would have been maintained using that view (and startdate greater than end date might have been a mistake from the user who maintains it).

Rare chances but this is one of the possibilities!!!

Thanks,

Prasath N

[KKilhavn]

Eh.... I feel a bit stupid for asking this, but just in case: <u>is</u> the end date less than the start date, or are you just displaying it in the format dd/mm/yyyy?

<i>Message was edited by Kjetil Kilhavn:</i>

I can't recall the name of the function module right now, but there is a function module which can be used to add substitution entries. Perhaps it allows the end date being before the start date?

[former_member186746]

that would be RH_SUBSTITUTES_LIST

I can't see directly that this FM checks for validity of periods.

Kind regards, Rob Dielemans

[Former Member]

The Date format i entered in my question is MM/DD/YYYY for the start date and end date as well..

I checked the FM RH_SUBSTITUTES_LIST. Once i execute it, it takes me to a window where i need to create substitution and even there it doesnot allow me to input an End Date less than Start Date.

[former_member186746]

Use the where-used list in se11 for this table to see if some strange custom program is causing this.

[Former Member]

Tried the where-used list in se11 for the table hrus_d2 and there is no custom program which can cause this.

[former_member186746]

According to SAP if you can't replicate the problem, there is no problem.

I think the pragmatic approach would be, to first find out if this kind of entry occurs only once in your system. If this is set, then you can discard the problem as some kind of weird exotic quirk SAP sometimes has.

I had the same kind of problem (the weird exotic, only happens once kind, or in my case about 3 times the last couple of 5 years) today. Where a workflow was behaving strange. I even created an OSS note for this, because I thought the fault was in the SAP standard because everything else worked fine, and the content of the containerelements were what I expected and still it didn't work. In the end I created a new workflow 100 procent exactly the same as the previous one and then it did work. Probably "something" went corrupt in one of the WF-definition tables

Kind regards, Rob Dielemans

[Former Member]

you cannot boss it hs been changed in debug mode that is what we do very easily. No change history no trace.

thanks

arghadip

[Former Member]

Thanks Arghadip for your reply...

As far as i know its not possible to debug in the Production Environment because of the access.. Do you still confirm that the the End Date might have been changed through Debug Mode or is there any other way to do that...

I guess SM30 T-code can be used to maintain a table.

Regards,

Pathanjali Reddy.