Skip to Content
avatar image
Former Member

Issue with Recordmode = 'D'

Hi Experts,

I'm using a standard extractor of type AIMD.

This captures the delta records correctly.

When the data are transferred to BW, the PSA holds the records with RecordMode = D.

However, these deleted records are not updated to the DSO correctly, meaning only one record is always deleted upon activation and the remaining records are not at all deleted.

Could you please advice on how to resolve this?

Br, Harish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 06, 2015 at 04:01 AM

    Can you please explain with an example of what is happening? Screenshots or sample data would help.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Suhas Karnik

      Hi Suhas,

      Thanks for your response.

      The extractor is of type AIMD which means that the delta is working with "After Image with Deletion Capture".

      In your scenario, the delta works in the following manner.

      If P1-P5 are deleted, the extractor extracts all P1-P10 records from the source, assigning recordmode = 'D' for P1-P5 and recordmode = ' ' for P6-P10.

      These ten records are correctly captured in the extractor and is available till PSA.

      The records with recordmode = 'D' will be deleted during DSO activation to my knowledge.

      My problem is that the deletion is not happening during the activation.

      Any suggestions?

      Br, Harish

  • Jan 06, 2015 at 06:52 AM

    Hello Harish,

    Seems to be a problem with the extractor itself. Have you checked for any existing SAP notes for this. if not I would recommend you to check for SAP note related to the extractor.

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gajesh,

      Many thanks for your response.

      The extractor is working fine as expected with deletion is correctly captured.

      The problem is in BW where the recordmode = 'D' is not deleted during DSO activations.

      Br, Harish

  • Jan 07, 2015 at 12:44 PM

    Hi,

    are the fields 'opportunity and multiple partners'  keys of the DSO object defintion? Did you check if the data are also correct before you activate the DSO data? Manage DSO object --> content --> "new data"?

    best regards,

    Janette Koppensteiner

    Add comment
    10|10000 characters needed characters exceeded