Skip to Content
Product Information
Author's profile photo Siwen Hu

Upload Prices in Sales from template-based spreadsheet

As pricing specialist, you always get excel file which list prices for products with different or same validity period. In past way, you need to manually input the product in system and update the price one by one. But now, on Manage Prices – Sales App, you can import excel file directly and update all prices for all products within one click.

Function List

Upload prices via excel has below functions:

  • Import
  • Export
  • Download Template
  • View Import History

functionlist.png

Import condition records: Click Import button, you can create or update condition records by importing a template-based spreadsheet.

Export condition records: Click Export button, you can export all displayed condition as spreadsheet according to the template.

Download Template: Click Download Template, you can get the template spreadsheet according to the input Condition Type and Key Combination. Note: You can download template without input filter, but it is really not suggested to do this.

View Import History: Click View Import History, you can view details of your imports. And track the status and correct import errors or view imported data by downloading them to a spreadsheet.

Below import status for import action:

  • In Progress
  • Success
  • Partial Success
  • Failed
  • System Error

Note: For system error status, you can click the hints to check the message and follow the guidance.

Sync and Async Upload

Manage Prices – Sales App will automatically trigger the import mode by sync or async. If the excel file size large than 100KB, then async import will be trigged, otherwise sync import will be trigged.

For sync mode, you will get the import result directly with prompt up dialog box. For async mode, you can click View Import History button on the prompt up dialog box, and see all the import logs in the import history page.

How to Use Template

The better way to upload prices via spreadsheet is export existing condition records, after change or add new condition records, then import the updated spreadsheet. But sometimes, you need to create new condition records which is not existed in system. For this case, you need download the template and manually input value in each column.

Before download template, you need input condition type and key combination. So that the template will be downloaded with all fields for specific condition type. It is also support input multiple condition types and key combinations. Such as below, set Condition Type as ZPR0 and Key Combination as 305:

download template.png

After click Download Template button, the template will be downloaded for ZPR0 – 305. There are two sheets on template file:

  • Field List: List the field description and supported value
  • Condition Data: List condition key for all combination and data columns

Field List Sheet.png

conditiondatapage.png

Example for importing condition record without scale line

Based on above template, you can copy data to template from other excel, the Product and Customer column need input product ID and customer ID. Below example is for create two new condition records for condition type ZPR0 and key combination 305.

ConditionRecord.png

Note: You can delete the row 1 to row 6 which list the key combination.

Example for importing condition record with scale line

You also can create condition record with scale lines which if marked “Is Scale” as value “X”. Below is example for create condition record with quantity scale lines.

createwithscale.png

Notes:

  • The amount for first scale line should same as condition record amount
  • The scale lines in system will be always replaced by the scale lines in spreadsheet

Example for importing condition record with supplement

You can create condition record with supplement lines, below example create two supplement lines.

supplementline.png

Export Prices Data as Excel File

Normally, you use template to create new condition record. But for update existing condition records, it is better to download existed condition record as excel file. Before export the condition records, you’d better to set filter to find the necessary condition records.

Such as below, set Condition Type as ZPR0 and PPR0, set Key Combination as 305, set Customer as 10100001 and 10100003, set Product as TG11 and TG12. Click Go button, you will get all condition records, then click Export button, all the displayed condition records will be downloaded as new excel file.

filterconditionrecord.png

In the downloaded excel, you will found more than 7 lines existed in excel file, as the supplement and scale lines will be exported together in the excel file.

exportedresult.png

Notes: For Product and Customer fields, you can input multiple filter value, but suggest to input less than 100 ones.

Upload Prices with Sync Mode

Import condition records with excel file which size less than 100KB, then sync mode will be trigged. You will get the import result directly in few seconds. Below example showed import successful and import failed case.

Upload Prices Successfully

Import condition records can update existing condition records and create new conditions records together in one action. You also can create or update condition records for multiple condition types.

Below excel file list condition records for condition type ZPR0 and PPR0 which include create and update actions. Update the amount and condition validity for existing lines and create new lines with new condition validity.

syncImport.png

Click Import button on App homepage, select the file path and click Import button on the prompt dialog. You will get below message for success import.

Importdialog.png

successimport.png

Close the message and check all the condition records are imported successfully on App.

successresult.png

Click View Import History button, the import history page will be showed. You will see the import log for above excel file, after select the log line, the Download Imported Records button enabled.

importlogline.png

You can click above button, then the imported condition records will be downloaded as excel file.

Upload Prices Failed

In the condition records excel file, sometimes will contains invalid or incorrect data for corresponding column. Before importing the condition records to system, all the condition records will be checked by system. And the error message will be collected for each condition record line.

Below excel file list condition records for condition type ZPR0 and PPR0 which include create and update actions. Update or create the condition records with invalid validity or invalid amount or invalid product.

failedexcel.png

Import above excel file, you will get error message below.

faileddialog.png

Click the Download button, new excel file will be downloaded with error message and related condition record lines. According to the error message, you can update the excel file with a valid value, then import this file again and no need to update the original excel.

errormessagedetail.png

Click View Import History button, on the Import History page, you will see the import failed line with Failed status. In this page, you also can download the excel file with error message after click Download Failed Records button.

errorlog.png

Upload Prices with Async Mode

Upload Prices Partially Success

If the file size large than 100KB, the App will automatically change the import mode to async. In this mode, you will waiting some time to get the import result. Go to Import History page and do manual re-fresh to get the import status.

Below excel file include about 1045 condition record lines, contains create and update operation for condition records. And also include some lines with invalid date format or condition amount.

async excel.png

Import above excel, you will get below prompt up message, compare as sync import, you will not get the result immediately.

async dialog.png

Click Import History button, new Import History page will be opened, you will see the import line with result In Progress, in this status, you only can click Go button to refresh it.

async import log.png

After some seconds, you will get the import result with Partial Success:

partialsucess.png

For partial success status, click Download Failed Records button, you can download excel file which contains condition record lines with error message. Click Download Imported Records button, you can download excel file for imported condition record lines.

Click Back button, you will go back to App home page. On this page, you can input filter to list all changed condition records.

Notes: You can copy the Customer or Product in downloaded excel file and paste to App filter as equal condition.

Q&A

1.Could I upload prices with large excel file?

Answer: Yes, you can, but too large file will cause system dump. So suggest upload excel file less or equal than 3MB.

2.Could I download pricing condition records as large excel file?

Answer: Yes, you can, but suggest to download less than 30 thousand condition records lines per time as an excel file.

3.Could I download pricing condition records with description? Such as for Customer and Product?

Answer: No, you can’t. Currently, the description will not be downloaded for pricing condition records in excel file.

4.What should I do if upload prices with System Error status?

Answer: In async import mode, if the import job executed failed or other un-expected net-work issue or un-expected system dump, system error status will be showed. In this case, you can re-import or reduce the excel file less than 3MB per time.

Assigned Tags

      22 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Chien Ping Lee
      Chien Ping Lee

      非常詳細的介紹

      Author's profile photo Ankit Mehrotra
      Ankit Mehrotra

      Awesome !

      Author's profile photo SIRIGIRI KISHORE
      SIRIGIRI KISHORE

      Hi ,

       

      Any reason on why "View Import History" is not visible on my S/4 2020 Fiori application ?

       

      Thanks for sharing ..

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      "View Import History" enabled in S/4 2020 SP1 not in S/4 2020 SP0 version.

      Author's profile photo SIRIGIRI KISHORE
      SIRIGIRI KISHORE

      Thank you Siwen Hu, also we are unable to use import option , getting virus scan error , any suggestion on how to fix it .

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      Thanks for quick response.

      Please follow this KBA to solve the issue: https://launchpad.support.sap.com/#/notes/3010735.

      Author's profile photo SIRIGIRI KISHORE
      SIRIGIRI KISHORE

      Thank you Siwen Hu , i have checked earlier and followed the same still have same issue , looks like Virus scan adapter is missing in system , working with my basis team to fix it .

      following below note.

      https://launchpad.support.sap.com/#/notes/0003012803

      Author's profile photo Sheila Ivonne Garcia Andres
      Sheila Ivonne Garcia Andres

      Hi Guys,

      What's the transaction code to execute? or it's a fiori app?

       

      I hope can you help me please.

      Regards,

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      It's a new Fiori App for Pricing Specialist. You can check this blog for more details: https://blogs.sap.com/2019/08/16/how-to-use-manage-prices-sales-app-2/

      Regards

      Siwen

      Author's profile photo Yusuf Avci
      Yusuf Avci

      Hi,

      Thank you for this useful blog post. I have a trouble with import the prices with excel. When I try to update the prices from 20 to 12 TRY like below screenshot, the system says ''0 Condition records imported.''  and no error message. Where am I do wrong?

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      Hi, Yusuf

       

      Please create incident, we need do more investigation for your problem.

       

      Regards

      Siwen

      Author's profile photo Andre Hartono
      Andre Hartono

      Hi Siwen Hu,

      Thanks for your detail info about this feature in Fiori and S4 HANA, btw is this feature available in ECC 6.0 EHP6? what Function Module/ BAPI we can use for this upload selling price with dynamic condition table and scales? thanks.

       

      Best Regards,

      Andre

       

       

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      Hi, Andre

      This feature not available in ECC 6.0 EHP6, however you can try to use FM  "RV_CONDITION_COPY" to create conditions.

      Regards

      Siwen

      Author's profile photo Andre Hartono
      Andre Hartono

      Hi Siwen Hu,

       

      Thanks a lot for your prompt reply and suggestion, noted on the FM RV_CONDITION_COPY, I will check and  study on this FM..

       

      Best Regards,

      Andre Hartono

      Author's profile photo Former Member
      Former Member

      Dear Siwen Hu,

      Due the fact that you are an expert on the app Manager Price I kindly ask you an help.

      I created a condition type with an access sequence with a custom field (ZZNUMEROSAGOME)

       

      When I execute the app, unfortunately I do not see that custom field (ZZNUMEROSAGOME).

      I can't import/export the template.

      Do you have any idea how to fix this issue?

      Thank in advance for your help

      Best Regards

      Maria Rita

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      Hi, Maria

       

      Thanks for your comments. For your question could you please check another blog which also write by me: https://blogs.sap.com/2021/01/13/extensibility-for-manage-prices-sales/ 

      If you still have question, please feel free to contact me. Thanks.

      Regards

      Siwen

      Author's profile photo SAP S4 HANA project team
      SAP S4 HANA project team

      Hi Siwen

      Thanks for blog, i have doubt i have existing condition record for PR00 which is already created and we have changed the validity to date to 10.01.2023, now when we try to upload the new price with different validity from and to 11.01.2023 to 31.12.2023, system is not allowing us to do export and import for this. please help

      Author's profile photo Richard Meng
      Richard Meng

      Dear friends,

      I am Siwen's colleague. Is there any error message reported from system? In our experience, export is awalys allowed, and error message will be reported if import is not allowed.

      Best Regards,

      Richard

      Author's profile photo Jean-Charles Servouse
      Jean-Charles Servouse

      Hello,

      we are currently using the Fiori app F41111 (Manage Prices Sales) and we encountering an issue when we try to export conditions records (37918 records).

      There is a pop-up what prevents us from exporting records :

      "You can export a maximum of 1000 rows. Please narrow down your search."

      Do you know how to the solve the issue ?

       

      We have tried to follow this blog but it is not possible :

      How to reset the limit of rows in Fiori apps

       

      Best regards,

       

       

      Author's profile photo Siwen Hu
      Siwen Hu
      Blog Post Author

      Hi, Jean

       

      Which version are you using? This limitation is removed in latest version.

       

      Regards

      Siwen

       

      Author's profile photo Manish Tajane
      Manish Tajane

      Hi Siwen Hu,

       

      I want to upload file using key combination of sales org/DC/customer hierarchy 2, 3, 4, which is HIENR02, HIENR03, HIENR04, but in template it is not available please suggest.

       

       

      In template CustHier04 is not available same with the manage prices - sales screen

       

      Author's profile photo Sankar b
      Sankar b

      Hi Siwen Hu,

      Thanks for the above post. It did help me with the Scale maintenance. I have the below questions. Can you help advise please?

      A) Is it possible to hide certain condition type from displaying based on user Roles? ie; I need to hide PR00 to certain users having roles X but Role Y users must see the condition type.

      B) Is it possible to restrict certain access sequence for a condition type in appearing in the app selection parameters for certain users ? ie; Material access must be restricted to certain set of users having roles X but users with role y must see this.

      C) Is it possible to do a simulation before the actual upload?

       

      Thanks

      Sankar