Skip to Content
author's profile photo Former Member
Former Member

NOT able to load historical data from excel

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 18, 2011 at 11:25 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • Posted on Nov 18, 2011 at 07:33 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.