rajark
Discoverer
Member since ‎08-18-2023

User Statistics

  • 4 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

How to schedule a procedure that runs daily in hana cloud using sap bas

11-21-2023
Hi i am trying to schedule a hana procedure in cloud environment through sap bas and with the help of sap documents i am running below query(CREATE SCHEDULER JOB DailyServiceMasterDataJob START TIME '00:00:00' REPEAT EVERY 1 DAY EXECUTE PROCEDURE Ser...

display sum of lower level values to higher level in hana data

08-20-2023
Hi all this is the query i am using SELECT m.solversionid, m.variant, m.description, m.level, m.services_crmid, m.parentnode, m.itemtype, CASE WHEN m.level = 1 THEN COALESCE(( SELECT SUM(sub.sspmaxmargin) FROM C...

Hna cloud sql query to sum the data based on levels and partitioning by parentnode

08-18-2023
id level description netprice Parentnode hirerachynode 100 0 Total sum(offering1+offering2) Null 1000 100 1 offering1 sum(service1+service2) 1000 11 100 1 offering2 sum(service3+service4) 1000 12 100 2 service1 sum(deilvery1+delivery2) 11 40 ...