Transformation Routine:Using Attribute Value from Characteristic

[#1]

Hello Xperts,

I have the following issue for which I'm looking for some help.

I have an infoobject PROMOTION. One of the attributes is DISCOUNT.

Transactional data passes through the promotionID.

Now when updating to the InfoCube I need to have access to the DISCOUNT (Master Data from PROMOTION) attribute in my transformation. I need this to compute NETPROFIT for example. It should be possible because I have the PROMOTIONID.

Question: how can I access this attribute value in the transformation?

I need it in the startroutine, since I need to do calculations to compute other characteristics.

Thx for the input!

ps I've read the SDN pdf about routines & transformations

[Former Member]

In characteristic definition, look the name of the table in wich master data is stored, then in infocube update rules read the table with ID to get discount attribute