Skip to Content
0
Former Member
Jan 09, 2012 at 04:33 PM

Transformations - Rule Group

21 Views

Hi All,

I have a DSO with below structure

PERNR Workdate Hours Posting Date Amount

20148 01/09/2012 8 01/09/2012 100.00

20148 01/10/2012 8 01/28/2012 100.00

20148 01/11/2012 8 02/15/2012 100.00

The next level DSO, I have 0FISCPER as a time-characteristic. I want to map both Workdate and Posting Date to this Time characteristic. So that my output looks like below

PERNR Fiscal Period Hrs Amount

20148 004.2012 24 200.00

20148 005.2012 - 100.00

Is that something that I can achieve in the transformation using Rule Group as I am mapping both the dates to the same time characteristic 0FISCPER. If so, how ? Also, let me know if this is a better approach or is there a better one .

Thanks,

Suresh

Edited by: Sridharan Suresh Kumar on Jan 9, 2012 5:34 PM