Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

PROBLEM

Go to solution
Former Member

‎10-07-2007 5:30 PM

0 Kudos

Can anybody solve the problem given below.

I have 3 Internal tables A,B,C by name.Internal tables A and B contain some numbers all in a field.Among them C has no data in it.Here I have 3 requirements.

1.I have to copy the contents of A and B into C.

2.I have to output the numbers which occur repeatedly in C and also I have to output that how many times each number is being repeated.

3.After obtaining the solution for second requirement I have to delete the numbers in Internal table C which are repeatedly occured.

I will award max points to those who have solved it.

1 ACCEPTED SOLUTION

Go to solution
GrahamRobbo
Active Contributor

‎10-08-2007 2:08 AM

0 Kudos

Hi Sandy,

you seem to be asking a lot of fundamental questions. Perhaps you should start reading the documentation and having a go? Maybe even buy a book or two?

Anyway, here is a quick code sample. I have used the sample table SFLIGHT for this and am comparing the field CONNID.

DATA a TYPE TABLE OF sflight.
DATA b TYPE TABLE OF sflight.
DATA c TYPE TABLE OF sflight.
DATA d TYPE REF TO sflight.
DATA e TYPE REF TO sflight.
DATA cnt TYPE i.

SELECT * FROM sflight INTO TABLE a.
SELECT * FROM sflight INTO TABLE b.

* 1.I have to copy the contents of A and B into C.
INSERT lines of a INTO TABLE c.
INSERT lines of b INTO TABLE c.

*2.I have to output the numbers which occur repeatedly in C and also I have to output that how many times each number is being repeated.
SORT c BY connid.
LOOP AT c REFERENCE INTO d.
  IF e IS NOT BOUND. e = d. ENDIF.
  IF d->connid = e->connid.
    ADD 1 TO cnt.
  ELSE.
    IF cnt > 1.
      WRITE: /, e->connid, cnt.
    ENDIF.
    e = d.
    cnt = 1.
  ENDIF.
ENDLOOP.

*3.After obtaining the solution for second requirement I have to delete the numbers in Internal table C which are repeatedly occured.
DELETE ADJACENT DUPLICATES FROM c COMPARING connid.

Cheers

Graham Robbo

1 REPLY 1

Go to solution
GrahamRobbo
Active Contributor

‎10-08-2007 2:08 AM

0 Kudos

Hi Sandy,

you seem to be asking a lot of fundamental questions. Perhaps you should start reading the documentation and having a go? Maybe even buy a book or two?

Anyway, here is a quick code sample. I have used the sample table SFLIGHT for this and am comparing the field CONNID.

DATA a TYPE TABLE OF sflight.
DATA b TYPE TABLE OF sflight.
DATA c TYPE TABLE OF sflight.
DATA d TYPE REF TO sflight.
DATA e TYPE REF TO sflight.
DATA cnt TYPE i.

SELECT * FROM sflight INTO TABLE a.
SELECT * FROM sflight INTO TABLE b.

* 1.I have to copy the contents of A and B into C.
INSERT lines of a INTO TABLE c.
INSERT lines of b INTO TABLE c.

*2.I have to output the numbers which occur repeatedly in C and also I have to output that how many times each number is being repeated.
SORT c BY connid.
LOOP AT c REFERENCE INTO d.
  IF e IS NOT BOUND. e = d. ENDIF.
  IF d->connid = e->connid.
    ADD 1 TO cnt.
  ELSE.
    IF cnt > 1.
      WRITE: /, e->connid, cnt.
    ENDIF.
    e = d.
    cnt = 1.
  ENDIF.
ENDLOOP.

*3.After obtaining the solution for second requirement I have to delete the numbers in Internal table C which are repeatedly occured.
DELETE ADJACENT DUPLICATES FROM c COMPARING connid.

Cheers

Graham Robbo