topic Re: Delimiting Costumized Table in Application Development and Automation Discussions

Delimiting Costumized Table

Former Member — Mon, 04 May 2009 07:32:12 GMT

Hi,

hope someone could help me not getting mad

I have created a table which holds parameters for our agencies to a specified date range (endda, agency is key).

Now I want to have the "delimit" button in SM31, so I could have these szenario:

agency - begda- endda- param

123 - 01.04.2009 - 31.12.9999 - 1

after delimitation:

123 - 01.04.2009 - 01.05.2009 - 1

123 - 01.05.2009 - 31.12.9999 - 2

I made it to get the button "delimit" in the transaction, I where asked for a delimitation date, but then I have only one entry:

123 - 01.05.2009 - 31.12.9999 - 2

But where is the history/delimited entry???

Re: Delimiting Costumized Table

Former Member — Mon, 04 May 2009 12:34:14 GMT

Hi,

The table will not save the history because only ENDDA and AGENCY are the key fields.

Include the BEGDA and/or PARAM as the key field(s), we can achieve the required.

Thanks,

Teja.

Re: Delimiting Costumized Table

Former Member — Mon, 04 May 2009 12:53:49 GMT

THX for reply.

When I include begda in key, the delimit button dissappears und in the generator for tablemaintanance the option "generate time-dependency" (don´t know exectly the name of this option in english in german it is "Zeitabh. generieren") is not enabled.

I generated the delimit button like mentioned here:

Re: Delimiting Costumized Table

Former Member — Thu, 07 May 2009 09:09:05 GMT

Hi,

Prerequisite is to set End Date as Key field. Begin Date does not need to be Key field.

When you create the table maintenance in SE11 (in 'Maintain Table' screen > Utilities > Table Maintenance Generator). In the 'Generate Table Maintenance Dialog' screen, click on Environment > Generate Time-Dep.

Then in SM30, you should see a Delimit button. Create your entry. Delimit that entry by specifying 01.05.2009 in your example. You should see the record being delimited. If you only see 1 record, try clicking the Expand <-> Collapse button. You should see 2 records.

No need for extra coding to have the delimit function. System will auto generate the required coding once you specify 'Generate Time-Dep'.

Hope it helps!

Re: Delimiting Costumized Table

Former Member — Thu, 07 May 2009 09:57:51 GMT

ARRRGG...

If I do so, I get a short dump with a syntax error at line 219 in include LSVIMF45. Don´t know why.

The Code there is:

ASSIGN (name) TO <vim_tctrl>.

Re: Delimiting Costumized Table

Former Member — Thu, 07 May 2009 10:12:42 GMT

Hi,

Can you try to delete your original maintenance screen and create a new one by following my steps above?

Re: Delimiting Costumized Table

Former Member — Thu, 07 May 2009 10:14:39 GMT

I did it so already, but the result was the same.

Re: Delimiting Costumized Table

Former Member — Thu, 07 May 2009 13:01:47 GMT

what about checking your screen dynpro and see if the table fields are the same as what you have defined in your table? I am just guessing coz 'vim_tctrl' is the table which you maintain your table entries in. or try assigning the table maintenance to another function group.

Re: Delimiting Costumized Table

Former Member — Thu, 07 May 2009 14:28:43 GMT

First of all: THX for your answers!!

I assigned the maintenance to another function group: same error.

I debugged into the code and 'name' is having the value 'TCTRL_Z0232_PARAM' (Z0232_PARAM is the table). Don´t know what this means.

Checked the dynpro and the field are the same like defined in table.

Anybody did this job successfully before? How, what I´m doing wrong?!

Re: Delimiting Costumized Table

Former Member — Fri, 08 May 2009 02:23:53 GMT

Sorry, I also don't know unless i can debug it. If you are at your wits end, try adjusting table in SE14, if not, delete the whole table and recreate again.