Skip to Content
0
Dec 13, 2008 at 01:19 PM

output not getting properly

77 Views

Dear All,

i am getting problem in At new command, in my out put i am getting '****' after first field, i refer some threads also then also not getting plz any body help me.

Thanks.

REPORT ZLC_REP no standard page heading.

  • line-size 250

*line-count 36(4).

TABLES : LFA1,BKPF,BSEG,BSAD.

SELECT-OPTIONS : DATE FOR BKPF-BLDAT,

LC FOR BKPF-XBLNR.

*SELECT-OPTIONS :

TYPES : BEGIN OF TY_FINAL,

XBLNR TYPE BKPF-XBLNR,

BELNR TYPE BKPF-BELNR,

LIFNR TYPE LFA1-LIFNR,

  • LAND1 TYPE LFA1-LAND1,

NAME1 TYPE LFA1-NAME1,

BLDAT TYPE BKPF-BLDAT,

BKTXT TYPE BKPF-BKTXT,

dmbtr TYPE BSEG-dmbtr,

END OF TY_FINAL.

TYPES : BEGIN OF TY_BKPF,

BUKRS TYPE BUKRS, "Company Code

BELNR TYPE BKPF-BELNR, "Doc.Number

XBLNR TYPE XBLNR,

BLDAT TYPE BLDAT, "Vendor Invoice Date

BKTXT TYPE BKTXT,

END OF TY_BKPF.

TYPES : BEGIN OF TY_BSEG,

BUKRS TYPE BUKRS, "Company Code

BELNR TYPE BSEG-BELNR,

dmbtr TYPE dmbtr,

umskz type umskz,

LIFNR TYPE BSEG-LIFNR, "Vendor Number

END OF TY_BSEG.

TYPES :BEGIN OF TY_LFA1,

LIFNR TYPE LIFNR,

NAME1 TYPE NAME1,

  • LAND1 TYPE LAND1,

END OF TY_LFA1.

DATA : T_FINAL TYPE STANDARD TABLE OF TY_FINAL INITIAL SIZE 1,

W_FINAL TYPE TY_FINAL.

DATA : M_FINAL TYPE STANDARD TABLE OF TY_FINAL INITIAL SIZE 1,

W1_FINAL TYPE TY_FINAL.

DATA : T_BKPF TYPE STANDARD TABLE OF TY_BKPF INITIAL SIZE 1,

W_BKPF TYPE TY_BKPF.

DATA : T_BSEG TYPE STANDARD TABLE OF TY_BSEG INITIAL SIZE 1,

W_BSEG TYPE TY_BSEG.

DATA : T_LFA1 TYPE STANDARD TABLE OF TY_LFA1 INITIAL SIZE 1,

W_LFA1 TYPE TY_LFA1.

data : res type i.

SELECT BUKRS

BELNR

XBLNR

BLDAT

BKTXT

FROM BKPF INTO TABLE T_BKPF

where BLDAT IN DATE

AND XBLNR in LC.

IF T_BKPF IS NOT INITIAL.

SELECT BUKRS

BELNR

dmbtr

umskz

LIFNR

FROM BSEG INTO TABLE T_BSEG

FOR ALL ENTRIES IN T_BKPF

  • WHERE BUKRS = T_BKPF-BUKRS

WHERE BELNR = T_BKPF-BELNR

and umskz = 'L'.

ENDIF.

IF T_BSEG IS NOT INITIAL.

SELECT LIFNR

  • LAND1

NAME1

FROM LFA1 INTO TABLE T_LFA1

FOR ALL ENTRIES IN T_BSEG

WHERE LIFNR = T_BSEG-LIFNR.

ENDIF.

&----


*& Sending Data to Final Internal table *

&----


LOOP AT T_BKPF INTO W_BKPF.

READ TABLE T_BSEG INTO W_BSEG WITH KEY BELNR = W_BKPF-BELNR.

READ TABLE T_LFA1 INTO W_LFA1 WITH KEY LIFNR = W_BSEG-LIFNR.

W_FINAL-XBLNR = W_BKPF-XBLNR.

W_FINAL-BELNR = W_BKPF-BELNR.

*W_FINAL-LAND1 = W_LFA1-LAND1.

W_FINAL-NAME1 = W_LFA1-NAME1.

W_FINAL-BLDAT = W_BKPF-BLDAT.

W_FINAL-BKTXT = W_BKPF-BKTXT.

W_FINAL-dmbtr = W_BSEG-dmbtr.

APPEND W_FINAL TO T_FINAL.

delete adjacent duplicates from t_final comparing belnr dmbtr.

ENDLOOP.

clear w_final.

SORT T_FINAL.

lOOP AT T_FINAL INTO W_FINAL.

AT NEW XBLNR.

WRITE : 05 W_FINAL-XBLNR ,

15 W_FINAL-LIFNR, 30 W_final-name1.

uline : /05(60).

endat.

WRITE : /05 w_FINAL-BELNR,

  • 20 w_FINAL-LIFNR,

35 w_FINAL-BLDAT,

50 w_FINAL-BKTXT,

80 w_final-dmbtr.

  • 90 w_final-name1.

AT END OF XBLNR.

SUM.

uline /80(20).

WRITE : /60 'LC TOTAL:',W_FINAL-XBLNR,80 W_FINAL-dmbtr.

uline /80(20).

  • res = sy-linct - sy-linno.

  • reserve res lines.

ENDAT.

AT LAST.

SUM.

WRITE : /65 'GRAND TOTAL:',80 W_FINAL-dmbtr.

uline /80(20).

uline /80(20).

  • res = sy-linct - sy-linno.

  • reserve res lines.

ENDAT.

ENDLOOP.

  • ENDLOOP.

clear w_final.

TOP-OF-PAGE.

write :50 'LETTER OF CREDIT'.

uline /05(150).

WRITE : /05 'DOCUMENTNO',

  • 20 'VENDORNO',

35 'DOCDATE',

50 'DESCRIPTION',

85 'AMOUNT'.

uline /05(150).

END-OF-PAGE.

uline /05(50).

write :/05 'end of page:',sy-pagno.