About former_member184795

former_member184795

Based on SAP NW 7.4 sp13 Background: We recently needed to quickly create an extract of sales order related data with ~200 columns using ~20 source tables from ECC on anyDB. With a relatively straightforward pull of data, with little or no calcula...

former_member184795

Rule tables (including Range/Select-Options) using Option, High, Low values are prevalent in the ABAP application stacks. While Carine's blog below goes into how to handle Select-Options and apply the filters within a Where clause within AMDP, I wan...

former_member184795

Based on SAP HANA SPS 10IntroductionSince SPS06, SAP HANA offers a flexibility around how it manages data type LOB (Large Object Types) columns, namely Hybrid LOBs. Data types, CLOB, NCLOB and BLOB are used to store a large amount of data such as tex...

former_member184795

Based on SAP HANA SPS 10IntroductionWhile you may have a requirement to use any number of SQLScript functions within your AMDP code, there are a specific number highlighted below that may frequently appear inside AMDP queries & coding logic. In this ...

former_member184795

Question on the table type definitions for variables.From Rich's link here:http://scn.sap.com/community/developer-center/hana/blog/2014/12/01/new-sqlscript-features-in-sap-hana-10-sps9On HANA db version 1.00.097Trying to declare the following table v...

former_member184795

Thanks Michelle, the Customer/BP example is probably one a lot of folks would be familiar with, so it was a good way to illustrate what can be done with conditional aggregation. This is also broken into 2 CDS views, it could be achieved in one view ...

former_member184795

hi Eldar, not sure if this is related to what is presented in the blog. but here's an example of a select with 3 input parameters on the Calc view.

former_member184795

--set schema "XXXX" --drop table country_acc_details; create column table country_acc_details ( country nvarchar(3) not null, account_number nvarchar(10) not null, dollar_value decimal, rating int, created_at timestamp, created_by nvarchar(10), cha...

former_member184795

hi Rahul, apologies I missed this question. You may have figured this out already, but you can declare CLOB columns like below.

former_member184795

hi Ajith, Apologies as I can't test this out in 750, but you may try some intermediatary / inner views to solve this.View 1: Creates a column with the result of the instr value in INT4, say instr_posView 2: Casts the instr_pos to char, e.g. instr_cha...

User Statistics

User Activity

Using Conditional Aggregation in CDS views on AnyDB or HANA

Process complex rule tables direct in AMDP

A closer look at tables that contain LOB data type columns

Frequently used SQLScript Functions in AMDPs

table type definitions for variables

Re: Using Conditional Aggregation in CDS views on AnyDB or HANA

Re: Frequently used SQLScript Functions in AMDPs

Re: Using HANA Database Triggers to capture Selected Column updates

Re: Frequently used SQLScript Functions in AMDPs

Re: Split string in CDS View