topic Re: ABAP Logic - tables with different format in Application Development and Automation Discussions

ABAP Logic - tables with different format

Former Member — Thu, 24 Oct 2013 12:31:15 GMT

I have no idea why my topic has been deleted so I am posting again.

Moderators: if there was a problem with my topic, please let me know.

I still have issues. I am gonna try to explain better this time.

I need to compare data that comes from an interface.

Data from SAP have this format in table:

TYPES: BEGIN OF lt_A,

nachn TYPE pad_nachn,

vorna TYPE pad_vorna,

stras TYPE pad_stras,

pstlz TYPE pstlz_hr,

ort01 TYPE pad_ort01,

END OF lt_A.

Data from table that is created with after I receive data from interface

TYPES: BEGIN OF lt_b,

name TYPE string,

vorname TYPE string,

strasse TYPE string,

haus_nr TYPE int4,

haus_nr_zusatz TYPE string,

plz TYPE string,

ort18 TYPE string,

END OF lt_b.

I need now to create another table to store only data that matches.

Criteria is: If name, last name, Street, PLZ and ORT from table 1 = table 2, populate table 3.

If they are not equal, message INCORRECT and do not populate table 3.

I am struglying to create table 3 as the other 2 tables have complete differente format. Can someone please help?

Thank you,

Re: ABAP Logic - tables with different format

nabheetscn — Thu, 24 Oct 2013 12:54:38 GMT

Why cant you keep both format same. Do a simple loop one and read other.

Re: ABAP Logic - tables with different format

ThomasZloch — Thu, 24 Oct 2013 12:55:55 GMT

I think your initial title was just "abap logic". All posts here are (or rather should be) about ABAP logic. Imagine an entire discussion overview, all with titles like "abap logic". Which one to look at first as an expert who wants to help but doesn't have much time to spend?

Now it looks a little better.

Thomas

Re: ABAP Logic - tables with different format

Former Member — Thu, 24 Oct 2013 12:57:56 GMT

I really wish I could Nabheet. But as my first post states, first table is SAP format and second table is outsourced company results format, which is not equal at all to SAP format.

Re: ABAP Logic - tables with different format

Former Member — Thu, 24 Oct 2013 12:58:42 GMT

Thank you so much Thomas. I am sorry for my lack of attention.

Re: ABAP Logic - tables with different format

Former Member — Thu, 24 Oct 2013 13:16:13 GMT

Even if the field names are different, if the order of the corresponding fields are same, you can do it like this using field symbols.

data : flag.
FIELD-SYMBOLS: <fs_comp1>, <fs_comp2>, <fs_comp3>.
clear : wa_ty1, wa_ty2, wa_ty3.
loop at tab_a into wa_ty1.
loop at tab_b into wa_ty2.
flag = 'X'.
do .

check flag = 'X'.

        ASSIGN COMPONENT sy-tabix of STRUCTURE wa_ty1 to <fs_comp1>.
        ASSIGN COMPONENT sy-tabix of STRUCTURE wa_ty2 to <fs_comp2>.
        ASSIGN COMPONENT sy-tabix of STRUCTURE wa_ty3 to <fs_comp3>.
       if <fs_comp1> is ASSIGNED and <fs_comp2> is ASSIGNED.
          if <fs_comp1> ne <fs_comp2>.
            clear flag.
         else.
           <fs_comp3> = <fs_comp1>.
        endif.
     endif.
   enddo.
   if flag = 'X'.
* Move any other extra fields to the third work area if the third table contains more fields than table 1.

       append wa_ty3 to tab_c.
   endif .
   clear : wa_ty1, wa_ty2, wa_ty3.
endloop.

endloop.

Re: ABAP Logic - tables with different format

Former Member — Thu, 24 Oct 2013 15:01:03 GMT

Not working. I have already converted the internals tables to the same format. Any news ideas to compare them then? Thanks. F

Re: ABAP Logic - tables with different format

nabheetscn — Thu, 24 Oct 2013 16:31:47 GMT

Can you please paste a screen shot of the data from two formats which you want to compare. It will be easy for usto understand your to understand your problem

Re: ABAP Logic - tables with different format

Former Member — Fri, 25 Oct 2013 06:44:11 GMT

You can a for all entries to retirve all datas that matches certain conditions just like a join.

Eg.

select name place etc from table1 into table internal-tab where condition.

select field1 field2 etc from table2 for all entries in internal-tab1 into internal-tab2

where condition.

loop internal-tab into w_internal-tab.

read table internal-tab2 into w_internal-tab2 with key (the joining condition fields) name = w_internal-tab-name.

append the field to the new structure or use move corresponding.

endloop

With regards

Suneesh

Re: ABAP Logic - tables with different format

Former Member — Fri, 25 Oct 2013 08:17:46 GMT

OK, Please see in attachment the screen shot. What I need ( since I have already converted all tables to the same format ), is to compare data from the fields: pad_vorna, pas_stras, pstlz-hr and pad_ort01. If values are the same in those fields in both tables, populate the table 3. If value is not the same or does not exist, message "error".

Re: ABAP Logic - tables with different format

nabheetscn — Fri, 25 Oct 2013 08:24:56 GMT

You have values in table now..why cant you loop on one and read other table with key and check..? I am not able to get what is the issue may be you need to show us the data of both table and what is the challenge

Re: ABAP Logic - tables with different format

Former Member — Fri, 25 Oct 2013 08:30:59 GMT

I think that the problem I am having in the street number which I need to separate before and that when I convert to sap format brings a lot of spaces to the field ... and the rest does not get passed ...

Re: ABAP Logic - tables with different format

nabheetscn — Fri, 25 Oct 2013 08:41:27 GMT

What is the value of street in both table which needs to be compared?

Re: ABAP Logic - tables with different format

Former Member — Fri, 25 Oct 2013 08:45:23 GMT

no especific value. value just needs to be the same in both tables. then fill the 3rd table if there is a match. for some reason I cannot put together the correct loop.

Re: ABAP Logic - tables with different format

nabheetscn — Fri, 25 Oct 2013 08:52:47 GMT

Please paste your code here..

Loop at ITAB1

read table ITAB2 with key

if sy-subrc eq 0.

match found append it to itab3

else.

message abcd

endif

endloop

Re: ABAP Logic - tables with different format

Former Member — Fri, 25 Oct 2013 09:12:12 GMT

loop at li_addr1 into ls_addr2. read table li_addr2 WITH KEY ls_addr1-vorna = ls_addr2-vorname. if sy-subrc eq 0. match found append li_addr1 to li_addr3 else. message Incorrect Address endif. endloop sorry, the code is too long and I confused myself ...

Re: ABAP Logic - tables with different format

nabheetscn — Fri, 25 Oct 2013 09:15:41 GMT

code looks ok..I guess you should switch on debugger and check where it fails show the contents of the variable.

Re: ABAP Logic - tables with different format

Former Member — Fri, 25 Oct 2013 09:26:41 GMT

Thing is I still cannot activate because tells me I have errors.

Re: ABAP Logic - tables with different format

nabheetscn — Fri, 25 Oct 2013 09:35:31 GMT

What are the errros?

Re: ABAP Logic - tables with different format

praveenboss — Fri, 25 Oct 2013 09:37:52 GMT

Hi Fafa,

May Be A Problem Of Data Mismatch,

And I Think This Case Should Be Solved By

inside Your Internal Table Which Filled By Other interface data

you Move Your Checked Data to Other Column

And Then Match with Internal Table which Filled By sap table data,

Ex.

Loop At IT_Other INTO W_other.

UNPACK P_FIELD TO C_FIELD.

modify IT_Other from W_Other .

ENDLOOP.

Now C_FIELD IS IN FORMAT AS Your internal table which filled by sap table data.

http://help.sap.com/abapdocu_731/en/abapunpack.htm

http://sapbrainsonline.com/abap-tutorial/syntax/unpack-sap-abap-keyword.html

THANKS.

PRAVEEN