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

Inserting duplicate values when only MANDT is primary key

Posted on Aug 02, 2006 at 07:20 AM 233 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!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

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

    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 a 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.

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

    Hi,

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

    Hope this helps,

    Rgds,

    Add a comment
    10|10000 characters needed characters exceeded

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

    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.