Skip to Content
Product Information
Author's profile photo Eugene You

Import Sales Orders – Part3: Text fields and pricing elements support

Hi Guys, I am glad to tell you a wonderful news that our Import Sales Orders app is able to support text fields and pricing elements now. In this blog, I will briefly introduce how to use them.

If you are not familiar with this app, please refer to this Blog.

Text Fields

In the excel template, the ‘Field List’ sheet lists all available fields. You can find the field names for text as well.

Data for Import Field Name Field Description
Header Text HEADER_TEXT.<TEXTID>.LONGTEXT Header text.  Logon language will be used by default.
HEADER_TEXT.<TEXTID>.LONGTEXT.<LANG> Language-specific header text
Item Text ITEM_TEXT.<TEXTID>.LONGTEXT Item text. Logon language will be used by default.
ITEM_TEXT.<TEXTID>.LONGTEXT.<LANG> Language-specific item text

Generally, you can upload different texts based on text type (text ID). Language-specific texts are also supported. Here,

  • <TEXTID> represents Text ID
  • <LANG> represents language

When adding these fields to the order data sheet, please remember to replace the <TEXTID> and <LANG> with text ID and language ID defined in your system. For example, if system language is English, and you want to upload ‘Shipping instructions’ in English and German, the column name could be:

HEADER_TEXT.0012.LONGTEXT and HEADER_TEXT.0012.LONGTEXT_DE

Quick tips: To query a text ID as Cloud customers, please open ‘Process Sales Orders’ app, open the value help for text type on the ‘Texts’ tab, and you can find available text names and text IDs. For Op customers, please open the ‘Create Sales Orders – VA01’ app. You can find text IDs and language keys as indicated below.

 

Pricing Elements

To import pricing element data, we provide four fields in the template. The import may change an existing pricing element (for which a condition record already exists) or add a new one (for which no condition record exists, but with condition type already defined in the related pricing procedure) when the sales order is created.

Data for Import Field Name Field Description
Header pricing element HEADER_PRICE.<CONDTYPE>.CONDITIONRATEVALUE Condition Amount or Ratio
HEADER_PRICE.<CONDTYPE>.CONDITIONCURRENCY Currency
HEADER_PRICE.<CONDTYPE>.CONDITIONQUANTITY Pricing Unit
HEADER_PRICE.<CONDTYPE>.CONDITIONQUANTITYUNIT Unit of Measure
Item pricing element ITEM_PRICE.<CONDTYPE>.CONDITIONRATEVALUE Condition Amount or Ratio
ITEM_PRICE.<CONDTYPE>.CONDITIONCURRENCY Currency
ITEM_PRICE.<CONDTYPE>.CONDITIONQUANTITY Pricing Unit
ITEM_PRICE.<CONDTYPE>.CONDITIONQUANTITYUNIT Unit of Measure

Here, <CONDTYPE> is used to distinguish condition types. Please be aware that not all four fields are not required for each condition type. Here are some examples.

Example 1:

Condition type SKTO (cash discount) is used for percentage-based price calculation. You only need to specify the ‘Condition Amount or Ratio’ field. Meanwhile, the app supports value with % or without %.

Example 2:

Condition type PR00 is used for amount-based price calculation. You can choose to fill in all four fields or only specify the ‘Condition Amount or Ratio’ field. If you only specify the ‘Condition Amount or Ratio’ field, the system will default the other three fields as follows:

  • If no condition record has been maintained (indicating that you’re adding a new pricing element), the system will default the currency to transaction currency of the sales order, pricing unit to 1, and unit of measure to the sales unit of the product.
  • If a condition record has been maintained (indicating that you’re changing an existing pricing element), the system will default the three fields to the values already maintained in the condition record.

If you add pricing element columns to the ‘Order Data’ sheet but leave all fields empty, the system will not transfer empty values to the sales order.

Quick Tips: If want to import a couple of condition types at one time, you can add more columns in the data sheet and replace <CONDTYPE>.

Related Information

Hope this blog can bring you something new. If you have any questions or ideas, feel free to contact us.

What’s new in SAP S/4 HANA Cloud 2108 for Import Sales Orders App

Introduction for Import Sales Orders

Blog – Import Sales Orders (Part 1): Beginner’s Guide

Blog – Import Sales Orders (Part 2): More fields are supported in app

Blog – Import Sales Orders (Part 4): Custom fields support

 

Assigned tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.