topic Re: maintaining version in Z table in Application Development and Automation Discussions

maintaining version in Z table

Former Member — Mon, 03 Jul 2006 09:57:23 GMT

Hi All!

I have a program which updated the Z table with certain rows every time it runs.I want to add a version number to the z table by adding a extra column which will distinguish me between program runs.

I mean if the program runs for the first time the version number will be 1 for the all the rows it updates the ztable.If it runs for a second time the version number will be two and so on...

Please advise how to achieve this..

Regards

Praneeth

Re: maintaining version in Z table

Former Member — Mon, 03 Jul 2006 09:59:07 GMT

Hi,

Instead of Version, you can think of having a date & time stamp which would help you to identify the latest run from the time & date,

Rgds,

Re: maintaining version in Z table

Former Member — Mon, 03 Jul 2006 10:00:32 GMT

change the in SE11 to add the column. You can adjust the table using SE14.

After the alter the code wherever you inserting rows into the table, to update the new column as well.

Regards,

Ravi

Note :Please mark the helpful answers

Re: maintaining version in Z table

Former Member — Mon, 03 Jul 2006 10:00:37 GMT

Hi Praneeth,

Add a column to the ztable for the serial number also.

Then maintain it using the function module NUMBER_GET_NEXT in the pai section .

Regards,

Ravi

Re: maintaining version in Z table

Former Member — Mon, 03 Jul 2006 10:01:52 GMT

You can acheive this by creating a change document object for your custom table.

After creating the change document object you need to call the change document function module(generated when you create the change document object) with proper parameters in you application which updates the custom table.

Please refer SAP documentation for change document objects.

-Kiran

Re: maintaining version in Z table

Former Member — Mon, 03 Jul 2006 10:02:00 GMT

You can maintain a field for Version in your Z table and use the internal table in the program (which updates all other fields in this table) to update this field each time the program runs.

You can give:

Itab-version = itab-version + 1.

Do this for each of the modified records and update to the table along with the other records.

The timestamp is also a good suggestion.

Hope this helps.

Sudha