topic Re: ALV Export to Excel problem in Application Development and Automation Discussions

ALV Export to Excel problem

Former Member — Sun, 06 Jan 2008 23:29:35 GMT

Hi All

I have a problem with exporting a ALV Grid to Excel. If I add the quantity field to my Grid output the excel spreadsheet does not bring through the quantity field and it puts all the other columns one place out. I tried changing field attributes from QUAN to CHAR field and it made no difference.

I am using the standard sap functionality:

List > Save > Local File > Spreadsheet

It works fine as long as I do not include my quantity column? I have tried many other custom FM's with no luck because all of them require you to put in a internal table inside the function but I do not want to send whole internal table to spreadsheet only the ones selected in the ALV Grid. So please do not suggest function modules as I have had no luck with these!

I need to know how to use the standard sap alv export to excel function with my quantity field? The only issue I can think of that would cause a error would be that I have 50+ columns on the grid and internal table. Even If I put quantity field by itself in the grid then export to excel it brings through the Qty header but no data.

Re: ALV Export to Excel problem

Former Member — Sun, 06 Jan 2008 23:37:34 GMT

Hi Brad,

Can you show your code, specially the quantity field defination and the fieldcatlog.

Regards,

Atish

Re: ALV Export to Excel problem

Former Member — Sun, 06 Jan 2008 23:43:06 GMT

Hi Atish

Quantity is below: (RMNGE)

Data type is QUAN, Length 10, Decimal places 0.

DATA: BEGIN OF I_DATA OCCURS 0.

INCLUDE STRUCTURE ZWRNTHDR.

DATA: POSNR LIKE ZWRNTITM-POSNR, "Sales Document Item

MATNR LIKE ZWRNTITM-MATNR, "Material Number

CLRFL LIKE ZWRNTITM-CLRFL, "Claim Reference Line ID

PCBPN LIKE ZWRNTITM-PCBPN, "PCB Part Number

PCBPX LIKE MAKT-MAKTX, "PCB Part Number Description

RMNGE LIKE ZWRNTITM-RMNGE, "Quantity

MEINS LIKE ZWRNTITM-MEINS, "Base Unit of Measure

WRNTC LIKE ZWRNTITM-WRNTC, "Warranty Claimed

WRNTG(3) TYPE C, "Warranty Given

FLTCD LIKE ZWRNTITM-FLTCD, "Fault Code

MFATE LIKE ZWRNTITM-MFATE, "Module Fate

CMNTS LIKE ZWRNTITM-CMNTS, "Comments

SRIAL LIKE ZWRNTITM-SRIAL, "Serial Number

PFREX LIKE ZWRNTITM-PFREX, "PFR External

PFINT LIKE ZWRNTITM-PFINT, "PFR Internal

RLCRQ LIKE ZWRNTITM-RLCRQ, "Replacement Requested

TCHID LIKE ZWRNTITM-TCHID, "Technician ID

PMATN LIKE ZWRNTITM-PMATN, "Parent Material

PMATX LIKE MAKT-MAKTX, "Parent Material Description

MDLNO LIKE ZWRNTITM-MDLNO, "Module Number

MDLNT LIKE MAKT-MAKTX, "Module Description

CLVFX LIKE ZWRNTITM-CLVFX, "Claim Value FX

CRVFX LIKE ZWRNTITM-CRVFX, "Credit Value FX

CRVLC LIKE ZWRNTITM-CRVLC, "Credit Value Local

XRATE LIKE ZWRNTITM-XRATE, "FX Rate

NAME1 LIKE KNA1-NAME1, "Customer Name

MAKTX LIKE MAKT-MAKTX, "Material Description

CTYPT LIKE DD07T-DDTEXT, "Customer Type Text

BUNTT LIKE DD07T-DDTEXT, "Business Unit Text

FRCRT LIKE DD07T-DDTEXT, "Freight Carrier Text

FLTCT LIKE ZFLTCODES-FDESC, "Fault Code Text

ISRES LIKE ZWRNTITM-ISRES, "Issue Resolved

DCODE LIKE ZWRNTITM-DCODE, "Date Code

ISTAT LIKE ZWRNTITM-ISTAT, "Ignore Stats

LABCL LIKE ZWRNTITM-LABCL, "Labour Claimed

MATCL LIKE ZWRNTITM-MATCL, "Material Claimed

END OF I_DATA.

Field Catalog:

*----

FORM BUILD_ALV_COLUMNS

*----

Build Main Page ALV Fieldcat

*----

FORM BUILD_ALV_COLUMNS.

CLEAR FIELDCAT_LN.

ADD 1 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'KUNNR'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-KEY = 'X'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 2 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'CLMID'.

FIELDCAT_LN-KEY = 'X'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 3 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Claim Type'.

FIELDCAT_LN-FIELDNAME = 'CTYPT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 4 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'CLREF'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 5 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Business Unit'.

FIELDCAT_LN-FIELDNAME = 'BUNTT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 6 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'CURCY'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C500'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 7 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'CHKID'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 8 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'RECVD'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 9 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'APVDT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 10 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'CRDRF'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 11 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'RORDR'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 12 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'RORDD'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 13 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'ARVDT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 14 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'TSTDT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 15 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'TEDDT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 16 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'FSTDT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 17 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'FEDDT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 19 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Freight Carrier'.

FIELDCAT_LN-FIELDNAME = 'FRCRT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 20 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'FRTRF'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 21 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'FRINV'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 22 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'UNAMECR'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 23 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'DATUMCR'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 24 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'UNAMECH'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 25 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'DATUMCH'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 26 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'UNAMEDE'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 27 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTHDR'.

FIELDCAT_LN-FIELDNAME = 'DATUMDE'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 28 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'POSNR'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-KEY = 'X'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 29 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'MATNR'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 30 TO COL_POS.

FIELDCAT_LN-TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'RMNGE'.

FIELDCAT_LN-SELTEXT_L = 'Qty'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 31 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'CLRFL'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 32 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'PCB Part No'.

FIELDCAT_LN-FIELDNAME = 'PCBPN'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 33 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'MEINS'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 34 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'WRNTC'.

FIELDCAT_LN-DO_SUM = SPACE.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 35 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Warranty Given'.

FIELDCAT_LN-FIELDNAME = 'WRNTG'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 36 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'FLTCD'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 37 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'MFATE'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 38 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'CMNTS'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 39 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'SRIAL'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 40 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'PFREX'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 41 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'PFINT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 42 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'RLCRQ'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 43 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'TCHID'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 44 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'PMATN'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 45 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'MDLNO'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 46 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Customer Name'.

FIELDCAT_LN-FIELDNAME = 'NAME1'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-KEY = 'X'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 47 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'MAKT'.

FIELDCAT_LN-FIELDNAME = 'MAKTX'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 48 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Parent Matl Description'.

FIELDCAT_LN-FIELDNAME = 'PMATX'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 49 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'PCB Matl Description'.

FIELDCAT_LN-FIELDNAME = 'PCBPX'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 50 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Fault Code Description'.

FIELDCAT_LN-FIELDNAME = 'FLTCT'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 51 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'CLVFX'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C500'.

FIELDCAT_LN-NO_ZERO = 'X'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 52 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'CRVFX'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-NO_ZERO = 'X'.

FIELDCAT_LN-EMPHASIZE = 'C500'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 53 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'XRATE'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-NO_ZERO = 'X'.

FIELDCAT_LN-EMPHASIZE = 'C500'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 54 TO COL_POS.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'CRVLC'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-NO_ZERO = 'X'.

FIELDCAT_LN-EMPHASIZE = 'C500'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 55 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Module Description'.

FIELDCAT_LN-FIELDNAME = 'MDLNT'.

FIELDCAT_LN-COL_POS = COL_POS.

FIELDCAT_LN-EMPHASIZE = 'C700'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 56 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Iss Resvld'.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'ISRES'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 57 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Date Code'.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'DCODE'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 58 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Ignore Stats'.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'ISTAT'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 59 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Labr Claimed'.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'LABCL'.

APPEND FIELDCAT_LN TO FIELDCAT.

CLEAR FIELDCAT_LN.

ADD 60 TO COL_POS.

FIELDCAT_LN-SELTEXT_L = 'Matl Claimed'.

FIELDCAT_LN-REF_TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'MATCL'.

APPEND FIELDCAT_LN TO FIELDCAT.

ENDFORM. " BUILD_ALV_COLUMNS

Re: ALV Export to Excel problem

Former Member — Sun, 06 Jan 2008 23:49:17 GMT

Hi Brad,

Try this

FIELDCAT_LN-qfieldname " type slis_fieldname, " field with quantity unit

FIELDCAT_LN-qtabname " type slis_tabname, " and table

pass parameter to these fields also while creating fieldcatlog

CLEAR FIELDCAT_LN.

ADD 30 TO COL_POS.

FIELDCAT_LN-TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'RMNGE'.

FIELDCAT_LN-SELTEXT_L = 'Qty'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

Regards,

Atish

Re: ALV Export to Excel problem

Former Member — Mon, 07 Jan 2008 00:05:10 GMT

Hi Atish

I tried the following:

CLEAR FIELDCAT_LN.

ADD 30 TO COL_POS.

FIELDCAT_LN-TABNAME = 'ZWRNTITM'.

FIELDCAT_LN-FIELDNAME = 'RMNGE'.

FIELDCAT_LN-QTABNAME = 'ZWRNTITM'.

FIELDCAT_LN-QFIELDNAME = 'RMNGE'.

FIELDCAT_LN-SELTEXT_L = 'Qty'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

This returned a dump with short text error of - UNIT parameter with WRITE has an unsupported type.

So I tried the following:

CLEAR FIELDCAT_LN.

ADD 30 TO COL_POS.

FIELDCAT_LN-TABNAME = 'ZWRNTITM'.
FIELDCAT_LN-FIELDNAME = 'RMNGE'.

FIELDCAT_LN-QTABNAME = 'ZWRNTITM'.

FIELDCAT_LN-QFIELDNAME = 'RMNGE'.

FIELDCAT_LN-SELTEXT_L = 'Qty'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.

The report ran but the quantity field didn't have the data required.

Do you know what the QTABNAME and QFIELDNAME are used for specifically? Any other ideas? Thanks for your help so far.

Re: ALV Export to Excel problem

Former Member — Mon, 07 Jan 2008 00:14:39 GMT

Hi Brad,

These fields are to refer to the quantity fields.

Just refer it to some standard table and field.

or if you go to SE11 there you have the reference table name (currency/quantity tab).

Regards,

Atish

Re: ALV Export to Excel problem

Former Member — Mon, 07 Jan 2008 00:16:09 GMT

Hi Atish

This is good to know, I have actually solved it myself!

I removed the reference to the table name as below and it solved my problem!

CLEAR FIELDCAT_LN.

ADD 30 TO COL_POS.

FIELDCAT_LN-FIELDNAME = 'RMNGE'.

FIELDCAT_LN-SELTEXT_L = 'Qty'.

FIELDCAT_LN-COL_POS = COL_POS.

APPEND FIELDCAT_LN TO FIELDCAT.