Update UDF Value Via Service Layer Integration

[patchnc]

I am currently doing an integration between SAP B1 and another service. Our client as created a custom field within the RDR12 table that I need to write too but can't see how to send the data to it in a JSON payload. The RDR12 uses the TaxExtension but the custom field is not accessible that way. Any ideas on what it will be accessible under?

[ANKIT_CHAUHAN]

Hi patchnc,

According to SAP Note 2872353:

The UDFs added to Business Partners – Addresses table CRD1 would be added automatically to the marketing document address table DOC12 and to the service call address table SCL7 by the application.

This is why you are having the UDFs in DOC12 (RDR12 table).

According to SAP Note 2890447:

Adding UDFs in DOC12 table should still not be possible via DI API. Therefore, you are not able to operate on the UDFs in RDR12 table because those are not exposed.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[ANKIT_CHAUHAN]

Hi patchnc,

Even though DI API allows to create UDF on all tables, it is not recommended to create UDF on tables which are not exposed in UDF management window.

It is not possible to operate on these UDF with DI API, Service Layer, B1 Studio or UI API.This is a limitation.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[patchnc]

Any thoughts on this ankit.chauhan1 ?

[patchnc]

Apologies ankit.chauhan1, I attached it incorrectly. Image from my client below

[patchnc]

Thanks Ankit, Please see the below message from my client with regards to this:

'I have tested and confirmed that I can insert data using the COM API on that field,

I think they may be looking in the wrong place because this table is exposed to the UDF window, perhaps send them the below:

Also worth noting – I am not using the TaxExtension endpoint to do this, SAP have an ‘AddressExtension()’ on the COM API that exposes UDFs, perhaps the service layer is the same?'

Can you please confirm if the Service Layer can access this UDF and if there is something similar to the COM API AddressExtension within the Service Layer?

[ANKIT_CHAUHAN]

Hi patchnc,

Unfortunately, the image in your last reply, cannot be displayed.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support