on ‎2006 Jan 20 3:42 AM
Hi experts,
Iam trying to display report like this.
fld1 fld2 fld3
---------------------------------------------------------
WQIYDGIWEUDOIUWQL Site Management shorttext
Material Management shorttext
Quality Management shorttext
---------------------------------------------------------
The above details are in one row.
fld2 details are in one ITAB1(since many rows are there).
fld3 details are in one itab2(since many rows are there).
While iam looping the above tables, iam getting like this.
fld1 fld2 fld3
---------------------------------------------------------
WQIYDGIWEUDOIUWQL Site Management
Material Management
Quality Management shorttext
shorttext
shorttext
---------------------------------------------------------
Iam getting some space at FLD3.How can i move up that FLD3 values? Here is my code.
itab1(fld2 see above)
LOOP AT T_DET.
LOOP AT T_LONG WHERE QMNUM = T_DET-QMNUM.
FCOUNT = FCOUNT + 1.
IF FCOUNT = 1. " IF IT IS FIRST ROW
<b>WRITE: 42(25) T_LONG-LTEXT.</b>
ELSE.
<b>WRITE:/42(25) T_LONG-LTEXT.</b>
ENDIF.
ENDLOOP.
itab2(fild 3)
SCOUNT = 0.
LOOP AT ITAB WHERE QMNUM = T_DET-QMNUM.
SCOUNT = SCOUNT + 1.
IF SCOUNT EQ 1.
<b>WRITE:110(80) ITAB-DESC.</b>
ELSE.
<b> WRITE:/110(80) ITAB-DESC.</b>
ENDIF.
ENDLOOP.
ENDLOOP.
Can any one tell me where to make changes?
reward guaranteed
kaki
Request clarification before answering.
Is QMNUM field value unique in tables T_LONG and ITAB?
And can you please give the format in which you want to have your output as.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, QMNUM is the main key for all ITABs.
Out put like this.
T_DET T_LONG ITAB
---------------------------------------------------------
200000163 Site Management somettest
Material Management some 3lines
Quality Management
---------------------------------------------------------
200000164 Site Management somettest
Material Management some 5 lines
Quality Management
some 6 lines
---------------------------------------------------------
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.