SAP R/3 Metadata Search Page

Use the SAP R/3 Metadata Search page to perform the following tasks:

find the search results that contain a specified search string. You can use the find text features to locate the search results that contain a specified text string.
review the results of your search for a given text string. The SAP R/3 Metadata Search page displays the results that match the search criteria that you specified in the Search Metadata for String dialog box. The search results are grouped according to the search options that you specified.
modify or refine your metadata search. You can either revise your metadata search criteria or refine your search by searching within the returned search results.
display the metadata and data contents of a selected table. You can select a table that is listed in the search results and view both the metadata for that table as well as the data in that table.
select the tables for which you want to write metadata to the metadata repository. You can select the tables that you want to identify as data sources in your SAS Data Integration Studio data warehouse. Metadata for source tables is written to the metadata repository and data stores that correlate to the tables are created in the data warehouse.

The SAP R/3 Metadata Search page contains the following items:

text string box

enables you to specify a text string that you want to search for. After you enter the text string, click Find Text to search all returned search results to locate the results that contain the specified text string.

Search Results list

displays a tree view of the results of your search and enables you to select the tables that you want to specify as data sources. Results are grouped according to the search string you specified in the Search Metadata for String dialog box. You can expand and collapse the folders in the Source Node tree view to view your search results. Search results groups include the following items:

Tables

displays all tables that met the specified search criteria. This search results group displays when you select the Tables check box in the Search Metadata for String dialog box.

Datamodel

displays all tables with a data model that met the specified search criteria. This search results group displays when you select the Datamodel check box in the Search Metadata for String dialog box. The data models display in hierarchical tree view. The tree view includes only the data models that contain your search string. You can expand and collapse the folders in the tree view as needed to locate the desired tables.

Entities

displays all tables that contain entities that met the specified search criteria. This search results group displays when you select the Entities check box in the Search Metadata for String dialog box. Entities are listed in a tree view in numerical order. You can expand and collapse the folders in the tree view as needed to locate the desired tables.

Tables w/Columns

displays all tables and views that met the specified search criteria. This search results group displays when you select the Tables w/Columns check box in the Search Metadata for String dialog box.

Columns

displays all tables that contain a column that met the search criteria you specified. This search results group displays when you select the Columns check box in the Search Metadata for String dialog box. Tables are listed in alphabetical order according to technical table name.

To select a table, highlight the desired table in the Search Results list and then click right-arrow icon

to move it to the Selected Sources list. Click double right-arrow icon

to move all tables. You can use the SHIFT and CTRL keys to select multiple tables.

Selected Sources tree

lists all tables that you have selected from the Search Results group box. To remove a table from the Selected Sources list, highlight the table in the Selected Sources list and then click left-arrow icon

. Click

to remove all selected tables.

The SAP R/3 Metadata Search page contains the following buttons:

Find Text

searches all returned search results to locate the results that contain the text string that you entered in the Text String box.

Expand

enables you to expand all subnodes within a selected node in the Search Results group box or Selected Sources list.

SAP Metadata Search

displays the Search Metadata for String dialog box, which enables you to search the pre-extracted SAP R/3 metadata for a given text string. It also allows you to limit the search to tables, entities, data models, and other filtering choices. This button enables you to perform multiple searches without removing any of the tables from the Selected Sources list.

Search Within Results

displays the Search Metadata for String dialog box and enables you to refine your search by searching within the already returned search results.

Delete Node

enables you to delete the selected node from the list of search results.

Display Table Metadata

displays the Displaying Metadata for SAP Table dialog box, which enables you to view metadata such as the field name, field text, field format, and so on for a selected table.

Display Table Contents

displays the Displaying Contents of SAP R/3 Table dialog box, which enables you to view the data in the selected table.

Undo Last Move

enables you to undo your last action. For example, if you accidentally delete a node, click this button to restore that node to the list of search results. This button enables you to undo only the last action that you performed.

SAP R/3 Metadata Search Page

See Also