topic Re: comparing values in different tables in Application Development and Automation Discussions

comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:20:37 GMT

Hi,

I am trying to compare values in two different table fields, can someone advise me of the ABAP to do it.

I need to find IHPA-PARNR(partner number) in table T527X-ORGEH(org unit number)

Thanks,

Alec

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:22:25 GMT

Hi,

use command READ TABLE if you work with internal table.

If you work with database tables, use command SELECT.

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:24:20 GMT

HI.

1.fetch PARNR value from table IHPA.

2.Fetch ORGEH value from table T527X by using All entries

3.check sy-subrc <> 0.

Regards.

Jay

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:24:50 GMT

Hi Alec,

In ABAP, you can make use of LOOP and READ statements to compare the values.

As in this case,

I need to find IHPA-PARNR(partner number) in table T527X-ORGEH(org unit number)


Loop at ihpa into wa_ihpa.
Read table t527x into wa_t527x with key orgeh = wa_ihpa-parnr
                                                            binary search.
if sy-subrc eq 0.
" This means the value exists in table t527x. you can do the required modifications here.
endif.
Endloop.

Hope this is what you are looking for.

Best Regards,

Ram.

Re: comparing values in different tables

former_member585060 — Fri, 19 Dec 2008 10:29:10 GMT

Hi,

Declare 1 internal table with one field PARNR,

Fill that internal table with all values of table IHPA,

Select the entries of table T527X into second internal table for all the values in first internal table, so the second internal table has all the vales only of the values in IHPA-PARNR.

Use SELECT statement with FOR ALL ENTRIES addition.

Regards

Bala Krishna

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:31:15 GMT

hi,

u can select data from IHPA by using slect

select PARNR from IHPA

into table it_tab.

and then select data from T527X

select ORGEH from t527X into i_tab2

for all entries in it_tab where parnr = it_tab-parnr.

then u can compare using loop at it_tab and read from table i_tab2.

thanks

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:39:29 GMT

Tried this as a test:

Loop at ihpa into wa_ihpa.

Read table t527x into wa_t527x with key orgeh = wa_ihpa-parnr

binary search.

if sy-subrc eq 0.

WRITE 'HELLO' TO ZORGUNIT.

endif.

Endloop.

I get a syntax error:

"VERSION ... ." expected after "IHPA".

what have I done wrong?

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:42:27 GMT

declare 2 internal table read all your data into these table and in loop endloop statement compare all the value you want

loop

'your if condition for comparision

endloop

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:42:35 GMT

Hi Alec,

What is IHPA? I mean is that an internal table. How is it declared?

Ideally it should have been declared as


data: ihpa type standard table of ihpa,
      wa_ihpa type ihpa.

Best Regards,

Ram.

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:43:13 GMT

hi,

data :it_tab like standard table of ihpa with header line.

now u can loop at it_tab instead of ihpa.

thanks

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 10:45:42 GMT

Hi,

Pls check this:

loop at it_ihpa into wa_ihpa.

loop at it_t527x into wa_t527x.

if wa_ihpa-parnr eq wa_t527x-orgeh.

endif.

endloop.

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 11:00:35 GMT

Hi,

First check the data type and length of parnr and orgeh fields. And make sure that values of these two fields have same length.

Check the following code:

data: it_ihpa like ihpa occurs 0 with header line,

wa_ihpa like it_ihpa,

it_t527x like t527x occurs 0 with header line,

wa_t527x like it_t527x.

select objnr parnr into corresponding fields of table it_ihpa from ihpa up to 100 rows.

sort it_ihpa by parnr.

select orgeh into corresponding fields of table it_t527x from t527x up to 100 rows.

sort it_t527x by orgeh.

loop at it_ihpa into wa_ihpa.

read table it_t527x into wa_t527x with key orgeh = wa_ihpa-parnr binary search.

if sy-subrc = 0.

write: 'successfully read'.

else.

write: 'read failed'.

endif.

endloop.

Regards,

Bhaskar

Re: comparing values in different tables

former_member585060 — Fri, 19 Dec 2008 11:02:24 GMT

Hi,

Don't read directly from the Table t527x, first get all the records into an internal table it_t527x and then use it.

Data : it_ihpa TYPE TABLE OF ihpa,

wa_ihpa TYEP ihpa,

it_t527x TYPE TABLE OF t527x,

wa_t527x TYPE t527x.

SELECT * FROM ihpa INTO TABLE it_ihpa.

SELECT * FROM t527x INTO TABLE it_t527x.

LOOP AT ihpa INTO wa_ihpa.

READ TABLE it_t527x INTO wa_t527x WITH KEY orgeh = wa_ihpa-parnr

BINARY SEARCH.

IF sy-subrc EQ 0.

WRITE 'HELLO' TO ZORGUNIT.

ENDIF.

ENDLOOP.

Regards

Bala Krishna

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 11:12:16 GMT

Hi,

Do this way:-


I need to find IHPA-PARNR(partner number) in table T527X-ORGEH(org unit number)
select parnr from IHPA into it_IHPA.

sort it_IHPA by PARNR
if not it_IHPA[] is initial.
   select ORGEH from T527X into table it_T527X
            for all entries in it_IHPA
            where  ORGEH = it_IHPA- PARNR.
endif.

now it_T527X contains the req result

Thanks & Regards,

Krishna

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 11:33:30 GMT

- Tried this

data: it_ihpa like ihpa occurs 0 with header line,

it_t527x like t527x occurs 0 with header line.

select parnr from IHPA into it_IHPA.

sort it_IHPA by PARNR

if not it_IHPA[] is initial.

select ORGTX from T527X into table it_T527X

for all entries in it_IHPA

where ORGEH = it_IHPA- PARNR.

endif.

write: it_T527X-ORGTX to ZORGUNITTEXT

- Got syntax error:

No component exists with the name "IF".

- What went wrong?

Re: comparing values in different tables

former_member585060 — Fri, 19 Dec 2008 12:01:33 GMT

Hi,

Try the following code

TYPES : BEGIN OF ty_ihpa,

parnr TYPE ihpa-parnr,

END OF ty_ihpa.

DATA : it_tipha TYPE TABLE OF ty_ihpa,

wa_tipha TYPE ty_ihpa.

DATA : it_ihpa TYPE TABLE OF ihpa,

wa_ihpa TYPE ihpa,

it_t527x TYPE TABLE OF t527x,

wa_t527x TYPE t527x.

SELECT * FROM ihpa INTO TABLE it_ihpa.

SELECT * FROM t527x INTO TABLE it_t527x.

LOOP AT it_ihpa INTO wa_ihpa.

READ TABLE it_t527x INTO wa_t527x WITH KEY orgeh = wa_ihpa-parnr

BINARY SEARCH.

IF sy-subrc EQ 0.

APPEND wa_ihpa-parnr TO it_tipha. "" Not able to understand what you are doing if Condition satisfied

ENDIF.

ENDLOOP.

Regards

Bala Krishna

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 12:17:28 GMT

Hi,

you forgott point after command "sort it_IHPA by PARNR"

PA: before your WRITE command, you need to use READ TABLE internal table it_T527X for move data to header line. If you don´t use that, ZORGUNITTEXT will be empty.

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 12:23:57 GMT

How can I get round the fact that T527X-ORGEH is type NUMC 8 characters and IHPA-PARNR is CHAR 12 characters.

I am currently trying the following but get a syntax error because the fields are not the same type / length

data: it_ihpa like ihpa occurs 0 with header line,

it_t527x like t527x occurs 0 with header line.

select * from IHPA into it_IHPA.

sort it_IHPA by PARNR.

if not it_IHPA is initial.

select ORGTX from T527X into table it_T527X

for all entries in it_IHPA

where ORGEH = it_IHPA-PARNR.

endif.

WRITE: it_t527x TO ZORGUNITEXT

Re: comparing values in different tables

former_member585060 — Fri, 19 Dec 2008 12:27:17 GMT

Hi,

Thats why use the sample code i have given above, fetch data from both tables and once u got the correct values clear the internal tables data which u don't require further.

see above post of mine for sample code and use it.

Regards

Bala Krishna

Re: comparing values in different tables

Former Member — Fri, 19 Dec 2008 12:35:45 GMT

This message was moderated.