Extract data from not connected tables??

[Former Member]

Hi experts,

I have to extract data from fields PERNR, WORKDATE, CATSHOURS, RAUFNR and AWART, from table CATSDB.

And from fields BTRTL and ENAME, from table PA0001.

And from fields LGART, BETRG and ANZHL, from table PPOIX.

Table PA0001 and PPOIX both has PERNR as primary key So, no problem to join them.

But table CATSDB does not have any primary key common to both PPOIX or PA0001 tables.

Can anyone please help me to how to extract data from those, not connected tables.

Please help me for this problem.

Thanks in advance.

[Former Member]

hi,

First get data from PA0001 and PPOIX with key PERNR,BEGDA and ENDDA.

Then fetch data from CATSDB using FOR ALL ENTRIES in the internal table fielled above.

[GauthamV]

hi,

You can use PERNR field in catsdb table to join with pa0001 and ppoix.

[Former Member]

While selecting data from CATSDB table, you can use either of the following field combination in the where clause. that will trigger secondary index and data retrieval will be faster.

1. PERNR, WORKDATE

2. PERNR,WORKITEMID

3. PERNR, STATUS, WORKDATE