None:
We will use the none value set to maintain
some format conditions like maximum size minimum value, maximum value, only
numbers and characters and so on…………
Navigation: System Administrator
Application 
Validation
Set
We
will enter the value set name and we will select the validation type as None.
We will mentions format type either character or number or date and time. Once
we create the value set we will attach to the multiple parameters in multiple
programs. Once we attached value set to the concurrent program we can not
delete. If we want to delete we need to release the value set from concurrent
programs.
Independent: Before going to create independent value set we
should have the list of values, which we are going to show in SRS window.
Navigation: System Administrator
Application
Validation
Set
Here we will create the independent value set
with validation type as independent. We will go to values screen select the
value set find button and we will enter the values. Once we attached the value
we cannot delete instead of that we will disable by Un checking enabled check
box.
Dependent : Before going to create dependent value set we
should create independent value set then later we will create dependent value
set.
First parameter will be independent value set.
Second parameter will be
dependent value set.
When ever user select first parameter based on that value second parameter will be going to show the values. The navigation steps are given below. First we will create the independent value set next dependent from following navigation.
Navigation:
System Administrator
Application
Validation
Set
We
will enter the values for independent while creating dependent we will select
edit information button and we will give the independent value set name We will
take the dependent value set we will enter the values in value screen by
selecting independent values. For all independent value set we will enter the
list of values.
Table :- By using table value set we can get the
list of values from the database table. Navigation to create table value set as
follows
Navigation:
System Administrator
Application
Validation
Set
If we will give the value set name and select
validation type as table and click the edit information button give the table
name in the table name field and mention the column name in the value field.
Meaning field: - If we want to display
the extra column like description we will mention the column name inside of
this meaning field.
ID field: - If we want to display one column and pass another column as a parameter
internally we will use this ID column.
Where or Order by: - In this text box we can write all the valid where clauses and order
by clauses.
Additional Columns: - In this field we can give the column names,
which we wanted to display additionally for reference purpose. We need to give
the alias name for every column.
Table application :- Here
we mention the name of the application where table has been registered. We will
take the table name then select application developer responsibility.
Navigation:
Application Developer
Application
Database
Table (press F1)
Give the table name to query the
data.
Allow Parent Values :- If
we check this checkbox it will accept both parent and chaild values as LOV.
Implementing Dependency in Table Value set:-
Using the :$FLEX$ we will be receiving the previous parameter value set
value.
Syntax:- :$FLEX$. previous
parameter value set
We will create first table value set by using following select query.
Select vendor_id from po_vendors;
We will create one more table value set which is going to depend on the
previous parameter value.
Select vendor_site_id from po_vendor_site_all where
vendor_id = :$FLEX$.previous parameter value set
Displaying the Input Parameters :-
We can display the user parameter values in
the output by using any one of the following way.
1. Select the field and change the source
property as bind variable.
2. Select the boilerplate text given the
variable name including ‘&’ operator.
Translated Independent &
Translated Dependent :-
These 2 value sets will be created like Independent
and Dependent value sets. It will be show in the Translation values
as LOV to the end user. While entering the values we will have a column called
translated value here we can find out the translation language.
Special & Pair :- These 2 value sets will be used to display
flex field data as LOV to the end user.
We will select the Value Set Screen and select Edit
Information button and enter the Key Flex Field code appl_short_name =””, Structure Number whether it is a Mandatory or
Optional and Segment Values and Description and etc…..
No comments:
Post a Comment