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

Import Sales Orders – Part4: Custom fields support

Hi Guys, I am glad to tell you another wonderful news that our Import Sales Orders app supports custom fields now. In this blog, I will briefly introduce how to achieve it

Background

Usually, the standard fields of sales order (VBAK, VBAP) provided by SAP may not be sufficient to our customer. Currently, customer can use Custom Fields app to create new custom fields and enable the usage of corresponding apps.

Creating Custom Field

1. Open the “Custom Fields” app (business role SAP_BR_ANALYTICS_SPECIALIST is needed to your user).

2. When creating custom fields, choose one of the following business contexts:

  • Sales: Sales Document
  • Sales: Sales Document Item

3. In the UIs and Reports area, enable usage for the following to use this field in the Import Sales Orders app:

SD_SALES_ORDER_IMPORT (Import Sales Orders)

Tips: If you also want to use this field in the Create Sales Orders – VA01, Change Sales Orders – VA02, and Display Sales Orders – VA03 apps, please enable usage for the following:

  • Create, Change, or Display Sales Documents (Header)
  • Create, Change, or Display Sales Documents (Item)

Usage of Custom Field

After the custom fields have been enabled for usage in the Import Sales Orders app, they will be automatically added to the ‘Field List’ sheet after you download the template.

Briefly, open Import Sales Orders app, click the ‘Download Template’ button on the top-right. After that, there will be a template excel downloaded to your local system.

In the template excel, you can find your custom fields in ‘Field List’ Sheet. This means this custom field is available now.

If you want to upload this field, you have to add a new column in the ‘Order Data’ sheet. The column technical name should be same as field name in ‘Field List’ sheet ( Better to copy and paste). Then you can enter order data for an import.

Tips: The technical field name is not case sensitive. Lower case is also acceptable.

 

Related Information

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

Blogs Series for Import Sales Orders

 

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Frank Xie
      Frank Xie

      Wonderful, the custom fields is vary useful for us.

      Author's profile photo Qun Gu
      Qun Gu

      Thank you, if we had more than 1 custom field, how to do with this?

      Author's profile photo Frank Xie
      Frank Xie

      Hi Qun, it will be very similar to one custom fields.  All custom fields activated will appear in your template, then you can use it like a normal  field in your second sheet in the template excel.

      Author's profile photo Qun Gu
      Qun Gu

      Thank you for your answer, I'm new to SAP, I don't know how to define a custom field and the meaning of activation, the template limited the field such as length etc. how can I find the header ocde on the left for the existed header content.

      Author's profile photo Gregory Neff
      Gregory Neff

      Great Blog - Thank you!

      Is it also possible to upload sales orders with a reference (e.g. towards a contract) with this app?

      Thanks!

      Author's profile photo Miles Xu
      Miles Xu

      Hello Gregory,

      We've also received requirement on supporting create with reference, we're planning it on our internal roadmap.

      If you are also a S/4HANA customer you could vote on the following customer influence request to help us prioritize the requirement.

      https://influence.sap.com/sap/ino/#/idea/279030/?section=sectionDetails

      Thanks & Best regards,

      Miles