Skip to Content
author's profile photo Aris Hidalgo
Aris Hidalgo

Inserting duplicate values when only MANDT is primary key

Posted on Aug 02, 2006 at 07:20 AM 165 Views

Hello experts,

I have 4 fields in my UDT(user defined table) namely MANDT, ZEVENT, ZRECIPIENT and ZEMAIL.

Now, Only MANDT is the primary key. My question is, how can I insert duplicate values

via SM30?

Again, thank you guys and take care!

ABAP Development
Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 07:29 AM

    You cannot have only client field in the primary key if you want to maintain multiple records in your table.

    In your table if you will always have one recipient per event then you should have ClientEvent as the primary key. If you might have more than one recipient per event then the primary key should be ClientEvent+Recipient.

    Kiran

    Please mark useful answers

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Aris Hidalgo
      Aug 02, 2006 at 08:51 AM

      Hi again,

      1. open the Layout of that screen

      2. using drag&drop

      just REMOVE the field from the table control.

      3. Also

      4. In the flow logic of that screen,

      remove the line / commen it

      which has been put in CHAIN

      for eg.

      • FIELD YHRT_FUNMST-FUNSORT .

      5. Activate everything

      6. try again via sm30 in new session.

      7. NOW IT WILL WORK. I JUST TRIED IT.

      regards,

      amit m.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 07:32 AM

    Hi,

    To insert duplicate values, make the following fields as key fields, MANDT, DATA & TIME in the table,

    Hope this helps,

    Rgds,

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 07:32 AM

    Hi Viraylab,

    You cannot insert Duplicate records if there is an Primary Key. You can do if your Table has COmposite Keys.

    Hope this would have helped you .

    😊

    Cheers,

    Prashanth

    Add comment
    10|10000 characters needed characters exceeded