Month conversion routine

[Former Member]

Hi All,

I have a field applied month in an ODS and the ODS is being updated by a Flat file. The format of applied month is YYYYMM and when I upload the data I am noticing that the format that is displayed is YY/MMYY (example Flat file has 199810; the data after load is displayed as 19/9810).

The infoobject applied month is referenced to 0calmonth and has Peri6 as a conversion routine with 7 as output length.

Please help.

[Former Member · Accepted solution]

Hi Ashmith,

1)

Goto SU01 > give your username>change>Defaults->

Date format-->Select YYYY.MM.DD..

2) Otherwise change your flat file data --> like 101998 ..

Don't forget to assign points..If helpful

[Former Member]

Hi,

You can use the following input formats for PERI6:

MM.YYYY

M.YYYY

MM.YY

M.YY

http://help.sap.com/saphelp_nw04/helpdata/en/2b/e9a20d3347b340946c32331c96a64e/frameset.htm

Best regards,

Eugene

[Former Member]

Hi Eugene,

Should I drop the conversion routine from the applied month? Can I use Peri 5 conversion routine?

[Former Member]

Hi All,

I dropped the conversion routine in the DataSource/Transfer rules and loaded the data to get the right results.

Thanks for your suggestions though.

Ashmith Roy

[Former Member]

Hi Ashimith,

Please maintain the data format MMYYYY at flat file...whenever you are uploading the data the conversion routine (PERI6) automatically converts in to his internal format.

Because check it input length is 6 and output length was 7 for 0calmonth info object.

Regards,

PRK

[Former Member]

Hello Ashmith,

Just used the format MM/YYYY and try to load this from flat file. It is nothid to do with the month conversion routine.

Regards

Gopal