Skip to Content
avatar image
Former Member

Time Dependant Master Data

I have a dataload for Time Dependant Master Data attributes ( 0HRPOSITION ), the Time Interval in the infopackage is set to 01.01.2000 to 31.12.9999. My problem is when a Position has been terminated, e.g

Previously before the termination the records extracted are:

01.01.2000 to 31.12.2007

01.01.2008 to 31.12.9999

After the termination the records extracted are:

01.01.2000 to 31.12.2007

01.01.2008 to 31.12.2009

But in the Masterdata the records are:

01.01.2000 to 31.12.2007

01.01.2008 to 31.12.2009

01.01.2010 to 31.12.9999 With previous details being recorded against this record not blanks as I would hope/expect . And this is where my problem is.

I canu2019t remove the records prior to loading as these exist in other Masterdata/Infoproviders and Iu2019ve tried changing dates on the Infopackage.

Could any one advise how I can get round this issue, this is a 3.1 BW system.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 25, 2010 at 02:07 PM

    Hi Jenny,

    the only way to handle this is to have an indicator saying this position is terminated for the timeperiod beyond the termination date.

    Consider using this field in the 0HR_POSITION_ATTR datasource "REDUN - Indicator: Position (etc.) Obsolete?"

    Good luck,

    vijay

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 25, 2010 at 04:39 PM

    I did not see any issue with this. Or I did not understand your issue correctly 😊

    Previously before the termination the records extracted are:

    01.01.2000 to 31.12.2007

    01.01.2008 to 31.12.9999

    After the termination the records extracted are:

    01.01.2000 to 31.12.2007

    01.01.2008 to 31.12.2009 (position is terminated as of 31.12.2009)

    But in the Masterdata the records are:

    01.01.2000 to 31.12.2007

    01.01.2008 to 31.12.2009

    01.01.2010 to 31.12.9999 (Since its time dependent data, by default this record would be created when u activate master data).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Mr. V is right. Whenever you load a time dependent master data, for every record, one additional record get created indicating the Date To as 31129999.

      Regards,

      Yogesh