problem with ALV

[Former Member]

i have allready a alv work.

i add a column MEINS to him in the right position

and in the results i have the data of the column before him why????

in itab i see the right value.

i use FM alv_grig

[Former Member]

check the order of adding coloumn in field catalog and internal table is same..?

[Former Member]

it'snumber 7 in the itab and the definition

[Former Member]

Hi Rani,

are you passing any variant option, is there any default variant present..

and can you show your ALV FM call....?

Regards

vijay

[Former Member]

&----

---

*& Form print_report

&----

---

FORM print_report.

l_program = sy-repid.

DATA ls_print TYPE slis_print_alv .

ls_print-prnt_info = ' ' .

SORT t_grid BY matnr.

*

MOVE 'TOP_OF_PAGE' TO it_event-name.

MOVE 'TOP_OF_PAGE' TO it_event-form.

APPEND it_event TO ls_event.

CLEAR it_event.

• LIST HEADING LINE: TYPE H

CLEAR gt_listheader.

gt_listheader-typ = 'H'.

gt_listheader-info = text-002.

APPEND gt_listheader TO slis_t_listheader.

*

• STATUS LINE: TYPE S

CLEAR: gt_listheader.

gt_listheader-typ = 'S'.

• gt_listheader-key = text-001.

CONCATENATE sy-datum6(2) '/' sy-datum4(2) '/' sy-datum(4)

'&&' sy-uzeit(2) ':' sy-uzeit+2(2)

INTO gt_listheader-key.

• gt_listheader-info.

REPLACE '&&' WITH ' ' INTO gt_listheader-key.

• gt_listheader-info.

APPEND gt_listheader TO slis_t_listheader.

IF NOT matkl IS INITIAL.

CLEAR gt_listheader.

gt_listheader-typ = 'S'.

gt_listheader-key = ''. "text-103.

CLEAR: zline.

DESCRIBE TABLE matkl LINES zline.

IF zline = 1 AND matkl-high = ''.

gt_listheader-key = text-103.

gt_listheader-info = matkl-low.

ELSEIF zline = 1 AND matkl-high <> ''.

gt_listheader-key = text-103.

CONCATENATE matkl-low '-' matkl-high INTO

gt_listheader-info SEPARATED BY space.

ELSEIF zline > 1.

LOOP AT matkl.

IF sy-tabix = 1.

CONCATENATE text-103 matkl-low INTO

gt_listheader-info.

ELSE.

CONCATENATE gt_listheader-info ',' matkl-low

INTO gt_listheader-info.

ENDIF.

ENDLOOP.

ENDIF.

APPEND gt_listheader TO slis_t_listheader.

ENDIF.

lvc_title = text-002.

ls_layout-zebra = 'X'.

ls_layout-cell_merge = 'X'.

ls_layout-colwidth_optimize = 'X'.

ls_layout-numc_sum = 'X'.

ls_layout-totals_only = 'X'.

ls_layout-totals_text = 'X'.

ls_layout-detail_initial_lines = 'X'.

ls_variant-report = sy-repid.

l_program = sy-repid.

PERFORM add_column CHANGING lt_fieldcat[].

PERFORM sort_fields CHANGING lt_sort[].

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = l_program

i_callback_user_command = g_user_command

i_callback_top_of_page = 'TOP_OF_PAGE'

is_layout = ls_layout

it_fieldcat = lt_fieldcat[]

it_sort = lt_sort

i_save = 'A'

i_grid_title = lvc_title

is_print = ls_print

it_events = ls_event

is_variant = ls_variant

• IS_SEL_HIDE = SLIS_SEL_HIDE_ALV

TABLES

t_outtab = t_grid

EXCEPTIONS

program_error = 1

OTHERS = 2.

ENDFORM. " print_report

*----

---

• FORM TOP_OF_PAGE *

*----

---

FORM top_of_page.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

i_logo = 'ENJOYSAP_LOGO'

it_list_commentary = slis_t_listheader.

ENDFORM.

**&----

---

**& Form add_column

**&----

---

*

FORM add_column CHANGING pt_fieldcat TYPE slis_t_fieldcat_alv.

DATA: ls_fieldcat TYPE LINE OF slis_t_fieldcat_alv.

DATA: l_col_pos(2) TYPE n,

l_index(2) TYPE n,

l_fieldname(7) TYPE c.

DEFINE add_level_column.

add 1 to l_col_pos.

ls_fieldcat-col_pos = l_col_pos.

ls_fieldcat-fieldname = &1.

ls_fieldcat-datatype = &2.

ls_fieldcat-inttype = &3.

ls_fieldcat-intlen = &4.

ls_fieldcat-reptext_ddic = &5.

ls_fieldcat-emphasize = &6. " Color

ls_fieldcat-no_zero = &7.

ls_fieldcat-do_sum = &8.

• ls_fieldcat-outputlen = &9.

• ls_fieldcat-ddictxt = 'L'.

append ls_fieldcat to pt_fieldcat.

END-OF-DEFINITION.

l_index = '01'."sy-index.

CONCATENATE 'MATNR' l_index INTO l_fieldname.

add_level_column:

'MATNR' 'CHAR' 'C' '' 'Material' 'C10' 'X' ' ' ,

'PLANT' 'NUMC' 'N' '15' 'Plant' 'C05' 'X' ' ' ,

'MTART' 'CHAR' 'C' '' 'Mat. Type' 'C05' ' ' ' ' ,

'MATKL' 'CHAR' 'C' '' 'Mat. Group' 'C05' ' ' ' ' ,

'MAKTXE' 'CHAR' 'C' '' 'Mat. descr. EN' 'C10' 'X' ' ' ,

'MAKTXH' 'CHAR' 'C' '' 'Mat. descr. HE' 'C10' 'X' ' ' ,

'MIENS' 'CHAR' 'C' '' '' 'C10' 'X' ' ' ,

'MFRNR' 'NUMC' 'N' '15' 'Manufacture' 'C05' 'X' ' ' ,

'NAME1' 'CHAR' 'N' '15' 'Mfr Name' 'C05' 'X' ' ' ,

'MFRPN' 'NUMC' 'N' '15' 'Mfr part number' 'C05' 'X' ' ' ,

'STPRS' 'NUMC' 'N' '15' 'Standard Price' 'C05' 'X' ' ' ,

'VERPR' 'NUMC' 'N' '15' 'Average Price' 'C05' 'X' ' ' ,

'PEINH' 'NUMC' 'N' '15' 'Price Unit' 'C05' 'X' ' ' ,

'KTGRM' 'NUMC' 'N' ' ' 'Acct Assy' 'C05' 'X' ' ' ,

'PRCTR' 'NUMC' 'N' ' ' 'Profit Center' 'C05' 'X' ' ' .

ENDFORM. "add_column

*

**&----

---

*

**& Form sort_fields

**&----

---

*

FORM sort_fields CHANGING pt_sort TYPE slis_t_sortinfo_alv.

DATA: ls_sort TYPE LINE OF slis_t_sortinfo_alv.

DATA: l_index(2) TYPE n,

l_fieldname(7) TYPE c.

DEFINE add_sort_level.

ls_sort-spos = &1.

ls_sort-fieldname = &2.

ls_sort-up = 'X'.

ls_sort-subtot = &3.

append ls_sort to pt_sort.

END-OF-DEFINITION.

add_sort_level: '1' 'MATNR' 'X',

• '2' 'PLANT' 'X',

'2' 'MTART' ' ',

'3' 'MATKL' ' '.

ENDFORM. " sort_fields

[Former Member]

THE PROBLEM IS meins

[Former Member]

i don't see any problem,try to comment the i_variant, and i_save and see .

i think it is because of the ALV default variant..?

Regards

vijay

[Former Member]

i dont have any vairiant.

now i place himr FIRST and i dont get the data and in the itab i see it WHY?

PLS

[Former Member]

Hi Rani,

can you show your Internal table, and you might have changed the order in the itab and that is the reason you didn't get the data. try to check your select query.

show that also..

Regards

vijay

[Former Member]

and tyr to change this...

it is not<b> MIENS</b> , it is <b>MEINS</b>

'MATNR' 'CHAR' 'C' '' 'Material' 'C10' 'X' ' ' ,

'PLANT' 'NUMC' 'N' '15' 'Plant' 'C05' 'X' ' ' ,

'MTART' 'CHAR' 'C' '' 'Mat. Type' 'C05' ' ' ' ' ,

'MATKL' 'CHAR' 'C' '' 'Mat. Group' 'C05' ' ' ' ' ,

'MAKTXE' 'CHAR' 'C' '' 'Mat. descr. EN' 'C10' 'X' ' ' ,

'MAKTXH' 'CHAR' 'C' '' 'Mat. descr. HE' 'C10' 'X' ' ' ,

'MATNR' 'CHAR' 'C' '' 'Material' 'C10' 'X' ' ' ,

'PLANT' 'NUMC' 'N' '15' 'Plant' 'C05' 'X' ' ' ,

'MTART' 'CHAR' 'C' '' 'Mat. Type' 'C05' ' ' ' ' ,

'MATKL' 'CHAR' 'C' '' 'Mat. Group' 'C05' ' ' ' ' ,

'MAKTXE' 'CHAR' 'C' '' 'Mat. descr. EN' 'C10' 'X' ' ' ,

'MAKTXH' 'CHAR' 'C' '' 'Mat. descr. HE' 'C10' 'X' ' ' ,

<b>'MIENS' 'CHAR' 'C' '' '' 'C10' 'X' ' ' ,</b>

'MFRNR' 'NUMC' 'N' '15' 'Manufacture' 'C05' 'X' ' ' ,

'NAME1' 'CHAR' 'N' '15' 'Mfr Name' 'C05' 'X' ' ' ,

'MFRPN' 'NUMC' 'N' '15' 'Mfr part number' 'C05' 'X' ' ' ,

'STPRS' 'NUMC' 'N' '15' 'Standard Price' 'C05' 'X' ' ' ,

'VERPR' 'NUMC' 'N' '15' 'Average Price' 'C05' 'X' ' ' ,

'PEINH' 'NUMC' 'N' '15' 'Price Unit' 'C05' 'X' ' ' ,

'KTGRM' 'NUMC' 'N' ' ' 'Acct Assy' 'C05' 'X' ' ' ,

'PRCTR' 'NUMC' 'N' ' ' 'Profit Center' 'C05' 'X' ' ' .

'MFRNR' 'NUMC' 'N' '15' 'Manufacture' 'C05' 'X' ' ' ,

'NAME1' 'CHAR' 'N' '15' 'Mfr Name' 'C05' 'X' ' ' ,

'MFRPN' 'NUMC' 'N' '15' 'Mfr part number' 'C05' 'X' ' ' ,

'STPRS' 'NUMC' 'N' '15' 'Standard Price' 'C05' 'X' ' ' ,

'VERPR' 'NUMC' 'N' '15' 'Average Price' 'C05' 'X' ' ' ,

'PEINH' 'NUMC' 'N' '15' 'Price Unit' 'C05' 'X' ' ' ,

'KTGRM' 'NUMC' 'N' ' ' 'Acct Assy' 'C05' 'X' ' ' ,

'PRCTR' 'NUMC' 'N' ' ' 'Profit Center' 'C05' 'X' ' ' .

it should be

<b>'MEINS' 'CHAR' 'C' '' '' 'C10' 'X' ' ' ,</b>

Regards

vijay

[Former Member]

THANKS hahahaha

[Former Member]

Hi

The Field Catalog order should be same as how expect to display order in output.

Regards,

Raghav

[Former Member]

Hi Rani,

can you show the field cat how you are doing it.

and is there any default variant, if so that will override the settings which you are trying,.,.,,,

if there is any default variant try to remove it...

and check it.

Regards

vijay