0recordmode issues

[sap_user62]

Hello Friends,

Env- BW 7.3

I am facing some challenges in getting updated records which are deleted in ECC. I use datasource 2lis_11_vaitm.

Model is -- data source-->DSO1-->DSO2-->CUBE

I tested the following scenario. I deleted few line item from an existing contract in ECC and saved it.

The delta queue shows line items which are deleted with "R" in the ROCANCEL field.

I mapped the ROCANCEL field of the data source to the 0RECORDMODE field of the DSO1. Loads look good. Change log table has the deleted line items with status "R" in 0recordmode. And in active data tables the lines are cleared out.

0RECORDMODE of DSO1 and DSO2 are already mapped in the transformation by the system. I did not have to change here.

Here the change log table does not show the lines which are deleted with a "R" status. It does not even have those lines.

Now as this is an existing contract, the active data table actually shows the lines which have been deleted too. This is not what is expected.

All the DTP's are taken from the Active data table(without archive).

Very strange thing is this test works good in the sandbox with the same settings for DTP and same transformation.

Thanks a lot for your time and inputs

Ed.

[ccc_ccc · Accepted solution]

Hi ,

Filter only those records in DTP and extract and see DTP log how the records are coming try to debug and check what record mode it has.

Thank you,

Nanda

[sap_user62 · Accepted solution]

Thanks Nanda for your reply.

I have debugged the code in dev. However debugging does not allow me to capture the values of 0recordmode.

I tried to check the data in the new data table, change log table and active data table after the loads.

I have seen that from 1st level dso to 2nd level dso the load goes fine. ( load only contains the deleted record test data)

The new data of 2nd level DSO has recordmode as "R" for deleted records.

However the change log table after activation has no data at all.

So the active data still contains records with the deleted items.

I have activated the transformation from 1st to 2nd level DSO and also activate the 2nd level DSO.

No positive results.

Thanks

Ed.

[sap_user62 · Accepted solution]

Hello All,

Further information, DSO1 has 2 keys and DSO2 has 4 keys(common 2 keys with DSO1).

The problem comes in activation of the 2nd level DSO. The new data table looks good.

Is it a known issue.

Ed,

[ccc_ccc · Accepted solution]

What is the error message.