Skip to Content
0
Jan 10, 2023 at 07:58 PM

SAC Parameter Issue within CDS View

350 Views

Hello Experts,

I have been encountering a couple of issues when working with parameters in CDS views and am hoping that someone will be able to point out from where the issue is stemming. Any help would be much appreciated!

In this example, I am using a data source that has the parameter "Clearing Date" and additional filters for paring down excess data.

image.png

This parameter (below) is a mandatory/default field for this view.

image.png

The filters (below) are to narrow down the selection to the correct ledger and document type.

image.png

Publishing it into production produced YY1_BI_SupplierJournalItem and YY1_BI_SupplierJournalItemResults. Using YY1_Results shows me the elements in the CDS view and the parameter is shown in YY1_BI_SupplierJournalItem.

image.png and image.png

So, my understanding is that the parameter is constraining the data flow and must be defined in the filters section. Essentially, if Clearing Status "X", then produce output "Y", and if Clearing Status "Blank", then produce output "Z".

However, when I try to add the clearing status from the Parameter sub-section section I receive:

image.png

When I try filtering on the clearing status from YY1_Results I receive:

image.png

In fact, it appears there is no data in the "YY1_Results" table despite the test system showing otherwise.

I have also received the error:

{"error":{"code":"CX_SADL_PARAMETER_MISSING","message":{"lang":"en","value":"Parameter 'P_CLEARINGSTATUSSELECTION' of entity 'YY1_BI_SUPPLIERJOURNALITEM' not provided"}

This prompted me to look at 2600276 - Exposing a CDS view with parameters as OData error code LCX_MISSING_PARAMETER (sap.com). However, after constructing the custom link and being prompted to enter my username/password I get the following error message:

image.png

Essentially, I cannot escape the error codes. I feel like I might be missing something simple, but there has been more than one set of eyes on this, and we haven't come up with a suitable solution. Some expert guidance would be much appreciated!

Attachments

image.png (65.5 kB)
image.png (57.8 kB)
image.png (28.3 kB)
image.png (59.4 kB)
image.png (45.4 kB)
image.png (10.6 kB)
image.png (9.7 kB)
image.png (68.5 kB)