topic problem with quantity field in an alv while displaying in Application Development and Automation Discussions

problem with quantity field in an alv while displaying

Former Member — Fri, 24 Jun 2011 08:57:40 GMT

Hi eveyone,

I have one problem with quantity field in my ALV grid. I have ERFMG & Unit of measure fields in my ALV grid. ERFMG is of type QUAN 13 data type. My problem is while displaying ALV grid, if UOM is Meters, i have to display quantity in 3 decimal places and is UOM is in EA or PCS i have to display quantity field as Integer i.e without any decimal places.

Is there any FM to convert this?

Can anyone help me.

Re: problem with quantity field in an alv while displaying

Former Member — Fri, 24 Jun 2011 09:01:16 GMT

Hi,

Make the quantity field in the ALV output as character field. Depending on the UOM move it to the respective local variables and move it back to the final character field.

Regards,

Ram

Re: problem with quantity field in an alv while displaying

Venkat_Sesha — Fri, 24 Jun 2011 09:23:35 GMT

Hey You can check this out.

OIB_QCI_CONVERSION_SIMPLE

Note: If you are using ecc5.0 then this will not....

Regards,

Bhargav

Re: problem with quantity field in an alv while displaying

Former Member — Fri, 24 Jun 2011 17:16:25 GMT

The quantity field and the Unit have to be linked properly in the fieldcatalog for the ALV to display the quantity field value properly. Refer below...


* Quantity field - QUAN
Clear K_Fieldcat.
Add 1 to V_Pos.
K_Fieldcat-col_pos	= V_Pos.
K_Fieldcat-fieldname	= 'LFIMG'.
K_Fieldcat-qfieldname	= 'VRKME'.         " Quantity field
K_Fieldcat-quantity	= 'X'.
K_Fieldcat-qtabname	= 'I_RECORDS'.
K_Fieldcat-seltext_m	= 'Dlv. qty.'.
K_Fieldcat-ddictxt	= 'M'.
K_Fieldcat-outputlen	= 17.
Append K_Fieldcat to I_Fieldcat.

* Unit key for QUAN field - UNIT
Clear K_Fieldcat.
Add 1 to V_Pos.
K_Fieldcat-col_pos	= V_Pos.
K_Fieldcat-fieldname	= 'VRKME'.
K_Fieldcat-tabname	= 'I_RECORDS'.
K_Fieldcat-reptext_ddic = 'SU'.
K_Fieldcat-outputlen	= 3.
Append K_Fieldcat to I_Fieldcat.
Add 1 to V_Pos.

Re: problem with quantity field in an alv while displaying

Former Member — Sat, 22 Oct 2011 04:55:26 GMT

HELLOW,

i am using alv grid to display MM data , in query i m doing sum for qnty (LMNGA), i need to display that sum in other couimn , i tried but it display only 0.00 , my query and code is below, i relly thanks ful for help .

SELECT A~ARBID

A~BUDAT

A~WERKS

SUM( A~LMNGA ) -- I m displaying this field in alv grid

A~AUFNR

B~KDAUF

B~KDPOS

C~VBELN

C~KUNNR

D~NAME1

E~MATNR

F~KDKG1

INTO CORRESPONDING FIELDS OF TABLE i_alv

FROM AFRU AS A INNER JOIN AUFK AS B ON A_{AUFNR EQ B}AUFNR

INNER JOIN VBAK AS C ON B_{KDAUF = C}VBELN

INNER JOIN KNA1 AS D ON C_{KUNNR = D}KUNNR

INNER JOIN VBAP AS E ON B_{KDAUF = E}VBELN

INNER JOIN VBKD AS F ON B_{KDAUF = F}VBELN

WHERE A_{ARBID = '10000181' AND A}BUDAT BETWEEN PONO AND jobno

GROUP BY A_{ARBID A}BUDAT A_{WERKS A}AUFNR B_{KDAUF F}KDKG1 E_{MATNR D}NAME1 C_{KUNNR C}VBELN B~KDPOS

ORDER BY B~KDPOS

displaying the alv grid

FORM get_fieldcatalog.

DATA: ls_fcat TYPE lvc_s_fcat.

REFRESH: fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'ObjectID'.

ls_fcat-fieldname = 'ARBID'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-NO_OUT = 'X'.

ls_fcat-outputlen = '18'.

ls_fcat-fix_column = 'X'.

ls_fcat-key = 'X'.

ls_fcat-col_pos = '1'.

REFRESH: fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'ProductionOrderNo'.

ls_fcat-fieldname = 'AUFNR'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '15'.

ls_fcat-col_pos = '2'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'SalesOrder'.

ls_fcat-fieldname = 'KDAUF'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '10'.

ls_fcat-col_pos = '3'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'CustomerName'.

ls_fcat-fieldname = 'NAME1'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '25'.

ls_fcat-col_pos = '4'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'MaterialCode'.

ls_fcat-fieldname = 'MATNR'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '25'.

ls_fcat-col_pos = '5'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'KVA'.

ls_fcat-fieldname = 'KDKG1'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '08'.

ls_fcat-col_pos = '6'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'Qnty'.

ls_fcat-fieldname = 'LMNGA'. this is the field which shows 0.00

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '08'.

ls_fcat-col_pos = '7'.

ls_fcat-DO_SUM = 'X'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ls_fcat-reptext = 'PostingDate'.

ls_fcat-fieldname = 'BUDAT'.

ls_fcat-ref_table = 'I_ALV'.

ls_fcat-outputlen = '10'.

ls_fcat-fix_column = 'X'.

ls_fcat-key = 'X'.

ls_fcat-col_pos = '8'.

ls_FCAT-DATATYPE = 'DATS'.

ls_FCAT-INTTYPE = 'D'.

ls_FCAT-INTLEN = '000008'.

ls_FCAT-DD_OUTLEN = '000010'.

APPEND ls_fcat TO fieldcat. CLEAR: ls_fcat.

ENDFORM.