Incorrect Record mode generated

[Former Member]

Hi,

I have a situation where records are not loading from underlying layer.

I load DSO 1 from DSO 2 and DSO 3.

DSO2--> Order data

DSO3-->delivery data

Delivery qty is mapper from delivery dso only.

DSO 1 has key--> Ordet item

One sales document in DSO 3 has delivery qty as 10 CS(say).

On loading DSO is picking 0 CS.

When i check change log of DSO 1 i find a very strange scenario.

A record with R recordmode is generated which negates the delivery qty value in DSO 1 and showing as zero.

For the same document delivery qty value is avaliable id DSO 3 (underlying DSo).

Checks:

In DSO 2 and 3 no deletion happened for the document and delivery qty is present.

In ECC the corresponding item was never deleted( Item 10 has issues).

Attaching the screnshot for change log of DSO 1.

Item 10 higlighted in green and the records are arranged in descending order of their loading and record number as well.

My question is if there is no deletion either in ECC and BW ,from where did the record with R image appear in DSO 1 and caused the issue,

Thanks

Nayab

[Former Member]

Still facing...

[Former Member]

Nayab,

          I think I understood the problem, but as like you I am also unable to trace the root cause. But as an observation from the data screen shot, the records which are in discussion, I see that there are no  values for company code and sales organization. I understand that if we want to really delete the records we don't need the values of data fields, but as per your analysis the 0recordmode is automatically generated with out your knowledge, if this is so, then other values should exist and this 0recordmode might some how generated with R.

If we are in sync so far then, if we see why the values are not generated in other fields, by debugging, I guess we might at least know the path of the cause.

This is just a blind guess, I might be totally wrong, but still with this explanation, if some one gets some different idea and that clicks, we all will be happy right.

Thanks,

-Mike.

[Former Member]

Hi Mike,

Thanks for highlighting the point and below is my observation

1) Data fields company code and sales org are only mapped from order dso

2) Record with R recordmode is generated from delivery side .

So for the record with R recordmode the data fields are blank because they arent mapped to delivery DSO.

Another thing that you can see from screenshot for item 10 delivery data is loaded prior to order data.

This is unusual behaviour , in correct scenarios order record will loaded before delivery record.

Anyways, i am still not able to figure from where did R recordmode showed up?

Thanks

Nayab

[Former Member]

Hi,

pls check reord no 1259 for item 10.

record 1262 is R recormode.

Thanks

Nayab

[Former Member]

Hi Nayab,

Sorry for that but i need few more information on this. May I know how many records are there in sourcly DSO. Because if its ABR then there should be only two records one is before reverce image and one is new Image but i can see here 4 records are there.

Thanks,

Kamal

[former_member182343]

Dear Nayub,

Change your DSO 1 modelling by adding one characteristic , which distinguish record is belongs to order or delivery.

As if both order and delivery holding same document number, record are getting overwrite.

I suggest you add 0VTYPE in key fields of DSO1 and write transformation (field level routine) -

DSO2--> Order data   records  as  - 10

DSO3-->delivery data records as - 20

Now, records get segregate according to Order and delivery status and avoids overwriting same key records.

Best wishes, Vijay

[Former Member]

Hi Vijay,

I dont need to remodel.

Different fiels are coming from DSO 2 and DSO3 to DSO 1.

Delivery quantity is coming only from delivery DSO.

So if my DSO 1 has 10 fields, i am updating 5 each from DSO 2 and DSO 3 to create one record in DSO 1. So no need to add another key and remodel

Thanks

Nayab

[Former Member]

Hi Kamal,

Item is key in source DSO so there will only be 1 record for item 10.

Do u need any more details?

thanks

Nayab

[Former Member]

Hi Nayab,

Just check one thing after loading from DSO3 to DSO1 check the data in actiation queue. This quantity is available or not in activate table. I just want to check this quantity is getting nagated at the time of loading or at the time of activations.And try to load that particular delivery only..

Thanks,

Kamal

[Former Member]

Hi Kamal,

Qty is not available in active table in DSO1 but it is available in DSO 3.

It is negated .

R mode is generated while loading the data from DSO 3 to DSO 1 (before activation)

thanks

Nayab