3655859 - Why do no tables appear in data integration/source data Process Intelligence even though the connection is valid

• No tables appear in the data integration/source data screen when attempting to extract a table from an S/4HANA system using the SAP RFC connection type with the On-Premises Extractor.
• The database connection status shows as "green" (successful).

Data Import for SAP Process Intelligence

1. Configure the SAP RFC connection type with the On-Premises Extractor.
2. Validate the database connection status, which appears as "green" (successful).
3. Navigate to the data integration/source data screen.
4. Attempt to add a table from the S/4HANA system; observe that no tables appear for selection.

1. Missing role authorization
2. Missing activation of the table

Step-by-step guide to check the authorization group assignment for your tables:

1. Open SAP GUI.
2. Enter transaction code SE16.
3. In the 'Table Name' field, enter 'TDDAT'.
4. In the 'TABNAME' field, enter 'BSIK' (please adjust this based on the table you are working with in your PINT Connection).
5. Review the authorization group assignment for each table.

Once you have verified the authorization groups, it is important to ensure that the tables are set to active.

How you can check this:

1. Open SAP GUI.
2. Run transaction code SE11.
3. Enter one of the tables configured in the PINT Connection setup (e.g., CDPOS) and press 'Display'.
4. Look at the top left-hand corner for the 'CDS Database Views' field.
5. Confirm that the status at the end of this row is 'Active'.

sap rfc connection, on-premises extractor, s/4hana system, data integration, source data screen, no tables appearing, database connection green, table extraction issue, sap process intelligence, sap data import troubleshooting , KBA , BPI-SIG-PI-DI , Data Import for SAP Signavio Process Intelligence , Problem