Skip to Content

Is anyone familiar with re-extracting a delta batch using the FPOP extractor?

Hi,

While attempting to resolve a failed process chain that uses the FPOP (Business Partner) extractor, I accidentally deleted the delta from the PSA. In order to retrieve that data, I need to somehow tell FPOP to extract those records again.

As an example, we had to do this in the past for the EBW_DQ_SS (Sales Statistics) extractor. That extractor is based on reconciliation keys, so in order to extract that data again we had to: 1) Look in table DBESTA_BWPROTH to find the reconciliation keys from the timeframe we needed to re-extract. 2) Use function module ISU_S_DBESTA_BWPROT_UPDATE to put those keys back into table DBESTA_BWPROT. 3) Rerun the extractor and process chain like normal.

So, can anyone familiar with the FPOP extractor tell me the steps to re-extract delta from there?

Thank you very much for your help!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 06:54 PM

    We created a custom ABAP program to do this which calls the FM 'FKK_DFKKKOBW_UPDATE'. See below:

    REPORT ZRFKK_DFKKKOBW_UPDATE.

    TABLES: dfkkko.

    DATA: lt_opbel TYPE TABLE OF opbel_kk,

    lv_opbel TYPE opbel_kk,

    lt_fkkkobw TYPE fkkkobw_t,

    ls_fkkkobw TYPE dfkkkobw.

    SELECT-OPTIONS:

    so_blart FOR dfkkko-blart,

    so_budat FOR dfkkko-budat,

    SO_ERNAM FOR DFKKKO-ERNAM,

    so_opbel FOR dfkkko-opbel obligatory.

    PARAMETERS ps_xsimu TYPE fkk_xsimu_kk default 'X'.

    START-OF-SELECTION.

    SELECT opbel

    FROM dfkkko

    INTO TABLE lt_opbel

    WHERE opbel IN so_opbel AND

    blart IN so_blart AND

    budat IN so_budat AND

    ERNAM in SO_ERNAM.

    IF lt_opbel IS INITIAL.

    WRITE 'No FICA documents are selected based on the selection criteria'.

    EXIT.

    ENDIF.

    IF ps_xsimu IS INITIAL.

    LOOP AT lt_opbel INTO lv_opbel.

    ls_fkkkobw-opbel = lv_opbel.

    APPEND ls_fkkkobw TO lt_fkkkobw.

    ENDLOOP.

    CALL FUNCTION 'FKK_DFKKKOBW_UPDATE'

    CHANGING

    ct_dfkkkobw_update = lt_fkkkobw

    EXCEPTIONS

    OTHERS = 1.

    IF sy-subrc <> 0.

    ROLLBACK WORK.

    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

    WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

    ELSE.

    COMMIT WORK.

    ENDIF.

    ENDIF.

    LOOP AT lt_opbel INTO lv_opbel.

    WRITE: / lv_opbel.

    ENDLOOP.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Richard,

      Thank you very much for the reply. I'm having one of our ABAP developers look at this, but I think this will be very helpful if we ever need to do this again.

      You don't happen to have a similar program for re-extracting Billing data (EBW_DQ_SS), do you? We actually had a SAP consultant onsite a year ago who was working on several issues for us. On one of them, he deleted the Billing delta from the previous evening, and then realized he could not simply rerun the process. He spent a few hours working with us to manually reset the correct reconciliation keys. We have notes on performing that process manually, but a program would be great if you have one and wouldn't mind sharing it.

      Regardless, thanks again for the help on the FICA load!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.