About martin_lehmann4

martin_lehmann4 · 03-03-2024

Hello all,I try to realize a "F4 help" with these values for the attribute DueItem of an accounting document:and tried to achieve this according to this solved subject Solved: Not Able to get F4 Help in Analytics query - SAP Community .With these two...

martin_lehmann4 · 03-23-2022

Hey folks, I have a requirement to read the last amount of HSL to this selection: WHERE RLDNR = 'LL' AND RACCT = '1234-321' AND RBUKRS = '4711' AND GJAHR = '2018' which gives me without using aggregate function LAST_VALUE 2 rows as result -unf...

martin_lehmann4 · 08-19-2021

Hi experts, I need to write and read to/from a local table in UDF / table function. I learned from this thread: https://answers.sap.com/questions/124436/create-temporary-local-table-in-function-on-hana.html , that this is only possible by calling a...

martin_lehmann4 · 07-28-2021

Hi experts we need to read data in hdb (release 1.00.122.27.1568902538) via SDA from cluster table BSEG in ERP (version NW 7.50 SP 16). As direct reading via CDS or SDA from any cluster or pool table is not supported by SAP would it be possible to ...

martin_lehmann4 · 04-20-2021

Hello all, I have a table with several PRCTR data, e.g. (first_selection) MANDT KOKRS PRCTR VAL_FROM REGION SHOP 1000 2000 4711 20110202 39 01 1000 2000 4712 20121231 39 ...

martin_lehmann4 · 03-23-2022

A data example for the above mentoined behaviour of LAST_VALUE would be:BELNR HSL0003102556 1000003102557 200I would like to select only the second row, but it doesn't work ... - it reads both this way.

martin_lehmann4 · 08-23-2021

That works, thanks a lot. HANA 2.0 is already on our sandbox system and soon on production system too - then I will try it with DML on table variables...

martin_lehmann4 · 08-20-2021

The use case is as follows:- A BEx query on Composite Provider reads from Calculation View with Table function (BWoH hdb release 1.00.122.27.1568902538) the number of sentences of the same table in five different ERP systems - these systems are conne...

martin_lehmann4 · 07-29-2021

Hi Werner,thanks for your answer - we will evaluate whether SDI is an option for us...Best regards, Martin

martin_lehmann4 · 07-28-2021

Hi Tobias,finally it turned out that your proposed settings were correct - but only with the installation of the then latest version of Eclipse 2020-12 and the corresponding HANA development plugin the SQLScript debugger in Prod works fine and helps ...

User Statistics

User Activity

Issue with value help for Custom Query

Issue with LAST_VALUE in SQLScript

How to use temporary table for table function?

Consume BSEG data via SDA

Issue with "single-row query returns more than one row"

Re: Issue with LAST_VALUE in SQLScript

Re: How to use temporary table for table function?

Re: How to use temporary table for table function?

Re: Consume BSEG data via SDA

Re: Debugging SQLScript in productive system