topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Tue, 22 Apr 2008 10:29:08 GMT

Hi,

I have selection screen with GL account range (BSEG-HKONT),Company code (BKPF-BUKRS),posting date range (BKPF-BUDAT).

Now,I have to find all the documents (Belnr) from BKPF that fall within the posting date range (bkpf-budat)

With regards

S0025444845 — Tue, 22 Apr 2008 10:31:49 GMT

hi,

Use

select * from bkpf into corresponding fields of it_bkpf

where burks in s_burks and

budat in s_budat.

regards,

sudha

Former Member — Tue, 22 Apr 2008 10:31:54 GMT

hi,

do this way ...


start-of-selection.

select belnr from bkpf into table it_bkpf 
  where budat in s_budat.
if sy-subrc = 0.

endif.

Former Member — Tue, 22 Apr 2008 10:36:50 GMT

Use this coding

start-of-selection

select belnr from bkpf into table it_bkpf

where budat in s_budat.

if sy-subrc = 0.

endif.

Reward Me Points

Pari

Former Member — Tue, 22 Apr 2008 10:42:40 GMT

SELECT * FROM bkpf WHERE bldat IN m_date.

SELECT SINGLE * FROM bseg WHERE belnr = bkpf-belnr.

IF sy-subrc = 0.

MOVE-CORRESPONDING bkpf TO itab.

MOVE-CORRESPONDING bseg TO itab.

APPEND itab.

CLEAR itab.

ENDIF.

ENDSELECT.

reward if useful