topic Re: Custom Time-Dependent Table in Application Development and Automation Discussions

Custom Time-Dependent Table

Former Member — Wed, 17 Mar 2010 20:58:23 GMT

Hi Experts,

I need to create a custom table in SAP ECC and I need it to be time-dependent, but transparent for the user that is going to maintain it through SM30.

Is there a way to achieve this?

Thanks!

Fábio

Re: Custom Time-Dependent Table

Former Member — Wed, 17 Mar 2010 21:50:23 GMT

Hello,

Yes; you can create a table using SE11 similar to table NAST. Date/Time are key fields of this table. After that, please generate a table maintenance dialog using SM30.

Thanks,

Venu

Re: Custom Time-Dependent Table

Former Member — Wed, 17 Mar 2010 22:03:46 GMT

Hi Venu,

I understood your answer and I believe the user would have to maintain the proper date ranges which I expected that could be done automatically somehow.

That´s mu doubt: Can it be done automatically? (Suppose the user doesn´t know the data is time-dependent)

Thanks,

Re: Custom Time-Dependent Table

Sandra_Rossi — Wed, 17 Mar 2010 22:58:17 GMT

You may use events in SM30, and automatically initialize date/time fields. This has been answered in the forum: http://www.sdn.sap.com/irj/scn/advancedsearch?query=modifyextractINDEX+f_index

Re: Custom Time-Dependent Table

Former Member — Thu, 18 Mar 2010 14:34:30 GMT

Hi Sandra,

Thanks for your reply, but I believe I neither understood your answer nor I put my doubt in a proper way.

What I was intending to do is someting like this:

The user fills a record into a Z tabel through SM30:

Key Field 1 Key Field 2 Key Field 1 Data Field 1

Name Address Date From Date To

Fabio Lafaiete St 18.03.2010 31.12.9999

In the example above, the user would only fills Name and Address fields (date fields would be filled automatically)

So, tomorrow, if the user changes this same record another record would be created, as following:

Key Field 1 Key Field 2 Key Field 1 Data Field 1

Name Address Date From Date To

Fabio Lafaiete St. 18.03.2010 18.03.2010

Fabio Prudente St. 19.03.2010 31.12.9999

Notice that the user would only see the last valid record through SM30, but all historic records would be registered in the table according to a data range whic data is valid.

Now, according to the example above, could this be done as proposed?

Thanks

Re: Custom Time-Dependent Table

SuhaSaha — Thu, 18 Mar 2010 14:58:51 GMT

I think your requirement is not logical.

You want to change the current entry & as per your req. you want to have a new entry added for the SAME KEY FIELDS !!! Absolutely not possible due to obvious reasons.

May be you can keep a track of the changes made via some change documents (r some other technique), but the way you want to do it is not possible.

Hope you get the point.

BR,

Suhas

Re: Custom Time-Dependent Table

Former Member — Thu, 18 Mar 2010 17:19:46 GMT

Well, I believe you didn´t notice that the field DATE FROM is also a key field. Therefore, the key is not the same at all. Check the example and you´ll see it.

Regards,

Re: Custom Time-Dependent Table

Former Member — Thu, 18 Mar 2010 17:31:47 GMT

I think you need a custom module pool program for this, not SM30.

Rob

Re: Custom Time-Dependent Table

PedroGuarita — Thu, 18 Mar 2010 17:34:56 GMT

Yes, something on the lines of delimiting infotypes for example. Well you can still use SM30 for this as well, it will need some extra coding though.

Re: Custom Time-Dependent Table

Former Member — Thu, 18 Mar 2010 17:49:23 GMT

Thanks for all replies.

As I have noticed, this probably could be done somehow but it would not be so trivial as setting some parameters or something like this. I thought coding could be avoided to a very limited level.

As a BW consultant I was hoping to be possible to set this easily as it´s done in SAP BW with Infoobjects (time-dependent master data).

Regards,