Table for Content of Codelist - Custom Field

[former_member599308]

Hi Everyone,

How can we reach contents of code list for a custom field? Is there any generated cds view or business object etc?

Thank you

Kind Regards,

Resul

[MartyMcCormick · Accepted solution]

Hello

I dont think you can reach the custom code list values from outside of the custom field context. However, I think that you could create a Custom Business Object and then when you create your custom field use option "Association to Business Object"? The CBO would have an underlying CDS view which could then be exposed as external API to an outside system. Let us know if this option would work for you.

Thanks,

Marty

[former_member599308 · Accepted solution]

Hi marty.mccormick ,

Thank you for information.

- Firstly I created a Custom Business Object Table.

- Then I created my custom field with "Association with Business Object" Type option.

Then now I directly reach Custom Business Object CDS view.

But, can we infer from that, all custom fields need to reference with a CBO in order to be reached the data by BW system?

As I understood from system that, if we create our custom field with "Code List" option, there is no specific CDS view of contents of custom field or reachable object(data source) for BW.

Then BW side, can not reach these contents anymore.

I don't know if there is any other solution.

Thank you

Resul

[ShyamSunderJKR]

For every custom field ( Code list ) added via custom fields app, a value table is created in the backend. The code and texts are stored in the value table. You can find the value table inside the domain.

Thanks,

Shyam

[Amith_Nair]

Hi Resul,

Not sure if I get your question completely, but once a custom field is enabled for a specific Business context, they can be consumed in the respective CDS view( Datasource) or ODATA or SOAP API's depending on the process and you could consume this field as a Query to expose this field outside of S4HANA Cloud to any system that accepts Webservices. So yes, the custom field can be consumed in your BW system for sure.

https://blogs.sap.com/2017/07/03/add-custom-fields-to-sap-s4hana-business-partner-odata-api-entities...

Thank you!

Amith Nair

[former_member599308]

Hi Everyone

Any answer?

We can use query for it but then my question will be "Is BW side able to reach this query?"

Thank you

Kind Regards,

Resul