Skip to Content
1
Former Member
Apr 25, 2014 at 03:21 PM

How to transpose Master data records from Row to Column

1148 Views

Hi Gurus,

I came across one requirement where I need to transpose Master Data records from Rows to Column.

Is there any alternative to Expert Routine? Development will be in BI7.3

We are getting some Material information from function Module datasource in below format.

Key part here is "Material & Char Type"

Material Characteristic type Char Value 1234 Z00_PART_Color Blue 1234 Z01_Part_Type Raw 1234 Z01_Part_plant USCH 1234 Z01_Part_vendor Ford 1234

We need above information to be loaded as part of Material Attr.

Key here will be only "Material".

Material color Type Plant Vendor 1234 Blue Raw USCH Ford

I'm trying to avoid Expert Routine, but if thats the only option, what could be the best logic for it considering huge amount of data.

Thanks,

Deepak Jain