Symptom
Your requirement is to extract the Remarks/Comments/Notes Fields from the Communication Data for Business Partners. Upon executing the OData query, the AddressCommunicationRemarkText appears empty.
<d:AddressCommunicationRemarkText></d:AddressCommunicationRemarkText>
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Execute the below OData query in the Google Chrome browser
- https://myxxxxxx-api.s4hana.cloud.sap/sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress(BusinessPartner='XYZ',AddressID='yyyyy')/to_EmailAddress
- https://myxxxxxx-api.s4hana.cloud.sap/sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress(BusinessPartner='XYZ',AddressID='yyyyy')/to_PhoneNumber
- https://myxxxxxx-api.s4hana.cloud.sap/sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress(BusinessPartner='XYZ',AddressID='yyyyy')/to_MobilePhoneNumber
- https://myxxxxxx-api.s4hana.cloud.sap/sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress(BusinessPartner='XYZ',AddressID='yyyyy')/to_FaxNumber
- In the Response Payload, the Remarks/Comments/Notes appears blank
<d:AddressCommunicationRemarkText></d:AddressCommunicationRemarkText>
where xxxxxx represents the tenant URL of the S/4HANA cloud system
XYZ represents the Business Partner ID
yyyyy represents the Address ID of the Business Partner
Cause
In the Business Partners, in the Communication data, the fields like Remarks/Comments/Notes is language dependent and there is no automatic translation for this field. So this field is blank when you log on to the system with another language.
When calling an API, you did not pass the language with which the communication user logged in to the system. Hence <d:AddressCommunicationRemarkText> remains blank.
Resolution
When calling an API, pass the language with which the communication user logged in to the system. To do so you should add the language parameter to the URL (e.g. adding '?sap-language=IT').
The language of the communication user is then set to the corresponding language and the <d:AddressCommunicationRemarkText> is displayed.
Keywords
AddressCommunicationRemarkText, Remarks, Notes, Comments, API, API_BUSINESS_PARTNER, OData, GET call, Maintain Business Partner, Business Partner, Email, Fax, E-Mail, Phone Number, Telephone, Mobile, Cell Phone Number, Phone , KBA , LO-MD-BP-ODT , OData Service for Business Partner , Problem