Need Logic

[Former Member]

Hi All,

First scenario

bukrs pblnr matnr tankno deviation quantity outof out

-

---

De01 10205206 123 1 10 1000 X Blank

De01 10205206 124 1 15 2000 Blank X

De01 10205206 125 1 20 3000 X X

I need to update other internal table based on following conditions.

Internal Table Fields --Bukrs,Pblnr,Traffic lights.

For same tankno,

Traffic Light

Green: The field value for the flag for OutOfNorm and OutOfNormP is blank for all tanks.

Red: For at least 1 tank the field value for the flag OutOfNorm and OutOfNormP is both 'X'.

Orange: All other cases.

Now i need to a record in the internal table

De01 10205206 'Red Light'

*******************************************************************************************************

Second scenario

bukrs pblnr matnr tankno deviation quantity outof out

-

---

De01 10205206 123 1 10 1000 X Blank

De01 10205206 123 3 15 2000 Blank X

De01 10205206 123 2 20 3000 X X

I need to update other internal table based on following conditions.

Internal Table Fields --Bukrs,Pblnr,Traffic lights.

For Same Material number

Green: The field value for the flag for OutOfNorm and OutOfNormP is off for all tanks.

Red: For at least 1 tank the field value for the flag OutOfNorm and OutOfNormP is both ON.

Orange: All other cases.

Now i need to a record in the internal table

De01 10205206 'Red Light'

Above 2 are 2 different scenarios. Need 2 different logics

[Former Member]

in general use this logic.

loop at the internal table then check ur conditions and set a flag for tht.

after the loop bsed on the flaog populate another internal table with bukrs pblnr and traffi light.

for traffic light will just the text do or u need icons for icons declare a field of char 4 and assign the following values

red @0A@

green @08@.

u cant expect us to think the entire logic and code for u.

i hv given u the hint so try it from here

Edited by: kartik tarla on Dec 1, 2008 7:41 PM