Skip to Content
author's profile photo
Former Member

Valid from and to date for time-dependent attributes

Time-dependent master data requires that the R3 source data has the valid 'From date' and 'To date' fields.

From the 'Attribute' tab there is a column to check whether the attribute is time-dependent or not. Most certainly some of these attributes may not have the the valid 'From date' and 'To date' fields from R3 but BW still has this column as checkable.

Would it be more effective if this 'Time-dependent' column were able to distinguish which attribute has the the valid ''From date' and 'To date' fields from the source and only allow it to be as checkable? Those attributes that don't have the the valid 'From date' and 'To date' fields from the source should have the 'Time-dependent' column grey-out or not checkable.

Another way to look at this would be that BW gives the flexibility to do flat file load to contain the valid 'From date' and 'To date' fields if the attributes from the R3 source do not have the valid 'From date' and 'To date' fields. Is this a correct observation of how this 'Time-dependent' column from the 'Attribute' tab work? So when it is checked, the data load should contain the valid 'From date' and 'To date' fields?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Sep 27, 2007 at 08:03 PM

    Hi Edna,

    The Validity dates are for the parent char, not the attribute. Eg if we look at char 0COSTCENTER, Profit Center may be marked as Time Dependant, whereas Cost Center Category is not time dependant. The master data table would look like:

    CostCenter___From_____To________ProfitCenter________CostCenterCategory

    C100___01.01.2000__12.31.2005____P100______________CC01

    C100___01.01.2006__12.31.9999____P105______________CC01

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhanu,

      It makes sense, but it seems that other chars, 0MATERIAL_ATTR for example, only has the field 'Valid-From Date' . Could I still use 0MATERIAL to do time-dependent reporting?

      Would it be correct to say that those chars that have the 'Valid-From Date' and 'Valid-To Date' can only be used for time-depedent reporting and those that don't have these fields can't be used to do so?

      What would be the main criteria to doing time depenndent reporting?