ecc-universe design

[Former Member]

Friends

I have a query with regard to creation of universe on top of SAP ECC/ERP system using IDT tool..

I am able to fetch Infoset based infoquery and design universe...but need small clarification..as

what is ABAP Function and how will this be used in Universe design

what is Group and how is this different from LOCAL while accessing Infoset-Query

Regards

Bose

[Former Member · Accepted solution]

Hi  Bose,

STEP 1:-  First, We have to create the connection in the Information Design tool by using ECC System Credentials

Like System =100   ; Application Server =       ; System Id=    “ System Number =

STEP 2:- By using that connection we have to create  Data Foundation

You can find your custom function group in hierarchy by drilling down as snapshot below,

Very Custom Function will be associated with a function Group.

A Global object can be moved across the environments, while Local  can't be.

You can check scope of the object by right clicking over the object and selecting change qualifier/owner or mouse hovering the object as in snapshot below.

Hope it helps you,

Regards,

Ram Gopal

[Former Member · Accepted solution]

Ram

Could you be more specific with regard to

Function module

Global

Local

Thx

bose

[former_member4998 · Accepted solution]

Hi...

Function module:

Function modules are created using transaction SE37 (function builder). The standard SAP system has a number of predefined function modules. Function modules are best used for carrying out database updates and communicating with different SAP systems.

In contrast to subroutines, function modules do not need to be defined in the source of your ABAP program. Function modules may have both input and output parameters. The input parameters can be mandatory or optional.

You can also assign default values to parameters. Function modules also provide the option of exception handling, which catches errors when the function module executes. You may also test function modules from transaction SE37 before including them in your programs.

Customers can now use the Universe on top of SAP ERP

Supported data sources

–Classic InfoSets

–ABAP Functions

–ABAP Queries

ABAP Function:

SAP Business Objects Business Intelligence introduced a new connectivity to SAP ERP via SAP JCo. It provides access to the ABAP Functions.

Tables out of the ABAP dictionary or a data cluster are not available for the Universe. You either need to create an ABAP function or an InfoSet on top of the data.

An ABAP function parameter can have the following type:

• Field of primitive ABAP type

• Structure, which is a sequence of several fields

• Table, which can be made of fields, structures, or even tables

Global and Local:

In the SAP ERP system, InfoSets are created within either a local work area or a global work area. Objects within the local work area are only accessed by its SAP ERP system client, while objects of the global work area can be accessed by all clients.

You can configure the global parameter values that apply to all connections. You can do this to improve performance, or to resolve issues with the connection that arise. Data access global parameters are maintained in the cs.cfg file. This is an XML file that contains Connection Server configuration parameters, and default configuration parameters that apply to all data access drivers.