About SilasL

SilasL

Dear Experts,I'm having the following error when I try to execute an insert CQL statement in SAP CAP for Java for a denormalized view, a projection of a database with filters.Caused by: org.h2.jdbc.JdbcSQLFeatureNotSupportedException: Feature not sup...

SilasL

Hey All, I'm trying to get a CDS view entity to take a currency amount and convert that amount to follow the format for the given currency code. I have a minimal version of my CDS view below. @AbapCatalog.viewEnhancementCategory: [#NONE] ...

SilasL

Hey All, I get the error in the title when I run performance db ATC test. I'm trying to get data from multiple tables using join. But since BSEG is a cluster table, I can't use join with it. So I made another statement using FOR ALL ENTRIES. To s...

SilasL

Hey, I am trying to create purchasing contracts by using BAPI_CONTRACT_CREATE in a program. Since version management is not support at the moment, the purchasing contracts do not have version management at creation. I understand that SAP has stat...

SilasL

Hey All,I noticed that I had the same issue and I was working on an SAP Tutorial for CAP Java. I don't seem to be the only one either as someone as already created a post about it. An error occurs in steps 1-3 of CAP Tutorial 'Extend the bookstore wi...

SilasL

Hey Ozan,I've tried changing those parameters and the results are the same. The converted amount still only has 2 decimal places. key t001.waers, @Semantics.amount.currencyCode: 'waers' bseg.dmbtr as original_amount, cas...

SilasL

Hey Ozan,The currency_conversion didn't work for me, here is how I used currency_conversion.define view entity z_cds_currency_convert as select from bseg inner join t001 on bseg.bukrs = t001.bukrs{ key t001.waers, @Semantics.amount.curren...

SilasL

My fault on the code. It should be INTO TABLE @DATA, so it's fixed now.I ran the ATC test called performance_db.I haven't looked into notes yet. I was mainly looking at SQL documentation for ABAP, seeing if there were specific notes for cluster tabl...

SilasL

The exact error is Description : SELECT * FOR ALL statement can be joined with SELECT statement at ... line ... Check :Search SELECT .. FOR ALL ENTRIES-clauses to be transformedThis error is for the select on BSEG.Yeah I forgot the TABLE keyword for...

User Statistics

User Activity

SAP CAP Java Insert CQL Statement Error for Denormalized Views

CDS View Entity Incorrect Currency Format

Performance DB SELECT * FOR ALL statement can be joined with SELECT statement at ... line ...

Activate Version Management for BAPI Purchasing Contract

Re: CAP CDS Import error in JAVA

Re: CDS View Entity Incorrect Currency Format

Re: CDS View Entity Incorrect Currency Format

Re: Performance DB SELECT * FOR ALL statement can be joined with SELECT statement at ... line ...

Re: Performance DB SELECT * FOR ALL statement can be joined with SELECT statement at ... line ...