Issue with Recordmode = 'D'

[Former Member]

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

[jko1]

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

[former_member186399]

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

[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

[former_member185132]

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

[Former Member]

Hi Suhas,

Many thanks for your reply.

My scenario is below.

Extractor: 0CRM_MULT_PART_GEN.

For this extractor for an opportunity, multiple partners were assigned.

For example, I have 10 partners assigned for an opportunity.

When I delete 5 partners out of 10, and if I trigger the extraction, I got all 10 records with recordmode = 'D' for the deleted 5 partners in the PSA. So far, so good.

If these 10 records were loaded to the DSO, and upon activation, not all 5 records (with D recordmode) are deleted.

My question is why all the recordmode D records were not deleted upon activation?

Let me know for any clarifications.

Br, Harish

[former_member185132]

Lets say you had partners P1, P2 ... P10 originally in source sys and BW.

Then, when P1-P5 were deleted from source sys, the delta may have brought all ten records (P1-P10) with recordmode D. However, it would also have brought in the P6-P10 records with recordmode N or recordmode " ".

So the system would first delete the P1-P10 records, and then again create the P6-P10 records. This would be why P6-P10 continue to appear in the DSO.

[Former Member]

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