Skip to Content
0
Former Member
Apr 22, 2009 at 01:37 PM

Create Technical Key in DSO

94 Views

Hello

I have a scenario where I need to load a source with more than 16 keys to a DSO for staging, in fact every field can be regarded as a key (it's datasource 0FI_CO_OM_CCA_1).

To solve this I've come up with the idea to use every field, except key figures, as a key by concatenating them into a string and calculate a hash-sum from that string. That hash-sum will then be the table key in the DSO.

We've created a program that takes every field from a structure and creates a hash from that.

In the routine I've defined every field except the key figures to be used, and in the ABAP code SOURCE_FIELDS contains only those non-key figure fields. (Structure definition of tys_SC_1 doesn't contain the key figures)

However, when the the routine is executed SOURCE_FIELDS and tys_SC_1 is redefined by SAP automatically and now the key figures is in the strucutre. This creates some issues.

This is just twisted! Why are SAP defining the structures of a routine differently in edit mode and in execution mode?!

Does anyone else have an idea how to create a technical key from every field in a DSO, without having to care about what fields that is in the DSO?

Regards

Daniel

Edited by: Edvall Daniel on Apr 22, 2009 3:49 PM