Populate "Created by" and "Created on" in the Input ready query

[surbhi_17]

There is a query where user will update the Master data for the attributes of Material , and it should populate the fields Created by and Created on in the Report whenever a new entry is made by any user 

How we can achieve this ? 

[gregor_dieckmann]

Hi,

you can use a master data planning query to maintain master data and master data attribute values. In your case create attributes 'Create by' and 'Create on' and fill the attribute values in characteristic relationship of type 'Exit'. In the exit class implementation implement the method DERIVE, there you can fill the attribute values.

Formally the characteristic relationship should have the key fields of the characteristic as source fields and the attributes you want to derive as target fields.

You should find many examples in this forum how to implement characteristic relationships of type exit.

Regards,

Gregor