Inventory of DTP (delta) with extraction from change log table.

[Former Member]

Dear all,

Is there a way get all  inventory (list) of DTP (with delta) where the extraction is from the Change log table ( DTP:->Delta Init.Extraction From->Change Log).

I have already looked into the table provided in the following link. But not able to figure it out.

DTP tables - SAP NetWeaver Business Warehouse - SCN Wiki

Thanks in advance!!

Thanks,

-J

[Former Member · Accepted solution]

hi Jugal,

I think your looking for table RSBKDTP-PROCESSMODE. Changing the setting from Active table to Changelog is changing this field from 'A' to '3'.

Please try and comfrim.

rgrds,

Mathijs

[Former Member · Accepted solution]

Hi Mathijs,

Thanks for your input.

Unfortunately the process mode is getting 3 for Active table extraction as well. Also I am able to see a extraction from change log with the processing mode as '1' . When I press the search help for process mode it says 3 = 'Parallel Extraction and Processing'.

Regards,

-J

[Former Member · Accepted solution]

Hi Jugal,

What does it changes to when you change the mode from Active Table (without Archive) to Changelog? For me it jumps to A to 3. There are certain combination (I think) that groups more settings together.

Before

After

Regards,

Mathijs

[Former Member · Accepted solution]

Hi Mathijs,

Thanks!! In a contrast even I can see with option 1 and extraction from change log.

Regards,

-J

[former_member309855]

Hi

Please check the Table name RSLPO_DFG_DTPGEN (Table of Generated DTPs)

There is filed DSO_CL, which indicates the data extraction from change log

Priya

[Former Member]

Hi Priya,

Thanks for your reply. I have already looked into this table ( where use list of RSDRI_CHANGELOG_EXTRACTION) . This table only contain the DTP for the SPO.

Thanks.

-J

[Former Member]

[Former Member]

Hi,

you can use "get all new data request by request" to get the data exactly in the same way from change log, i hope this is what your requirement is "list of dtp"? . you can use 0recordmode in start routine to the change(after image) records (according to your requirement) from the change log.

[Former Member]

Hi

I will rephrase my question:

I want to know all the DTPs in the production system ( or any system in this case) where the delta extraction is from the change log table.

Instead of looking into individual DTP and preparing the inventory (excel), I am looking for is there a table or multiple tables or a class / method / function module where I can get the desired information.

Thanks,

-J

[Former Member]

Dear Gurus,

Any input ?

thanks,

-J