Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers