Skip to Content

Delta on date fields in SAP BODS

hi experts,

I have a table ZCONTRACT in my SAP ECC system. This table have - created on and changed on date fields.I have created a table based generic extractor on this custom table.Now i need to create a job in BODS to fetch the data from this table and store it in template. But i need to create a delta on created on date and changed on date in BODS to capture delta records.

I dont want to create delta in source system.

Could you please let me know the steps in detail how can i create CDC in bods on these 2 fields?

Your response will be highly appreciated.

Thanks,

Abhimanyu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 06, 2018 at 05:16 PM

    Create a batch control table and store the last extraction date in it. Compare the Last extraction date with the date fields from source and fetch records which are satisfying the CDC criteria.
    I assume the following:

    Here when a record is added in source the created_on and changed_on are same while once a change is made then only the changed_on date is changed. Then your CDC criteria will be changed_on>= last extraction date. This will help in identifying the delta records.

    record id created_on changed_on

    1 12/6/2018 1:01:06 PM 12/6/2018 1:01:06 PM

    2 12/6/2018 1:01:06 PM 12/6/2018 2:01:06 PM

    Regards,
    Rishabh

    Add comment
    10|10000 characters needed characters exceeded