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