topic Re: Issue with internal table columns in Application Development and Automation Discussions

Issue with internal table columns

Former Member — Tue, 22 Jan 2013 06:41:01 GMT

Hi All,

I got an issue while working with internal tables.

I am trying to create an output table from input table based on the customized mapping table. Mapping table records will be like this

inputfld outputfld

COL1 COL3

COL4 COL1

COL3 COL2

here, From my input table(itab1) COL1 data should map to output Table ( Itab2) COL3, similarly for itab1-COL4 should map to itab2-COL1.

Mapping should be based on customized mapping table ZMAP.

Is there any Idea to achive this.

Please help .

Thanks,

Vishnu

Re: Issue with internal table columns

Venkat_Sesha — Tue, 22 Jan 2013 06:54:28 GMT

This looks to me as Requirement Dumping which is against Forum Rules.

Please show what research you have done before posting. So, we could continue answering to the post.

Please Read the Rules of Engagement

Hope this helps.

Re: Issue with internal table columns

Former Member — Tue, 22 Jan 2013 07:09:45 GMT

Hi,

I have tried with using field symbols for mapping table & reading the COL1 number from ZMAP.

and assigning to output table is not happening....

Re: Issue with internal table columns

Former Member — Tue, 22 Jan 2013 09:22:49 GMT

Hello,

please suggest any idea...

Thanks!

Re: Issue with internal table columns

Venkat_Sesha — Tue, 22 Jan 2013 09:43:49 GMT

Ok , Sure we are here to help.

Lets take the Example with FIELDS to avoid confusion.

ITAB1 ITAB2

----------- -------------

MATNR MATNR

COL1 COL3

COL4 COL1

COL3 COL2

so assuming your INPUT Table (ITAB1)

Now we prepare the OUTPUT Table (ITAB2)

When first point comes into Picture.. COL1 which is MATNR of ITAB1 will be placed at COL3(MATNR) in ITAB2. Is that what you want?

In That case what about the COL4 and COL1, before that you should have a field right..

Please explain clearly..

Re: Issue with internal table columns

RaymondGiuseppi — Tue, 22 Jan 2013 09:45:54 GMT

What is going wrong with ASSIGN COMPONENT comp OF STRUCTURE struc,

Loop at internal table 1 assigning a field symbol to the record (or use a work area), append an initial record to internal table 2 assigning an other field symbol. Then loop into your "customizing table", loaded in memory in an internal table, which should contain pair of field name and assign one field symbol to component name1 of internal table 1 field symbol and another field symbol to component name2 of internal table 2 field symbol and move the data from first field symbol to the second

Regards,

Raymond

Re: Issue with internal table columns

Former Member — Tue, 22 Jan 2013 10:44:32 GMT

Hi,

Will you please explain logic in detail.....becoz i have done some mistakes while assigning field symbols of customization table to internal table 2.

thanks!

Re: Issue with internal table columns

kesavadas_thekkillath — Tue, 22 Jan 2013 10:55:53 GMT

Hi,

Instead of wasting time with the two liners , try to provide the code part which you have written.

Re: Issue with internal table columns

Former Member — Tue, 22 Jan 2013 11:35:34 GMT

Hi,

I have done the coding like this. Sorry if any mistakes i am learning use of field symbols.

LOOP AT ITAB1 ASSIGNING <FS_ITAB1>.
   LOOP AT ZMAP INTO WA_ZMAP.
     ASSIGN COMPONENT WA_ZMAP-SAPFLD OF STRUCTURE ZMAP TO <FS1>.
     ASSIGN COMPONENT WA_ZMAP-OUTPUT OF STRUCTURE ZMAP TO <FS2>.

     WA_ITAB2-<FS2> = <FS_ITAB1>-<FS1>.   " Is this possible?

     APPEND WA_ITAB2 TO ITAB2.

   ENDLOOP.
ENDLOOP. .

Thanks!

Re: Issue with internal table columns

Former Member — Tue, 22 Jan 2013 11:46:04 GMT

Hi,

any idea..

Re: Issue with internal table columns

Venkat_Sesha — Tue, 22 Jan 2013 11:59:23 GMT

Here is the thing that I noticed.

ASSIGN COMPONENT WA_ZMAP-SAPFLD OF STRUCTURE ZMAP TO <FS1>.

ASSIGN COMPONENT WA_ZMAP-OUTPUT OF STRUCTURE ZMAP TO <FS2>.

Did you declared ZMAP as Structure in your Program.

Because when you say Loop at ZMAP It should be a ITAB.

If you declare ZMAP with TABLEs Parameter then it wont suite in this requirement.

One more thing is that. Lets say WA_ZMAP-SAPFLD has the field Value as 'MATNR' then it should of which structure ? does ZMAP structure has MATNR in it.?

Please check the BOLD part the code

Hope this helps

Re: Issue with internal table columns

RaymondGiuseppi — Tue, 22 Jan 2013 18:27:09 GMT

Try

LOOP AT ITAB1 ASSIGNING <FS_ITAB1>.
   LOOP  AT ZMAP INTO WA_ZMAP.
     TRY.
       ASSIGN COMPONENT WA_ZMAP-SAPFLD OF STRUCTURE<FS_ITAB1> <FS1>.
       ASSIGN COMPONENT WA_ZMAP-OUTPUT OF STRUCTURE WA_ITAB2 TO <FS2>.
       <FS2> =<FS1>.
       " Here try to CATCH mapping error
     ENDTRY.
   ENDLOOP.  
   APPEND WA_ITAB2 TO ITAB2. 
ENDLOOP.

Regards,

Raymond

Re: Issue with internal table columns

former_member16322 — Tue, 22 Jan 2013 18:41:47 GMT

That is not possible

vishnu vishnu wrote:
Hi,
  I have done the coding like this. Sorry if any mistakes i am learning use of field symbols. 
LOOP AT ITAB1 ASSIGNING <FS_ITAB1>.
   LOOP  AT ZMAP INTO WA_ZMAP.
     ASSIGN COMPONENT WA_ZMAP-SAPFLD OF STRUCTURE ZMAP TO <FS1>.
     ASSIGN COMPONENT WA_ZMAP-OUTPUT OF STRUCTURE ZMAP TO <FS2>.
    
     WA_ITAB2-<FS2> = <FS_ITAB1>-<FS1>.   " Is this possible?
      
     APPEND WA_ITAB2 TO ITAB2. 
     
   ENDLOOP.  
 ENDLOOP. .
Thanks!

The line:

wa_itab2-<FS2> = <FS_ITAB1>-<FS1> .

That is not possible.

When you assign a component, of a structure to a field symbol, you can use the field symbol directly as if it were the field.

<fs2> = <fs1> .

Additionally, it is always a good idea to ensure assignment of a field symbol was successful.

Usually a IF ASSIGNED statement will work, in this case:

IF <fs2> IS ASSIGNED .

IF <fs1> IS ASSIGNED .

<fs2> = <fs1> .

ELSE .

" Handle what to do if <FS1> IS not assigned

ENDIF .

ELSE .

" Handle what to do if <FS2> is not assigned.

ENDIF .

That should work for actually carrying out the data transfer.

ZMAP stores the maps, correct? ITAB1 and ITAB2 store data to be moved?

Your ASSIGN statements should be changed as follow I believe:

ASSIGN COMPONENT wa_zmap-sapfld OF STRUCTURE <fs_itab1> TO <fs1> .

ASSIGN COMPONENT wa_zmap-output OF STRUCTURE wa_itab2 TO <fs2> .

Edit - Raymond already answered.

Re: Issue with internal table columns

Former Member — Wed, 23 Jan 2013 09:32:16 GMT

Hi Raymond,

Thanks for valuable reply.

I Have tried like this but i need to move ITAB1-COL1 data to ITAB2-COL3. IF suppose ITAB1-COL contains data as "123", with first ASSIGN component statement I am able to get "123" into <FS1>.

After 2nd ASSIGN Component statement I am moving <FS1> to <FS2>.

Now my issue is how to move the data "123" to ITAB2-COL3.?

here is my code.

FIELD-SYMBOLS : <FS_ITAB1> TYPE TY_ITAB1,

<FS1>,<FS2>.

ASSIGN WA_ITAB2 TO <FS2>.

LOOP AT IT_ITAB1 ASSIGNING <FS_ITAB1>.
     LOOP AT IT_ZMAP INTO WA_ZMAP.
       ASSIGN COMPONENT WA_ZMAP-SAPFIELD OF STRUCTURE <FS_ITAB1> TO <FS1>.
       ASSIGN COMPONENT WA_ZMAP-OPTCOL OF STRUCTURE WA_ITAB2 TO <FS2>.
       <FS2> = <FS1>.   "here value <FS2> is containing value"123" but i need to assign this to

                                    "WA_ITAB2-COL3.then I will append the same to ITAB2.

     ENDLOOP.

    APPEND <FS2> TO IT_NEW.

ENDLOOP..

Please suggest......

Re: Issue with internal table columns

Former Member — Wed, 23 Jan 2013 09:39:36 GMT

Many Thanks Raymond......got it......!!