Skip to Content
0
Former Member
Feb 24, 2009 at 10:39 AM

HELP ME IN THIS REPORT

32 Views

HI GUYS,

IM SAP-ABAP FRESHER BELOW MY REPORT IS THERE IM GETING ERROT IN SELECT STATEMENT I DONT KNW WT DO PLZ GUIDE ME, WHERE I DID MISTAKE?UNABLE TO DEBUG

THANKS IN ADVANCE...A WAITING REPAY....

REGARDS..

JINKU

&----


*& Report ZAC1_ROUGH_NOSTD_PAGE

*&

&----


*&

*&

&----


REPORT ZAC1_ROUGH_NOSTD_PAGE.

tables: kna1,vbak.

types : begin of ty_orders,

kunnr type kunnr,

name1 type name1,

land1 type land1,

ort01 type ort01,

vbeln type vbeln,

erdat type erdat,

netwr type netwr,

end of ty_orders.

data : w_orders type ty_orders.

data : t_orders type STANDARD TABLE OF ty_orders INITIAL SIZE 1.

SELECTION-SCREEN : begin of block b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS : custno for kna1-kunnr.

SELECT-OPTIONS : ordno for vbak-vbeln.

*PARAMETERS : custno type kna1-kunnr DEFAULT 1000.

*PARAMETERS : ordno type vbak-vbeln.

SELECTION-SCREEN : end of block b1.

  • select k~kunnr

  • k~name1

  • k~ort01

  • v~vbeln

  • v~erdat

  • v~netwr into table t_orders from kna1 as k inner join

  • vbak as v on kkunnr = vkunnr where

  • k~kunnr in custno and

  • v~vbeln in ordno.

select k~kunnr

k~name1

k~land1

k~ort01

v~vbeln

v~erdat

v~netwr into table t_orders from kna1 as k inner join

vbak as v on kkunnr = vkunnr where

k~kunnr = custno and

v~vbeln = ordno.

sort t_orders by kunnr.

loop at t_orders into w_orders.

write :/05 w_orders-kunnr,

20 w_orders-name1,

40 w_orders-land1,

65 w_orders-ort01,

95 w_orders-vbeln,

115 w_orders-erdat,

125 w_orders-netwr.

at end of kunnr.

skip.

skip.

sum.

write :/50 'sum of net order value',125 w_orders-netwr.

endat.

endloop.

top-of-page.

write:/40 'custmor order information'.

uline.

write :/05 'customer num',

20 'customer name',

40 'cust count',

65 'cust city',

95 'ord num',

115 'ord date',

130 'ord value'.

uline.

end-of-page.

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

Please read the rules of engagement about using all caps

Also please be more carefule when assigning p o i n t s for answers.

Edited by: Rob Burbank on Feb 24, 2009 10:59 AM