Skip to Content

HANA Scripted View How to add the quantity for each row value

Nov 09, 2017 at 05:42 PM


avatar image
Former Member

Hi Experts,

Please help me with the code in Scripted HANA View for the below requirement.

Requirement: I need to Populate the Calculated column based on Req Qty and Material.

For each material need to sum up all the quantities based on date.

Example: for Material Mat1 1st row it has to populate 10 in the calculated column,

And in the 2nd row it has to populate 40 in the calculated column i.e 30+10

Similarly in the 3rd row it has to populate 60 in the calculated column i.e 40+20

Like that I need to populate the calculate column in the below table.

RESBReq NoReq DateMaterialPlantReq QtyCalculated ColumnReq17/11/2017Mat150011010Req28/11/2017Mat150013040Req39/11/2017Mat150012060Req410/11/2017Mat1500150Req17/11/2017Mat250011010Req28/11/2017Mat250013040Req39/11/2017Mat2500120Req49/11/2017Mat2500130Req56/11/2017Mat2500110

10 |10000 characters needed characters left characters exceeded
Former Member

Please find the table below for reference.

snasc.png (16.3 kB)
* Please Login or Register to Answer, Follow or Comment.

0 Answers