Delimiting Costumized Table

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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:

[Former Member]

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!

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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?!

[Former Member]

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.