Delimiting dates in SM30

[Former Member]

I created a custom 'Z' table with key fields including end date (ENDDA). The begin date (BEGDA) is the first field that is not a key field. When I click on the delimit button and enter a date to delimit the record, the previous record is delimited but the new record is not created. This process should delimit the existing record and create a new one, but instead there is only the delimited record. Isn’t this part of the SAP standard delimiting functionality? I’ve seen posted issues like mine but no resolutions. Any help would be appreciated.

[Former Member]

Hi Rick,

I'm not really sure what you mean by the <i>delimit button</i> or for that matter what you're trying to <i>delimit</i>. Could you please explain the problem once more ?

Is there any standard table that resembles your Z table ? That would help analyze the probelm better.

Regards,

Anand Mandalika.

[Former Member]

Hi Anand,

The delimit 'feature' I'm referring to is similar to delimiting info-type (PAxxxx) records in HR. When I enter SM30 to maintain my 'Z' table, there is a Delimit button along with the 'New Records', 'Copy', and 'Delete' buttons. (I think this is because ENDDA and BEGDA are specified as adjacent fields with ENDDA being the last key field.). The Delimit button (when pressed) should allow the user to 'end' an existing record AND create a new record. As an example: My 401k contribution is currently 5% so my record would have a Begin Date of 01/01/2004 (my hire date) and an End Date of 12/31/9999. Today I change my contribution to 7%. When I delimit the existing record, the End Date is updated - Begin Date 01/01/2004 and End Date 07/20/2005. A new (delimited) record SHOULD also be created - Begin Date 07/21/2005 and End Date 12/31/9999. However, the new record is not being created, that’s my problem.

Regards, Rick.

[Former Member]

Well, I don't think it's part of standard SAP functionality. But as I suggested in an earlier post on a different thread, there are events defined in the table maintenance generator. You could probably do what you want using one of these.

From the table maintenance generator screen:

Environment->Modification->Events

Rob

[andreas_mann3]

Hi Rick,

there're fm , which can help you, to delimit data:

-> look function group TITI

regards Andreas

[Former Member]

Hi,

I would suggest you to use events to handle your problem.

1. Go to se54

2. Specify the table/view name

3. From the menu: Environments----->Events

4. In the first column specify the event and in the second column specify the subroutine.

5. In the subroutine handle your requirements.

Thanks & Regards,

Venkat