About martin_chambers

martin_chambers · 04-23-2023

I would like to loop over a table with 3 fields and use the value in column LOOKUP_1 in each row to create a hierarchy. The hierarchy consists of several rows. I want to append these rows to a 2nd table. Thus, if my 1st table has 30 rows, I want my 2...

martin_chambers · 03-26-2023

I would like to use the Hierarchy function as a filter. I have a table with 3 fields (see below). For each value in P_CHAIN I want to compare the fields in the columns. In particular, I want to check if the value (node) in LOOKUP_2 is contained in ...

martin_chambers · 03-14-2023

Currently, I have a list of records that looks a bit like this (it is actually much longer) I would like to generate all pairwise combinations of Field_B with the same value in Field_A. If there is only one vleue in Field_B assigned to Field_A, ...

martin_chambers · 03-14-2023

We are using BW/4 HANA 2.0 and all our transformations use HANA SQL in the routines. I would like to create a list with the DTP ID and all the transformation IDs used for that DTP.This is not too difficult if only 1 transformation per DTP, i.e. the...

martin_chambers · 07-01-2019

I have found some transformations in the table RSTRAN with an object version OBJVERS=R I know A, M, T and D but what does R mean?

martin_chambers · 04-23-2023

Hi JohanThank you for your idea. Unfortunately, I have not understood your reply. Could you add more details? A fully funcitonal code would be helpful.

martin_chambers · 03-26-2023

I have found a solution.I just create a self join using only Field A in the on condition. This will create a cartesian product of all records with the same value in Field A. In other words, I have created the paired combinations.

martin_chambers · 03-15-2023

Hi Muthaiah,thank you very much for your quick response. I tried your SQL query with my data. The SQL query results for Field A = 2 are not what I had hoped for. I has been expecting.a) The fields C and D are swapped. This is not important.b) a "C" i...

martin_chambers · 03-15-2023

Thank you Dominikthat is exactly what I was looking for!

martin_chambers · 03-15-2023

Thankyou Muthaiah for answering so soon.I tried your SQL query but the table (or view) SBIW_TRANSFORAMTION_MAPPING was not recognized (Invalid table name). I also could not find it in SE16.

User Statistics

User Activity

HANA SQL - Loop over table A and append rows to table B

Using the SQL Hierarchy function as a filter

Generate pairwise combinations in HANA SQL

How do I identify the BW transformations used in a DTP

SAP BW object version R

Re: Using the SQL Hierarchy function as a filter

Re: Generate pairwise combinations in HANA SQL

Re: Generate pairwise combinations in HANA SQL

Re: How do I identify the BW transformations used in a DTP

Re: How do I identify the BW transformations used in a DTP