topic Re: Create a client specific table in Application Development and Automation Discussions

Create a client specific table

Former Member — Thu, 06 Jul 2006 19:33:57 GMT

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,

Re: Create a client specific table

Former Member — Thu, 06 Jul 2006 19:35:51 GMT

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.

Re: Create a client specific table

Former Member — Thu, 06 Jul 2006 19:36:52 GMT

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

Re: Create a client specific table

Former Member — Thu, 06 Jul 2006 19:40:49 GMT

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

Message was edited by: Amit Gupta

Re: Create a client specific table

Laxmana_Appana_ — Thu, 06 Jul 2006 19:41:04 GMT

Hi,

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

Laxman

Re: Create a client specific table

RichHeilman — Thu, 06 Jul 2006 19:42:12 GMT

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

Re: Create a client specific table

Former Member — Thu, 06 Jul 2006 19:42:39 GMT

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.

Re: Create a client specific table

Manohar2u — Thu, 06 Jul 2006 19:45:20 GMT

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