Skip to Content
author's profile photo
Former Member

Delta update vs enhancement fields

Hi guys, how are you?

I'm having a trouble with the delta update in 2LIS_08TRTLP datasource.

I have appended the enhacement structure of this datasource with the field VFKP-BUDAT (Settlement date) and create a ABAP code to fill the field in the BW exit in CMOD.

When I execute a full update the extract runs well.

The problem occurr in the delta update, because if there is an update in the value of the field VFKP-BUDAT, the delta of the 2LIS_08TRTLP datasource will not see this and the BW will not be updated.

I think that this issue happens because the delta control only transport documents updates, and it will not see the update in VFKP table.

I will give an example:

TKNUM = 250000020
BUDAT = '10 apr 2011'.

If  BUDAT changes to '12 apr 2011' but there is no updates in any field of the 
Shipment Number (250000020),  BW won't update.

How can I do to make setup table of 2LS_08TRTLP take changes in the table VFKP too?

Is there a way to BW extract a shipment document again without any changes in his delta control?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Posted on May 05, 2011 at 06:36 AM

    Hi,

    see in transaction lbwe. the datasource checks only the table vtrlk, vtrlp, vtsp, vttk and vtts.

    => when you append a datasource, check always: do you get a delete, when you change your appended field?

    **** happend.

    Do you load your LIS data in an DSO? So you can create a generic datasource and change budat in dso.

    => I think, budat is the change pointer in the table vfkp: so you can select it in your infopackage (budat = yesterday).

    Sven

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sven and Arvind,

      Thank you very much.

      You gave to me some good ideas.

      I would like to takea way to make the delta control of 2LIS_08TRTLP datasource take the changes table vfkp.

      I was thinking in search an exit in the transaction that changes de values of VKFP table and when I verify that BDAT changes, for example, I can update a field in the tables vtrlk, vtrlp, vtsp, vttk or vtts to make the delta get this shippment number again and when it pass through CMOD exit, It will update BW.

      What do you think about this?

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 08:06 AM

    hi,

    There is no way that DS 2LS_08TRTLP will take changes which happened in the table VFKP.

    There can be an alternate to your design, instead of writing a CMOD code in source system, why don't you combine the data of

    2LIS_08TRFKP and 2LS_08TRTLP on the BW side, both these DS have shipment number as common field.

    The DS 2LIS_08TRFKP will extract the delta changes in the settlement date.

    regards,

    Arvind.

    Add comment
    10|10000 characters needed characters exceeded