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.