Hi pls help me

[Former Member]

Hi Experts,

Need to some modificatioons ..pls help..

acatually i m learning to use slis function in my code.

w_fldcat-fieldname = 'EKORG'.

w_fldcat-ref_tabname = 'S012'.

w_fldcat-tabname = 'GT_GOODS'.

w_fldcat-col_pos = 1.

i have used this much.

now i need to display 'purachasing oraganisation as heading under ekorg filed.

i mean it shud come

Purchasing organisation

100

101

shud i include sele text functionality..

in the bottom i like o display 'total' result.(which i got)

pls help me

[Former Member]

HI,

see this sample code for totals.

TABLES : vbak.

TYPE-POOLS: slis.                      " ALV Global types

SELECT-OPTIONS :
  s_vkorg FOR vbak-vkorg,              " Sales organization
  s_kunnr FOR vbak-kunnr,              " Sold-to party
  s_vbeln FOR vbak-vbeln.              " Sales document

SELECTION-SCREEN :
  SKIP, BEGIN OF LINE,COMMENT 5(27) v_1 FOR FIELD p_max.
PARAMETERS p_max(2) TYPE n DEFAULT '20' OBLIGATORY.
SELECTION-SCREEN END OF LINE.

DATA:
  BEGIN OF gt_vbak OCCURS 0,
    vkorg LIKE vbak-vkorg,             " Sales organization
    kunnr LIKE vbak-kunnr,             " Sold-to party
    vbeln LIKE vbak-vbeln,             " Sales document
    netwr LIKE vbak-netwr,             " Net Value of the Sales Order
    waerk LIKE vbak-waerk,             " Document currency
  END OF gt_vbak.

*---------------------------------------------------------------------*
INITIALIZATION.

  v_1 = 'Maximum of records to read'.

*---------------------------------------------------------------------*
START-OF-SELECTION.

  PERFORM f_read_data.

  PERFORM f_display_data.

*---------------------------------------------------------------------*
*      Form  f_read_data
*---------------------------------------------------------------------*
FORM f_read_data.

  SELECT * INTO CORRESPONDING FIELDS OF TABLE gt_vbak
           FROM vbak
             UP TO p_max ROWS
          WHERE kunnr IN s_kunnr
            AND vbeln IN s_vbeln
            AND vkorg IN s_vkorg.

ENDFORM.                               " F_READ_DATA
*---------------------------------------------------------------------*
*      Form  f_display_data
*---------------------------------------------------------------------*
FORM f_display_data.

  DEFINE m_fieldcat.
    add 1 to ls_fieldcat-col_pos.
    ls_fieldcat-fieldname   = &1.
    ls_fieldcat-ref_tabname = 'VBAK'.
    ls_fieldcat-do_sum      = &2.
    ls_fieldcat-cfieldname  = &3.
    append ls_fieldcat to lt_fieldcat.
  END-OF-DEFINITION.

  DEFINE m_sort.
    add 1 to ls_sort-spos.
    ls_sort-fieldname = &1.
    ls_sort-up        = 'X'.
    ls_sort-subtot    = &2.
    append ls_sort to lt_sort.
  END-OF-DEFINITION.

  DATA:
    ls_fieldcat TYPE slis_fieldcat_alv,
    lt_fieldcat TYPE slis_t_fieldcat_alv,
    lt_sort     TYPE slis_t_sortinfo_alv,
    ls_sort     TYPE slis_sortinfo_alv,
    ls_layout   TYPE slis_layout_alv.

  m_fieldcat 'VKORG' ''  ''.
  m_fieldcat 'KUNNR' ''  ''.
  m_fieldcat 'VBELN' ''  ''.
  m_fieldcat 'NETWR' 'X' 'WAERK'.
  m_fieldcat 'WAERK' ''  ''.

  m_sort 'VKORG' 'X'.                  " Sort by vkorg and subtotal
  m_sort 'KUNNR' 'X'.                  " Sort by kunnr and subtotal
  m_sort 'VBELN' ''.                   " Sort by vbeln

  ls_layout-cell_merge = 'X'.

  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
       EXPORTING
            is_layout   = ls_layout
            it_fieldcat = lt_fieldcat
            it_sort     = lt_sort
       TABLES
            t_outtab    = gt_vbak.

ENDFORM.                               " F_DISPLAY_DATA

for column text

  afield-seltext_l = 'col_text'.  "long text
  afield-seltext_m = 'col_text'.  "medium text
  afield-seltext_s = 'col_text'.  "short text
  afield-reptext_ddic = 'col_text'."text in datadictionary

rgds,

bharat.

[Former Member]

Hi,

Add one more step ,,,

w_fldcat-fieldname = 'EKORG'.

w_fldcat-ref_tabname = 'S012'.

w_fldcat-tabname = 'GT_GOODS'.

w_fldcat-col_pos = 1.

w_fieldcat-seltext_l = ''purachasing oraganisation '.

Don't forgwet to reward if useful....

[Former Member]

Hi ,

Can u pls telll me hw to adjust the the o/p (column lenaght and widtth as we do in excel..

what functioanlity shud i add using alv

[Former Member]

hi,

do the below mentioned fashion ...

data : ls_layout TYPE slis_layout_alv.

ls_layout-colwidth_optimize = 'X'.

[Former Member]

Hi Santhosh,

Pls help me..

Like i have fount out sum of one filed like this using alv.

w_fldcat-fieldname = 'WEMNG'.

w_fldcat-tabname = 'GT_GOODS'.

w_fldcat-col_pos = 9.

w_fldcat-do_sum = 'X'.

w_fldcat-no_zero = 'X'.

w_fldcat-seltext_s = 'Quantity of Goods Recieved'.

w_fldcat-seltext_l ='Quantity of Goods Recieved'.

w_fldcat-OUTPUTLEN = '30'.

Now in the o/p screen i want to display the word 'total' in the left side of sum waht we got..

what shud i dop?

[Former Member]

hi,

do this way ..

w_fldcat-fieldname = 'EKORG'.
w_fldcat-ref_tabname = 'S012'.
w_fldcat-tabname = 'GT_GOODS'.
w_fldcat-col_pos = 1.
w_fldcat-seltext_s = 'Purchase Org.'.
w_fldcat-seltext_l = 'Purchase Organisation'.

[Former Member]

Hi you hust have to add one more field to the filed catalog..

what ever heading you want you and write there , see the below code..

l_fieldcat-fieldname = 'EKORG'.

l_fieldcat-ref_tabname = 'S012'.

l_fieldcat-tabname = 'GT_GOODS'.

l_fieldcat-col_pos = 1.

l_fieldcat-seltext_s = 'Purchase Org.'. "short

l_fieldcat-seltext_l = 'Purchase Organisation' "long

Hope its helpful