‎2007 Jun 04 12:43 PM
tables: qamr.
data: prueflos, mittelwert, pruefbemkt.
select querry....
O/p will come:
For ex:
prueflos PRUEFBEMKT MITTELWERT
40000000764 R 9.2
40000000764 Y 7.5
40000000764 B 4.8
40000000764 Y 3.4
40000000764 R 9.0
Now I want it in this format....
PRUEFBEMKT
prueflos R Y B K
40000000764 9.2 - - -
40000000764 - 7.5 - -
40000000764 - - 4.8 -
40000000764 - 3.4 - -
40000000764 9.0 - - -
i.e under R : 9.2 and 9.0 shud display
under Y : 7.5 nd 3.4 shud display
under B: 4.8 shud display..
Can anyone help me in this.....
‎2007 Jun 04 12:51 PM
Hi,
Use the "write" with UNDER option.
Ex: WRITE: / 'Peterson' UNDER 'Name',
Sudheer.A
‎2007 Jun 04 1:40 PM
Hi,
try this
TYPES :
BEGIN OF tt_etat,
lifnr TYPE zvalo_stocks_ncg-lifnr,
name1 TYPE lfa1-name1,
sdebit_compt TYPE bseg-dmbtr,
scredit_compt TYPE bseg-dmbtr,
sdebit_stat TYPE bseg-dmbtr,
scredit_stat TYPE bseg-dmbtr,
ecart_sdebit TYPE bseg-dmbtr,
ecart_scredit TYPE bseg-dmbtr,
END OF tt_etat.
data:
gt_etat TYPE STANDARD TABLE OF tt_etat,
gs_etat TYPE tt_etat.
WRITE : 'Report Evaluation Ecart de marge statistique/comptable'.
WRITE : / p_bukrs.
WRITE : gd_butxt.
WRITE : / sy-datum.
WRITE : ' ',sy-uzeit.
WRITE : / p_gjahr.
WRITE : ' ', s_monat.
*Affichage de l'état
Ligne 1
WRITE : / sy-uline(147).
WRITE AT /1(1) '|'.
WRITE AT 3(35) ' Fournisseurs'.
WRITE AT 39(1) '|'.
WRITE AT 41(33) ' Balance <<auxiliare>>'.
WRITE AT 75(1) '|'.
WRITE AT 77(33) ' Valorisation de stock'.
WRITE AT 111(1) '|'.
WRITE AT 113(33) ' Ecart'.
WRITE AT 147(1) '|'.
Ligne 2
WRITE AT /1(1) '|'.
WRITE AT 3(35) ''.
WRITE AT 39(1) '|'.
WRITE AT 41(33) ' Total des mouvements'.
WRITE AT 75(1) '|'.
WRITE AT 77(33) ' Total des mouvements'.
WRITE AT 111(1) '|'.
WRITE AT 113(33) ' Balance - Valorisation'.
WRITE AT 147(1) '|'.
Ligne 3
WRITE AT /1(1) '|'.
WRITE AT 3(35) ''.
WRITE AT 39(1) '|'.
WRITE AT 41(33) ' (607-609) période'.
WRITE AT 75(1) '|'.
WRITE AT 77(33) ' période'.
WRITE AT 111(1) '|'.
WRITE AT 113(33) ''.
WRITE AT 147(1) '|'.
Ligne 4
WRITE AT /1(1) '|'.
WRITE AT 39(1) '|'.
WRITE AT 75(1) '|'.
WRITE AT 111(1) '|'.
WRITE AT 147(1)'|'.
Ligne 5
WRITE AT /1(1) '|'.
WRITE AT 3(35) ''.
WRITE AT 39(1) '|'.
WRITE AT 41(14)' D'.
WRITE AT 56(1) '|'.
WRITE AT 58(14)' C'.
WRITE AT 75(1) '|'.
WRITE AT 77(14)' SD'.
WRITE AT 92(1) '|'.
WRITE AT 94(14) ' SC'.
WRITE AT 111(1) '|'.
WRITE AT 113(14) ' D'.
WRITE AT 129(1) '|'.
WRITE AT 131(14) ' C'.
WRITE AT 147(1) '|'.
WRITE : / sy-uline(147).
*Boucle dans la table interne gt_etat
LOOP AT gt_etat INTO gs_etat .
WRITE AT /1(1) '|'.
WRITE AT 3(35) gs_etat-name1.
WRITE AT 39(1) '|'.
ld_temp_text = gs_etat-sdebit_compt.
WRITE AT 41(15) ld_temp_text.
WRITE AT 56(1) '|'.
WRITE AT 58(14) gs_etat-scredit_compt.
WRITE AT 75(1) '|'.
clear ld_temp_text.
ld_temp_text = gs_etat-sdebit_stat.
WRITE AT 77(15) ld_temp_text.
WRITE AT 92(1) '|'.
WRITE AT 94(14) gs_etat-scredit_stat.
WRITE AT 111(1) '|'.
clear ld_temp_text.
ld_temp_text = gs_etat-ecart_sdebit.
WRITE AT 113(15) ld_temp_text.
WRITE AT 129(1) '|'.
WRITE AT 131(14) gs_etat-ecart_scredit.
WRITE AT 147(1) '|'.
ENDLOOP.
WRITE : / sy-uline(147).
‎2007 Jun 04 1:50 PM
hi,
top-of-page.
write:/10 'PRUEFBEMKT'.
write: 10 'prueflos',
30 'R',
40 ' Y',
50 ' B',
60 ' K'.
end-of-selection.
loop at itab.
write:/10 itab-prueflos,
30 itab-r,
40 itab-y,
50 itab-b,
60 itab-k.
endloop.
if helpful reward some points.
with regards,
suresh.
‎2007 Jun 12 6:26 PM
yaa i hav written a program for it but I m getting under R -- 9.2 9.2 9.2 9.2 9.0
y----0.0 7.5 7.5 3.4 3.4
b----0.0 0.0 4.8 4.8 4.8
k----0.0 0.0 0.0 0.0 0.0
Can u solve this issue?
‎2007 Jun 12 7:50 PM
Varun,
Why do u put separate WRITE statements for R Y B K and for the values unger them.
Like
write: /n 'R spaces Y spaces ............'
wite: /n ....................
Is that what u need? Did I get that in a right way?
Rgds,
Naren