topic Re: Extract data from not connected tables?? in Application Development and Automation Discussions

Extract data from not connected tables??

Former Member — Fri, 03 Oct 2008 06:04:12 GMT

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.

Re: Extract data from not connected tables??

Former Member — Fri, 03 Oct 2008 06:08:55 GMT

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.

Re: Extract data from not connected tables??

GauthamV — Fri, 03 Oct 2008 06:10:55 GMT

hi,

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

Re: Extract data from not connected tables??

Former Member — Fri, 03 Oct 2008 06:29:49 GMT

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