04-08-2008 5:24 PM
hi all,
what is time dependent master data?how does it effect in a hirearchy
can some one reply ASAP <REMOVED BY MODERATOR>
thanks,
deeraj
Edited by: Alvaro Tejada Galindo on Apr 8, 2008 1:26 PM
04-08-2008 6:32 PM
To extract time-dependent master data correctly, the extract structure of the DataSource must contain the 'DATETO' and 'DATEFROM' fields. The extract structure fields must, in turn, correspond exactly with those of the view from which the data is extracted. Therefore the date fields must already contain the names 'DATETO' and 'DATEFROM' in the view.If the table underlying the view has other field names, these table fields must be assigned to the view fields 'DATETO' and 'DATEFROM' within the view maintenance (SE11).
Time-dependence:
The time-dependence of a DataSource that uses generic data extraction is recognizable by the fact that it contains selectable fields whose field names are 'DATETO' and 'DATEFROM'.
Therefore, you should note the following: if the table from which you want to extract data has field names other than DATETO / DATEFROM (for example DATBI / DATAB), you must create a view that maps these fields onto DATETO / DATEFROM. Then, a DataSource is created which is extracted via this view. If the DataSource had already been created for this view before, you must generate it again. Otherwise, changes of the DB view are not transferred to the generated extract structure.
In DataSources delivered in the Business Content the time dependence may also be contained in other fields. In these cases, the corresponding fields in the BW System should be assigned to InfoObjects '0DATETO' and '0DATEFROM'.
This makes sure that they are treated with respect to selection in the same way as the fields named 'DATETO' and 'DATEFROM' are treated in the generic extraction.
The Scheduler offers two separate input fields in Tabstrip 'Update' for the entry of the interval limits of time-dependence. The time interval thus is entered as two single values for different fields and transferred to the extractor in this form.
Both the 'DATETO' and 'DATEFROM' fields as well as the fields which are assigned to the InfoObjects '0DATETO' and '0DATEFROM' are therefore not available in the selection table control.