topic Re: Reports in Application Development and Automation Discussions

Reports

Former Member — Fri, 22 Jun 2007 10:32:38 GMT

HI Experts,

Few dasy bck I have joined a comany. company comes in Manufacturing industry, making fertilizers. as an ABAP Consultant, I deals with all SAP Developments for company reports. I need to know what types of reports or smartforms programs (PO, Invoice etc. ) required to develop, which help the company grow better. Kindly tell me some other thing that I have to keep in mind for better prospects.

Thanks,Khan

Re: Reports

Former Member — Fri, 22 Jun 2007 10:43:21 GMT

Hi Khan,

Report for PO and Invoice, it is better to use Smartforms because you can take printouts of your PO's and Invoice's by using Smartform Reports.

To see the data of PO issued or Invoices created on the system for a particular vendor or a particular material, use ALV Report for the same, in this you can download your data in file (Excel, Doc, Txt etc.).

Regards,

Sandeep Kaushik

Re: Reports

che_eky — Fri, 22 Jun 2007 10:58:25 GMT

Hi,

These will definately help the company grow better (probably):

000 /BEV1/EMLADELIST EN DE Translate Load list

000 /BEV1/EMLGSALDO EN DE Translate Empties balance

000 /BEV1/EMRVDNOTE EN DE Translate Delivery note

000 /BEV1/EMRVDNOTE2 EN DE Translate Delivery note

000 /BEV1/EMRVINVOI EN DE Active Invoice

000 /BEV1/EMRVINVOI1 EN DE Translate Invoice

000 /BEV1/EMRVORDER1 EN DE Translate Order confirmation

000 /BEV1/VDINVOICE1 EN DE Active Delivery note valued

000 /BEV1/VD_BEWLIEF EN DE Active Delivery Note

000 /BEV3/CH14ACST03 EN DE Active Acct stmnt for days in arrs

000 /BEV3/CH14ACSTV1 EN DE Active Acc. statement w/o CH Contr.

000 /BEV3/CH14ACSTV2 EN DE Active Account statement/CH Contracts

000 /BEV3/CHA_TEST EN DE Active Contract abstract

000 /BEV3/CHFIKNTSL EN DE Translate Example (documentation)

000 /BEV3/CHFIKONT EN DE Active Example (Documentation)

000 /BEV3/CHRVINVCE1 EN DE Translate Invoice

000 /BEV3/CHVRTAUSZG EN DE Active Contract abstract

000 /BEV3/CHVTRAUSZG EN DE Active Contract Statement

000 /BEV4/PLPANSCHR EN DE Active Letter Pendulum List

000 /BEV4/PLPANSCHRO EN DE Active Letter pendulum list

000 /BEV4/PLPPLISTE EN DE Translate Pendulum list

000 /CWM/INVENT EN DE Translate Physical Inventory Document

000 /CWM/MR_PR_KONSI EN DE Active Inv.Verif.: ERS, Consi, Reval

000 /CWM/WASCHEIN EN DE Translate Goods Issue Slip

000 /CWM/WASCHEINV1 EN DE Translate Goods Issue Slip

000 /CWM/WASCHEINV2 EN DE Translate Goods Issue Slip

000 /CWM/WESCHEINV2 EN DE Translate Goods Receipt Slip Version 2

000 /CWM/WESCHEINV2 ES DE Translate Vale entrada mercancías vers.2

000 /CWM/WEVERS1 ES DE Translate Vale entrada mercancías CWM

000 /CWM/WEVERS1 EN DE Translate CWM Goods Receipt Slip

000 /ISDFPS/LM_ACC_C EN DE Translate Aircraft accident - cover page

000 /ISDFPS/LM_ACC_E EN DE Translate LM: Air. accident - Print equi

000 /ISDFPS/LM_ACC_F EN DE Translate LM: Air. accident - Print FL

000 /ISDFPS/LM_ACC_H EN DE Translate LM: Air. accident - Print eq.h

000 /ISDFPS/LM_ACC_M EN DE Translate LM: Air. accident - Meas. docs

000 /ISDFPS/LM_ACC_N EN DE Translate LM: Air. accident - Print CONF

000 /ISDFPS/LM_ACC_O EN DE Translate LM: Air. accident - Print ORD.

000 /ISDFPS/LM_ACC_Z EN DE Translate Air. accident - back banner pg

000 /NFM/MEDRUCK EN DE Translate Purchase Orders with NF Metals

000 /NFM/RVINVOICE01 EN DE Translate Invoice with NF Metals

000 /NFM/RVORDER01 EN DE Translate NF Metal Order Confirmation

000 /SAPNEA/J_SC_01 EN EN Active PO for Subcontracing Materials

000 /SAPNEA/J_SC_02 EN EN Active Subcontractor list

000 /SAPNEA/J_SC_03 EN EN Active Notification of payment term

000 /SAPNEA/J_SC_04 EN EN Active Delivery note for Subcon.

000 /SAPNEA/J_SC_05 EN EN Active Delivery note for Subcon.

000 /SAPNEA/J_SC_06 EN EN Active Price list of char.components

000 /VSO/B_LOADLIST EN DE Active Shipping Document (Sample)

000 /VSO/P_LVSLABELS EN DE Active Picking Labels

000 /VSO/P_LVSTALIST EN DE Active Print Transfer Order List

000 AD23_ATTACH EN EN Active RRB/RRQ document attachment

000 AD23_FRONT EN EN Active RRB/RRQ document front page

000 ANNAHMEANORDNUNG EN DE Translate Acceptance Request

000 APPRAISAL01 EN DE Active Request Appraiser

000 ASSORTMENT_LIST EN DE Active

000 AUSZAHLANORDNUNG EN DE Translate Payment Requests

000 AUTO_GARAGE EN DE Active Notice of Loss Form

000 AUTO_LPA_DRUCK EN DE Active JIT Calls

000 BE_MEDRUCK DE EN Active

000 BE_MEDRUCK EN EN Active Purchase order form (Belgium)

000 BE_MEDRUCK FR EN Active

000 BE_MEDRUCK NL EN Active

000 BKKCHEQUE_BLOCK EN DE Active Notification: Check lock

000 BKK_KONTOAUSZUG EN DE Active Bank Statement

000 BKK_SALDEN EN DE Translate Balance Notification

000 BORGR_UNLOAD_LST DE DE Active Entladeliste Automotive

000 BORGR_UNLOAD_LST EN DE Translate Automotive Unloading List

000 BVTEST03 DE EN Active Test

000 BVTEST03 EN EN Active test:do not translate(english)

000 BV_TEST_01 EN DE Active test rstxr3tr ENGLISH

000 BV_TEST_02 EN DE Translate Last transport and translation

000 CLAIM_CLOSE EN DE Active Notice of loss form

000 CLAIM_FREETEXT EN DE Active Claim Notification Form

000 CLAIM_OPEN EN DE Active Notice of loss form

000 CLAIM_SUBRO EN DE Active Notice of loss form

000 CLAIM_SUBROINT EN DE Active Claim Notification Form

000 CLAIM_THIRDPARTY EN DE Active Notice of loss form

000 CLM_NOTIF_OVERVW EN DE Translate Claim Overview

000 CLM_REPLY01 PT DE Active Claim: enviar aviso

000 CLM_REPLY01 ES DE Translate Reclamación: Enviar decisión

000 CLM_REPLY01 CA DE Translate Reclamació: Enviar avís

000 CLM_REPLY01 EN DE Translate Claim: Send Decision

000 CLM_REPLY01 FR DE Translate Réclamation : envoyer avis

000 CL_DUNN_01 EN DE Translate Dunning Form for Loans

000 COM_NOTE EN DE Active Commission documentation

000 CONTROLCYCLE EN DE Translate Control Cycle Printout Form

000 CO_ORDER_ALL EN DE Translate CO: Order master data

000 CO_ORDER_KURZ EN DE Translate CO: Master data

000 CO_ORDER_LANG EN DE Translate CO: Order Master Data

000 DAUERANORDNUNG EN DE Translate Standing Requests

000 DDS_COVER_HTP EN DE Translate Cover sheet

000 DDS_COVER_ITS EN DE Translate Cover sheet

000 DDS_COVER_ORI EN DE Translate Cover sheet

000 DDS_COVER_PAGE EN DE Translate Cover sheet

000 DDS_COVER_PLO EN DE Translate Cover sheet

000 DDS_RECEIPT EN DE Translate Cover sheet

000 DMEE_CH_EZAG EN DE Translate EPO/DD (Switzerland)

000 DQLJ0 DE EN Active

000 DQLJ0 EN EN Active SI lost application

Keep in mind positive thoughts and a piece of coal in your pocket for better prospects.

Re: Reports

Former Member — Fri, 22 Jun 2007 11:04:19 GMT

Hi Khan ...

i am sending you one report which is list of the purchase order in ALV ... and it is also al drilldown report when you press the purchase order it will take you to STANDARD Trascation code ME23N ....

*& The basic requirement for this demo is to display a number of       *
*& fields from the EKKO table.                                         *
*&---------------------------------------------------------------------*
REPORT  zdemo_alvgrid                 .

TABLES:     ekko.

type-pools: slis.                                 "ALV Declarations
*Data Declaration
*----------------
TYPES: BEGIN OF t_ekko,
  ebeln TYPE ekpo-ebeln,
  ebelp TYPE ekpo-ebelp,
  statu TYPE ekpo-statu,
  aedat TYPE ekpo-aedat,
  matnr TYPE ekpo-matnr,
  menge TYPE ekpo-menge,
  meins TYPE ekpo-meins,
  netpr TYPE ekpo-netpr,
  peinh TYPE ekpo-peinh,
 END OF t_ekko.

DATA: it_ekko TYPE STANDARD TABLE OF t_ekko INITIAL SIZE 0,
      wa_ekko TYPE t_ekko.

*ALV data declarations
data: fieldcatalog type slis_t_fieldcat_alv with header line,
      gd_tab_group type slis_t_sp_group_alv,
      gd_layout    type slis_layout_alv,
      gd_repid     like sy-repid,
      gt_events     type slis_t_event,
      gd_prntparams type slis_print_alv.


************************************************************************
*Start-of-selection.
START-OF-SELECTION.

perform data_retrieval.
perform build_fieldcatalog.
perform build_layout.
perform build_events.
perform build_print_params.
perform display_alv_report.


*&---------------------------------------------------------------------*
*&      Form  BUILD_FIELDCATALOG
*&---------------------------------------------------------------------*
*       Build Fieldcatalog for ALV Report
*----------------------------------------------------------------------*
form build_fieldcatalog.

* There are a number of ways to create a fieldcat. 
* For the purpose of this example i will build the fieldcatalog manualy
* by populating the internal table fields individually and then 
* appending the rows. This method can be the most time consuming but can
* also allow you  more control of the final product.

* Beware though, you need to ensure that all fields required are
* populated. When using some of functionality available via ALV, such as
* total. You may need to provide more information than if you were 
* simply displaying the result
*               I.e. Field type may be required in-order for
*                    the 'TOTAL' function to work.

  fieldcatalog-fieldname   = 'EBELN'.
  fieldcatalog-seltext_m   = 'Purchase Order'.
  fieldcatalog-col_pos     = 0.
  fieldcatalog-outputlen   = 10.
  fieldcatalog-emphasize   = 'X'.
  fieldcatalog-key         = 'X'.
*  fieldcatalog-do_sum      = 'X'.
*  fieldcatalog-no_zero     = 'X'.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'EBELP'.
  fieldcatalog-seltext_m   = 'PO Item'.
  fieldcatalog-col_pos     = 1.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'STATU'.
  fieldcatalog-seltext_m   = 'Status'.
  fieldcatalog-col_pos     = 2.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'AEDAT'.
  fieldcatalog-seltext_m   = 'Item change date'.
  fieldcatalog-col_pos     = 3.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'MATNR'.
  fieldcatalog-seltext_m   = 'Material Number'.
  fieldcatalog-col_pos     = 4.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'MENGE'.
  fieldcatalog-seltext_m   = 'PO quantity'.
  fieldcatalog-col_pos     = 5.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'MEINS'.
  fieldcatalog-seltext_m   = 'Order Unit'.
  fieldcatalog-col_pos     = 6.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'NETPR'.
  fieldcatalog-seltext_m   = 'Net Price'.
  fieldcatalog-col_pos     = 7.
  fieldcatalog-outputlen   = 15.
  fieldcatalog-do_sum      = 'X'.
  fieldcatalog-datatype     = 'CURR'.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

  fieldcatalog-fieldname   = 'PEINH'.
  fieldcatalog-seltext_m   = 'Price Unit'.
  fieldcatalog-col_pos     = 8.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.
endform.                    " BUILD_FIELDCATALOG


*&---------------------------------------------------------------------*
*&      Form  BUILD_LAYOUT
*&---------------------------------------------------------------------*
*       Build layout for ALV grid report
*----------------------------------------------------------------------*
form build_layout.
  gd_layout-no_input          = 'X'.
  gd_layout-colwidth_optimize = 'X'.
  gd_layout-totals_text       = 'Totals'(201).
*  gd_layout-totals_only        = 'X'.
*  gd_layout-f2code            = 'DISP'.  "Sets fcode for when double
*                                         "click(press f2)
*  gd_layout-zebra             = 'X'.
*  gd_layout-group_change_edit = 'X'.
*  gd_layout-header_text       = 'helllllo'.
endform.                    " BUILD_LAYOUT


*&---------------------------------------------------------------------*
*&      Form  DISPLAY_ALV_REPORT
*&---------------------------------------------------------------------*
*       Display report using ALV grid
*----------------------------------------------------------------------*
form display_alv_report.
  gd_repid = sy-repid.
  call function 'REUSE_ALV_GRID_DISPLAY'
       exporting
            i_callback_program      = gd_repid
            i_callback_top_of_page   = 'TOP-OF-PAGE'  "see FORM
            i_callback_user_command = 'USER_COMMAND'
*            i_grid_title           = outtext
            is_layout               = gd_layout
            it_fieldcat             = fieldcatalog[]
*            it_special_groups       = gd_tabgroup
            it_events               = gt_events  
            is_print                = gd_prntparams  
            i_save                  = 'X'
*            is_variant              = z_template
       tables
            t_outtab                = it_ekko
       exceptions
            program_error           = 1
            others                  = 2.
  if sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  endif.
endform.                    " DISPLAY_ALV_REPORT


*&---------------------------------------------------------------------*
*&      Form  DATA_RETRIEVAL
*&---------------------------------------------------------------------*
*       Retrieve data form EKPO table and populate itab it_ekko
*----------------------------------------------------------------------*
form data_retrieval.

select ebeln ebelp statu aedat matnr menge meins netpr peinh
 up to 10 rows
  from ekpo
  into table it_ekko.
endform.                    " DATA_RETRIEVAL


*-------------------------------------------------------------------*
* Form  TOP-OF-PAGE                                                 *
*-------------------------------------------------------------------*
* ALV Report Header                                                 *
*-------------------------------------------------------------------*
Form top-of-page.
*ALV Header declarations
data: t_header type slis_t_listheader,
      wa_header type slis_listheader,
      t_line like wa_header-info,
      ld_lines type i,
      ld_linesc(10) type c.

* Title
  wa_header-typ  = 'H'.
  wa_header-info = 'EKKO Table Report'.
  append wa_header to t_header.
  clear wa_header.

* Date
  wa_header-typ  = 'S'.
  wa_header-key = 'Date: '.
  CONCATENATE  sy-datum+6(2) '.'
               sy-datum+4(2) '.'
               sy-datum(4) INTO wa_header-info.   "todays date
  append wa_header to t_header.
  clear: wa_header.

* Total No. of Records Selected
  describe table it_ekko lines ld_lines.
  ld_linesc = ld_lines.
  concatenate 'Total No. of Records Selected: ' ld_linesc
                    into t_line separated by space.
  wa_header-typ  = 'A'.
  wa_header-info = t_line.
  append wa_header to t_header.
  clear: wa_header, t_line.

  call function 'REUSE_ALV_COMMENTARY_WRITE'
       exporting
            it_list_commentary = t_header.
*            i_logo             = 'Z_LOGO'.
endform.


*------------------------------------------------------------------*
*       FORM USER_COMMAND                                          *
*------------------------------------------------------------------*
*       --> R_UCOMM                                                *
*       --> RS_SELFIELD                                            *
*------------------------------------------------------------------*
FORM user_command USING r_ucomm LIKE sy-ucomm
                  rs_selfield TYPE slis_selfield.

* Check function code
  CASE r_ucomm.
    WHEN '&IC1'.
*   Check field clicked on within ALVgrid report
    IF rs_selfield-fieldname = 'EBELN'.
*     Read data table, using index of row user clicked on
      READ TABLE it_ekko INTO wa_ekko INDEX rs_selfield-tabindex.
*     Set parameter ID for transaction screen field
      SET PARAMETER ID 'BES' FIELD wa_ekko-ebeln.
*     Sxecute transaction ME23N, and skip initial data entry screen
      CALL TRANSACTION 'ME23N' AND SKIP FIRST SCREEN.
    ENDIF.
  ENDCASE.
ENDFORM.


*&---------------------------------------------------------------------*
*&      Form  BUILD_EVENTS
*&---------------------------------------------------------------------*
*       Build events table
*----------------------------------------------------------------------*
form build_events.
  data: ls_event type slis_alv_event.

  call function 'REUSE_ALV_EVENTS_GET'
       exporting
            i_list_type = 0
       importing
            et_events   = gt_events[].
  read table gt_events with key name =  slis_ev_end_of_page
                           into ls_event.
  if sy-subrc = 0.
    move 'END_OF_PAGE' to ls_event-form.
    append ls_event to gt_events.
  endif.

    read table gt_events with key name =  slis_ev_end_of_list
                           into ls_event.
  if sy-subrc = 0.
    move 'END_OF_LIST' to ls_event-form.
    append ls_event to gt_events.
  endif.
endform.                    " BUILD_EVENTS


*&---------------------------------------------------------------------*
*&      Form  BUILD_PRINT_PARAMS
*&---------------------------------------------------------------------*
*       Setup print parameters
*----------------------------------------------------------------------*
form build_print_params.
  gd_prntparams-reserve_lines = '3'.   "Lines reserved for footer
  gd_prntparams-no_coverpage = 'X'.
endform.                    " BUILD_PRINT_PARAMS


*&---------------------------------------------------------------------*
*&      Form  END_OF_PAGE
*&---------------------------------------------------------------------*
form END_OF_PAGE.
  data: listwidth type i,
        ld_pagepos(10) type c,
        ld_page(10)    type c.

  write: sy-uline(50).
  skip.
  write:/40 'Page:', sy-pagno .
endform.


*&---------------------------------------------------------------------*
*&      Form  END_OF_LIST
*&---------------------------------------------------------------------*
form END_OF_LIST.
  data: listwidth type i,
        ld_pagepos(10) type c,
        ld_page(10)    type c.

  skip.
  write:/40 'Page:', sy-pagno .
endform.

reward points if it is usefull ....

Girish

Re: Reports

Former Member — Fri, 22 Jun 2007 12:18:44 GMT

HI.

I think u misunderstood my question. I know that PO and invoice would have to b in Smartforms. I only like to know is there any standard reports or smartforms that would b used for manufacturing company. Kindly name that things and where do I find..

Thanks.

Khan.

Re: Reports

Former Member — Sat, 30 Jun 2007 10:21:08 GMT

self