06-03-2008 5:46 PM
Hi,
We have a report that output data per LIFNR like this (as-is):
Minimum Max No. delivs. PCT accum. PCT
1000- 100- 5 17,24 100,00
99- 30- 0 0,00 82,76
29- 20- 0 0,00 82,76
19- 17- 0 0,00 82,76
16- 14- 0 0,00 82,76
13- 12- 0 0,00 82,76
11- 10- 0 0,00 82,76
The first to columns are fixed interval values that are the same for all LIFNR. As you can see it outputs data vertically. For your info I give you the existing internal tables that are used below:
DATA: BEGIN OF itab OCCURS 100,
lifnr LIKE ekko-lifnr,
ekgrp LIKE ekko-ekgrp,
days TYPE i,
ebeln LIKE ekko-ebeln,
ebelp LIKE ekpo-ebelp,
matnr LIKE ekpo-matnr,
bedat LIKE ekko-bedat,
eindt LIKE eket-eindt,
slfdt LIKE eket-slfdt,
budat LIKE ekbe-budat,
lfdat LIKE likp-lfdat,
menge LIKE ekpo-menge,
meins LIKE ekpo-meins,
gjahr LIKE ekbe-gjahr,
belnr LIKE ekbe-belnr,
ekorg LIKE ekko-ekorg, "I002
END OF itab.
DATA: BEGIN OF ebeln_zb OCCURS 0, "I001
ebeln LIKE ekko-ebeln, "I001
ebelp LIKE ekpo-ebelp, "I001
lifnr LIKE ekko-lifnr, "I001
ekgrp LIKE ekko-ekgrp, "I001
bedat LIKE ekko-bedat, "I001
END OF ebeln_zb. "I001
DATA: BEGIN OF i_eket OCCURS 0, "I001
eindt LIKE eket-eindt, "I001
slfdt LIKE eket-slfdt, "I001
END OF i_eket. "I001
DATA: BEGIN OF list OCCURS 29,
min TYPE i,
max TYPE i,
no TYPE i,
pct TYPE f,
apct TYPE f,
END OF list.
What we want is to "turn the output around" like below. Are there any more or less simple way to do this as data is already there ?
min / max min / max etc.
LIFNR LIFNAME 1000-/100- 99-/30-
999999 CC & Son 5 5 0 0
etc.
Any ideas are very much appreciated.
06-05-2008 12:50 PM