delta data loading for bseg table

[Former Member]

Hi experts please help,

                I want to do delta data loading for BSEG table, As i am new to DATA SERVICES please let me know step by step process for delta data loading for BSEG table.

1.the BSEG table is directly fetch from ECC.

2.I have 2 environments in data services that is ECC and Oracle, so that i can drag and drop BSEG table from ECC, and then do the process for delta data loading.

[former_member187605]

Modifications to BSEG are logged in CDHDR table.

Create an ABAP dataflow where you join both tables:

The join condition is:

BSEG.MANDT || BSEG.BUKRS || BSEG.BELNR || BSEG.GJAHR = CDHDR.OBJECTID and

CDHDR.OBJECTCLAS = 'BELEG'

Put your delta-calculation in the where-clause, something along the lines of:

CDHDR.UDATE >= $ExtractionStart and CDHDR.UDATE < $ExtractionEnd

Then use this ABAP dataflow as the source in the dataflow loading into your Oracle target.