Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Create a client specific table

Former Member
0 Likes
1,367

Hi,

I have to create a client specific table which should have no key as I need to append duplicate rows.

Can anyone tell me?

Best Regards,

JS

7 REPLIES 7
Read only

Former Member
0 Likes
833

Hi Jashandeep,

Table should have a key.The best way i can suggest is have the date & time of execution as Key.Then you can have duplicate records for what ever you want.

Read only

Former Member
0 Likes
833

I guess you can do that by creating a Ztable in SE11 but i guess you cannot escape from not giving any key as <b>MANDT</b> is the field that is suppose to be one of the key fields for all the entries that you create in that

Read only

Former Member
0 Likes
833

Well use MANDT as 1st column and made all the fields as a key.

Message was edited by: Amit Gupta

Read only

Laxmana_Appana_
Active Contributor
0 Likes
833

Hi,

You can try this ,make all the fields of the table as key feilds ,if all the column values are not repeating.

Laxman

Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
833

If you need this functionality of persisting data like this with no key and with duplicate records, then you best bet is to write to a flat file on the application server using the DATASET statements.

Regards,

Rich Heilman

Read only

Former Member
0 Likes
833

You have to have at least one key field and its content should be unique. You can probably have a sequence number as the key field and create a unique sequence number and use it.

Read only

Manohar2u
Active Contributor
0 Likes
833

You should have atleast one key, for this you can keep time stamp as a key or any number range/serial number as key.

Regds

Manohar