Product Information
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
Wonderful, the custom fields is vary useful for us.
Thank you, if we had more than 1 custom field, how to do with this?
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.
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.
Great Blog - Thank you!
Is it also possible to upload sales orders with a reference (e.g. towards a contract) with this app?
Thanks!
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
Hi Miles,
Can we customize and enable this app to load Credit Memo Request and Debit Memo request ?
Thanks,
Kishor
Hi Miles,
can we enable upload of Credit Memo Request using this app ?
thanks,
kishor