DSO tables active data table and change log table

[#1]

Active data table under DSO(/BIC/A<ODSNAME>00): does it contain just the latest active record or also the historical data?

Change log table Under DSO: does this table contain only the historical info only, or the active record is also available within this table?

Thanks a lot for the helpful info.

[Former Member · Accepted solution]

Hi

Active Data Table contains only Latest records where as in change log it will contains Historical Data.

Suppose i loaded this records to dso

Company code    price    quantity

1000                    200     10

after activation in active table i wl see these records

Company code    price    quantity

1000                    200     10

same in change log also

in second load i loaded

Company code    price    quantity

1000                    300     15

after activation in active data table

1000           300             15

in change log

1000            200          10

1000            200          10 -

1000             300          15 

i hope it may help ful

[Former Member]

Hi

Active table contains all the data based the key fields (Historical and latest). The data is depends on the aggregation you selected(Over write or Additive).

If you select aggregation as 'Overwrite' then you will unique records for each key field value with key figure values overwritten.

If you select aggregation as 'additive' then you will have unique records for each key field value with key figures values additive.

You can check whether key figures are overwritten or additive in transformation.

Change log table also contains historical and current data based on 0recordmode however you will not have aggregations here.

Check out the below one how change log and active table contains data.

http://explore-sapbw.blogspot.in/2012/04/how-does-dso-maintains-delta-records-in.html

Regards,

Venkatesh

[Former Member]

Hi Kumar,

For active data table the KEY FIELDS will be the same as the key fields for the definition of DSO. Hence the data gets overwritten based on these key fields

So, history of a record cannot be traced if the data comes for the same key fields. This contains the latest activated record only.

For change log table the KEY FIELDS are Request number for the data transfer, Data packet number and Data record number. Hence the data will be stored based on the values of these fields, which cannot be same at any case. Change log tables holds the value of 0RECORDMODE, which helps in identifying the history of a single record.

Suppose a DSO has been defined with Company code and Calyear as key fields. Amount has been defined as data field. Assume the data comes in this way.

Load 1

-----------

Company Code          Calyear          Amount

IN10                         2010               100

After activation

In Active data table

IN10  2010  100

In Change log table  (The last entry is 0RECODMODE)

IN10   2010   100   N

Load 2

----------

IN10  2010  200

After activation

In Active data table

IN10   2010  200   >>> The entry 100 for the amount has been overwritten by 200 as the same data has come for the key fields (Company code and Calyear)

In Change log table  (The last entry is 0RECODMODE)

IN10  2010  100   N   >> Loaded after activation of load 1

IN10  2010  100-   X   >> Before Image - Loaded after activation of load 2

IN10  2010  200        >> After image - Loaded after activation of load 2

This is how we can trace the history of each record in Change log table. It is clear that we can understand that for company IN10 and year 2010, the amount was 100 initially. Later it has been changed to 200. But this cannot be understood at a glance on active data table as the entry has been overwritten.

Hope this clears you

Regards

Chandu

[former_member188080]

active data table stores all the active records so far till date ..

and change log table would store the data for any new record which is coming or any change record is coming based on type of datasource means before image /after image..etc it will recalculate the keyfigure delta value and then it will add it in the chnge log table..

Thanks and regards

Kiran

[Former Member]

Hi,

Activation queue: Used to save DataStore object data records that need to be updated, but that

have not yet been activated. After activation, this data is deleted if all requests in the activation

queue have been activated.

Active data: A table containing the active data (A table).

Change log: Contains the change history for the delta update from the DataStore object into other

data targets, such as DataStore objects or InfoCubes.

Check this link..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90d9ab26-7a66-2e10-36bb-deea308c7...

Regards,

Aravind.