cancel
Showing results for 
Search instead for 
Did you mean: 

Database Table

0 Kudos

How to create a database table in SE11, which accepts only single record and if user tries to make an entry of more than one record, it should throw an error.

I tried using TMG events, but, its not working as per the requirement.

former_member763929
Participant
0 Kudos

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

amontella96
Active Contributor

Hi s2jha

is it not what is described Please use event 05

cheers!A

0 Kudos

How to get the number of entries which user is trying to insert into the database?
How to restrict user to enter only one record in the table control of tmg??
As while clicking on save for the first time, it will save/insert multiple data at once.

Accepted Solutions (0)

Answers (1)

Answers (1)

DominikTylczyn
Active Contributor
0 Kudos

Hello s2jha

Assuming the table is client-dependent, you should create a table with only one key field of type MANDT. This way you'll be able to add only one record to the table.

Best regards

Dominik Tylczynski

0 Kudos

Any other alternative?

DominikTylczyn
Active Contributor
s2jha

Why would you need an alternative? That solution I've described is the simplest one, 100% standard., without any additional developments.