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