PSA table name

[Former Member]

Hi every body,

Where shall i find the PSA table name for a particular info cube.

Thanks in advance

[GFV · Accepted solution]

You can find PSA table name by Data Source (not by InfoProvider) with SE16. See Table RSTSODS in field specify DS tech name (with * at the end, eg: 2LIS_11_VAITM*): in field ODSNAME_TECH you will find tech name of PSA table.

Hope it helps

GFV

[Former Member · Accepted solution]

Hi,

there is also the possibility to implement a little custom program (ZGET_PSA_TAB) that allows to know the name of a PSA table starting from a dataload request number.

See OSS note 500966 for more details.

TYPE-POOLS: RSA.

INCLUDE <ICON>.

PARAMETERS:

REQUEST TYPE RSREQUNR DEFAULT 'REQU_NNNNNNNNNNNNNNNNNNNNNNNNN'.

DATA:

LD_ODSNAME_DB TYPE RSA_ODSDBNAME,

LS_RSSELDONE TYPE RSSELDONE.

START-OF-SELECTION.

WRITE:/ 'Get PSA table:'.

ULINE.

SELECT SINGLE * FROM RSSELDONE INTO LS_RSSELDONE

WHERE

RNR EQ REQUEST.

IF SY-SUBRC NE 0.

WRITE: / ICON_LED_RED AS ICON, 'ERROR: Request', REQUEST,

' does not exist!'.

ELSE.

WRITE: / ICON_LED_GREEN AS ICON, 'Request:', AT 30 REQUEST .

ULINE.

WRITE: / ICON_LED_GREEN AS ICON, 'DataSource:',

LS_RSSELDONE-OLTPSOURCE

UNDER REQUEST.

WRITE: / ICON_LED_GREEN AS ICON, 'Selection Date:',

LS_RSSELDONE-SELDATE

UNDER REQUEST,

LS_RSSELDONE-SELTIME.

ENDIF.

CALL FUNCTION 'RSAR_ODS_NAME_GET'

EXPORTING

I_LOGSYS = LS_RSSELDONE-LOGSYS

I_ISOURCE = LS_RSSELDONE-OLTPSOURCE

I_ISTYPE = LS_RSSELDONE-TYP

I_DATE = LS_RSSELDONE-SELDATE

IMPORTING

E_ODSNAME_DB = LD_ODSNAME_DB

EXCEPTIONS

PARAMETER_FAILURE = 1

NO_ODS_FOUND = 2

NO_FIELDS_TO_ODS = 3

OTHERS = 4

.

ULINE.

IF SY-SUBRC <> 0.

WRITE:/ ICON_LED_RED AS ICON, 'ERROR: No PSA table found !'.

ELSE.

WRITE:/ ICON_LED_GREEN AS ICON, 'Name of PSA table:',

LD_ODSNAME_DB UNDER REQUEST.

ENDIF.

Hope this helps.

Bye,

Roberto

[Former Member]

Hi,

Another way to view the PSA table name:

Go to the infocube and select "show data flow" option. Turn on the technical name there an you can see the PSA table name for that infocube in the data flow.

Hope it helps you.

Thanks

[Former Member]

Another way:

- In the Admin workbench, click on the PSA button

- Seach for your Info Source

- Right click and choose "Delete PSA Data" (no worry a nothing will be deleted, a new screen will popup)

- pull the scrollbar to the right, you will find the PSA table name

Ioan