About rindia

rindia · 08-31-2016

This document is prepared on HANA SPS 12 based on this thread. Use case: The user is asked to enter a date. If nothing is specified then it should be default to first day of...

Data based on Conditions in a table · 05-21-2016

In this document we will see how to fetch data based on the conditions available in a table. Typically we will see such requirements when applications are built based on SAP HANA. This document is prepared based on version SPS 11 Revision 112...

rindia · 01-29-2016

Hi,A requirement is like this: 2 tables - employee and condition. In condition table, there can be 0 or n number of records.Based on condition table, data from employee has to be fetched depending on attribute operator and value.An attribute may occu...

rindia · 05-28-2014

Hi,Before i did Visualize plan many times without any problem.Now I am getting error while doing so.I was able to run "Explain Plan" successfully.I am on HANA revision 60. I saved above error log and the log information is given below:I can identif...

rindia · 03-25-2014

Hi,Problem description:After creating design-time artifacts, Analytic view with Anlaytic privilege having assign restriction as repository procedure is not returning desired results.HANA AWS revision 70.Problem Recreation:Below I am giving the proces...

rindia · 11-30-2023

One chance could be:In Purchase Order creation, check the Vendor Name.You might have added the Plant Assignment to this Vendor (Tcode: BP, BP Role FLVN01 Supplier, Purchasing - Vendor-General Data)If the Plant is assigned, Remove the Assignment.In EW...

rindia · 11-21-2023

Hi Rahul,You need to Update Standard Characteristics for Batch Valuation.Path: SPRO -> Logistics General -> Batch Management -> Batch Valuation -> Update Standard Characteristicsor using TCode: BMSMYou will get the pop-up screen asking for Update the...

Re: Table Transpose in SAP HANA Modeling · 08-09-2018

Hi Pavan, Better to go for script based on table function. Would like to know how you had done? Regards Raj

Re: Table Transpose in SAP HANA Modeling · 07-03-2018

In a calculation view, the columns have to be fixed. If the number of column changes then you can go for Dynamic sql.

Re: My Tables : Where used it is · 06-08-2018

You can get the list of all the tables used in a view by just using the option "Auto Documentation" . If you are not aware of this option then by google you can find it.

User Statistics

User Activity

Input parameter based on procedure of type Date

Data based on Conditions in a table

Data based on optional conditions

Error while doing "Visulaize Plan"

Incorrect results with design-time artifacts

Re: PU Withdrawn qty exceeded by 5 000 : 100000114 1710 171D

Re: Generation of class SAP_EWM_LOBM failed

Re: Table Transpose in SAP HANA Modeling

Re: Table Transpose in SAP HANA Modeling

Re: My Tables : Where used it is