problem in report

[Former Member]

Hi friends,

fOR one document no with 4 line item...

it Display like this for eg :

Doc_No Mat

101 123

101 124

101 125

101 126

but my requirement is to display in Horizontal row

for eg:

Doc_no mat1 mat2 mat3 mat4

101 123 124 125 126

I have coded like this but problem is

it is not displaying all line item of doc_no in one row...

but it is displaying first line item mat in first row fisrt coloum...

& second line item in second row second coloum..&

so on up to 4item...

can any one help me..

LOOP AT I_MIC INTO WKA_MIC.

WKA_FINAL-MBLNR = WKA_MIC-MBLNR.

WKA_FINAL-AUFNR = WKA_MIC-AUFNR.

WKA_FINAL-MEINS = WKA_MIC-MEINS.

WKA_FINAL-BWART = WKA_MIC-BWART.

WKA_FINAL-LGORT = WKA_MIC-LGORT.

WKA_FINAL-SHKZG = WKA_MIC-SHKZG.

Doc_no = WKA_mic-mblnr.

At new mblnr.

clear v_count.

endat.

v_count = v_count + 1.

if doc_no = WKA_mic-mblnr and ( v_count = 1 ).

WKA_FINAL-MATNR1 = WKA_MIC-MATNR.

WKA_FINAL-CHARG1 = WKA_mic-charg.

WKA_FINAL-menge1 = WKA_mic-menge.

Elseif doc_no = WKA_mic-mblnr and ( v_count = 2 ).

WKA_FINAL-matnr2 = WKA_mic-matnr.

WKA_FINAL-CHARG2 = WKA_mic-charg.

WKA_FINAL-menge2 = WKA_mic-menge.

Elseif doc_no = WKA_mic-mblnr and ( v_count = 3 ).

WKA_FINAL-matnr3 = WKA_mic-matnr.

WKA_FINAL-CHARG3 = WKA_mic-charg.

WKA_FINAL-menge3 = WKA_mic-menge.

Elseif doc_no = WKA_mic-mblnr and ( v_count >= 4 ).

WKA_FINAL-matnr4 = WKA_mic-matnr.

WKA_FINAL-CHARG4 = WKA_mic-charg.

WKA_FINAL-menge4 = WKA_mic-menge.

endif.

APPEND WKA_FINAL TO I_FINAL.

CLEAR WKA_FINAL.

ENDLOOP.

[Former Member]

Use at end of...endat statement.Check this modified code.

LOOP AT I_MIC INTO WKA_MIC.

WKA_FINAL-MBLNR = WKA_MIC-MBLNR.

WKA_FINAL-AUFNR = WKA_MIC-AUFNR.

WKA_FINAL-MEINS = WKA_MIC-MEINS.

WKA_FINAL-BWART = WKA_MIC-BWART.

WKA_FINAL-LGORT = WKA_MIC-LGORT.

WKA_FINAL-SHKZG = WKA_MIC-SHKZG.

Doc_no = WKA_mic-mblnr.

At new mblnr.

clear v_count.

endat.

v_count = v_count + 1.

if doc_no = WKA_mic-mblnr and ( v_count = 1 ).

WKA_FINAL-MATNR1 = WKA_MIC-MATNR.

WKA_FINAL-CHARG1 = WKA_mic-charg.

WKA_FINAL-menge1 = WKA_mic-menge.

Elseif doc_no = WKA_mic-mblnr and ( v_count = 2 ).

WKA_FINAL-matnr2 = WKA_mic-matnr.

WKA_FINAL-CHARG2 = WKA_mic-charg.

WKA_FINAL-menge2 = WKA_mic-menge.

Elseif doc_no = WKA_mic-mblnr and ( v_count = 3 ).

WKA_FINAL-matnr3 = WKA_mic-matnr.

WKA_FINAL-CHARG3 = WKA_mic-charg.

WKA_FINAL-menge3 = WKA_mic-menge.

Elseif doc_no = WKA_mic-mblnr and ( v_count >= 4 ).

WKA_FINAL-matnr4 = WKA_mic-matnr.

WKA_FINAL-CHARG4 = WKA_mic-charg.

WKA_FINAL-menge4 = WKA_mic-menge.

endif.

AT END OF mblnr.

APPEND WKA_FINAL TO I_FINAL.

CLEAR WKA_FINAL.

ENDAT.

ENDLOOP.

Regards,

Joy.

[Former Member]

Hi,

Joyjit Ghosh

Thanx A lot....

Its working....