Field "Reference 1" in Upload Customer Open Items App.

[Grzegorz_S]

Hi Experts!
I need your help with application Upload Customer Open Items - F4051.
System is SAP Public Cloud.

For Polish Standard Audit File purposes, SAP provided standard field "Reference 1", with technical ID "Reference1InDocumentHeader", where we can store important data for every invoice.

Because We have to maintain large number of FI invoices, We also need this field to be properly populated from excel template.
However Reference 1 is not available in that app, as  template cannot be extended by such technical ID.
Is there a way get this field somehow maintained in this scenario?

Thank you in advance!
Grzegorz

[Chuma]

Hello @Grzegorz_S 

Thank you for reaching out.

Your options and the limitations are correct.

The F4051 (Upload Customer Open Items) template only supports the delivered columns plus custom fields you create via Custom Fields and Logic; SAP’s standard “Reference 1” (XREF1_HD / Reference1InDocumentHeader) is not exposed for upload in that template. SAP Help Portal-Upload Customer Open Items

If you need to populate Reference 1 in bulk, the supported paths are:

Upload General Journal Entries (F2548) and map XREF1/XREF2/XREF3; if they don’t post, set them to Optional in SSCUI 102013 – Define Field Status Variants. SAP Support Portal-3578086 - When uploading Journal Entries through the app, the Upload General Jour...

Post through the API (Journal Entry Post; change via Journal Entry Change) and include the header reference in the payload.SAP Help-APIs for General Ledger Accounting-Post Invoices with Payment Terms

Let me know if you need further information

With kind regards

Chuma