You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Value Set Customization

Question
11
Views
0
Comments

Summary:

We need a list of values for a Purchase Requisition DFF field. LOV will pick from items table so we will create a table based value set. However, we would like to filter the table SQL based on the Business Unit (BU) of the Requisition.

Please advise if any of the following options are feasible in general:

  1. Read the value of a field from the page where the DFF is shown.
  2. Read the user id(Login id) of the user who is working on the requisition. We can then use the query to fetch the User's BU.
  3. How we can select distinct values in value set query or use group by.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!