conditions

[Former Member]

Hi to all experts(urgent).

Doc no line item tax code amt tax item

-

---

-

---

-

---

-

---

-

---

1 10 20 200 a

1 11 20 300 a

1 12 20 100 b

2 11 20 400 b

My process is

First check it tax item –if it is ‘a’ for any line item for particular docno.

Then u leave the value related to tax item ‘b’ for same doc no.

Then u not taken other tax item value.

If tax item- is not ‘a’ for any line item for particular doc no than u accept value related to

Tax item b.

Output in this way.

Doc no tax code amt

-

---

-

---

-

---

1 20 500

2 20 400

Then how can I solve this issues.

Please give sample code for that.

Thanks in advance and reward also.

Regard : deep

[Former Member]

Hi to all experts(urgent).

Doc no line item tax code amt tax item

-

---

-

---

-

---

-

---

-

---

1 10 20 200 a

1 11 20 300 a

1 12 20 100 b

2 11 20 400 b

My process is

First check it tax item –if it is ‘a’ for any line item for particular docno.

Then u leave the value related to tax item ‘b’ for same doc no.

Then u not taken other tax item value.

If tax item- is not ‘a’ for any line item for particular doc no than u accept value related to

Tax item b.

Output in this way.

Doc no tax code amt

-

---

-

---

-

---

1 20 500

2 20 400

Then how can I solve this issues.

Please give sample code for that.

Thanks in advance and reward also.

Regard : deep

[Former Member]

Hi deep,

take loop,

loop at itab into wa: Where you have all values populated.

on change of <field> i.e. a/b

wa-<field> (your 500/400) = sum.

append wa to jtab. > Output.

endon.

sum = wa-<field> + sum.

endloop.

Reward if useful!