How to extend fields for PO Mass upload template ?

[Li_Grace]

Hi Experts,

We are using RPA  to mass upload PO to Public Cloud system.

We want to add some fields in the template, for example storage location.

What can we do? Please give your advice.

Gloria

[Chuma]

Hello @Li_Grace 

In SAP S/4HANA Cloud Public Edition, if you’re using the Migrate Your Data app or an RPA bot to upload Purchase Orders in bulk, adding new fields like Storage Location to the Excel template isn’t straightforward. You can only use the fields that SAP has already made available in the template.

Follow the steps below,

Check if the Field is Supported

• First, verify whether Storage Location (LGORT) is part of the standard migration template for Purchase Order Items.
• Use the app, Migrate Your Data – Migration Cockpit
• In the template, open the sheet Field List → search under PurchaseOrderItem to see if Storage Location is available.

 If it's listed there,
You can add it to the Excel sheet (PurchaseOrderItem tab) and fill it in — the system will process it during upload.

 If it's not listed,
The field is not supported in the standard migration object and cannot be added manually to the template. You’ll need a workaround (see below).

 Workaround Options

1st option, Post-Processing Update via API or Mass Change App

• Upload POs with available fields
• Use Mass Changes to Purchase Orders app or API_PURCHASEORDER_PROCESS_SRV to update the storage location afterwards.

2nd option, BTP RPA/Script Extension

If you're using SAP RPA

• Extend your bot to update the storage location after creation using the Change Purchase Order app or API.

SAP officially recommends using

• Mass Changes to Purchase Orders” Fiori app or
• API_PURCHASEORDER_PROCESS_SRV
  ...to update or maintain fields like Storage Location if they’re not part of the initial upload.

 SAP References:

• SAP Help: Migrate Your Data - Migration Cockpit and Mass Changes to Purchase Orders
• Check also the migration object documentation in the Fiori app for the list of supported fields.

Hope it helps!

With kind regards

Chuma