SAP HANA XSJS SourceCode Automation

SAP HANA XSJS SourceCode Automation

Hello folks, Recently I have been working extensively on the SAP Cloud Platform using the Classic Neo environment for developing. What I have seen is we have xsodata that supports most of the CRUD operations using the user exits and modification exits, but still there are scenarios where we cannot rely on the xsodata. This is where the xsjs comes into picture.

With xsjs we can create our custom insert, update or perhaps Deep Insert logic to name a few. And when it comes to larger tables, we have to write the custom insert or update logic accordingly, test the application for any errors in the code. Most of times its the datatype missmatch. Integer field is been specified as string and so on. This is very tedious and time consuming work, especially when you have too many tables to work on in a project.

But then I thought why not automate the code!!! Simply mention the table name and table structure and get the entire functionality built for the custom insert, update or even deep insert or automate the entire source code for header item relation in xsjs. This could save a lot of coding efforts and help you focus on business functionality more. So I built a website out of it to do just that. You can visit the website at:
www.xscodegen.codes

SAP HANA XS Code Generator provides list of tools for auto code generation for xsjs. Its completely free to use,  you have auto code generators for xsjs (Server side javascript) that can generate source code based on your table structure. You have the option to choose CDS or hdbtable. Mention your table structure and the SAP HANA XS code generator creates entire source code for you.
I have also included INSERT SQL script generator.
Link:  www.xscodegen.codes/#!/upload

Upload your CSV file and provide your table structure and you have the insert scripts created for all the records. This is specially handy if you want to replicate data from one system to another.

Just give it a try and let me know if you face any problems. Also if you have any ideas that you want me to add do let me know. And the website doesn't store any of your information, the cookies used mostly are for Facebook like buttons and processing the inputs or so...

Thanks,
Mayur