Custom Time-Dependent Table

[Former Member]

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

[Former Member]

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

[Former Member]

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,

[Sandra_Rossi]

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

[Former Member]

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

[SuhaSaha]

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

[Former Member]

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,

[Former Member]

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

Rob

[PedroGuarita]

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.

[Former Member]

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,