Primary Key update in RAP

[former_member839746]

Hello All,

We have a requirement, where the CDS have 3 primary keys, out of which 2 keys will be entered by the user, and the 3rd primary key should be auto populated based on the 2 keys, that were entered by the user.

Consider in the Fiori app, user enters value as A and B for the first two primary keys, on clicking save, the third primary key should be auto-populated as A-B.

Is this possible? While checking the SAP help documentation, I see the concepts of UUID, late numbering, Early numbering concepts, but unable to find a way to achieve the above functionality.

Thanks,
Naga

[Ramjee_korada]

Hi Naga,

Have you tried to use Adjust numbering concept?

It helps you to adjust key fields during save sequence.

Best wishes,

Ramjee Korada

[former_member839746]

Hi Ramjee,

We are trying update the primary which is a character based one, so I guess the adjust numbering concept will not work in this scenario.

Thanks and Regards,

Naga

[TamasFodor]

Hi,

We helped you to accept the answer, since there were no updates after few days. You can unaccept it anytime if you have further questions.

Kind regards,

Tamas

[_4ndr3as_]

Ciao Sunkara,

not sure, because I don't have deep knowledge, but did you check via the Behavior Definition and Determine logic?

determination get_key3 on save { field key1, key2; }<br>

The method get_key3 can be implemented in your behavior impl class.

METHOD get_key3.
READ ENTITIES OF ... IN LOCAL MODE
ENTITY ...
FIELDS ( ... )
WITH CORRESPONDING #( keys )
RESULT DATA(...).
....
ENDMETHOD.

Again no garantie on that.

Regards Andreas

[former_member839746]

Thanks for the update.

I've tried this approach, but it didn't work for the primary keys. It worked for the non-primary keys.