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

Generic delta settings

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 05:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 05:35 AM

    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-b062adbb3e33

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 02:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 04:51 AM

    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.........

    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.