Transpose the dynamic rows in to static columns in CDS or AMDP View

[rajeshkothamasu]

Hi,

I got an requirement from client saying Infotype 0014 wants to see data from multiple rows to single rows in CDS / AMDP view

I referred some scn sites but it hasn't resolved.

Here is example

Usually we will have data in infotype 0014 as below

Now i have to transpose the row data to columns

Note : wage types (lgart) will change from one person to another person it won't same for all employees

Thanks,

[lbreddemann]

Many front end reporting tools do this pivot operation on the fly. That would be the easiest approach.

[shrikantpatil]

Hii,

Did you find the solution?