avatar© Soft Metrics Consulting, February 15, 2021

SAP S/4HANA, SAP HANA

What are SAP S/4HANA and SAP HANA? SAP HANA is completely new generation of the SAP Business Suite.

Cover Image

SAP S/4HANA is written natively for the SAP HANA platform and is not a new Porsche model.

SAP S/4HANA is a move away from the transactional system that merely records data toward giving end users active decision support in real time that is based on data from both internal and external sources.

SAP HANA implementation first steps are focused around SAP Simple Finance and SAP Simple Logistics.

The next steps are simpler inventory management and valuation, along with simplifications in supply chain management, mainly demand planning.

Logistics involves some of the most complicated ERP processes, but the customer demand is strongest here since the main benefits the customers are looking for is a higher throughput.

INSERT INTO "<SCHEMA_NAME>"."ZZSTUDENT" VALUES ( '10', 'SACHIN', 'MUMBAI');

INSERT INTO "<SCHEMA_NAME>"."ZZCOURSE" VALUES('100','HINDI');
INSERT INTO "<SCHEMA_NAME>"."ZZCOURSE" VALUES('200','ENGLISH');
INSERT INTO "<SCHEMA_NAME>"."ZZCOURSE" VALUES('300','MATHS');

INSERT INTO "<SCHEMA_NAME>"."ZZENROLL" VALUES ( '100', '10', '2005');
INSERT INTO "<SCHEMA_NAME>"."ZZENROLL" VALUES ( '200', '10', '2005');
INSERT INTO "<SCHEMA_NAME>"."ZZENROLL" VALUES ( '300', '10', '2005');

SELECT A.NAME AS STUDENT_NAME,
 B.CODE AS COURSE_CODE,
 C.NAME AS COURSE
 FROM "<SCHEMA_NAME>"."ZZSTUDENT" AS A
 INNER JOIN "<SCHEMA_NAME>"."ZZENROLL" AS B
 ON A.ROLLNUMBER = B.ROLLNUMBER
 INNER JOIN "<SCHEMA_NAME>"."ZZCOURSE" AS C
 ON B.CODE = C.CODE
 WHERE C.CODE = '100';
 
 CREATE PROCEDURE _SYS_BIC.ZZPROCEDURE(
IN IV_CODE NVARCHAR(10),
OUT LT_OUTPUT <SCHEMA_NAME>."LT_OUTPUT")
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
 
/********* Begin Procedure Script ************/
BEGIN
LT_OUTPUT = SELECT A.NAME AS STUDENT_NAME,
 B.CODE AS COURSE_CODE,
 C.NAME AS COURSE
 FROM "<SCHEMA_NAME>"."ZZSTUDENT" AS A
 INNER JOIN "<SCHEMA_NAME>"."ZZENROLL" AS B
 ON A.ROLLNUMBER = B.ROLLNUMBER
 INNER JOIN "<SCHEMA_NAME>"."ZZCOURSE" AS C
 ON B.CODE = C.CODE
 C.CODE =:IV_CODE;
END;
/********* End Procedure Script ************/
Insert Data into table and some simple queries