topic Re: ALV output error in Application Development and Automation Discussions

ALV output error

former_member209770 — Thu, 06 Nov 2014 10:28:21 GMT

Hi Gurus,

Does FIELDNAME not allowed lower case? Please refer to the below code.

'Cause I meet the weird situation, totalofsoqtys will show the value of MATNR, and the left 4 fields also be the same with the value of TOTALOFMOQTYS.

Could anyone share with me the cause? Thanks.

***************************************************************************************

FORM FIELDS .

DATA: V_COL TYPE I.

REFRESH I_FIELDCAT_ALV.

V_COL = 0.

PERFORM SET_FIELDS USING 'MATNR' 'Material'.

PERFORM SET_FIELDS USING 'totalofsoqtys' 'SO qty'.

PERFORM SET_FIELDS USING 'TOTALOFMOQTYS' 'MO qty'.

PERFORM SET_FIELDS USING 'totalOfPoQtys' 'PO qty'.

PERFORM SET_FIELDS USING 'totalOfInventory' 'Stock'.

PERFORM SET_FIELDS USING 'totalOfMMDoc' '261 qty'.

ENDFORM. " FIELDS

FORM SET_FIELDS USING P_IN_FNAME P_IN_SELTEXT.

CLEAR I_FIELDCAT.

ADD 1 TO V_COL .

I_FIELDCAT-COL_POS = V_COL .

I_FIELDCAT-FIELDNAME = P_IN_FNAME .

I_FIELDCAT-SELTEXT_L = P_IN_SELTEXT .

i_fieldcat-LOWERCASE ='X'.

APPEND I_FIELDCAT TO I_FIELDCAT_ALV .

CLEAR I_FIELDCAT.

ENDFORM . "SET_FIELDS

Jamie

Re: ALV output error

Arun_Prabhu_K — Thu, 06 Nov 2014 10:37:37 GMT

Hello.

Only caps are allowed.

To find out any inconsistency in ALV, just press SHIFT button and double click the right mouse button in the blank area.

Regards.

Re: ALV output error

Former Member — Thu, 06 Nov 2014 13:21:59 GMT

Pass the ref_tabname and ref_fieldname also to the field catalog

I_FIELD_CAT-REF_TABNAME = 'MSEG'.
I_FIELD_CAT-REF_FIELDNAME = 'MENGE'.

I_FIELD_CAT-LOWERCASE = 'X'.

I_FIELD_CAT-QFIELDNAME = 'MEINS'.

Re: ALV output error

roberto_vacca2 — Thu, 06 Nov 2014 16:48:04 GMT

Hi.

Probably you'll have to check out DOMAIN type.

From SE11 check out your Field Domain.

Here you can see a flag LOWERCASE in the section Output Characteristics (definition). You should activate this.

Hope to help.

BYe

Rob

Re: ALV output error

alessandroieva — Thu, 06 Nov 2014 17:04:55 GMT

Hi,

the only field not valorized that i see is TABLENAME.

are you sure that in your internal table there are the correct values?

could i see your internal table (alv table) before that you call the output?

let me know,

Re: ALV output error

former_member213545 — Thu, 06 Nov 2014 19:14:16 GMT

Hi,

You can define filed type for that field as CHAR18 and convert to lower case.

You can define new domain with same characteristics as MATNR and check box for lowercase.

Create new data element with new domain. Use new data element as type for the field which you want to display.

Santosh

Re: ALV output error

former_member209770 — Fri, 07 Nov 2014 01:50:43 GMT

Hi K.Arun,

Yes, I know it only allowed uppercase, I just wanna sure about that I can't assign lowercase into fieldname. Thanks

Re: ALV output error

former_member209770 — Fri, 07 Nov 2014 02:05:07 GMT

Hi Rob,

After I tick the flag LOWERCASE and activate it, it doesn't work, also get the value from the preceding field...

Any help? Thanks.

Re: ALV output error

former_member209770 — Fri, 07 Nov 2014 02:09:44 GMT

Hi AI,

Yes, it got the correct data that I see on the debug screen .

Re: ALV output error

roberto_vacca2 — Mon, 10 Nov 2014 11:06:47 GMT

Ok. Well there's something not clear in your code. You declare the V_COL variable as local in FORM FIELDS and you use it like a global variable in FORM SET_FIELDS. That shouldn't be declared in such way.

By the way I suggest you this code for your output so you'll not have to configure manual fieldcatalog:

DATA: lr_func TYPE REF TO CL_SALV_FUNCTIONS_LIST.

DATA : lt_columns TYPE REF TO cl_salv_columns_table,

lr_column TYPE REF TO cl_salv_column_table.

DATA: gd_alv_table TYPE REF TO cl_salv_table.

* Create ALV grid instance

TRY.

CALL METHOD cl_salv_table=>factory

* EXPORTING

* LIST_DISPLAY = IF_SALV_C_BOOL_SAP=>FALSE

* R_CONTAINER =

* CONTAINER_NAME =

IMPORTING

r_salv_table = gd_alv_table

CHANGING

t_table = gt_yourtable "YOUR global internal table

"Functions

lr_func = gd_alv_table->get_functions( ).

lr_func->set_all( ).

*- Get all the Columns

lt_columns = gd_alv_table->get_columns( ).

*- Set Column optimization

lt_columns->set_optimize( C_X ).

lr_column ?= lt_columns->get_column( 'MATNR' ).

lr_column->set_lowercase( value = if_salv_c_bool_sap=>true ).

gd_alv_table->display( ).

CATCH cx_salv_msg .

CATCH cx_salv_not_found.

ENDTRY.

Let me know if this can help you.

Bye