Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error in ALV output

Go to solution
Former Member

‎11-23-2008 6:50 AM

0 Kudos

Hi All,

I am getting a runtime error in output while i try to do sum in ALV output.

In my ouput table i want to do sum for below feilds those are defined in output table :

CURR TYPE P DECIMALS 2,

B30 TYPE P DECIMALS 2,

B60 TYPE P DECIMALS 2,

B90 TYPE P DECIMALS 2,

B120 TYPE P DECIMALS 2,

BG121 TYPE P DECIMALS 2,

i defined feildcatalog as below:

WA_FIELDCAT-FIELDNAME = 'B60'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-033.

WA_FIELDCAT-DO_SUM = 'X' .

WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

even if i try to download the ouput feilds in file,then also i am getting a run time error as field symbols are not assign,

Please help.

Thanks and Regards,

Mohit

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎11-24-2008 6:52 AM

0 Kudos

Instead of 'DEC' u can WRITE WA_FIELDCAT-DATATYPE = 'P'.

6 REPLIES 6

Go to solution
former_member212653
Active Contributor

‎11-23-2008 8:04 AM

0 Kudos

Looks like there is a problem in the field-catalog. Check out the following link.

http://help.sap.com/saphelp_erp2004/helpdata/en/22/a3f5fed2fe11d2b467006094192fe3/frameset.htm

Go to solution
Former Member

‎11-23-2008 9:27 AM

0 Kudos

Hi

maybe you can try

WA_FIELDCAT-FIELDNAME = 'B60'.
WA_FIELDCAT-SELTEXT_L = TEXT-033.
WA_FIELDCAT-DO_SUM = 'X' .
APPEND WA_FIELDCAT TO IT_FIELDCAT.
CLEAR WA_FIELDCAT.

Go to solution
Former Member
In response to Former Member

‎11-24-2008 6:10 AM

0 Kudos

Hi ,

I have already tried this option.But it doesn't work.

Please help.

Thanks

Mohit

Go to solution
Former Member
In response to Former Member

‎11-24-2008 6:37 AM

0 Kudos

Hi,

I am getting a dump that cause of by a message type (X).Same i get if i try to download the file.

My ouput internal table is as below:

data:BEGIN OF IT_FINAL occurs 0,

BUKRS TYPE BUKRS, "Company code

KUNNR TYPE KUNNR, "Customer number

NAME1 TYPE NAME1, "Name

BILL_TO TYPE KUNNR, "Bill To

BILL_NAME TYPE NAME1, "Bill To Name

BRANCH TYPE FILKD, "Branch

BRANCH_NAME TYPE NAME1, "Branch Name

BRANCH_REGION TYPE REGIO, "Region

BRANCH_CITY TYPE ORT01, "City

BELNR TYPE BELNR, "Accounting Document Number

ACC_CLK_SOLD TYPE BUSAB, "A/C Clerk Sold To

ACC_CLK_SOLD_NAME TYPE SNAME, "A/C Name

ACC_CLK_PAYER TYPE BUSAB, "A/C Payer

ACC_CLK_PAYER_NAME TYPE BUSAB, "A/C Payer Name

ASM_PART TYPE KUNN2, "ASM Partner

ASM_NAME TYPE NAME1, "ASM Name

DUNNING TYPE BUSAB, "Dunning Clerk

KATR4 TYPE KATR4, "Local /National Account

ZUONR TYPE DZUONR, "Assingment Number

REFERENCE TYPE XBLNR, "Reference

XREF1 TYPE XREF1, "Ref Key1

XREF2 TYPE XREF2, "Ref Key2

XREF3 TYPE XREF3, "Ref Key3,

SGTXT TYPE SGTXT, "Item Text

DUE_DATE TYPE SY-DATUM, "Due Date

DOC_DATE TYPE BLDAT, "Doc Date

BILL_DOC_NO TYPE VBELN, "Billing Doc Number

ZTERM TYPE DZTERM, "Terms

HKONT TYPE HKONT, "Gl Account

CURR TYPE P DECIMALS 2, "Current Balance

B30 TYPE P DECIMALS 2, "1-30

B60 TYPE P DECIMALS 2, "32-60

B90 TYPE P DECIMALS 2, "61-90

B120 TYPE P DECIMALS 2, "91-120

BG121 TYPE P DECIMALS 2, " >121

BAL TYPE p DECIMALS 2, "Balance

P_CURR TYPE CHAR10, "Current Percentage

PB30 TYPE CHAR10, "1-30 %

PB60 TYPE CHAR10, "32-60 Percentage

PB90 TYPE CHAR10, "61-90 Percentage

PB120 TYPE CHAR10, "91-120 Percentage

PBG121 TYPE CHAR10, ">121 %

END OF it_final..

My fieldcatalog is below:

WA_FIELDCAT-FIELDNAME = 'BUKRS'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-004.

WA_FIELDCAT-OUTPUTLEN = 12.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'KUNNR'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-005.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'NAME1'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-006.

WA_FIELDCAT-OUTPUTLEN = 30.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BILL_TO'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-007.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BILL_NAME'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-008.

WA_FIELDCAT-OUTPUTLEN = 30.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BRANCH' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-009.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BRANCH_NAME' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-043.

WA_FIELDCAT-OUTPUTLEN = 30.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BRANCH_REGION'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-010.

WA_FIELDCAT-OUTPUTLEN = 8.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BRANCH_CITY'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-011.

WA_FIELDCAT-OUTPUTLEN = 12.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BELNR' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-012.

WA_FIELDCAT-OUTPUTLEN = 11.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ACC_CLK_SOLD' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-013.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ACC_CLK_SOLD_NAME'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-014.

WA_FIELDCAT-OUTPUTLEN = 30.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ACC_CLK_PAYER' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-015.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ACC_CLK_PAYER_NAME'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-016.

WA_FIELDCAT-OUTPUTLEN = 30.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ASM_PART'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-017.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ASM_NAME'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-018.

WA_FIELDCAT-OUTPUTLEN = 30.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'DUNNING' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-019.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'KATR4'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-020.

WA_FIELDCAT-OUTPUTLEN = 2.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ZUONR'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-044.

WA_FIELDCAT-OUTPUTLEN = 18.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'REFERENCE'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-021.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'XREF1' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-022.

WA_FIELDCAT-OUTPUTLEN = 12.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'XREF2' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-023.

WA_FIELDCAT-OUTPUTLEN = 12.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'XREF3' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-024.

WA_FIELDCAT-OUTPUTLEN = 12.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'SGTXT'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-025.

WA_FIELDCAT-OUTPUTLEN = 50.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'DUE_DATE'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-026.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'DOC_DATE'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-027.

WA_FIELDCAT-OUTPUTLEN = 10.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BILL_DOC_NO'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-028.

WA_FIELDCAT-OUTPUTLEN = 15.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'ZTERM'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-029.

WA_FIELDCAT-OUTPUTLEN = 5.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'HKONT'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-030.

WA_FIELDCAT-OUTPUTLEN = 11.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'CURR'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-031.

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DO_SUM = 'X' .

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'B30'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-032.

WA_FIELDCAT-DO_SUM = 'X' .

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'B60'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-033.

WA_FIELDCAT-DO_SUM = 'X' .

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'B90'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-034.

WA_FIELDCAT-DO_SUM = 'X' .

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'B120'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-035.

WA_FIELDCAT-DO_SUM = 'X' .

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BG121'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-036.

WA_FIELDCAT-DO_SUM = 'X' .

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'BAL'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-045.

WA_FIELDCAT-DO_SUM = 'X' .

  • WA_FIELDCAT-OUTPUTLEN = 17.

WA_FIELDCAT-DATATYPE = 'DEC'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'P_CURR'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-037.

WA_FIELDCAT-OUTPUTLEN = 17.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'PB30'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-038.

WA_FIELDCAT-OUTPUTLEN = 17.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'PB60'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-039.

WA_FIELDCAT-OUTPUTLEN = 17.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'PB90'.

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-040.

WA_FIELDCAT-OUTPUTLEN = 17.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'PB120' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-041.

WA_FIELDCAT-OUTPUTLEN = 17.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

WA_FIELDCAT-FIELDNAME = 'PBG120' .

WA_FIELDCAT-TABNAME = 'IT_FINAL'.

WA_FIELDCAT-SELTEXT_L = TEXT-042.

WA_FIELDCAT-OUTPUTLEN = 17.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

Please help.

Thanks

Mohit

Go to solution
Former Member

‎11-24-2008 6:12 AM

0 Kudos

HI.

The TRY block contains the application coding whose exceptions are to be handled. This statement block is processed sequentially. It can contain further control structures and calls of procedures or other ABAP programs.

Refer this program:DEMO_HANDLE_EXCEPTIONS

Regards.

Jay

Go to solution
Former Member

‎11-24-2008 6:52 AM

0 Kudos

Instead of 'DEC' u can WRITE WA_FIELDCAT-DATATYPE = 'P'.