cancel
Showing results for 
Search instead for 
Did you mean: 

NOT able to load historical data from excel

Former Member
0 Kudos

I have created a excel file with columns

Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8

Plant Product Brand Sold-to party (customer) Sales organization Month (for example, 012006) Quantity Unit of measure

Saved the file as CSV ( comma delimited). Loaded this data in info cube. It shows the messge data is extracted but when trying to test the data , all of the data is shown under APO location lolumn under DP_IC list output. And the column names( Dimentions) are different than the above coulmn names. Please let me know where I am going wrong. Looks like my data is not been corrrectly extracted Is anything wrong with the CSV file.

When I am trying to maintain charactersick combinations and select the respective info provider and info cube it says ' No characterstick combination is created? Does this mean in the previous step data is not uploaded correctly.

Please guide me.

Thanks

Gayatri

Accepted Solutions (1)

Accepted Solutions (1)

former_member209769
Active Contributor
0 Kudos

Hi Gayatri,

you would have defined the datasource with certain fields. Either maintain the fields in excel in the same sequence, or otherwise do a mapping between the source file fields and the infosource fields. You can preview how your loaded data would look like in the infopackage.

For CSV file, it's very important that you create a excel file, then save this file as a csv file. Do not change anything in csv file now. Subsequently, when you close the csv file, it will ask you to to save. DO NOT SAVE while closing. Use this csv file now as it is. Not sure if this would be helpful for you, but I faced some issues due to this when I started in APO long time back.

Before going to create CVCs, check that data in cube is loaded properly. Based on your information, definitely the data is not coming to cube properly.

Former Member
0 Kudos

Thanks Pawan and Manimarn for your guidance.

Can you please guide me how to do mapping between the source file fields and the infosource fields. I followed the regular procudure data is uploading into info cube but not properly. All of the column dada is displaying in only one column APO location. I am not able to figure out what is wrong.

I wanted to upload a print sceen but there is not option to do an attachment here.

Please reply.

Thanks

Gayatri

Former Member
0 Kudos

Thanks Manimaran.

Former Member
0 Kudos

Hello Gayatri,

If your data loading is successful but the data is loaded in one column only, please check the following:

1. open the .csv file with note pad & check whether the separator has " , " or " ; ". Mostly you will have " , " as your data separator in file.

2. check the data separator in the infopackage also(external data tab). by default in SAP it is " ; ", change it to " , " & remove " , " from separator for thousands field.

3. check the preview before loading again.

hope this will help you.

Thanks

Former Member
0 Kudos

Thank you Sushant for your reply.

I followed the steps you mentioned in your reply. I am getting this error. "CONVERSION_EXIT_CUNIT_INPUT"

Do you have any idea what this error means? Please guide me if you can.

Thanks

Gayatri

former_member209769
Active Contributor
0 Kudos

Issue lies likely with your "Unit of measure" field.

Conversion routine is finding some issue with teh values that you are trying to enter. What all values have you entered while defining UoM (in SAP)?

Try choosing "format" = "external" in your source system definition for UoM field.

Former Member
0 Kudos

The error happens because you would have mentioned the characteristics name on the first line of the csv file. Kindly enter only the data with reference to those fields rather than entering the field name on the top. I faced a similar issue upon which the data was loaded fine after removing the field name from the top of the csv file.

Hope your query was answered. Try it and let us know.

Former Member
0 Kudos

Hello Gayatri,

Go to your datasource or transfer structure, & remove the BASE_UOM from unit column for your sales history or any quantity key figure & CUNIT from Convesion Column for your BASE_UOM fields.

You don't need them if you using excel upload functionality.

& also be sure you have excluded the header row in your infopackage.

Let me know if this works.

Thanks.

Former Member
0 Kudos

Thanks Janani,

I tried doing that. There is one positive thing happened. When I checked monitor after loading data. It showed successful status. Where as all other earlier loading failed. But I am stil not getting the results. All of my CSV file data is entered into only one column that is APO Location. When I try to preivew my data after selecting the source file it shows the same. All of my data is inserted into only one field ( One column). Please help. Is there any way I can post screen shots in the forum.

Thanks

Gayatri

Former Member
0 Kudos

Thanks a lot Sushant for your guidance. I checkes datasource/ transfer structure. There is no BASE_UOM for unit column of sales history.

But there is CUNIT in the conversion column of BASE_UOM. I tried removing it and checked if this fixes y problem. It diid not. Its still the same.

Gayatri

former_member209769
Active Contributor
0 Kudos

Hi Gayatri, regarding all data coming into a single column - Did you already try to check what Shushant told you some time back? You should see what separator exists in your CSV file. Let me elaborate if Shushant's comments were not clear. Right click on CSV file, and then choose the option "open with". Now choose the option "notepad". In the window that opens, check how your data is separated. Most likely, it would be comma. If it is comma, which most likely it would be, go to "extraction" tab of your infopackage, and change the value in "data separator" field from semicolon ( to comma (,). If there is a field called data format, make sure that you have chosen an option similar to " separated with separator (for example CSV)".

1 row you would have already ignored in infopackage by now, I guess (if you are still maintaining that in your csv file).

regarding UoM topic - Do you still face some issue? You would have maintained the quantity column in your csv file as data type "quantity" in datasource. What is teh UoM you maintained in SAP for this "quantity" type field? I would assume that this unit for quantity field corresponds to the unit what you maintain in the last column of your csv file.

Pls share the unit that you have maintained for quantity field in datasource and also the unit that you have maintained in the last column in CSV (along with SAP names for these fields).

Former Member
0 Kudos

In the external data tab, you will find a option named "data separator". If it holds " ; ", kindly change it to " , ". As pawan stated, convert the csv file to a notepad and check the separator. You have to change the separator in the info package corresponding to the notepad. Mostly it would be " , ". Do check the preview tab and now load the file.

Hope it got loaded as per your requirement.

Cheers

Janani

Former Member
0 Kudos

Thank you all for your insight into my problem error. It is solved partially. I changed the data seperator from ";" to ",". When I check preview it shows data correctly. Next i go to schedule and run the one time upload job. It says data is extracted. When I go to Info_ Cube and check for the data. It is still in the same . All data inserted in one column. When I check the monitor for load. It says :" Incorrect".

I guess that means data load is unsuccessful.

Pawan,

I checked unit of measure data type. In CSV file it is ST( String) and in datasource trans structure it is Unit.

and also for quanity field ( history) data type is CHAR. and UoM for quantity is 'Unit'.

Please reply,

Thanks

Gayatri

Former Member
0 Kudos

Hi,

Make sure you saved the settings once you changed the data separator.

Save it & then schedule it for load.

even after that you have problems. go to monitor, double click on the recent incorrect error. check the error message in status tab or you can go to Details tab & find the error there. May be you select PSA maintance there & correct the error.

Thanks.

Former Member
0 Kudos

Thanks everyone. Solved the problem. Now I can see the data uploaded in info cube correctly.

But I still see the prvious data uploaded in there. How to delete the previous data.

Gayatri

Former Member
0 Kudos

What is the correct format for 0CALMONTH. Looks like the dates I entered in data are messed up when loaded in infocube.

I entered my dates in DDMMYYYY format (05082010) and after uploading data the date format became 082005.

And another question, How the data is loaded? I mean. Is first row in the csv corresponds to first row in the data uploaded?

Please reply

Gayatri

former_member209769
Active Contributor
0 Kudos

For calmonth, the data in your csv file should be in the format yyyymm format (if I remember correctly). Since you are using 0calmonth in SAP, do not maintain the date of the month in the csv file. Maintain only the month and year in CSV in yyyymm format. If you want to use full date yyyymmdd in the csv file, then use 0calday in SAP.

In your csv file, you may or may not use the header row which contains the name of the field (if this is what you mean). If you maintain the header row, then maintain the value of "header rows to be ignored" as "1" in your infopackage. Othewise if you are not maintaining the header row in csv, the value of this field "header rows to be ignored" should be 0.

This info above is valid assuming that in your csv file, the very first row (row 1) contains the header, and from row 2 onwards, you have maintained the actual data. Do not leave any blank rows on the top in CSV file as SAP doesn't have a way to identify the row from which you maintained the data in your file.

For your history, change the data type to "QUAN" else you can't use the data for any calculations. Maintain the Unit field for history as the same what you use for the field of UNIT. e.g. if you have used 0UNIT as the SAP field for unit (related to your last column in csv), and your field name for history is 9AVHISTORY (related to your second last column in csv), then unit for 9AVHISTORY should be 0UNIT.

Answers (1)

Answers (1)

m_manimaran
Active Contributor
0 Kudos

Hi,

Please check the sequence you defined in the data source is same as that of your CSV file. Before loading your data, you can preview the load in the data source. Then load the data correctly and try.

Regards,

Manimaran M.