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
Showing results for 
Search instead for 
Did you mean: 

GETWA_NOT_ASSIGNED

Former Member
0 Kudos
272

Hii Expert's,

I have one customized report, it is working fine and i am getting the values properly, but after executing this report, when i am trying to download this data to EXCEL sheet, this report is going to dump and i got this  "GETWA_NOT_ASSIGNED" error. Please give an idea.

Thanks & Regards,

Srikanth.Y,

9632834140.

1 ACCEPTED SOLUTION

basarozgur_kahraman
Contributor
0 Kudos
188

Hi Srikanth,

it sounds like a fieldcatalog error.

To identify problem, in ALV screen go to any blank point in container, while holding ctrl+shift double click mouse right button. You will get "Consistency check of ALV Grid Control" screen.

Make sure there aren't any error messages in List. You should clear warning messages, too.

6 REPLIES 6

sandeep_katoch
Contributor
0 Kudos
188

Hi Srikanth,

During the download there must be a field symbol that has been used.

In case of field symbols whenever they are used they must be assigned some values and if the values are not assigned then it throws dump.

Check the dump by going to st22 and click on editor on left hand side top.

You will come to the point where it is throwing the dump.

Check why not the value is assigned to  field symbol.

Hope it helps.

Rgds,

Sandeep katoch

former_member194152
Contributor
0 Kudos
188

might be field catalog issue, check speeling of each and every field with data type in field catalog, or if possible post piece of code here.

0 Kudos
188

DATA : ref_grid TYPE REF TO cl_gui_alv_grid.

DATA :alv_fieldcat            TYPE slis_t_fieldcat_alv,
       alv_fieldcat_line       LIKE LINE OF alv_fieldcat,
       alv_sort                TYPE slis_t_sortinfo_alv,
       alv_sort_line           LIKE LINE OF alv_sort,
       alv_layout              TYPE slis_layout_alv,
       g_repid                 LIKE sy-repid VALUE sy-repid,
       alv_status_set          TYPE slis_formname VALUE 'ALV_STATUS_SET',
       alv_user_comm           TYPE slis_formname VALUE 'ALV_USER_COMM',
       grid_title              TYPE lvc_title,
       alv_fieldcat_acty       TYPE slis_t_fieldcat_alv,
       g_save,
       gs_variant                LIKE disvariant,
       g_exit_caused_by_caller   TYPE c,
       gs_exit_caused_by_user    TYPE slis_exit_by_user.


DATA: alv_fieldcat_line_acty  LIKE LINE OF alv_fieldcat_acty,
       alv_layout_acty         TYPE slis_layout_alv,
       gt_list_top_of_page     TYPE slis_t_listheader,
       gt_events               TYPE slis_t_event,
       message                 TYPE string,

       r_ucomm     LIKE sy-ucomm,
       rs_selfield TYPE slis_selfield.

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS: s_lifnr  FOR rbkp-lifnr,             "Different Invoicing Party
                 s_budat  FOR rbkp-budat," OBLIGATORY,  "Posting Date
                 s_werks  FOR rseg-werks," OBLIGATORY, " Plant
                 s_txcode FOR rseg-mwskz ,           " Tax codes
                 s_bukrs  FOR rbkp-bukrs." OBLIGATORY NO INTERVALS NO-EXTENSION. " Company code

SELECTION-SCREEN END   OF BLOCK b1.


*&---------------------------------------------------------------------*
*&      Form  DISPLAY_DATA
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM display_data .

   IF git_final IS NOT INITIAL.

     git_display[] = git_final[].

     PERFORM build_alv_layout.
     PERFORM s_sort_build USING alv_sort[].
     PERFORM build_field_catalogs.
     PERFORM eventtab_build CHANGING gt_events.
     g_save = 'A'.

     CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
       EXPORTING
         i_callback_program       = g_repid
         i_callback_pf_status_set = alv_status_set
         i_callback_user_command  = alv_user_comm
         i_grid_title             = grid_title
         i_save                   = g_save
         is_variant               = gs_variant
         is_layout                = alv_layout
         it_fieldcat              = alv_fieldcat[]
         it_events                = gt_events[]
         it_sort                  = alv_sort[]
        IMPORTING
         e_exit_caused_by_caller  = g_exit_caused_by_caller
         es_exit_caused_by_user   = gs_exit_caused_by_user
       TABLES
         t_outtab                 = git_final[].

     PERFORM alv_user_comm USING r_ucomm
                                 rs_selfield.
     IF sy-subrc = 0.
       IF g_exit_caused_by_caller = 'X'.
       ELSE.
         IF gs_exit_caused_by_user-back = 'X'.                 " F3

         ELSE.
           IF gs_exit_caused_by_user-exit = 'X'.             " F15
             LEAVE TO SCREEN 0.
           ELSE.
             IF gs_exit_caused_by_user-cancel = 'X'.         " F12
             ELSE.
             ENDIF.
           ENDIF.
         ENDIF.
       ENDIF.
     ELSE.
*" Fatal error calling ALV
     ENDIF.
   ELSE.
     MESSAGE id 'ZMM' TYPE 'I' NUMBER '000'.
     LEAVE LIST-PROCESSING.
   ENDIF.

ENDFORM.                    " DISPLAY_DATA
*&---------------------------------------------------------------------*
*&      Form  BUILD_ALV_LAYOUT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM build_alv_layout .

   CLEAR alv_layout.
   alv_layout-colwidth_optimize  = 'X'. "always display full columns
   alv_layout-info_fieldname     = 'COLOR'. "color a line
   alv_layout-detail_popup       = 'X'.
   alv_layout-zebra              = 'X'. "Zebra output
ENDFORM.                    " BUILD_ALV_LAYOUT
*&---------------------------------------------------------------------*
*&      Form  S_SORT_BUILD
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->P_ALV_SORT[]  text
*----------------------------------------------------------------------*
FORM s_sort_build  USING lt_sort TYPE slis_t_sortinfo_alv.
   DATA: ls_sort TYPE slis_sortinfo_alv.
   CLEAR  ls_sort.
ENDFORM.                    " S_SORT_BUILD
*&---------------------------------------------------------------------*
*&      Form  BUILD_FIELD_CATALOGS
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM build_field_catalogs .

   CLEAR: alv_fieldcat.
   REFRESH: alv_fieldcat.

*Invoice No
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Vendor Invoice No'.
   alv_fieldcat_line-fieldname  = 'XBLNR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '3'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*LIV Number
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'LIV Number'.
   alv_fieldcat_line-fieldname  = 'BELNR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-hotspot = 'X'.
   alv_fieldcat_line-col_pos  = '1'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*LIV Year
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'LIV year'.
   alv_fieldcat_line-fieldname  = 'GJAHR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '2'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Invoice Date.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Invoice Date'.
   alv_fieldcat_line-fieldname  = 'BLDAT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '4'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Posting date
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Posting date'.
   alv_fieldcat_line-fieldname  = 'BUDAT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '5'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Invoice Line.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Invoice Line'.
   alv_fieldcat_line-fieldname  = 'BUZEI'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '6'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Vendor Code
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Vendor Code'.
   alv_fieldcat_line-fieldname  = 'LIFNR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '7'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.


*Tax Code
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Tax Code'.
   alv_fieldcat_line-fieldname  = 'MWSKZ1'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '8'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Vendor Name
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Vendor Name'.
   alv_fieldcat_line-fieldname  = 'VEND_NAME'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '9'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

**Vendor address
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = 'Vendor address'.
*  alv_fieldcat_line-fieldname  = 'VEND_ADDR'.
*  alv_fieldcat_line-just  = 'C'.
*  alv_fieldcat_line-col_pos  = '10'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.

*TIN No.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'TIN No'.
   alv_fieldcat_line-fieldname  = 'J_1ILSTNO'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '11'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*CST No.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'CST No.'.
   alv_fieldcat_line-fieldname  = 'J_1ICSTNO'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '12'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Basic Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Basic Amount'.
   alv_fieldcat_line-fieldname  = 'WRBTR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '13'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Unit
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Currency'.
   alv_fieldcat_line-fieldname  = 'WAERS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '14'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO No..
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'PO No.'.
   alv_fieldcat_line-fieldname  = 'EBELN'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '15'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO Line.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'PO Line'.
   alv_fieldcat_line-fieldname  = 'EBELP'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '16'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO Order Qty.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'PO Order Qty.'.
   alv_fieldcat_line-fieldname  = 'MENGE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '17'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO UoM.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'PO UoM.'.
   alv_fieldcat_line-fieldname  = 'MEINS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '18'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO Value.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Net PO Value'.
   alv_fieldcat_line-fieldname  = 'NETPR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '19'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO currency.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'PO Currency'.
   alv_fieldcat_line-fieldname  = 'WAERS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '20'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*PO value in LC.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'PO value in LC'.
   alv_fieldcat_line-fieldname  = 'NETWR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '21'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Material Code
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Material Code'.
   alv_fieldcat_line-fieldname  = 'MATNR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '22'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Material Desc
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Material Desc'.
   alv_fieldcat_line-fieldname  = 'MAKTX'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '23'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Plant
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Plant'.
   alv_fieldcat_line-fieldname  = 'WERKS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '24'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*GR Qty.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'GR Qty'.
   alv_fieldcat_line-fieldname  = 'MENGE_105'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '25'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.
******
*GR Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'GR Amount'.
   alv_fieldcat_line-fieldname  = 'GR_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '26'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.


**GR Qty
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = 'GR Qty'.
*  alv_fieldcat_line-fieldname  = 'MENGE'.
*  alv_fieldcat_line-just  = 'C'.
*  alv_fieldcat_line-col_pos  = '24'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.

**GR Amount
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = 'GR Amount'.
*  alv_fieldcat_line-fieldname  = 'WRBTR'.
*  alv_fieldcat_line-just  = 'C'.
*  alv_fieldcat_line-col_pos  = '25'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.

*Currency
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Currency'.
   alv_fieldcat_line-fieldname  = 'CURRENCY'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '27'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*GR Amount in LC
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'GR amount in LC'.
   alv_fieldcat_line-fieldname  = 'AMNT_105'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '28'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Local currency
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Local currency'.
   alv_fieldcat_line-fieldname  = 'LOC_CURRENCY'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '29'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

**103/101/ SES Doc No
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = '103/101/ SES Doc No'.
*  alv_fieldcat_line-fieldname  = 'LFBNR'.
*  alv_fieldcat_line-just  = 'C'.
*  alv_fieldcat_line-col_pos  = '29'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.

******103 Line item number
*****  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*****  alv_fieldcat_line-seltext_l = '103 Line item number'.
*****  alv_fieldcat_line-fieldname  = 'LFPOS'.
*****  alv_fieldcat_line-just  = 'C'.
*****  APPEND alv_fieldcat_line TO alv_fieldcat.
*****  CLEAR alv_fieldcat_line.
*****
******103 Doc year.
*****  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*****  alv_fieldcat_line-seltext_l = '103 Doc year'.
*****  alv_fieldcat_line-fieldname  = 'LFGJA'.
*****  alv_fieldcat_line-just  = 'C'.
*****  APPEND alv_fieldcat_line TO alv_fieldcat.
*****  CLEAR alv_fieldcat_line.

******103 Qty.
*****  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*****  alv_fieldcat_line-seltext_l = '103 Qty'.
*****  alv_fieldcat_line-fieldname  = 'MENGE_103'.
*****  alv_fieldcat_line-just  = 'C'.
*****  APPEND alv_fieldcat_line TO alv_fieldcat.
*****  CLEAR alv_fieldcat_line.
*****
******103 Unit.
*****  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*****  alv_fieldcat_line-seltext_l = '103 Unit'.
*****  alv_fieldcat_line-fieldname  = 'MEINS_103'.
*****  alv_fieldcat_line-just  = 'C'.
*****  APPEND alv_fieldcat_line TO alv_fieldcat.
*****  CLEAR alv_fieldcat_line.

**Movt Type
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = 'Movt Type'.
*  alv_fieldcat_line-fieldname  = 'BWART'.
*  alv_fieldcat_line-just  = 'C'.
*  alv_fieldcat_line-col_pos  = '30'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.

******105 Doc No
*****  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*****  alv_fieldcat_line-seltext_l = '105 Doc No.'.
*****  alv_fieldcat_line-fieldname  = 'BELNR_105'.
*****  alv_fieldcat_line-just  = 'C'.
*****  APPEND alv_fieldcat_line TO alv_fieldcat.
*****  CLEAR alv_fieldcat_line.
*****
******105 Doc year
*****  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*****  alv_fieldcat_line-seltext_l = '105 Doc year'.
*****  alv_fieldcat_line-fieldname  = 'DOC_YR_105'.
*****  alv_fieldcat_line-just  = 'C'.
*****  APPEND alv_fieldcat_line TO alv_fieldcat.
*****  CLEAR alv_fieldcat_line.

*******105 line item
******  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
******  alv_fieldcat_line-seltext_l = '105 line item'.
******  alv_fieldcat_line-fieldname  = 'BUZEI_105'.
******  alv_fieldcat_line-just  = 'C'.
******  APPEND alv_fieldcat_line TO alv_fieldcat.
******  CLEAR alv_fieldcat_line.
******

*Accounting Doc.
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Invoice Accounting Doc'.
   alv_fieldcat_line-fieldname  = 'ACC_DOC'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '30'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Accounting Doc year
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Accounting Doc year'.
   alv_fieldcat_line-fieldname  = 'ACC_DOC_YR'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '31'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Planned delivery cost
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Planned delivery cost'.
   alv_fieldcat_line-fieldname  = 'MWSK2'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '32'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.


*Unplanned delivery cost
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Unplanned delivery cost'.
   alv_fieldcat_line-fieldname  = 'UNPLN_DEL_COST'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '33'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*BED  (Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'BED (Recoverable)'.
   alv_fieldcat_line-fieldname  = 'BED'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '34'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*BED (Non Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'BED (Non Recoverable)'.
   alv_fieldcat_line-fieldname  = 'N_BED'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '35'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*AED  (Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'AED  (Recoverable)'.
   alv_fieldcat_line-fieldname  = 'AED'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '36'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*NAED  (Non Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'NAED (Non Recoverable)'.
   alv_fieldcat_line-fieldname  = 'N_AED'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '37'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*ECESS (Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'ECESS (Recoverable)'.
   alv_fieldcat_line-fieldname  = 'ECESS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '38'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*ECESS (Non Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'NECESS (Non Recoverable)'.
   alv_fieldcat_line-fieldname  = 'NECESS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '39'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*AED  (Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'HECESS (Recoverable)'.
   alv_fieldcat_line-fieldname  = 'HECESS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '40'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*HECESS (Non Recoverable)
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'HECESS (Non Recoverable)'.
   alv_fieldcat_line-fieldname  = 'NHECESS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '41'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*CST Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'CST Amount'.
   alv_fieldcat_line-fieldname  = 'CST_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '42'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*CST Rate
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'CST Rate'.
   alv_fieldcat_line-fieldname  = 'CST_RATE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '43'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Non recoverable CST Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'CST amount'.
   alv_fieldcat_line-fieldname  = 'NCST_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '44'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Non recoverable CST Rate
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'CST Rate'.
   alv_fieldcat_line-fieldname  = 'NCST_RATE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '45'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

* LST Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'LST amount'.
   alv_fieldcat_line-fieldname  = 'LST_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '46'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*LST Rate
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'LST Rate'.
   alv_fieldcat_line-fieldname  = 'LST_RATE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '47'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*VAT non recoverable Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'VAT non recoverable Amount'.
   alv_fieldcat_line-fieldname  = 'VAT_NON_REC_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '48'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*VAT Recoverable amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'VAT Recoverable amount'.
   alv_fieldcat_line-fieldname  = 'VAT_REC_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '49'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*VAT amount total
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'VAT amount total'.
   alv_fieldcat_line-fieldname  = 'VAT_AMNT_TOT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '50'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.


*VAT non recoverable %
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'VAT non recoverable %'.
   alv_fieldcat_line-fieldname  = 'VAT_NON_REC_RATE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '51'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*VAT recoverable %
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'VAT recoverable %'.
   alv_fieldcat_line-fieldname  = 'VAT_REC_RATE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '52'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*VAT rate total
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'VAT rate total'.
   alv_fieldcat_line-fieldname  = 'VAT_RATE_TOT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '53'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Entry tax
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Entry Tax'.
   alv_fieldcat_line-fieldname  = 'ENTRY_TAX'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '54'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Additional VAT
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Additional VAT'.
   alv_fieldcat_line-fieldname  = 'ADDTNL_VAT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '55'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Additional Tax
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Additional Tax'.
   alv_fieldcat_line-fieldname  = 'ADDTNL_TAX'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '56'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Additional tax amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Additional tax amount'.
   alv_fieldcat_line-fieldname  = 'ADDTNL_TAX_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '57'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Service Tax
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Service Tax'.
   alv_fieldcat_line-fieldname  = 'SERVC_TAX'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '58'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Cess Rate
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Cess Rate'.
   alv_fieldcat_line-fieldname  = 'CESS_RATE'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '59'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Cess Amount
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Cess Amount'.
   alv_fieldcat_line-fieldname  = 'CESS_AMNT'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '60'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Service Tax ECESS
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Service Tax ECESS'.
   alv_fieldcat_line-fieldname  = 'SERVC_ECESS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '61'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

*Service Tax HECESS
   alv_fieldcat_line-tabname    = 'GIT_FINAL'.
   alv_fieldcat_line-seltext_l = 'Service Tax HECESS'.
   alv_fieldcat_line-fieldname  = 'SERVC_HECESS'.
   alv_fieldcat_line-just  = 'C'.
   alv_fieldcat_line-col_pos  = '62'.
   APPEND alv_fieldcat_line TO alv_fieldcat.
   CLEAR alv_fieldcat_line.

** Frieght Amount
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = ' Frieght Amount'.
*  alv_fieldcat_line-fieldname  = 'FRT_AMNT'.
*  alv_fieldcat_line-just  = 'C'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.
*
**Loading/Unloading Charges
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = 'Loading/Unloading Charges'.
*  alv_fieldcat_line-fieldname  = 'LOAD_CHRGS'.
*  alv_fieldcat_line-just  = 'C'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.
*
*
**Unplanned cost
*  alv_fieldcat_line-tabname    = 'GIT_FINAL'.
*  alv_fieldcat_line-seltext_l = 'Unplanned cost'.
*  alv_fieldcat_line-fieldname  = 'UNPLND_COST'.
*  alv_fieldcat_line-just  = 'C'.
**  alv_fieldcat_line-emphasize   = 'C300'.
*  APPEND alv_fieldcat_line TO alv_fieldcat.
*  CLEAR alv_fieldcat_line.



ENDFORM.                    " BUILD_FIELD_CATALOGS
*&---------------------------------------------------------------------*
*&      Form  EVENTTAB_BUILD
*&---------------------------------------------------------------------*
*----------------------------------------------------------------------*
FORM eventtab_build  CHANGING lt_events TYPE slis_t_event..

   FIELD-SYMBOLS: <lt_events> LIKE LINE OF lt_events.

   CALL FUNCTION 'REUSE_ALV_EVENTS_GET'
     EXPORTING
       i_list_type     = 0
     IMPORTING
       et_events       = lt_events
     EXCEPTIONS
       list_type_wrong = 1
       OTHERS          = 2.

* Define TOP_OF_PAGE event
   READ TABLE lt_events WITH KEY name = slis_ev_top_of_page
        ASSIGNING <lt_events>.
   IF sy-subrc EQ 0.
     MOVE gc_formname_top_of_page TO <lt_events>-form.
   ENDIF.
ENDFORM.                    " EVENTTAB_BUILD
*&---------------------------------------------------------------------*
*&      Form  ALV_USER_COMM
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM alv_user_comm  USING    r_ucomm     LIKE sy-ucomm
                              rs_selfield TYPE slis_selfield.

*Determine the main component beign viewed
   READ TABLE git_final INTO gwa_final INDEX rs_selfield-tabindex.

   CALL FUNCTION 'GET_GLOBALS_FROM_SLVC_FULLSCR'
     IMPORTING
       e_grid = ref_grid.

   IF ref_grid IS NOT INITIAL.
     CALL METHOD ref_grid->check_changed_data( ).

   ENDIF.

   CASE r_ucomm.

     WHEN '&IC1'.       " single / double click

       CASE rs_selfield-fieldname.
* Display FI document
         WHEN 'BELNR'.
           SET PARAMETER ID 'RBN' FIELD gwa_final-belnr.
           SET PARAMETER ID 'GJR' FIELD gwa_final-gjahr.
           CALL TRANSACTION 'MIR4' AND SKIP FIRST SCREEN.
       ENDCASE.

     WHEN '&F03'.
       LEAVE TO SCREEN 0.

     WHEN '&F15'.
       LEAVE TO SCREEN 0.

     WHEN '&F12'.
       LEAVE  TO SCREEN 0.

*      ENDCASE.
     WHEN 'SAVE'.

       PERFORM save_data.

   ENDCASE.
ENDFORM.                    " ALV_USER_COMM

*&---------------------------------------------------------------------*
*&      Form  TOP_OF_PAGE
*&---------------------------------------------------------------------*
FORM top_of_page.
   REFRESH gt_list_top_of_page.
   CLEAR gt_list_top_of_page.
   PERFORM comment_build USING gt_list_top_of_page.

* Output GSPC logo on report header

   CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
     EXPORTING
       it_list_commentary = gt_list_top_of_page.
*      I_LOGO             = 'GSPC_LOGO'.
ENDFORM.                    "top_of_page
*&---------------------------------------------------------------------*
*&      Form  COMMENT_BUILD
*&---------------------------------------------------------------------*
*----------------------------------------------------------------------*
FORM comment_build  USING   gt_top_of_page TYPE slis_t_listheader.

   DATA: gs_line TYPE slis_listheader.
   CLEAR gs_line.
   gs_line-typ  = 'H'.
   gs_line-info = 'Purchase Register'.
   APPEND gs_line TO gt_top_of_page.

   CLEAR gs_line.
   gs_line-typ  = 'S'.
   gs_line-key  = 'User:'.
   gs_line-info = sy-uname.
   APPEND gs_line TO gt_top_of_page.

   CLEAR gs_line.
   gs_line-typ  = 'S'.
   gs_line-key  = 'Date:'.
   WRITE sy-datum TO gs_line-info MM/DD/YYYY.
   APPEND gs_line TO gt_top_of_page.

   CLEAR gs_line.
   gs_line-typ  = 'S'.
   gs_line-key  = 'Time:'.
   WRITE sy-uzeit TO gs_line-info USING EDIT MASK '__:__:__'.
   APPEND gs_line TO gt_top_of_page.
   CLEAR gs_line.
   gs_line-typ  = 'S'.
   gs_line-key  = ''.
   WRITE ' '.
   APPEND gs_line TO gt_top_of_page.

ENDFORM.                    " COMMENT_BUILD

*&---------------------------------------------------------------------*
*&      Form  alv_status_set
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->RT_EXTAB   text
*----------------------------------------------------------------------*
FORM alv_status_set USING rt_extab TYPE slis_t_extab.
   SET PF-STATUS 'ZSTANDARD' EXCLUDING rt_extab.
ENDFORM.                    "alv_status_set

0 Kudos
188

Type declaration for table - GIT_FINAL?

Also remove "alv_fieldcat_line-just  = 'C'." for field which does not having CHAR and NUMC data type, like Amount and similar kind of field u need to not mention justified.

Regards,

Gagan

basarozgur_kahraman
Contributor
0 Kudos
189

Hi Srikanth,

it sounds like a fieldcatalog error.

To identify problem, in ALV screen go to any blank point in container, while holding ctrl+shift double click mouse right button. You will get "Consistency check of ALV Grid Control" screen.

Make sure there aren't any error messages in List. You should clear warning messages, too.

0 Kudos
188

Yes my problem got resolved. One field not assigned. Thank you for your co-operation...