Smart Fields on Group Section Reports
Introduction to Smart Fields
A Smart Field is a data dictionary item that has a Business
Function attached. The Business Function includes a Named Mapping that maps the
source for each parameter of the Business Function data structure. Smart Fields
can be used for deriving column headings or to populate a value using a
calculation.
Few easy steps explaining the design of Smart Field.
- Create Data Dictionary Item (Glossary Group K)
- Create Data Structure
- Define Named Mapping
- Create Business Function or NER
- Add Named Mapping to Data Dictionary Item.
- Smart Field Template (P91420)
- Report Director Template (P91400)
- Update Report View Options, Smart Field Selection.
Create Data Dictionary Item (Glossary Group K)
Create a data
dictionary item. Define the data item as glossary group ‘K’. The data item will
serve as a data dictionary column in report to hold the return value
(calculated value) from the business function.
*You can use any existing data item with glossary group K
not necessarily needed to create new data item.
Create Data
Structure
A data structure is a list of parameters used to pass values
between your report and the database tables. It contains all data items
required to complete the function of the Smart Field.
Define Named
Mapping
The Named Mapping is a part of the data structure and is used only for
Smart Fields. The Named Mapping defines the source for each parameter (or data
item) of the Data Structure. For example, source values are determined for the
prompts, tables, processing options and return values. Examples of the
different sources for Named Mapping are:
- Literal: A literal is used to assign a specific value to the data item
- Prompt: Specify the data item to be used as the prompt
- Table: Specify the data items that originate from a table.
- Data Dictionary Item: Select this option if you will need to pass values from a processing option into your data structure.
- System Value: You would select this option of you wanted today's date (system date) etc. System values are stored in the F98VAR table.
On Data structure design tool another option for Named
Mapping.
Click on Add Button and enter the name to Named Mapping.
Create Business
Function or NER
Create C Business function or NER object from Business
Function Design Aid. Add data structure to business function
Write business logic and required code to business function
Build Business Function or NER.
Open application Work with Data Items (P92001), Open DD item
created in step 1.
On form exit select Smart Field
Provide the business function name and event where it needs
to be called and the Name Mapping
Smart Field
Template (P91420)
On JD Edwards Solution Explorer, under Advance Report Setup
select Smart Field Templates
Or go to application P91420
On Work with Smart Fields. Click on ADD button
Name Smart Field Template and provide description. Select
the data item in grid
Report Director
Template (P91400)
On JD Edwards Solution Explorer, under Advance Report Setup
select Report Director Templates
Or go to application P91400
On Work with Report Director Templates. Click on ADD button
On Report
Director Templates Revisions
Enter
Section Type as ‘44’ for group section
Enter
Business view on which Smart Field is required to be called
Enter
Processing Option Values
Enter the
Smart Field Template Name that you want to attach to report director.
On grid,
define the sequencing required for the section
Update Report View
Option and Smart Field Selection
On Report Design Aid, Go to View tab then User Option
Click on check box Allow Smart Field Template Selection
Create a group section with provided business view. Double
click on section or go to section properties. On Smart Field Template drop down
list select the report director template.
On Insert tab. You can see Smart Field is enable. You can
select the field and drop down anywhere in section.
No comments:
Post a Comment