Skip to Content
0
Former Member
Mar 03, 2009 at 04:38 PM

Internal table processing

42 Views

Hi,

I have itab rows in the following way.

Doc. CoCode Rep Region Sold-To Firm Payer ccode crep creg

1400000999 9000 jack NY 12695 455 6011560

1400000999 9000 jack NY 12695 455 6011560

1400000999 6790 john WA 55111 881 55111

1400000999 9000 jack NY 7265 455 7265

1400631256 6500 tng1 CA 112233 105 6000177

1400631256 6500 tng1 CA 416122 105 6000177

I need to check for the cross company code , cros rep and cross region for document and append those columns with 'Yes' or 'No'. This is required only for the first item per document number. The output should be like below.

Doc. CoCode Rep Region Sold-To Firm Payer ccode crep creg

1400000999 9000 jack NY 12695 455 6011560 yes yes yes

1400000999 9000 jack NY 12695 455 6011560

1400000999 6790 john WA 55111 881 55111

1400000999 9000 jack NY 7265 455 7265

1400631256 6500 tng1 CA 112233 105 6000177 no no no

1400631256 6500 tng1 CA 416122 105 6000177

ex: document 140000999 has a different company code in row 3. so its a cross company code.

Could anyone suggest the best way to do this.

Thanks,

RVK