topic Re: internal table shows '*' values... in Application Development and Automation Discussions

internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 09:33:40 GMT

hi all,

im doing one report in which after using at new conditions the internal table shows ********** values like this in some of fileds ....

plzzz help me out to solve this problem...

thank uuuuu......

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 09:38:37 GMT

If You are using AT NEW Control Break statement all the fields on the right of the specified table

will appear as *(for Char) and space(for Numeric).

So either Get the Value of sy-tabix for AT NEW.

or Get the row value into a work area everytime.

Or USE alternate to At NEW.

Itab has three Fields F1,F2,F3.
At new is on F3 Say.

Data:W_f3 like Itab-F3
sort Itab by F3.

Loop at itab.
If  W_f3 Ne Itab-F3.                    " Similar to AT NEW
Write : f1,f2,f3.
else.
Write:f1,f2.
endif.
W_f3 = Itab-F3.
Endloop.

Regards,

Gurpreet

Re: internal table shows '*' values...

I355602 — Sat, 07 Mar 2009 09:42:14 GMT

Hi,

When you use at new, then * is printed coz the field on which you use at new command contains some other field with multiple entries. And if the row is printed once (for field used in at new) then * is printed for the other field value.

Example:-

field1 field2

10 2

10 3

10 4

If you print simply then it will the same the data in specified as above.

But if using AT NEW, if only one row is printed, then it will print as:

field1 field2

10 *

So make sure that you sort the internal table before using AT NEW command

Hope you get it.

Regards,

Tarun

Re: internal table shows '*' values...

former_member203501 — Sat, 07 Mar 2009 09:42:47 GMT

hi ,

use sort on that field and read it..

sort itab by field.

read table itab1 with key field = itab-field.

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 09:51:11 GMT


> Hi,
> 
> When you use at new, then * is printed coz the field on which you use at new command contains some other field with multiple entries. And if the row is printed once (for field used in at new) then * is printed for the other field value.
> Example:-
> field1  field2
> 10      2
> 10      3
> 10      4
> 
> If you print simply then it will the same the data in specified as above.
> But if using AT NEW, if only one row is printed, then it will print as:
> field1  field2
> 10      *
> 
> So make sure that you sort the internal table before using AT NEW command
> 
> Hope you get it.
> 
> Regards,
> Tarun

it is already sorted.....

Re: internal table shows '*' values...

I355602 — Sat, 07 Mar 2009 09:55:04 GMT

Hi,

Can you please paste your code and internal table data.

Regards,

Tarun

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:00:16 GMT

i dont remember exactly but i think i have tried

Move itab1 to itab2.

and it worked but i dont remember along with this what i have done..

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:01:07 GMT


> Hi,
> 
> Can you please paste your code and internal table data.
> 
> Regards,
> Tarun

loop at itab1.

at end of vbeln.

SUM.

APPEND itab1 TO itab3.

CLEAR itab3.

ENDAT.

endloop.

Re: internal table shows '*' values...

I355602 — Sat, 07 Mar 2009 10:02:46 GMT

Hi,

What is problem with this code, and

what values is it appending to itab3?

Regards,

Tarun

Edited by: Tarun Gambhir on Mar 7, 2009 3:35 PM

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:04:43 GMT


> loop at itab1.
> at end of vbeln.
>    SUM.
> APPEND itab1 TO itab3.  
>  CLEAR itab3.
>     ENDAT.
> endloop.

check in debugging the value of itab1 inside the at end of... endat

кu03B1ятu03B9к

Edited by: kartik tarla on Mar 7, 2009 3:35 PM

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:09:53 GMT

there is no problem with the table field. both tables have the same structure so dont worry abt values....

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:15:08 GMT

> >


> > loop at itab1.
> > at end of vbeln.
> >    SUM.
> > APPEND itab1 TO itab3.  
> >  CLEAR itab3.
> >     ENDAT.
> > endloop.

> check in debugging the value of itab1 inside the at end of... endat

> кu03B1ятu03B9к

> Edited by: kartik tarla on Mar 7, 2009 3:35 PM

when it goes into at end of , some values becomes *********

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:19:16 GMT

Use sy-tabix value at 'AT END'.Try to use READ TABLE ITAB1 into ITAB3 INDEX SY-TABIX.

Regards,

Gurpreet

Re: internal table shows '*' values...

faisalatsap — Sat, 07 Mar 2009 10:19:22 GMT

Hi, Nilesh

VBELN Must be on the LEFT Most side other wise it show all the value as * which appear on the left side of VBELN, Hope will help you,

Kind Regards,

Faisal

Re: internal table shows '*' values...

I355602 — Sat, 07 Mar 2009 10:19:40 GMT

Hi,

Say you have data in internal table as:-

EBELN EBELP MATNR MENGE

100001 00010 MAT1 20

100001 00020 MAT2 30

100001 00030 MAT1 40

Now if you use at end of ebeln and use SUM, then it will sum the field MENGE for a group of EBELN and inside this at end..endat, you will have EBELP = ***** and MATNR = ****.

Hope you understand.

Regards,

Tarun

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:21:15 GMT


> Hi,
> 
> Say you have data in internal table as:-
> 
> EBELN EBELP MATNR MENGE
> 100001 00010    MAT1    20
> 100001 00020    MAT2    30
> 100001 00030    MAT1    40
> 
> Now if you use at end of ebeln and use SUM, then it will sum the field MENGE for a group of EBELN and inside this at end..endat, you will have EBELP = ***** and MATNR = ****.
> 
> Hope you understand.
> 
> Regards,
> Tarun

so wats the soltion for this...????

Re: internal table shows '*' values...

I355602 — Sat, 07 Mar 2009 10:22:59 GMT

Hi,

Actually I am not able to understand your requirement, that why are you moving data from itab1 to itab3 in at end...endat

Can you explain.

Regards,

Tarun

Re: internal table shows '*' values...

faisalatsap — Sat, 07 Mar 2009 10:23:19 GMT

Hi,

Define a WA like you internal table and just before going to AT END of assign the values to that WA and than you will find all values present in the AT END BODY.

Please Reply if any Issue,

Kind Regards,

Faisal

Re: internal table shows '*' values...

Former Member — Sat, 07 Mar 2009 10:26:01 GMT


> Hi,
> 
> Actually I am not able to understand your requirement, that why are you moving data from itab1 to itab3 in at end...endat
> 
> Can you explain.
> 
> Regards,
> Tarun

bcoz it has all item data and i want only the sum of all the item data's gross value.

now i hope u'll solve my problem..

Re: internal table shows '*' values...

I355602 — Sat, 07 Mar 2009 10:29:00 GMT

Hi,

In that case try using AT END OF...ENDAT with two fields i.e, order and item and then calculate sum and move data to another internal table.

Hope this solves your problem.

Regards,

Tarun