will delta work for Characteristic

[Former Member]

Hi,

I have a question , whether the delta will work for characteristic?

Ex. client is changing the  material in the order.

Previous

order    item    material   qty

2991    10        213         10

now

order    item    material   qty

2991    10        215         10

i knew if it is keyfigure, the changes in keyfigure value will be handled by changelog... how the changes in characteristics will be handled

[anshu_lilhori · Accepted solution]

Hi,

It depends how you want to get the final output.

In case you need the latest record and in your dso you only have Order and item as keyfield then second record will overwrite the first one based on the key combinations.

Another case if you need both the records then you can make material also part of your keyfield then it will create another record without over writing.

Hope it give you a clear idea.

Regards,

AL

[former_member202718]

Hi Hoa,

The changes will be against the Sale Order,

If the Keys of the DSO is Order and Item then,

Previous

Order    item    material   qty

2991    10        213         10

Latest

Order    item    material   qty

2991    10        215         10

Change Log will have 

Order    item    material   qty

2991    10        213         10

2991    10        213        -10

2991    10        215         10

Final in DSO Active

Latest

Order    item    material   qty

2991    10        215         10

rgds

SVU123

[KamalMehta]

Hi Ng,

Normally we have Sales Order and Item as Key Fields in the Sales Order Item DSO.

If you stick to above then system would identify any change in the combination of the above 2 characteristics and would consider that as an new record . In your case this would overwrite the old Material with the new one which i guess is what is required.

Thanks

Kamal

[former_member182470]

Change-log doesn't work for characteristic. This is basically a char information change for your transaction data.

It all depends on the keys what you choose in your DSO. If you  keep Order, Item and Material as Key fields. You will get old material num as well as latest material num. But it will be difficult to show the latest record in the report as all other fields are common in both the records.

It's always better to overwrite the old record with the latest one.

I suggest you to keep Order and Item as Key fields in DSO.

Regards,

Suman