Issue :select query in custom fields and Logic

[vsbharath]

Hi All ,

I am facing an issue while writing a select query against the table or view in custom fields and logic app . I have custom field in the PO and while creating PO this custom filed should be auto populated in the app . For which i written a select query in the Custom logic to fetch the field from the quotation .

Then getting the below error " Use of table is not permitted " .

Thanks in advance .

[Jerry_Lowery · Accepted solution]

Hi Bharath,

The ABAP used for BAdIs, etc. in S/4 HANA Cloud is a restricted version.

I suspect the error you are getting is because you are trying to direct table access within restricted ABAP and this is not allowed.

The best practice would be to use a CDS View. Your options are to locate the standard CDS View for the object, or create a custom CDS View containing the data you need.

Blog about Restricted ABAP

Please see this help article about working with Custom Logic and available statements, use cases, etc.

Custom Logic - S/4HANA Cloud Help

Please let us know if this answers your question. If you could provide some more specific details, someone on here could probably help further.

Thank you

Jerry