Skip to Content
avatar image
Former Member

How to create generic extractor based on multiple custom tables with delta functionality

Hello All,

Need Solution for an issue as described below:

We have a requirement of creating generic DS using 2 generic table (Hdr & Itm).

-Hdr table has key field (say Invoice GUID) and Itm table has key field (say Invoice Item GUID and Invoice GUID as normal field).

-View has Invoice Item GUID field as key field

-We created a view on these two tables using condition Invoice GUID from both tables.

-Both tables has created on & changed on fields.

-Inside view we added the above fields from both tables.

-Using this view we created a Function Module.

-logic to capture delta is: when new record enters then created on filed gets value and changed on field will be blank (created on to be considered)and when old records gets updated then the changed on field will be updated and created on will have the value(changed on to be considered).

-On which one field we can define delta.

-In BW, we need to create a DSO to load data at regular interval and then to the cube

-How to delta load will work for the DSO

How can we achieve this and the process we follow is correct or not? Please help in solving this issue.

Thanks & Best Regards, Ashish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 16, 2017 at 07:45 AM

    Create one dummy date field and set as dummy date field as delta(Function Module)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Chandra,

      Dummy field to be added in the view and data will be updated for this field from FM.

      Can you share some sample code to do the same for the above requirement of capturing delta.

      Thanks.

  • Mar 16, 2017 at 07:51 AM

    Correct and fill the dummy date field with the (max change or create date)

    Add comment
    10|10000 characters needed characters exceeded