Skip to Content
0
Former Member
Oct 29, 2007 at 05:21 AM

report

12 Views

sir

i m create a zreport and fetch the data in database but when we executed the report every line in report repeated in 2 times plz check my coding

REPORT ZXP2.

Tables : bkpf, bseg,bkpf_alv.

DATA: BEGIN OF ITAB OCCURS 0,

BUDAT LIKE BKPF-BUDAT,

BLART LIKE BKPF-BLART,

BELNR LIKE BKPF-BELNR,

BSCHL LIKE BSEG-BSCHL,

HKONT LIKE BSEG-HKONT,

wrbtr like bseg-wrbtr,

sgtxt like bseg-sgtxt,

filkd like bseg-filkd,

END OF ITAB.

SELECT-OPTIONS : s_budat for bkpf-budat.

SELECT BUDAT FROM BKPF INTO CORRESPONDING FIELDS OF ITAB WHERE BUDAT IN S_BUDAT.

APPEND ITAB.

ENDSELECT.

SELECT BSCHL sgtxt belnr wrbtr FROM BSEG INTO CORRESPONDING FIELDS OF ITAB.

APPEND ITAB.

ENDSELECT.

write:/ sy-uline.

write:/,40'NTF INDIA PVT LTD'.

write:/,45 'LEDGER'.

write :/, 35 'From:', s_budat-low , 'TO' , s_budat-high.

write:/, sy-uline.

write:/, 'Date', 10 'Voucher NO', 30 'Particulars', 50 'Debit/Credit', 75 'balance'.

write:/, sy-uline.

loop at itab.

WRITE:/, ITAB-BUDAT, 15 itab-belnr, 30 itab-sgtxt , 60 ITAB-BSCHL, 70 itab-wrbtr.

endloop.

SIR I M USING MODIFY STATEMENT BUT WHEN WE USE MODIFY STATEMENT SHOW SYANTX ERROR. PLZ SIR SLOVE MY PROBLEM

ritu