Import Supplier Invoices - Add fields

[KM11]

Hi

I have a requirement to add standard fields( Reference Key 1, 2 and 3) as well as few custom fields in Import Supplier Invoices. Kindly suggest a way to add these fields in the excel upload template of the application and use them for successful posting of invoice.

Thanks

Kanika

[Shakeel_Ahmed1]

Hi,

You can include these three reference fields by utilizing the 'Data Source Extension' feature through the 'Custom Fields' application. Please refer to the provided screenshots for a step-by-step guide.

Include the three reference fields in the Data Source, as depicted below

Save and publish your changes

After the changes have been published, please log off from the system and then log back in. You should now have the ability to include these three fields in the 'Display Line Items in General Ledger' application.

You can apply the same method to incorporate extra fields into different Data Sources.

sourced from SAP S/4HANA Cloud, public edition Finance | SAP Community

Regards

Shakeel

[KM11]

Hi Shakeel

I assume these are custom fields that you created, but I wanted standard fields to be used to store values for reference keys 1,2 and 3? Is there a way for that?

Thanks

Kanika

[Luis_Lara]

Hi, did you manage to find the way to add standard fields? I need to add the plant (werks) to this template.

[shaileshvb55]

Well explained Sir. I love your blogs

[Ernesto_Cepeda]

Hi Kanika,

Since Shakeel already provided the steps to add the custom fields let me show you how you can see the available standards fields in the template.

In order to see the fields you have to Unhide the fields as shown here:

The template now shows you all the standard fields available at the header level.

And then, I also recommend to add the technical labels that might help to identify the fields you need. You can do this by unhiding the labels in the rows as show here:

Now the template shows (in row 5) the technical labels.

I hope this helps you to find the standard fields you want to use. If not, please let the community know so we can try to continue helping.

Ernesto Cepeda

[KM11]

Hi ecepeda

Thanks for the steps, the fields are require are not part of the template, thus want them to be added in the template somehow.

Regards

kanika

[Shakeel_Ahmed1]

Hi Kanika,

Standard data source is used, please and explore.

Regards

Shakeel

[KM11]

Hi skl.ahmed

Unfortunately Data Source for Import Supplier Invoices is not available.

Let me know if we have other options?

Thanks

Kanika