Generic delta settings

[Former Member]

Hi there, i want to create a generic DS based on a table/view, that'd support DELTA loads. I have "Created on" and "Modified on" fileds. The "Modified on" filed is not mandatory, i mean, when i change a record in the origin R/3 table, this filed does not change its value.

Question is, is there any reason to make the Generic DELTA with the associated filed "Modified on" ??

If i do it with "Created on" filed, only the new records will be updated on upload, but not modified ones.

And just general question: If, for example, "modified on" field were the mandatory one and the records wouls change its value when a record is changed in the origin table. How can my DS be aware of the both new and modified records, since i only have the option to include only one filed as the associated field: Change date or Creation date??

Thanx

[Former Member · Accepted solution]

Hi,

How can my DS be aware of the both new and modified records, since i only have the option to include only one filed as the associated field: Change date or Creation date??

You have to create 2 DS one for Create and another for Change if you want to report on both the dates.

You cannot fetch both the fields at a time by using one ds.

Or either You have to take ABAP coding help by using FM - Generic DS.

Hope it helps

[Former Member]

Hi

Check the link, this document explains very clearly on how to create a generic datasource with delta method

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b062adbb...

But your requirement you should rather use pseudo delta meaning you should have both the date fields as selections and create a routine in infopackage for date selections

Also refer to Ajeet posting

Hope this helps

Regards

Edited by: BI C on Dec 23, 2008 6:36 AM

Edited by: BI C on Dec 23, 2008 6:36 AM

[Former Member]

Thanx, points assigned

[Former Member]

Hi.......

U can achieve this by using a function module instead of table/view..........But for that u hav to write ur own ABAP logic.....u can use a control table in this case...........to store the last time stamp so each time the extractor runs ............it will pick the last run time stamp ..........and collect the data from that point..........

Hope this helps......

Regards,

Debjani.........

[Former Member]

Hi,

thats true...It will not be aware of the both.

either you could have picked created on or changed on...... and depending upon that you could have got only new records or changed records.

May be to get both you need to create two data source with delta on each field and then update it to the same target like DSO in over write mode with the created on loading first before changed on load.

This will make sure that the new records will get overwritten by changed one if any.

Thanks

Ajeet