topic Re: Join Table PLPO PLWP in Application Development and Automation Discussions

Join Table PLPO PLWP

Former Member — Wed, 02 May 2007 13:35:30 GMT

HI,

i want to read the packets of an operation.

I use the following function moduls.

Operations

CALL FUNCTION 'CI03_READ_PLPO'

EXPORTING

I_PLNTY = anleitungen-plnty

I_PLNNR = anleitungen-plnnr

I_PLNAL = anleitungen-plnal

I_DATE = anleitungen-erdat

I_ADD_WORK_PLACE = 'X'

IMPORTING

E_PLAS_TAB = PLAS_TAB

E_PLPO_TAB = PLPO_TAB

EXCEPTIONS

DATABASE_INCONSISTENT = 1

WORK_PLACE_NOT_FOUND = 2.

Packets

CALL FUNCTION 'CI_03_PLWP_VALID_READ'

EXPORTING

PLNAL_IMP = anleitungen-plnal

PLNNR_IMP = anleitungen-plnnr

PLNTY_IMP = anleitungen-plnty

STTAG_IMP = anleitungen-erdat

TABLES

PLWP_TAB_EXP = plwp_tab.

How can i get the right packets to an operation?

this is wrong*********************

loop at plpo_tab into plpo_tab_wa where vornr = vorgaenge-vornr.

loop at plwp_tab into plwp_tab_wa

where plnty = plpo_tab_wa-plnty

and plnnr = plpo_tab_wa-plnnr

and plnkn = plpo_tab_wa-zaehl.

kriterien-aufnr = anleitungen-aufnr.

kriterien-paket = plwp_tab_wa-paket.

kriterien-strat = plwp_tab_wa-strat.

kriterien-arbid = plpo_tab_wa-arbid.

append kriterien.

endloop.

regards

Re: Join Table PLPO PLWP

Former Member — Wed, 02 May 2007 13:40:57 GMT

Use all key fields

PLNTY

PLNNR

PLNKN

ZAEHL

for reading the records between PLPO and PLWP tables.

Reward points if useful

Regards

Anji

Re: Join Table PLPO PLWP

sreeramkumar_madisetty — Wed, 02 May 2007 13:44:28 GMT

Use as many key fields as possible in the where condition while perform joins.

Regards,

Sreeram

Re: Join Table PLPO PLWP

Former Member — Thu, 03 May 2007 06:27:01 GMT

Hi,

in the table PLPO the field ZAEHL is not the same as in the table PLWP.

Sometimes i have problems when some operations are deleted or the general task list has a change number.

regards

Re: Join Table PLPO PLWP

Former Member — Thu, 03 May 2007 06:36:45 GMT

•Use Parallel cursor technique should be used wherever possible instead of LOOP ….WHERE because the numbers of iterations are reduced thereby reducing the processing time.

loop at table1.

loop at table2 where commonfield = table1-commonfield.

table3 = table1-f1.

table3 = table1-f2.

...

table3 = table2-f1.

so on...

think it ll solve ur problem