Skip to Content
author's profile photo Former Member
Former Member

Master data reorganization - No update

Dear expert,

We are loading a master data with time-dependent attributes :

before update :

date from date to value

01012011 31122011 100

update record is loaded contains following values :

date from date to value

01012011 31032011 100

After this update what must be the content of the attributes and wich period will be stored ?

Because it seems that no update are done.

The "date to" has been reduced but the previous value is still stored in the master data, how to manage the update ?

Thank for your help.

Best regards

Christophe

Edited by: Christophe Courbot on Dec 23, 2011 11:18 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2011 at 10:43 AM

    Hi Christophe

    I guess you should not have a problem with that. It is normal behaviour. As 'dateto' is part of the key, you would still have the old record. But when you run the query, i guess the time dependant master data table would be checked for the 'validity to' date in ascending order and if the date from the query is before 31032011, the value against the new record loaded in master data, would be returned. if the date from the query is after 31032011, the value from the old record would be returned.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      In fact my question is :

      if the last valid period end in 03/2011 then the previous validity period (ended in 12/2011) must also to be updated

      if the objective is to have no value after 03 2011 ?

      I think that all periods must be updated, because after loading, 03 2011 is not stored in the table key because of the previous record (having the same value) valid to 12 2011 ...

      Thanks for your precision

      Best regards

      Christophe

  • Posted on Dec 24, 2011 at 11:23 AM

    hi,

    i guess below link might be helpful to you

    Time Dependent Master data attribute Date-From & Date-To

    regards

    laksh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 26, 2011 at 04:16 AM

    Hi,

    Once the attribute is time dependent you can see all the values like that.

    There is no problem with it.

    All the values are stored like this

    01.02.2011 - 31.03.2011 x

    01.04.2011- 20.10.2011 y

    21.10.2011-31.12.9999 z

    so there is no problem with it..

    if you want to have a look at above values you need to have calendar day /fiscal period in selection.

    You can also use key date property of query.emove any unwanted master data values.

    You can also use master data reorganisation in case you need to r

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.