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
Next
.
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
OK
.
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:
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
OK
.
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
Go
Advanced
, and add a description. Select the SAP table and click
OK
.
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