cancel
Showing results for 
Search instead for 
Did you mean: 

devloped an ALV report for daily cash receipts for selected date range

Former Member
0 Kudos

hi,

how to devlop an ALV report for daily cash receipts for selected date range.for this report what are the tables and fields we have to use.what is the selectionscreen&what is logic.give me sample report.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can develop simple reports using Report Painter.

You may be also interested in:

Check report SAPMF05A for credit memo

See the following Std reports on Payment Advices execute the Tcodes:

S_ALR_87009888

S_ALR_87009889

S_ALR_87009890

S_ALR_87009891

S_ALR_87009892

S_ALR_87009893

S_ALR_87009978

S_ALR_87009979

S_ALR_87009980

S_ALR_87009981

S_ALR_87009982

S_ALR_87009983

S_ALR_87010056

S_ALR_87010057

S_ALR_87010058

S_ALR_87010059

S_ALR_87010060

S_ALR_87010061

S_ALR_87010066

S_ALR_87010067

S_ALR_87012106

S_ALR_87012107

S_ALR_87012108

S_ALR_87012109

S_ALR_87012110

S_ALR_87012111

S_ALR_87012116

S_ALR_87012117

S_ALR_87012200

S_ALR_87012201

S_ALR_87012202

S_ALR_870122

S_ALR_87012204

S_ALR_87012205

S_ALR_87012350

S_ALR_87012351

S_ALR_87012352

S_ALR_87012353

S_ALR_87012354

S_ALR_87012355

sample ALV report:

tables:

marav. "Table MARA and table MAKT

----


  • Data to be displayed in ALV

  • Using the following syntax, REUSE_ALV_FIELDCATALOG_MERGE can auto-

  • matically determine the fieldstructure from this source program

Data:

begin of imat occurs 100,

matnr like marav-matnr, "Material number

maktx like marav-maktx, "Material short text

matkl like marav-matkl, "Material group (so you can test to make

" intermediate sums)

ntgew like marav-ntgew, "Net weight, numeric field (so you can test to

"make sums)

gewei like marav-gewei, "weight unit (just to be complete)

end of imat.

----


  • Other data needed

  • field to store report name

data i_repid like sy-repid.

  • field to check table length

data i_lines like sy-tabix.

----


  • Data for ALV display

TYPE-POOLS: SLIS.

data int_fcat type SLIS_T_FIELDCAT_ALV.

----


select-options:

s_matnr for marav-matnr matchcode object MAT1.

----


start-of-selection.

  • read data into table imat

select * from marav

into corresponding fields of table imat

where

matnr in s_matnr.

end-of-selection.

----


*

  • Now, we start with ALV

*

----


*

*

  • To use ALV, we need a DDIC-structure or a thing called Fieldcatalogue.

  • The fieldcatalouge can be generated by FUNCTION

  • 'REUSE_ALV_FIELDCATALOG_MERGE' from an internal table from any

  • report source, including this report.

  • The only problem one might have is that the report and table names

  • need to be in capital letters. (I had it )

*

*

----


  • Store report name

  • i_repid = sy-repid.

  • Create Fieldcatalogue from internal table

CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'

EXPORTING

I_PROGRAM_NAME = sy-repid

I_INTERNAL_TABNAME = 'IMAT' "capital letters!

I_INCLNAME = sy-repid

CHANGING

CT_FIELDCAT = int_fcat

EXCEPTIONS

INCONSISTENT_INTERFACE = 1

PROGRAM_ERROR = 2

OTHERS = 3.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = i_repid

I_STRUCTURE_NAME = 'marav'

I_DEFAULT = 'X'

I_SAVE = 'A'

TABLES

T_OUTTAB = imat.

IF SY-SUBRC <> 0.

WRITE: 'SY-SUBRC: ', SY-SUBRC .

ENDIF.

Hope this will help.

Regards,

Naveen.