DDIC Entry problem

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Dear aditya,

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

[GauthamV]

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.

[SuhaSaha]

>

> 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

[Former Member]

Dear All,

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

[Former Member]

Hi,

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

Regards,

Nick

[Former Member]

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

[Former Member]

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?

[Former Member]

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?

[kesavadas_thekkillath]

Hello ... See what is a primary key

[Former Member]

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.

[SuhaSaha]

>

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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