Skip to Content
avatar image
Former Member

CDS View Modification

Hello Experts,

We have a requirement to filter/restrict the Sales Order/Quotation based on user default plant.

In the standard CDS view C_SALESORDERWL_F1873 we do not have the option to filter based on plant.

So how can we achieve this in CDS view extension to restrict the result set based on user plant. This user plant will be enhanced at FIORI app side and passed from Manage Sales Order and Sales Quotation app.

I'm new to CDS, please let me know your inputs.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 23, 2017 at 06:02 AM

    Hello Rahul ,

    Just giving a wild thought

    For the consumption view C_SALESORDERWL_F1873 is there any DCL ( data control language ) associated ( please check for annotation for authorization in C_SALESORDERWL_F1873 ) if yes....please navigate to the DCL and check the authorization object used in DCL and check if the data can be controlled via authorization object .

    please check the below link for details

    Blog Link

    Hope this helps ,

    Anup D

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 23, 2017 at 07:27 AM

    I think you're trying to say passed to, not from, right?

    "This user plant will be enhanced at FIORI app side and passed from Manage Sales Order and Sales Quotation app."

    If YES, then did you want to get the filtered list from the UI?

    IF NO, then did you want to the filtered list from the CDS?

    I don't think you could reach this by standard CDS extension(maybe, I didn't get the extension point you meant ), how about create your own CDS view if you just want to filter the value?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I agree with what you have said and understood. I am able to add fields via extension but as you said we can't filter it out there as it would require inner logic to work.

      Then we are left with building own CDS view as said.

      Thanks for your support..much appreciated.