PowerExchange for SAP NetWeaver User Guide

10.4.0
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.2
- 10.5
- 10.4.1

Back Next

Importing an SAP Table Data Object

Import an SAP Table data object to specify the SAP table from which you want to read data. You can then create a data object read operation based on the data object, and add the read operation to a mapping, mapplet, or profile.

Select a project or folder in the

Object Explorer

view.

Click

File

New

Click

New

Data Object

Select

SAP Table Data Object

and click

Effective in version 10.2, Informatica dropped support for data object of type

SAP Data Object (Deprecated)

. Informatica deprecated these objects in version 10.0. If you upgrade from versions earlier than 10.2, then you must create a new data object of type

SAP Table Data Object

to read data from SAP tables.

The

New SAP Table Data Object

dialog box appears.

Click

Browse

next to the

Location

option and select the target project or folder.

Click

Browse

next to the

Connection

option and select an SAP connection from which you want to import the SAP table metadata, and then click

To add an SAP table to the SAP Table data object, click

Add

next to the

Resource

option.

The

Add Resource

dialog box appears.

On the left pane, expand the connection, and click

Tables/Views

A list of SAP tables appears on the right pane.

You can identify an ABAP CDS view by the table category. The table category for an ABAP CDS view is

CDSView

The following image shows an ABAP CDS view selected and its column metadata:

In the above example,

paramO

denotes an optional parameter.

paramM

denotes a mandatory parameter. For more information on parameters, see GUID-12E7D04A-B3A0-45F3-9D5F-6C09556A7B74#GUID-12E7D04A-B3A0-45F3-9D5F-6C09556A7B74

Select an SAP table or search for the SAP table to add to the data object:

To import an SAP table from the list, select the SAP table and click

To search for an SAP table based on a name, enter a name in the

Name

field. To search for an SAP table based on a description, click

Advanced

, and add a description. Select the SAP table and click

When you search for an SAP table by the name, you can include wildcard characters and separate multiple table names with a comma. You cannot search for an ABAP CDS view based on a description.

If required, add additional SAP tables to the SAP Table data object.

Optionally, enter a name for the SAP Table data object.

Click

Finish

The data object appears under Physical Data Objects in the project or folder in the

Object Explorer

view.

Building Informatica Objects for SAP Table Data Extraction

Download Guide

Watch

Comments

Communities