topic Re: DDIC Entry problem in Application Development and Automation Discussions

DDIC Entry problem

Former Member — Mon, 01 Feb 2010 09:41:18 GMT

Dear All,

In customer table I need to enter records, but I am not able to enter more than one record it showing 'A data record with the specified key already exists'. Please suggest me how can I enter the records.

Thanks and regards,

Krish....

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 09:43:35 GMT

Hi,

May be you are trying to make a new entry with same key fields. Please check the entry that you are tring to entry.

Please close the thread, if solved,

Regards,

Aditya

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 09:47:11 GMT

Hi,

No 'may be' about it, the message is pretty clear what the problem is.

It is most likely that the design of the key of your table does not match the data that is needed in it. Review the requirements, the data and the table design to define a key that's fit for purpose.

Regards,

Nick

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 09:47:28 GMT

Dear aditya,

I am entering different record but client number is the same.

Re: DDIC Entry problem

GauthamV — Mon, 01 Feb 2010 09:49:52 GMT

you will have that problem if you are creating 2 records which have same primary

key condition satisfied.

Check the primary key fields in your table and use accordingly.

Re: DDIC Entry problem

SuhaSaha — Mon, 01 Feb 2010 09:50:55 GMT


> I am entering different record but client number is the same.

Hello,

Then check what are the key fields of the table. As suggested by Nick an entry with the same key fields already exists in the DB so you are getting this error.

BR,

Suhas

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 10:07:30 GMT

Dear All,

How can I check what are the key fields of the table please guide me.

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 10:09:39 GMT

Hi,

Tables are defined in transaction SE11, a check in the 'Key' column denotes the key fields.

Regards,

Nick

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 10:11:29 GMT

Hi,

Goto SE12 tcode and give the table name and click on display button.On Fields tab, you will see all the fields , the fields against the Key (tick mark) are primary fields.

Regards,

Aditya

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 11:16:17 GMT

Dear All,

Is it possible to create Table Maintenance generator for standard table. If yes which function group I have to give in the function group option. suppose my table name start with '/sap/abc' if I give the function group name starts with '/sap...' it is showing the error 'No suitable namespace is available'. If I assign the another function group which is start's from z is there any problem?

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 11:20:53 GMT

Hi,

It is possible, but not advisable.

Regards,

Nick

P.S. Is this still relating to the table key, or have you started a new question?

Re: DDIC Entry problem

kesavadas_thekkillath — Mon, 01 Feb 2010 11:31:20 GMT

Hello ... See what is a primary key

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 11:32:36 GMT

Dear Nick Young ,

I am trying to do create table maintenance generator for that standard table. Before that what I did I copied the standard table into z table I created table maintenance generator for that z table after that it accept's the second entry in the same way I am trying create table maintenance generator for the standard table but it is not allowing the function group for that. This is the reason I asked the above question. Please suggest if my process is correct or wrong.

Re: DDIC Entry problem

SuhaSaha — Mon, 01 Feb 2010 11:41:45 GMT


> I am trying to do create table maintenance generator for that standard table.

Hey Krish,

A few questions:

1.Why SAP did not create a maintenance generator for this table ?

2. Did you check if there are any maintenance views for this table ?

3. Is this table maintained through some program ?

I think these questions need to be answered before creating the maint. generator.

BR,

Suhas

PS: If this table is for testing purposes, the points are not valid .

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 11:43:50 GMT

Hi,

My point is this. If the SAP table you are wanting to fill was designed to be populated directly then a table maintenance would already exist, it does not, so you should not create one.

Rather than speculate on the potential ways to update a standard table, can I instead ask what is the table you are trying to update?

Regards,

Nick

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 12:11:11 GMT

Dear Suhas Saha ,

1.Why SAP did not create a maintenance generator for this table ?

Ans: It is not standard table it is customer specific table we have no authorization to change it. while created table they may not create the TMG(Table maintenance generator).

2. Did you check if there are any maintenance views for this table ?

Ans: There is no Views for this table.

3. Is this table maintained through some program ?

Ans: No, purpose of this table is it is communicate with the XI and Webservices.if we give one time entry like web service ip address, user name and password it will pass through one server only but we have another server and another web service we need to enter another server details also.

Dear Nick Young ,

The table name is '/MXXXXXXX' and it is the specific to client only I think it is not there is standard sap tables.

My question is if I create z function group in the same package is it effect to standard functionality. If give the function group as '/sap.../ it won't accept what can I do in this case. Please suggest me.

Thanks and regards,

Krish.....

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 12:17:10 GMT

To be ansolutley honest, iIf you don't know how to check what key fields exist for a transparent table then you really should not have been let loose on the SAP system, especially when trying to fulfill a development role. I would suggest you read up or attend the Data dictionary course for SAP BEFORE you start any devlopment work.

Now, I assume that you're not a developer, possibly a functional person, so I'm going to give you the benefit of the doubt.

Although any functional or development person that asked me that question in the company that I work for would swiftly be shown the door.

Jason

Edited by: Jason Stratham on Feb 1, 2010 1:17 PM

Re: DDIC Entry problem

Former Member — Mon, 01 Feb 2010 13:14:24 GMT

Hi,

So, you have a table provided as a piece of custom development that is designed to take one entry and one entry only.

Even if you change the definition of the table to allow you to add a second entry that alone will not necessarily be enough, as the code that reads the table will probably have been written on the assumption the table has only one entry. It would seem you're not just updating a table here, you are changing the way a piece of development works and you need to approach it as such.

It feels like you need to go back to whoever designed and built this for you in the first place and get them to revise it to meet your new requirements.

Regards,

Nick