SAP Knowledge Base Article - Public

3326862 - Mass Phone Number Update for Supplier

Symptom

Mass updating of supplier phone numbers is not possible, as the migration tool does not display the Address section in enhance mode, and the Telephone Number field is not available in the Mass Data Maintenance template.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Mass Data Maintenance work center
  2. Select Import Suppliers Link
  3. Update Suppliers - Script Changes
  4. There is no phone number column in the Addresses or Contacts tab.

Cause

Currently, it is not possible to mass update telephone numbers for suppliers using the Mass Data Maintenance work center.

Resolution

Telephone numbers for suppliers can be updated using the 'ManageSupplierIn' web service.

https://api.sap.com/api/PSM_ISI_R_II_MANAGE_SUPPLIER_IN/overview

This service allows for the submission of telephone numbers.

For detailed information about APIs, please refer to the following link:

https://blogs.sap.com/2019/09/26/sap-business-bydesign-an-api-overview/

Examples for mass changes can be found here:

https://blogs.sap.com/2015/05/15/mass-changes-of-byd-data-using-excel-and-byd-web-services/

A sample to update the telephone number of a supplier can be constructed as follows:

<n0:SupplierBundleMaintainRequest_sync_V1 xmlns:n0="http://sap.com/xi/SAPGlobal20/Global">

<BasicMessageHeader>
</BasicMessageHeader>
<Supplier actionCode="04">
<InternalID></InternalID>
<AddressInformation actionCode="04" >
<UUID></UUID>
<Address actionCode="04">
<PhoneFormattedNumberDescription>*</PhoneFormattedNumberDescription>
</Address>
</AddressInformation>
</Supplier>
</n0:SupplierBundleMaintainRequest_sync_V1>

InternalID: This is the ID of the supplier.

UUID at addressInformation: This information can be obtained by executing a query service beforehand.

The QuerySupplier service can be used to retrieve this information.

https://api.sap.com/api/PSM_ISI_R_II_QUERY_SUPPLIER_IN/overview

<n0:SupplierByElementsQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global">
<SupplierSelectionByElements>
<SelectionByInternalID>
<InclusionExclusionCode>I</InclusionExclusionCode>
<IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
<LowerBoundaryIdentifier></LowerBoundaryIdentifier>
</SelectionByInternalID>
</SupplierSelectionByElements>
<ProcessingConditions>
<QueryHitsUnlimitedIndicator>true</QueryHitsUnlimitedIndicator>
</ProcessingConditions>

<RequestedElements supplierTransmissionRequestCode="2">
<Supplier addressInformationTransmissionRequestCode="1"/>
</RequestedElements>
</n0:SupplierByElementsQuery_sync>

The <RequestedElements> tag can be used to limit the response to the desired data."

<RequestedElements supplierTransmissionRequestCode="2">

<Supplier addressInformationTransmissionRequestCode="1"/>
</RequestedElements>

Once this information is retrieved, the web service call can be created to update the telephone numbers.

Keywords

Supplier, Mass Upload, Migration, Telephone, Mobile, Enhance, Phone , KBA , SRD-MD-BP-SUP , Suppliers , Problem

Product

SAP Business ByDesign all versions