public cloud (update partner function for our customer)

[abdelrahman_khaimse5f2c1]

hello all ,

i have task on public cloud to create app to upload excel sheet of customer till bow there is now problem but i need your help on how i can update partner function for our customer so if anyone can help please provide me with it

[Chris1973]

Good day @abdelrahman_khaimse5f2c1 

Thank you for your question.

In Public Cloud, the better option when updating a customer partner function from an Excel upload is to use the released Business Partner A2X OData API, not direct table updates.

In simple terms:

• You can maintain customers through Business Partner master data.
• Customer partner functions are sales area dependent.
• The relevant API entity is A CustSalesPartnerFunc.
• Ensure you confirm whether the partner function exists, before either creating or updating it.

See KBA 2859009 for more details. Note that API_BUSINESS_PARTNER helps you create, update, and delete operations for Business Partner, customer, and Supplier data.

See the following reference for more insights

https://help.sap.com/docs/SAP_S4HANA_CLOUD/3c916ef10fc240c9afc594b346ffaf77/85043858ea0f9244e1000000...

Here are areas you should consider:

You can enable your API using communication scenario SAP_COM_0008 Business Partner, Customer and Supplier Integration in Communication Arrangements. Note that SAP_COM_0008 is the communication scenario for Business partner, Customer and Supplier Integration.

See the following reference for more insights

https://help.sap.com/docs/SAP_S4HANA_CLOUD/6ef7f849fed34f95adfc449f29835255/42d25fb7d75a484c8df17432...

From your Excel upload, you can prepare these values per row:

• Customer,
•  Sales Organisation,
•  Distribution Channel,
•  Division,
• Partner function,
• Partner customer, Supplier, Personnel number, or Contact Person

Before updating, call: API_BUSINESS_PARTNER/A CustSalesPartnerFunc?$filter=Customer eq customer

If the partner function does not exist, you can create it with POST to A CustSalesPartnerFunc.

If it already exists, ensure you update it with PATCH, PUT, or MERGE. Note that the Business Partner master data can be updated using these methods.

See the following reference for more insights

https://help.sap.com/docs/SAP_S4HANA_CLOUD/3c916ef10fc240c9afc594b346ffaf77/81c9afd408d24612a580ad0c...

For partner functions, pass only one partner reference field in the payload: BPCustomerNumber, Supplier, PersonnelNumber, or ContactPerson. See KBA 3274422 for more details.

Let me know if you have further questions.

Best regards

Chris