Generic Delta Datasource

[Former Member]

Hi Experts,

I have a Table on which I need to build generic delta datasource.I have created On (ERDAT) and Changed on (AEDAT) fields. I need to find a way to capture both newly created records and changed records in a single datasource. Any suggestions is appreciated.

Thanks,

SB.

[Former Member · Accepted solution]

Hi,

You should create this generic datasouce with Function Module. Here, you can get delta from changed data or new data by coding. Here is a shorted code of function module:

OPEN CURSOR WITH HOLD S_CURSOR FOR

SELECT (S_S_IF-T_FIELDS) FROM ZSD_BILLING_T

WHERE VBELN IN L_R_VBELN AND

BUKRS IN L_R_BUKRS AND

POSNR IN L_R_POSNR AND

( AEDAT IN L_R_AEDAT OR ERDAT IN L_R_AEDAT )

ZSD_BILLING_T : transparent table (source of data)

ERDAT: enter date

AEDAT: changed date

S_S_IF-T_FIELDS: set of selection fields and its value of your data source

L_R_AEDAT: parameter get date from delta saving date.

In maitain generic datasource (rso2) you go to delta generic and chose AEDAT is delta-specific field

Hope this helps

BR

TRUC

[Former Member]

HI,

Do u have any posting date in the table.

If so please use that field.

Regards,

shashikanth.

[Former Member]

HI,

May be you can create two data sources and load it in the DSO in the overwrite mode.

Keep the delta for one on the changed on date and for another one keep it on created on.

Load the created on first and changed on data source after that.. one after another to the DSO.

Since a newly created record will not have any changed on date but once changed you will have the date there...so to capture intially you can have one data source and to capture the changes you can another data source.

I dont think you can do anything elese other then that.

Thanks

Ajeet

[rajkumar_kandula]

making that Data source delta enabled will helps you in geting even changed records along with newly created ones. Revert back if still have any queries

[Former Member]

Hi Raj,

Thanks for the new response. The datasource is build on a view with delta enabled on CHANGED ON AEDAT field. It picks up the changed records but it does not pick up the newly created records. Any suggestions!!

Thanks,

SB.