topic Table Maintenance NUMERATOR in Application Development and Automation Discussions

Table Maintenance NUMERATOR

Former Member — Wed, 19 Oct 2005 10:15:21 GMT

Hi,

I want to add a numerator field ( domain CULFD ) in table maintenance screen. I was wondering if it can be filled automatically.

Thank you

joseph Fryda

Re: Table Maintenance NUMERATOR

former_member225448 — Wed, 19 Oct 2005 10:44:55 GMT

Hello Joseph,

if you maintain the "table maintainance dialog", you can find a kind of "userexit" in the menu path "Environment-> Modifications->Events".

If you create an entry of type 05 "creating a new entry".

The form has no parameters and is able to change the global workarea of your table, where you will find the new, just created table entry. Set your desfaults;-)

If you find my answer useful, please don't forget the reward.

Regards,

Juergen

Re: Table Maintenance NUMERATOR

Former Member — Wed, 19 Oct 2005 11:37:04 GMT

I don't want to maitain it by myself.

I want to do it as you can do it with ACCESS, just by declaring a field with numerator.

Re: Table Maintenance NUMERATOR

former_member225448 — Wed, 19 Oct 2005 14:57:55 GMT

Hello Joseph,

OK, but this is a database feature, that can not be used via ABAP/DDIC. It is a special field type, that is database specific.

SAP uses <b>Number Ranges</b> to handle such getting unique ID's in master data or documents. To get a new number of a certain number range say SD documents, you write:


CALL FUNCTION 'NUMBER_GET_NEXT'
     EXPORTING
       nr_range_nr = '01'
       object      = 'RV_BELEG'
     IMPORTING
       returncode  = da_rc
       number      = vbak-vbeln.

You have several named number objects or "number groups". Within an object you might have several ranges.

If you find my answer useful, please don't forget the reward.

Regards,

Juergen

Re: Table Maintenance NUMERATOR

Former Member — Wed, 19 Oct 2005 18:35:02 GMT

Somewhere, you have to code for filling that column, whether it is in your programs, or in the table events or in your maintenance program.