Skip to Content
0
Former Member
Jun 21, 2011 at 09:35 AM

FI Document Programing

68 Views

Hello Experts,

I was trying to build a FI Report, that contain this parameters:

from Table BKPF :

bukrs, belnr, gjahr

from Table BSEG :

buzei, dmbtr, vorgn

the structure that I planned is this:

can someone please tell me what is wrong in this structure???

I am total confused...

DATA: gs_bkpf TYPE bkpf.

DATA: gt_bkpf TYPE STANDARD TABLE OF bkpf.

DATA: gs_bseg TYPE bseg.

DATA: gt_bseg TYPE STANDARD TABLE OF bseg.

TYPES: BEGIN OF ts_beanz,

bukrs TYPE bukrs,

belnr TYPE belnr,

gjahr TYPE gjahr,

buzei TYPE buzei,

dmbtr TYPE dmbtr,

vorgn TYPE vorgn,

END OF ts_beanz.

DATA: gs_beanz TYPE ts_beanz.

DATA: gt_beanz TYPE STANDARD TABLE OF ts_beanz.

SELECT-OPTIONS: pr_belnr FOR gs_bkpf-belnr.

PARAMETERS: bukrs TYPE bukrs,

gjahr TYPE gjahr.

START-OF-SELECTION.

SELECT belnr bukrs gjahr FROM bkpf

INTO CORRESPONDING FIELDS OF gs_bkpf

WHERE belnr IN pr_belnr

and bukrs = bukrs

and gjahr = gjahr.

endselect.

select belnr dmbtr from bseg

into corresponding fields of gs_bseg

where belnr in pr_belnr

and dmbtr = dmbtr.

endselect.