Generic extractor on LIKP, LIPS using time stamp

[ramesh_duraisamy]

Hi Gurus,

We need to extract the LIKP and LIPS using generic extractor but we had a challenge that we could not calculate time stamp?! We can get only document creation date and time, but changed records we cannot identify the change time from both the tables. Can some one help in deriving this extractor?

Thanks and Regards,

Ramesh D

[kr_pavankumar · Accepted solution]

Hi Ramesh,

Go thru this link:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70806d62-1c59-2e10-7597-91c114600...

Create function module with LIKP & LIPS tables and use CDPOS and CDHDR table for delta mechanism where the changed records information will store in CDPOS and CDHDR.

Hope it helps.

-- KRPK

[ramesh_duraisamy]

Hi Vijay,

Thanks,Can you please elaborate?!

[former_member182343]

Hi,

I mean to say that, get logic from ROOSGENDLM table to achieve delta.

Check my earlier replay more clearly.

Get back if you have any further issues.

Regards, Vijay

[ramesh_duraisamy]

Hi Purushotham,

Thanks for the input, the above fields in the table does not fulfill the change time of records.

ERZET (LIKP Table) - Entry Time (Does not give the change timings)

POTIM(LIKP Table) - Confirmation Time.(Does not give the change timings, most of the time it looks 00:00:00)

Is there any other alternate approach?!

[former_member182343]

Dear Ramesh,

Here enabling delta for function module based generic datasource is bit complex and need through testing.

Here I am providing bit of Delta logic:

SELECT SINGLE * INTO IS_DELTA_RUN

                          FROM ROOSGENDLM

                          WHERE OLTPSOURCE = I_DSOURCE.

        ENDIF.

*This means it's a delta run

        IF IS_DELTA_RUN IS NOT INITIAL.

          SELECT MBLNR MJAHR CPUDT CPUTM FROM MKPF

                             INTO TABLE LT_MKPF

                             WHERE CPUDT GE IS_DELTA_RUN-DELTAID(8)

                               AND BUDAT IN R_BUDAT.

      ELSE.

*This means that it is a full run or FIRST run, since no pointers are found

          SELECT MBLNR MJAHR CPUDT CPUTM BUDAT FROM MKPF

                     INTO TABLE LT_MKPF

       endif.

Best wishes, Vijay

[Former Member]

Hi Ramesh,

In LIKP and LIPS table you will able to find the time (TIMS) fields. Please select the appropriate field and calculate those fields in your modeling area or in ECC side.

ERZET (LIKP Table) - Entry Time

POTIM(LIKP Table) - Confirmation Time.

Thanks,

Purushotham.

[RafkeMagic]

so why not add 000001 (or another constant) as time?

unless you need (near to) real-time extraction that won't pose any problem I guess, right?