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

Need "Generic Data source using Function module" to handle Delta

I have used the function module RSAX_BIW_GET_DATA_SIMPLE and copied to write a generic data extractor to suit my requirement, its working fine in and I have been able to successfully load data into BW system form the source system using this data source.

I would now like to make it delta enabled, my main table (from where the FM extractor gets the data) has two (actually four) fields. Create date and Time, Change Date and Time is available.

Can any body suggest as how do I make this data extraction delta enabled (either by Time stamp or delta queue or anything else)?

For your information the start table is CMSD_LO_HEADER. Do we have any existing data source form SAP for this.

Thx

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Posted on Apr 06, 2006 at 06:52 AM

    I am not too sure of GET_DATA_SIMPLE can be used for delta.

    It works fine for init but there is a different function that needs to be used for delta. SOmething like RSD....

    This post would give you the right FM.

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2006 at 07:10 AM

    Hi,

    sure you can use that fm for the generic delta. Just define one date field (lets say zdate) of your extract structure as the generic delta field. It will be passed to the fm automatically by the service api in the table with the select options. Check that table for an entry with fieldname zdate. If it is there, you are in a delta load, if it is not there, the load is a full or init.

    Pass the value to a range table or any other variable that you can use in the select statement for the delta like:

    select * from table

    where creation_date >= zdate-variable

    or change_date >= zdate-variable.

    With this you always get all records created or changed since your last delta. But take care about deletions.

    Siggi

    PS: let me know your email and I can sent you another template.

    Message was edited by: Siegfried Szameitat

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Srinivas,

      Can you please send me the working template for "Function module for Generic DS"?

      I have been fighting with this FM for a long time even though I am working really much time on this.

      I greatly appreciate your help.

      Regards,

      Hanuma

  • author's profile photo Former Member
    Former Member
    Posted on Jun 23, 2006 at 03:44 PM

    Arunava,

    <b>give me ur email id?</b> i will send you how to that. update the thread with code. we make it as delta enable.

    all the best.

    Regards,

    Nagesh Ganisetti.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2006 at 09:30 AM

    Hi Nagesh Ganisetti,

    I have a same problem like Guenter. Can you please send me the template, would be very nice.

    My e-mail is: ygany@hotmail.com

    Thanks in advance

    Regards

    YEOU

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2006 at 02:52 AM

    Hi All,

    I am also facing the same problem would anyone please send me steps or document. I appreciate it in advance. My mail id is akr2754@yahoo.com.

    Thanks a lot

    Regards

    Kishore.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2007 at 12:22 AM

    Hi Siggy,

    Can you please send me the template for delta extraction, That would be a good help.

    krishnamalyala2002@yahoo.com.

    Kind Regards,

    Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 07:56 PM

    Hi there,

    Can you please send me the template for "Function module for Generic DS"? I am struglling for the problem. My email box is tomtwj@yahoo.com.

    thanks

    Tom

    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.