topic Inserting Multiple Records in Transparent Table in Application Development and Automation Discussions

Inserting Multiple Records in Transparent Table

Former Member — Sun, 06 Jul 2008 12:40:41 GMT

Hi Friends,

I am New to ABAP and Previously i was in Web Dynpro Java....

I am doing an scenario Travel Request.

The Problem i am facing i this scenario is inserting the data in the table. I have to maintain a custom table in which Travel request No (Primary Key), Employee No (Primary Key) and Transport Details.....etc.are maitained...

Employee Number -

Travel Request No--~~Place From~~-Place To

70043 -

817--

Chicago--

Miami

70043 -

817--

Miami--

Chicago

I have to maintain table like this

Whenever i inseted the data into the Tranparent Table its showing dump and sy-subrc count is 4

Plz provide suggestion to achieve this........Thanks in Advance

Regards

Chandran S

Re: Inserting Multiple Records in Transparent Table

former_member195698 — Sun, 06 Jul 2008 12:47:00 GMT

Hi,

Your primary key is Travel request No, Employee No

So combination of these two should be unique.

You are trying to insert two Entries in the table with the same primary key, which is causing issues.

Re: Inserting Multiple Records in Transparent Table

Former Member — Sun, 06 Jul 2008 12:48:15 GMT

In ur case u r trying to enter duplicate values that's why u r getting error.

In ur custom table, Employee Number and Travel Request No are 2 primary keys. That means for each record content of these fields should be unique but in ur case they are same. If u really need to maintain data in this way then u have to make another field as key field so that it can uniquely identify a record.

Employee Number Travel Request No Place From Place To

70043 817 Chicago Miami

70043 817 Miami Chicago

Regards,

Joy.

Re: Inserting Multiple Records in Transparent Table

former_member1007904 — Sun, 06 Jul 2008 22:48:03 GMT

u have duplicate entries in ur primary key.