I an ABAP fresher and getting an error when doing ...

Former Member · ‎09-13-2016

Category ABAP Programming Error

Runtime Errors MESSAGE_TYPE_X

ABAP Program SAPLSLVC

Application Component BC-SRV-ALV

Date and Time 13.09.2016 10:34:29

Error Analysis:

Short text of error message:

Long text of error message:

Technical information about the message:

Message class....... "0K"

Number.............. 000

Variable 1.......... " "

Variable 2.......... " "

Variable 3.......... " "

Variable 4.......... " "

Trigger Location of Runtime Error

Program SAPLSLVC

Include LSLVCF36

Row 2,742

Module type (FORM)

Module Name FILL_DATA_TABLE

Hi people, pls help me on this issue, please let me know if any more details are required.

Regards,

Aditya

former_member196331 · ‎09-13-2016

Where is the code, May i know which lines giving the dump. If observe carefully in dump file it will show us , which source code line is having the problem, just click on that line it will take you to the Source code.

Former Member · ‎09-13-2016

I did that. here's the screenshot of the dump:

the dump isnt occuring in my program.. instead some standard functionality is giving the dump

Former Member · ‎09-13-2016

-Check your fieldname if matching with the fieldcat.

-Check fieldtype if allowed for do sum.

Former Member · ‎09-13-2016

Hi Aditya,

Can you please share the piece of code where you are doing auto sum logic?

This will be helpful.

Regards,

PrAvIn

Former Member · ‎09-13-2016

Pravin S.: Hi Pravin.. following is the peice of code to where I am performing auto sum:

Either ways, when I commented " x_fieldcat-do_sum = 'X'." this statement the dump does not occur but when I click autosum in ALV by clicking the column for which I want the sum, the dump occurs again, I even checked the field for the column and the program, the fields are exactly what they are supposed to be, i.e. a field from DB - bsad-dmbtr.

Elzkie La : I checked both, fieldname as well as fieldtype.

Former Member · ‎09-13-2016

Hi Aditya,

What data type are you using for field DEBIT in it_final internal table?

This sample program BALVST02_GRID will be also helpful. take a look .

Regards,

PrAvIn

raymond_giuseppi · ‎09-13-2016

Obviously wrong field catalog (look in the dump for the fieldname value <ls_fcat>-fieldname described in field catalog and either not existing or not compliant with the actual internal table)

Hint: If you are able to display the ALV without the sum, execute the Consistency Check.

Regards,

Raymond

Former Member · ‎09-13-2016

Raymond Giuseppi::

Hi Raymond, I obviously executed the consistency check, yet no errors but 2 warning msgs, program runs, but only when I do the 'AutoSum' function, the Short Dump occurs again.

raymond_giuseppi · ‎09-13-2016

In the consistency check, what is datatype of this field (in Field Catalog AND in Output Table) if type NUMC, did you check in the layput the field NUMC_TOTAL, else it must be an integer, packed (quantity, amount) or any numeric type not alphabetic...

Former Member · ‎09-13-2016

the datatype of this field which i am referring to is bsad-dmbtr, its exactly same in FieldCatalog and Output table.

Former Member · ‎09-13-2016

Hi Aditya,

Are you still facing an issue? Did you take look in program BALVST02_GRID?

If you still facing an issue, is it poosible you to complete code ?

Regards,

PrAvIn

raymond_giuseppi · ‎09-13-2016

Check in field catalog for the currency code associated to this amount, is this field in the internal table?

Former Member · ‎09-13-2016

Hi PrAvIn s : Thanks a lot for your help, I am comapring my program with the one u suggested..

really appreciate ur suggestion, I would update u if the problem still persists..

Thank you so much,

Regards,

Aditya

lord339 · ‎09-13-2016

Hi,

For currency field we have to pass reference datatype like 'CURR' ,

i tried to fetch the data from BSAD table and display in ALV Grid and Auto-Sum for DMBTR field, it was working fine,

Try once by passing by DATATYPE, check the screen shots

Former Member · ‎09-13-2016

Hi Sharad Pawar: Thank you for ur suggestion, i tried doing that, and yet its giving the same dump.

lord339 · ‎09-13-2016

Hello ADITYA ,

Then once check the fieldcatalog,

Error maybe just bcoz of Fieldcatalog, kindly post the Fieldcatalog code completely

former_member196331 · ‎09-13-2016

Need small information.

Can you disabled that particular column and run the report. and tell me whether it is giving or some other column is giving the dump check it.

Hope you understood.

former_member196331 · ‎09-13-2016

Can you please attache you code here. Then only we can check it easily.

lord339 · ‎09-13-2016

hi,

Actually i tried that one before only.

By commenting that fieldcatalog-Datatype my program is working fine.

Former Member · ‎09-13-2016

NewB To Abap:

hii.. I have checked using the solution you provided and yet the dump occurs when I want sum for another similar column, i.e. Credit, my ALV report gives dump for SUM and SORT function

former_member196331 · ‎09-13-2016

Need Code please.

Former Member · ‎09-13-2016

NewB To Abap

There you go:

*&---------------------------------------------------------------------*

*& Report ZTAT_REPORT

*&

*&---------------------------------------------------------------------*

*&

*&---------------------------------------------------------------------*

REPORT ztat_report.

TYPE-POOLS: slis.

TABLES: bsad,vbrk,kna1.

TYPES: BEGIN OF ty_bsad,

bukrs TYPE bsad-bukrs,

kunnr TYPE bsad-kunnr,

umsks TYPE bsad-umsks,

umskz TYPE bsad-umskz,

augdt TYPE bsad-augdt,

augbl TYPE bsad-augbl,

zuonr TYPE bsad-zuonr,

gjahr TYPE bsad-gjahr,

belnr TYPE bsad-belnr,

buzei TYPE bsad-buzei,

budat TYPE bsad-budat,

bldat TYPE bsad-bldat,

waers TYPE bsad-waers,

xblnr TYPE bsad-xblnr,

blart TYPE bsad-blart,

bschl TYPE bsad-bschl,

shkzg TYPE bsad-shkzg,

dmbtr TYPE bsad-dmbtr,

wrbtr TYPE bsad-wrbtr,

hkont TYPE bsad-hkont,

zfbdt TYPE bsad-zfbdt,

zterm TYPE bsad-zterm,

zbd1t TYPE bsad-zbd1t,

rebzg TYPE bsad-rebzg,

vbeln TYPE bsad-vbeln,

dmbe2 TYPE bsad-dmbe2,

flag TYPE c,

post_date TYPE bsad-budat,

" country TYPE c,

land1 TYPE kna1-land1,

division TYPE mara-spart,

rebzj TYPE bsad-rebzj,

rebzz TYPE bsad-rebzz,

indicator TYPE c,

lv_credit TYPE bsad-dmbtr,

lv_debit TYPE bsad-dmbtr,

ndays TYPE i,

paid_amt TYPE bsad-dmbtr,

wat TYPE p LENGTH 14 DECIMALS 2,

dayxrecp TYPE bsad-dmbtr,

invref TYPE bseg-belnr,

invyear TYPE bseg-gjahr,

invbuzei TYPE bseg-buzei,

invbukrs TYPE bseg-bukrs,

invbudat TYPE bkpf-budat,

inv_amt TYPE bseg-dmbtr,

END OF ty_bsad.

TYPES: BEGIN OF ty_vbrk,

vbeln TYPE vbrk-vbeln,

fkart TYPE vbrk-fkart,

fktyp TYPE vbrk-fktyp,

vbtyp TYPE vbrk-vbtyp,

waerk TYPE vbrk-waerk,

vkorg TYPE vbrk-vkorg,

fkdat TYPE vbrk-fkdat,

belnr TYPE vbrk-belnr,

gjahr TYPE vbrk-gjahr,

kdgrp TYPE vbrk-kdgrp,

zterm TYPE vbrk-zterm,

netwr TYPE vbrk-netwr,

kunrg TYPE vbrk-kunrg,

kunag TYPE vbrk-kunag,

sfakn TYPE vbrk-sfakn,

spart TYPE vbrk-spart,

xblnr TYPE vbrk-xblnr,

zuonr TYPE vbrk-zuonr,

kidno TYPE vbrk-kidno,

vtweg TYPE vbrk-vtweg,

"VKORG TYPE vbrk-vkorg,

END OF ty_vbrk.

TYPES: BEGIN OF ty_kna1,

kunnr TYPE kna1-kunnr,

name1 TYPE kna1-name1,

adrnr TYPE kna1-adrnr,

land1 TYPE kna1-land1,

END OF ty_kna1.

DATA: date1 TYPE d.

DATA: mb_dmbtr TYPE bsad-dmbtr,

mb_wrbtr TYPE bsad-wrbtr,

mb_dmbtr1 TYPE bsad-dmbtr,

mb_dmbtr3 TYPE bsad-dmbtr,

mb_dmbtr4 TYPE bsad-dmbtr.

DATA: it_invoice TYPE TABLE OF ty_bsad,

wa_invoice TYPE ty_bsad,

it_payment TYPE TABLE OF ty_bsad,

wa_payment TYPE ty_bsad,

wa_bsad4 TYPE ty_bsad,

it_output TYPE TABLE OF ty_bsad,

wa_output TYPE ty_bsad,

it_final TYPE TABLE OF ty_bsad,

wa_final TYPE ty_bsad,

it_vbrk TYPE TABLE OF ty_vbrk,

wa_vbrk TYPE ty_vbrk,

it_kna1 TYPE TABLE OF ty_kna1,

wa_kna1 TYPE ty_kna1.

DATA: x_fieldcat TYPE slis_fieldcat_alv,

it_fieldcat TYPE slis_t_fieldcat_alv,

l_layout TYPE slis_layout_alv,

x_events TYPE slis_alv_event,

it_events TYPE slis_t_event,

wa_top TYPE slis_listheader,

it_top TYPE slis_t_listheader.

DATA : invref TYPE bsad-augbl,

invyear TYPE bsad-gjahr,

invbuzei TYPE bsad-buzei,

invbukrs TYPE bsad-bukrs,

invbudat TYPE bsad-budat,

invinv_amt TYPE bsad-dmbtr.

date1 = sy-datum - 1000.

FIELD-SYMBOLS: <wa_invoice> TYPE ty_bsad.

FIELD-SYMBOLS : <wa_final> TYPE ty_bsad.

FIELD-SYMBOLS : <fs_payment1> TYPE ty_bsad.

FIELD-SYMBOLS : <fs_payment2> TYPE ty_bsad.

START-OF-SELECTION.

"" BREAK-POINT.

SELECT *

FROM bsad

INTO CORRESPONDING FIELDS OF TABLE it_invoice

WHERE blart = 'RV' AND budat GE date1 AND budat LE sy-datum

AND kunnr = '0000200167'

AND bukrs = 'SOSL' .

IF it_invoice IS NOT INITIAL.

SELECT *

FROM vbrk

INTO CORRESPONDING FIELDS OF TABLE it_vbrk

FOR ALL ENTRIES IN it_invoice

WHERE vbeln = it_invoice-vbeln.

"ENDIF.

"IF it_vbrk IS NOT INITIAL.

SELECT *

FROM kna1

INTO CORRESPONDING FIELDS OF TABLE it_kna1

FOR ALL ENTRIES IN it_invoice

WHERE kunnr = it_invoice-kunnr.

LOOP AT it_invoice ASSIGNING <wa_invoice>.

READ TABLE it_vbrk INTO wa_vbrk WITH KEY vbeln = <wa_invoice>-vbeln.

IF sy-subrc = 0.

<wa_invoice>-division = wa_vbrk-spart.

ENDIF.

READ TABLE it_kna1 INTO wa_kna1 WITH KEY kunnr = <wa_invoice>-kunnr.

IF sy-subrc = 0.

<wa_invoice>-land1 = wa_kna1-land1.

ENDIF.

ENDLOOP.

"" BREAK-POINT.

SELECT *

FROM bsad

INTO CORRESPONDING FIELDS OF TABLE it_payment

WHERE blart <> 'RV' AND budat GE date1 AND budat LE sy-datum

AND kunnr = '0000200167'

AND bukrs = 'SOSL' .

DATA: flag1 TYPE c.

"" DATA: MB_DMBTR1 TYPE BSAD-DMBTR.

LOOP AT it_invoice INTO wa_invoice.

invref = wa_invoice-belnr.

invyear = wa_invoice-gjahr.

invbuzei = wa_invoice-buzei.

invbukrs = wa_invoice-bukrs.

invbudat = wa_invoice-budat.

wa_invoice-invbudat = invbudat.

invinv_amt = wa_invoice-dmbtr.

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

mb_dmbtr = 0.

IF wa_invoice-shkzg = 'H'.

wa_invoice-lv_credit = wa_invoice-dmbtr.

ELSE.

wa_invoice-lv_debit = wa_invoice-dmbtr.

ENDIF.

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

APPEND wa_invoice TO it_final.

CLEAR: mb_dmbtr.

"" BREAK-POINT.

DO.

" READ TABLE it_bsad1 INTO wa_bsad1 WITH KEY rebzg = invref

"

flag1 = ' '.

LOOP AT it_payment ASSIGNING <fs_payment1> WHERE rebzg = invref AND rebzj = invyear AND rebzz = invbuzei AND flag = ' ' AND bukrs = invbukrs."

IF <fs_payment1>-rebzg NE <fs_payment1>-belnr.

flag1 = 'X'.

invref = <fs_payment1>-belnr.

invyear = <fs_payment1>-gjahr.

invbuzei = <fs_payment1>-buzei.

<fs_payment1>-vbeln = wa_invoice-vbeln.

<fs_payment1>-land1 = wa_invoice-land1.

<fs_payment1>-division = wa_invoice-division.

<fs_payment1>-flag = 'X'.

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""17082016""

IF <fs_payment1>-shkzg = 'H'.

<fs_payment1>-lv_credit = <fs_payment1>-dmbtr.

ELSE.

mb_dmbtr = <fs_payment1>-dmbtr.

ENDIF.

IF mb_dmbtr >= 0.

<fs_payment1>-lv_debit = mb_dmbtr.

ELSE.

ENDIF.

<fs_payment1>-invbudat = invbudat.

<fs_payment1>-inv_amt = invinv_amt.

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""17082016""

APPEND <fs_payment1> TO it_final.

ENDIF.

CLEAR: mb_dmbtr,<fs_payment1>.

ENDLOOP.

IF flag1 = ' '.

EXIT.

ENDIF.

ENDDO.

IF wa_invoice-vbeln IS NOT INITIAL.

LOOP AT it_payment ASSIGNING <fs_payment1> WHERE vbeln = wa_invoice-vbeln.

IF <fs_payment1>-flag NE 'X'.

<fs_payment1>-land1 = wa_invoice-land1.

<fs_payment1>-division = wa_invoice-division.

<fs_payment1>-invbudat = wa_invoice-bldat .

<fs_payment1>-inv_amt = wa_invoice-dmbtr .

APPEND <fs_payment1> TO it_final.

<fs_payment1>-flag = 'X'.

ENDIF.

ENDLOOP.

ENDIF.

CLEAR: mb_dmbtr.

ENDLOOP.

ENDIF.

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""16082016""""""""""""""""""""""""""""""""""""""""

LOOP AT it_final ASSIGNING <wa_final>. "26.8.2016

IF <wa_final>-post_date IS NOT INITIAL.

<wa_final>-ndays = <wa_final>-budat - <wa_final>-invbudat.

<wa_final>-wat = <wa_final>-lv_credit * <wa_final>-ndays / <wa_final>-inv_amt.

ENDIF.

ENDLOOP.

*DATA: mb_dmbtr TYPE bsad-dmbtr,

* mb_wrbtr TYPE bsad-wrbtr,

* mb_dmbtr1 TYPE bsad-dmbtr,

* wa_bsad5 like LINE OF it_bsad.

**LOOP AT it_bsad ASSIGNING <fs_bsad2>."

*loop at it_bsad INTO wa_bsad.

*mb_dmbtr = 0.

*IF wa_bsad-shkzg = 'H'.

* mb_dmbtr = mb_dmbtr + wa_bsad-dmbtr * -1.

* else.

* mb_dmbtr = mb_dmbtr + wa_bsad-dmbtr.

*ENDIF.

*wa_bsad5 = wa_bsad.

*

*IF mb_dmbtr <> 0 .

* IF mb_dmbtr >= 0.

* wa_bsad5-lv_debit = mb_dmbtr.

* else.

* wa_bsad5-lv_credit = mb_dmbtr * -1.

* ENDIF.

*APPEND wa_bsad5 to it_final.

*ENDIF.

*

*ENDLOOP.

"" delete ADJACENT DUPLICATES FROM it_bsad1 COMPARING belnr gjahr.

""""""""""""""""""""""""""""""""""fieldcat""""""""""""""""""""""""""""""""""""""

x_fieldcat-fieldname = 'LAND1' ."country divison postoing date, doc noo comp code invoce no amount debit/credit indicator

x_fieldcat-seltext_l = 'Country'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 1.

x_fieldcat-outputlen = '9'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'Division'.

x_fieldcat-seltext_l = 'Division'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 2.

x_fieldcat-outputlen = '9'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'BUKRS'.

x_fieldcat-seltext_l = 'Comp.Code'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 3.

x_fieldcat-outputlen = '9'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'GJAHR'.

x_fieldcat-seltext_l = 'Year'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 4.

x_fieldcat-outputlen = '7'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'BELNR'.

x_fieldcat-seltext_l = 'Doc No'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 5.

x_fieldcat-outputlen = '11'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'BUZEI'.

x_fieldcat-seltext_l = 'Line item'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 6.

x_fieldcat-outputlen = '7'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'BUDAT'.

x_fieldcat-seltext_l = 'Payment Date'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 7.

x_fieldcat-outputlen = '11'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'BLART'.

x_fieldcat-seltext_l = 'Doc. Type'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 8.

x_fieldcat-outputlen = '11'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'POSTDT'.

x_fieldcat-seltext_l = 'Posting Date'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 9.

x_fieldcat-outputlen = '11'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'VBELN'.

x_fieldcat-seltext_l = 'Order No.'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 10.

x_fieldcat-outputlen = '11'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

*x_fieldcat-fieldname = 'SHKZG'.

*x_fieldcat-seltext_l = 'D/C Indicator'.

*x_fieldcat-tabname = 'IT_FINAL'.

*x_fieldcat-col_pos = 11.

*x_fieldcat-outputlen = '11'.

*x_fieldcat-emphasize = 'C411'.

*APPEND x_fieldcat TO it_fieldcat.

*CLEAR x_fieldcat.

x_fieldcat-fieldname = 'AUGBL'.

x_fieldcat-seltext_l = 'Clearing Doc. No.'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 12.

x_fieldcat-outputlen = '11'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'LV_DEBIT'.

x_fieldcat-seltext_l = 'DEBIT'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 13.

x_fieldcat-outputlen = '25'.

x_fieldcat-emphasize = 'C411'.

x_fieldcat-datatype = 'CURR'.

* x_fieldcat-do_sum = 'X'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'LV_CREDIT'.

x_fieldcat-seltext_l = 'CREDIT'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 14.

x_fieldcat-outputlen = '25'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'NDAYS'.

x_fieldcat-seltext_l = 'No. of Days'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 15.

x_fieldcat-outputlen = '7'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

x_fieldcat-fieldname = 'WAT'.

x_fieldcat-seltext_l = 'Weighted Avg. TAT'.

x_fieldcat-tabname = 'IT_FINAL'.

x_fieldcat-col_pos = 16.

x_fieldcat-outputlen = '7'.

x_fieldcat-emphasize = 'C411'.

APPEND x_fieldcat TO it_fieldcat.

CLEAR x_fieldcat.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

* I_INTERFACE_CHECK = ' '

* I_BYPASSING_BUFFER = ' '

* I_BUFFER_ACTIVE = ' '

I_callback_program = sy-repid

* I_CALLBACK_PF_STATUS_SET = ''

* I_CALLBACK_USER_COMMAND = ''

* I_CALLBACK_TOP_OF_PAGE = ''

* I_CALLBACK_HTML_TOP_OF_PAGE = ' '

* I_CALLBACK_HTML_END_OF_LIST = ' '

* I_STRUCTURE_NAME =

* I_BACKGROUND_ID = ' '

* I_GRID_TITLE =

* I_GRID_SETTINGS =

is_layout = l_layout

it_fieldcat = it_fieldcat

* IT_EXCLUDING =

* IT_SPECIAL_GROUPS =

* IT_SORT =

* IT_FILTER =

* IS_SEL_HIDE =

i_default = 'X'

i_save = 'A'

* IS_VARIANT =

* IT_EVENTS =

* IT_EVENT_EXIT =

* IS_PRINT =

* IS_REPREP_ID =

* I_SCREEN_START_COLUMN = 0

* I_SCREEN_START_LINE = 0

* I_SCREEN_END_COLUMN = 0

* I_SCREEN_END_LINE = 0

* I_HTML_HEIGHT_TOP = 0

* I_HTML_HEIGHT_END = 0

* IT_ALV_GRAPHICS =

* IT_HYPERLINK =

* IT_ADD_FIELDCAT =

* IT_EXCEPT_QINFO =

* IR_SALV_FULLSCREEN_ADAPTER =

* IMPORTING

* E_EXIT_CAUSED_BY_CALLER =

* ES_EXIT_CAUSED_BY_USER =

TABLES

t_outtab = it_final

EXCEPTIONS

program_error = 1

OTHERS = 2

.

IF sy-subrc <> 0.

* Implement suitable error handling here

ENDIF.

Former Member · ‎09-13-2016

Hi Aditya,

In your IT_FINAL table you have around 45 fields and but only for 16 fields you have defined fieldcatlog.

Regards,

PrAvIn

Former Member · ‎09-13-2016

PrAvIn s.

Hi, tried implementing.. i am getting an error saying "Desired operation cannot be performed for column 'DEBIT'"

Following is the output

raymond_giuseppi · ‎09-13-2016

left aligned, etc. doesn't look like a numeric field...

When manually defining the field catalog you MUST provide at least either

FIELDNAME, REF_TABLE and REF_FIELD
FIELDNAME, INTTYPE, OUTPUTLEN, COLTEXT and SELTEXT

Doesn't seem the case, so ALV consider your field as CHAR...

Regards,

Raymond

former_member209525 · ‎09-13-2016

Hi Aditya,

While creating fieldcatalog, I found 2 places where code change may required. When using do_sum or sort, field name should be as it is. You missed to capatalized one field name.

x_fieldcat- fieldname = 'DIVISION'.

Also there is no fieldname found as POSTDT. I guess that should be POST_DATE.

Kindly do the changes and revert.

Regards,

Shivangi

Former Member · ‎09-13-2016

Shivangi Vyas: Hi Shivangi, you have actually resolved my problem, the report is working perfectly fine now, and it can be moved to production, thank you so much.

Regards,

Aditya Parakh

Chintu6august · ‎09-13-2016

Hi,

You just debugging and check whether field catalog table is populating correctly with correct data.

thank you!!

Former Member · ‎09-13-2016

Thank you so much Guys for all your suggestions, very much appreciated!

Regards,

Aditya Parakh

I an ABAP fresher and getting an error when doing autosum, need help over this issue