Selection using selection help in FI reports

[Former Member]

Hi all,

I am new to FI reporting. can anyone sugess me that what is the mean for Selection using selection help in FI reports.

Is it for selection fields values.

Also anyone sugess me that any logical database used in FI reports. and any special statement used in FI reports like

GET PERNR in HR reports.

Points will be sured for valuable answers.

Thanks

Sanket sethi

[Former Member]

Correction: Selection using search help

[Former Member]

hi,

Most of the standard field references in FI has search help, for eg, like BUKRS, PRCTR, KOSTL etc.

If the standard is not suitable for you, create one using SE11 and assign it in the parameters or select-options variable using the addl. stmt. MATCHCODE OBJECT zsh_test. (No appostrophe).

There are few LDBs but I dont think it is compulsory to use them. WIthout them also you can achieve your results.

There is no spl stms like HR all are simple basic ABAP stmts only.

Regards,

Subramanian

[Former Member]

Hi,

Please refer the example code below for search help:

PARAMETERS:p_matnr(18) TYPE c.
 
DATA:BEGIN OF itab OCCURS 0,
matnr TYPE matnr,
END OF itab.
 
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_matnr.
 
 
  itab-matnr = 'ABC123456788'.
  APPEND itab.
  itab-matnr = 'BCS123456788'.
  APPEND itab.
  itab-matnr = 'DFC123456788'.
  APPEND itab.
  itab-matnr = 'ASW123456788'.
  APPEND itab.
 
"you can use select statement as well
"incase you are using any table field.
 
 
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield    = 'MATNR'
      dynpprog    = sy-repid
      dynpnr      = sy-dynnr
      dynprofield = 'P_MATNR'
      value_org   = 'S'
    TABLES
      value_tab   = itab.

And Try using the LDB SDF. In FI it is very rare to use LDBs.

Widely used Tables in FI are :

BSIS, BSAS, BKPF, BSEG, BSIK, BSAK, BSID, BSAD.

Thanks,

Sriram Ponna.

[Former Member]

hiiii

Selection Using Search Help..it means give facility to user for searching data from database table.so you make all entries available to that user.it can only done by using F4 help with that selection.

LDB is mostly use for HR tables.For FI Accessing BSEG you can Access BSIS , BSAS, BSIK , BSAK, BSID , BSAD.These are transparent tables that gives the same data as BSEG.You can use views to improve performance for FI tables.

regards

twinkal