BPC on HANA Stored Procedure

[former_member212431]

Hi All,

Just one simple question on HANA Native Model thing and also the implementation of writing back data using HANA Stored Procedure. As understood from the design concept, it is supposed to push-down calculation to HANA database level. Therefore as seen from various blogs on it. There are many things need to be considered E.g. data authentication, work status and so forth. Is there any standard content similar to the class CL_UJO_WRITE_BACK or we do have to write it from scratch? I have actually done some POC on HANA Stored Procedure but before I would propose it to our client would want to know more on standardization of coding from SAP perspective.

Best Regards

David Yee

[former_member186338 · Accepted solution]

"we do have to write it from scratch" - to my mind!

[lucas_costa3]

There is no standard solution using procedures. The approach with db procedures needs to be very specific to justify doing inserts on the db layer.

Usually, I'd suggest doing the calculations on database layer and leaving the write back to the ABAP layer so security/ auditability/ workstatus/ data consistency... is handled in standard.