Generic Delta Extractor for FPLT.

[Former Member]

How do we go about creating a generic delta extractor on FPLT?

This table has no time/date fields to create delta extraction on.

We have a requirement wherein we want to create a generic delta extractor on FPLT with Sales order and sales order item from vbak and vbap.

All help appreciated.

[andr_klos]

Hello,

if the records of table FPLT are relevant for change history, you can use the tables CDHDR and CDPOS for creating the deltas. But consider that these tables are very large (--> bad performance).

Regards,

André Klos

[Former Member]

Thanks everyone for your answers.

I am still looking for a solution.

Please share all thoughts/suggestions about this

[Former Member]

Hi.

There are only 3 options available for generic delta, for two of which u dont have the field (date and timestamp), now the last one is numeric pointer .. You need to use this then.

Althoug it will pick up the delta records, but will always check the document number higher than the last sales order number extracted. So in case if any doc number less than that changed it will not be considered for delta. So please take care of this scenario.

Thanks

dipika

[Former Member]

Thanks Sonti and Dipika,

Could this be done by a function module? maybe an inner join on tables fpla, vbap ?

FPLA , FPLT are important tables and am sure someone must have done a generic extractor on these before.

Could someone guide me through the process?

Thanks!

[Former Member]

Hi,

These tables are related to Planning ??

now the way u can proceed is that :

1. Although I am sure but still try to find out some standard Datasource for it.

2. If u dont find, then u need to spend some time with Functional person to undersatnd that whenever they change the data related to these tables where is some date or timestamp is noted down. Sometime it happens that we dont get directly timestamp or change date noted down in these tables but is saved in related tables.

3. After the identification of change table and change field u need to create the generic ds and then use them.

In SAP as we all know its nearly impossible that change log is not maintained. So need to track out the related tables.

Thanks

dipika

[Former Member]

I need help to write a function module for a generic extractor based on FPLT, FPLA VBAP VBKD?

Havn't written a function module for generic extraction before and would appreciate any help on I can get on it.

Thanks

[Former Member]

Hi CC,

Please copy the FM RSVD_BW_GET_DELTA_DATA and make modifications in the new FM according to the requirements. Hope this helps.

Thanks and Regards

Subray Hegde

[Former Member]

Hi,

I guess you can use Numeric Pointer on Sales Order field. Try this.

-Sonti-