|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Working with Infosets, User Groups, Query in detail
By Suraj Kumar Pabbathi, YASH Technologies
In this document we
shall cover Topic#2. For topic#1, click here.
Ø InfoSets are special views of data sources.
Ø An InfoSet describes which fields of a data source can be reported on in queries.
Ø InfoSets are assigned to user groups.
Ø End-users are able to work only with those InfoSets that are relevant to their particular area, as designated by the role or user group that they are assigned to.
Eg: Vendor master data can be important in purchasing as well as
in accountancy. The relevant InfoSet is assigned to both roles/user groups. This
means that queries based on this InfoSet can be copied and executed by both
Infosets – Prerequisites
The following questions help in meeting the prerequisites of creating an infoset.
Ø Which data source corresponds to the requirements?
For example: Material reports in Materials Management
Document reports in Financial Accounting
Ø Which fields do you need to include in the InfoSet?
Ø Do you need additional information which is not available in the data source? (This means you are going to have to connect additional tables and the definitions of additional fields.)
Ø Do you need parameters and selection criteria? (Parameters and selection criteria appear on the selection screens of queries that are created using the InfoSet).
Ø Do you need to include any particular measures such as access protection?
Do you need to be able to change the long texts and headers for
the selected fields?
Assign Data sources
Ø Table join using a table: Is used when Query is prepared for retrieving data from more than one database tables having relationships.
Ø Reading tables directly: Is used when Query is prepared for retrieving data from one table.
Ø Logical databases: Is used when Query is prepared for retrieving data based on a Logical database (LDB)
Ø Sequential datasets
Ø No Automatic Text Recognition
Fixed Point Arithmetic
Ø The InfoSet display allows you to examine or change the structure of the InfoSet.
Ø Assigning additional tables
Ø Creating additional fields
Ø Creating additional Structures
Ø Further Code
Application Specific Enhancements
Definition of field
Ø A field group combines related fields together into a meaningful unit.
Ø Fields must be assigned to a field group before they can be used in queries.
Ø Include all table fields
Ø Include key fields
Create empty field groups
Logical Database having more than
4 structures has different way of creating field groups.Eg: PNP
Ø The User Groups component is used to maintain user groups. The system administrator uses it to set up the work environment for end-users.
Ø Every user assigned to the user group is able to execute the query.
Ø Users are not allowed to modify queries from other user groups, although they may, under certain circumstances, copy and execute
1.Creating infosets or functional areas
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards