Infopackage error

[Former Member]

I am trying to load a csv file with date format yyyymmm [0fiscper] into a cube, but i keep getting an error when i load the data. Is there anyway i can get around this?

does anyone knowa conversion routine for this?

[Former Member · Accepted solution]

Hi,

Go through the oss notes:

Format YYYY-MMM not provided in convrsn exit PERI7:306272

Format 0CALMONTH, 0CALWEEK and 0FISCPER incorrect:157643

InfoPackage: Conversion exit for 0FISCPER :371300

PERI7 Conversion Routine :

http://help.sap.com/saphelp_nw04/helpdata/en/3f/e2e32d7e612d4eb4f610b2674af40b/content.htm

Regards-

Siddhu

Message was edited by: sidhartha

Message was edited by: sidhartha

[Former Member · Accepted solution]

So how do i get around this ? How do i add the zeros in the CSV file?

[Former Member · Accepted solution]

Hi,

Open your file in Excel, format the columns with zeros as 'Text', add zeros and save your file AS csv.

Best regards,

Eugene

[Former Member · Accepted solution]

when i change it to CSV., the zeros still vanish

[Former Member · Accepted solution]

Could you describe in details what exactly are you doing?

[Former Member · Accepted solution]

Hi Ravi,

No issues ,if you give it as 12003 also it is going to take as 2003001.

So no probs if the zero's vanish also .

Thanks

krish

[Former Member]

Hi Ravi,

Let me elaborate the steps you need to perform:

1. Select the column of the FISCPER in the excel file.

2. Right click and select "Format cells".

3. Select the ctegory as "text" from the first tab(Number).

4. Now add the leading zeroes.

You can also alternatively open the file in notepad and add the leading zeroes.

Bye

Dinesh

[Former Member]

Hi Ravi,

You can do as Eugene suggested or open the ".csv" file in notepad and add the zeroes.

Hope this helps.

Bye

Dinesh

[Former Member]

what is the error u r getting. ru loading through psa then to cube. if yes is the data loading correctly in psa?

[Former Member]

krishna,

i'm trying to understand here. 0fiscper format is yyyymmm. if the csv file has the same format why does he need to change the file format to mmmyyyy. can u help me understand.

[Former Member]

Hi Ravi,

You have to give the data as MMMYYYY for the CSV file as the infoobject 0fiscper has a conversion routine peri7 which converts the format to YYYYMMM.

This should solve your problem.

Thanks,

Krish

*Awarding points is a way of saying thanks in SDN

[Former Member]

how do i put the format as MMMYYYY in the CSV file? The zero's keep vanishing when i enter the figures.

Thanks in advance