RAP - Numbering
In this article we will take a look at automatic number assignment and how we can assign numbers ourselves in the case of the partner app.
Table of contents
When we worked with the previous app, we always had to assign a number to new data sets ourselves. Here, however, the RAP object should assign the number itself and leave us, the user, alone.
Scenarios
There are three different scenarios for assigning numbers in RAP, which are also intended for different purposes:
- Early numbering (external) - This variant was already used by us in the old app, the user is responsible for assigning the primary key himself. The validation only checks for duplicate keys and whether the key has been filled.
- Early numbering (internal) - In this variant, the key field usually consists of a UUID and the unique ID is assigned via the RAP framework. A uniqueness check is no longer necessary since the UUID is always unique.
- Late numbering - The late number assignment only occurs in the storage sequence of the framework, just before the data is written to the database. At this point you can assign a number by number range or assign the key in another way.
The assignment of the number can be particularly important when it comes to complete receipts or numbering. A document that does not leave the draft status or is deleted again would create a gap in the document numbers, which is not possible from a business point of view.
Early numbering (internal)
There are two forms of this form of number assignment, one variant via the automatic assignment of a UUID and the second variant with the manual assignment of a number. In the first variant, the "numbering" attribute is defined in the corresponding field. This tells RAP that an automatic UIUD should be assigned here.
field ( numbering : managed ) FieldName;
For internal assignment by method, the addition "early numbering" must be used in the behavior definition of the object. The "FOR NUMBERING" method must then be implemented. There you have the possibility to implement a number assignment with coding. This variation is similar to the late number assignment example below.
Late numbering
Um die späte Nummernvergabe zu realisieren, muss in der Verhaltensdefinition am Objekt der Zusatz "late numbering" ergänzt werden. Gleichzeitig sollte das Schlüsselfeld auf Read-Only gesetzt werden, da der User hier keine Eingabe mehr machen kann. Dazu der Auszug aus der Verhaltensdefinition:
managed implementation in class zbp_bs_demo_rappartner unique;
strict;
define behavior for ZBS_I_RAPPartner alias Partner
persistent table zbs_dmo_partner
lock master
authorization master ( instance )
late numbering
{
create;
update;
delete;
field ( readonly ) PartnerNumber;
mapping for zbs_dmo_partner
{
PartnerNumber = partner;
PartnerName = name;
Street = street;
City = city;
Country = country;
PaymentCurrency = payment_currency;
}
}
The compiler then tells us that we still have to generate the implementation, which is done automatically with CTRL + 1. The empty implementation is created in the memory sequence and not in the behavior implementation as before. The "ADJUST_NUMBERS" method can now be filled:
CLASS lsc_zbs_i_rappartner DEFINITION INHERITING FROM cl_abap_behavior_saver.
PROTECTED SECTION.
METHODS adjust_numbers REDEFINITION.
ENDCLASS.
CLASS lsc_zbs_i_rappartner IMPLEMENTATION.
METHOD adjust_numbers.
ENDMETHOD.
ENDCLASS.
We use a very simple logic for the number assignment, in which we determine the maximum number and then increase it for all new data records:
SELECT FROM zbs_dmo_partner
FIELDS MAX( partner )
INTO @DATA(ld_max_partner).
LOOP AT mapped-partner REFERENCE INTO DATA(lr_partner).
ld_max_partner += 1.
lr_partner->PartnerNumber = ld_max_partner.
ENDLOOP.
Test
Before we can start testing, we need to comment out the implementation of the validateKeyIsFilled method. The key is no longer assigned externally, but only in the storage sequence. Because validation is called before the sequence, validation would hinder the save operation. Let's take a look at the largest partner number:
With "Create" we create an empty data record and also see that the partner number is blocked, manual entry as before is not possible.
After the fields have been filled, we can click on the "Save" button, the fields will be locked and the new record will be presented. The number has been assigned and can be seen in the detail image.
Conclusion
As you can see, the implementation of the automatic number assignment is not rocket science and only requires a few small steps. When designing the RAP business objects, you should think about what type of keys you want to use. No matter whether UUID or number range, the automatic assignment takes a lot of work.
