Mapping date from DDMMYYYY to InfoObject (MMYYYY)

[Former Member]

hi,

I extract a date field (DDMMYYYY) from a DataSource. I should map this Field to a Infoobject 0CALMONTH (MMYYYY).

How can i do this??

regards

sunny

[Former Member]

hi,

thanx for reply. I need the Conversion in Start- Routine before i map the field.

i get items from DS like

doc number| pos number| date______|value

1000_____|__10_______| 01.02.2009 | 100

1000_____|__10_______| 02.02.2009 | 150

1000_____|__10_______| 01.03.2009 | 200

1000_____|__10_______| 02.03.2009 | 300

i must consilidate the delta for each month.

doc number| pos number| date______|delta

1000_____|__10_______| 02.2009___| 50

1000_____|__10_______| 03.2009___| 100

When i get a Before and after image, i must calculate the delta and looks whether already exists a delta for this month.

Therefore i need the conversion.

[Former Member]

Sunny,

Directly map using automatic time conversion.

Srini

[Former Member]

Hi

If you are using SAP BI7.0 then just map the date field to month field. The system will do the conversion automatically.

If you are using SAP BW 3.5 then use time distribution in update rules.

Hope it helps.

Regards

Sadeesh

[shanthi_bhaskar]

Sunny,

write a routine in tranformations.

Map date field to 0calmonth in tranforamtion and put below code in the routine.

RESULT = SOURCE_FIELDS-<FIELD>(6).

try to test this code in the transforamtion rule itself by clicking test routine so that you can use correct offset code in it.