196 questions
0
votes
0
answers
17
views
Re-Using schema across two projects in NODEJS SAPUI5 CAP FIORI
I am new to nodejs sapui5 fiori cap applications and I am trying to create two applications that use the same database schema, they are connected to the same database as it is part of a multi-step ...
- 386
0
votes
0
answers
80
views
How to set value for @Consumption.filter.defaultValue?
I've got code like @Consumption.filter: { default value: '2025' }. Instead of this constant value, I want to have a dynamic value approach like:
last day of the current month
current year
= !blank
...
0
votes
0
answers
94
views
Error During CAP Integration with SAP SuccessFactors: "Failed to Build Headers"
I’m encountering an issue while working on an SAP CAP-based application. I'm sharing the details below and hoping for guidance from anyone experienced in CAP and SuccessFactors API integration.
The ...
0
votes
0
answers
442
views
ABAP CDS View - ON and Where Clause Using Substring
I create SAP ABAP CDS view using Z table join with table AUFK and COBRB. I want filter field GABJA based on year of KEYDT and field GABPE based on month of KEYDT. But, when I put code c.gabja = ...
0
votes
1
answer
431
views
How to simulate LEFT and RIGHT functions in ABAP CDS 7.40?
The Eclipse (version June 2023 release) is showing a syntax error on the below SAP CDS view, I am unable to save/activate it in our SAP ECC system, but exactly the same code is saving/activating fine ...
- 11
0
votes
2
answers
164
views
AMDP Unable to use UNION ALL with local tables - sql syntax error: incorrect syntax near "UNION
I have a requirement to create a table for 2 columns: first date of the month and the last day of the respective month. The last day calculation works correctly but I am not able to merge the results ...
- 1,008
0
votes
0
answers
64
views
Spring message not recognised correctly in other languages except English
In cds-messages.properties we have defined the message
409003=''{0}'' is a required field (*).
For the same in error-messages-label-mapping.properties file we have defined the variable names
name=...
- 1
0
votes
0
answers
91
views
Currency decimals issue CDS to SAC
I have developed CDS view that is consumed by SAP Analytics Cloud. One of the columns represent financial balance.
As you might see the value is formatted with two decimals (typical for SAP DBs I ...
- 23
-1
votes
1
answer
298
views
Extend CDS consumption view with one field
I want to extend standard CDS /PF1/C_VH_ACCOUNT_ID with "segment_id" field from table /PF1/DB_SGMT_ACT. The reason is that i want to use this field to build additional access control to this ...
- 23
-1
votes
2
answers
1k
views
How to get beginning/start date and month of the year in ABAP CDS view using $session.system_date
The requirement is to fetch all the material master data based on the date and the date must be beginning of the year i.e., 01.01.2024. We have declared $session.system_date as a current date input ...
0
votes
0
answers
503
views
How to pass parameter from parameterized parent view to parameterized child view?
I have two CDS-Views with the same Parameters. They have a composition - to parent association constellation.
The parent view will be used to build a Fiori List Report Page (via Elements). The ...
- 61
1
vote
1
answer
122
views
Static factory action doesn’t appear on the table toolbar
I have defined a static factory action in the behavior definition as follows:
In the behavior projection, it is also enabled:
Here is how the static factory action is annotated in the meta extension
...
- 34.1k
0
votes
0
answers
91
views
SUM aggregates on multi level autoreference table in ABAP CDS
I have an auto-referenced table with "storage location".
Location
Higher Level Location
A
A1
A
AA1
A1
AAA1
AA1
AAAA1
AAA1
B
In another table, I have some stock in AAA1.
I have ...
- 57
0
votes
0
answers
133
views
CDS View Geolocation Data - Coordinates get interpreted as measures
we have the requirement for a geomap in an accounting dashboard.
For this we need geolocation data which we get from the table geot005.
The geodata gets selected just fine, but gets interpreted as ...
- 267
0
votes
0
answers
146
views
CDS View select from parameterized view
I have a CDS view with parameters defined like this:
@AbapCatalog.sqlViewName: 'CFIMSPLANACT2501'
@EndUserText.label: 'mspa'
@VDM.viewType: #CONSUMPTION
@Analytics.query: true
@AccessControl....
- 81
0
votes
0
answers
216
views
SAP SAC Analytical Model cannot be opened
I want to create a model for SAC.
I have an initial CDS view to collect the data like this:
@AbapCatalog.sqlViewName: 'ZWODPROBLEMZZ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl....
- 81
1
vote
1
answer
436
views
SAP SAC Customs view not visible after upgrade
We had an update on the SAP system and when searching for custom CDS views in SAC i cannot find any of them anymore. They are all gone but i can open the old stories which use the right analytical ...
- 81
0
votes
0
answers
95
views
SAPUI5 Basic Template use of Annotations
I am having requirement to use value help that was created using @Consumption.valueHelpDefinition.
I have used them in different UI5-based templates. There is no need of extra coding for that.
Is ...
0
votes
1
answer
694
views
Universal way to check for empty/uninitialized RAW values
I am hoping to find a universal way to test "initial"/uninitialized values of RAW type (potentially other binary too). ABAP initial value article says there are no initial values for ...
- 1,646
0
votes
0
answers
29
views
How to verify maintained texts in Maintain Translations Tile App?
I'm trying to explore the Maintain Translations tile app. I have successfully translated labels of a custom CDS views. However, I am not sure on how to test it.
I have tried to login on a different ...
- 55
2
votes
0
answers
1k
views
CDS View Table functions Abap Class consume with parameters
I want to select data through a class method implemented in ABAP class. This method takes parameters from the defined table function to filter on POnumber and POitem.
Goal is to call this table ...
- 81
0
votes
1
answer
236
views
Show aggregated values breakdown in a separate column?
I wanted to ask how can i see which values have been aggregated during the aggregation when using for example a sum agg in SQL.
E.G
Product
Quan
A
5
A
10
Consider this i want to agg the Quan and ...
- 81
0
votes
0
answers
268
views
TypeError: Cannot read properties of undefined (reading 'options')
I am seeing below error after i run 'cds add xsuaa' in project terminal.
Type Error: Cannot read properties of undefined (reading 'options')
at new ProjectReader (/home/user/.node_modules_global/lib/...
0
votes
0
answers
264
views
Count_distinct in analyticsDetails abap cds consumption view
I have a little problem, but I don't know what it is. I created a consumption CDS view and it works fine, but I'm trying to count one field with a condition.
This is my code:
@AbapCatalog....
- 175
1
vote
1
answer
2k
views
Virtual element is not calculated
I'm trying to display item texts in Fiori app Display Line Items in General Ledger (F2217). I've extended the standard CDS view with a virtual element, but the code calculating the virtual element is ...
- 1,820
0
votes
0
answers
306
views
SAP / DDLS Usages not deleted after removing custom field
In an SAP System I deleted a field object created over the app "Custom fields and logic". Even though I am quite sure I deleted the usages of the field there are still objects which are in ...
- 11
2
votes
1
answer
327
views
How to list all extensions created for a standard CDS view? [closed]
I want to know name of all existing extensions in CDS view. Is there any FM or class which can help here? Any class which, accept a CDS view and returns all existing extensions.
0
votes
3
answers
422
views
Is there a command to Move Fields from an internal structure to fields of a data reference from the same type?
I have the following code in ABAP, which I would like to simplify.
I have a CDS View of type Z_I_CAR and an internal structure of type ZCAR and I need to make a data reference to the CDS View in order ...
- 1
2
votes
2
answers
2k
views
How to use hierarchy CDS in another CDS?
I created an ABAP CDS hierarchy and I want to use it in another CDS to get the root node ID as a field. How can I do that?
This is my source table:
@EndUserText.label : 'Hierarchy'
@AbapCatalog....
- 1,049
0
votes
1
answer
109
views
Title: SAPUI5 Consume OData - Displaying Count of Plants in LaunchPad View
I am working on a SAPUI5 application using CAP Business Application Studio (BAS), and I have a LaunchPad view with a tile that navigates to the PlantsList view. I want to display the count of plants ...
0
votes
0
answers
1k
views
multiple values as input parameter for CDS consumption view
is there a way to pass multiple values as input parameter, if the CDS View is a consumption view consumed by a list report template?
As far as I found out you could achieve this by calling the CDS ...
- 33
0
votes
1
answer
818
views
Change the behavior of a filter on a standard unmanaged query
I have added a field to the Supplier List Fiori app by extending the underlying CDS views C_SupplierList and C_Supplier. This new field holds a concatenation of the Supplier's Industry sectors in a ...
- 1,820
1
vote
0
answers
219
views
Idiomatic way to call a BAPI from BOPF CDS?
What is the idiomatic way of calling a BAPI from within a generated BOPF Business Object? In this case I mean the ones generated using the @ObjectModel.* CDS annotations.
For example I would like to ...
- 125
0
votes
0
answers
959
views
Add custom field to Fiori App "Record Defect" (F2929) - SAP Quality Management
I tried to add a custom field (simple CHAR20 text) to the Fiori App "Record Defect" (F2929), but I got really stuck.
What I have tried:
I followed this blogpost (https://blogs.sap.com/2020/...
- 1
0
votes
1
answer
314
views
Unable to update the association field
Unable to update the association field:
CDS Entity 1:
entity PackagingIssues : cuid, managed {
PackagingIssueId : String;
issueDes : String(80);
postingDocument : PostingDocument;
}
...
0
votes
1
answer
1k
views
Is it possible to have file upload using pure ABAP CDS and SAP Fiori Elements?
I would like to try uploading a file in a generated SAP Fiori Elements app using pure ABAP CDS. I know that I can create a file upload dialog in a Freestyle app, but that is not what I'm looking for.
...
- 125
2
votes
1
answer
2k
views
SAP-RAP-Unmanaged: Confusion about execution of behav's read
I have an unmanaged rap scenario, where the topmost root entity is covered with a projection, the corresponding behav also has a projection.
The generated implenentation of the behav created empty ...
- 1,851
1
vote
1
answer
537
views
No authorization for data preview in ADT 2023-06
The error I faced when trying to access view demo_cds_curr_conv on ABAP BTP Trial is
I want to find out what is the authorization missing, is there a way?
In classic ECC accessed via SAPGui we can ...
- 10.6k
0
votes
1
answer
3k
views
abap sql / CDS- how to get multiple rows into a single row (group by)?
My CDS view delivers a result like this.
* RESULT CDS VIEW
*----------------------------
*|CHARG|Z_F1 |Z_F2 |Z_F3 |
*----------------------------
*|011 |VAL F1| | |
*|011 | |VAL F2|...
- 1,233
0
votes
1
answer
3k
views
SAP RAP CDS annotations.. is it possible to show association to Table in List Report Object Page (for Fiori elements)?
I have seen many tutorials for SAP RAP CDS annotations for Fiori Elements..
I already managed to show the relation "composition" [1-1] to a sub-entity (e.g from Users to TodoItems), but only ...
- 3,593
1
vote
0
answers
1k
views
SAPUI5, RAP, unmanaged and freestyle: Create entity and children with "create by association" - how to call from client code?
I want to create a header with its 2 associations in one go.
My behaviour class exists, the "create" on the root entity is called properly and twerks nicely.
But the passed parameter for ...
- 1,851
0
votes
0
answers
1k
views
How to use nested $expand on CDS Views with OData.publish:true
Imagine we have three nested CDS Views A>B>C that are linked together with associations with 0..* from top to bottom (e.g.: A > 0..* > B > 0..* > C). All three CDS Views are ...
- 35
1
vote
0
answers
2k
views
analytical cds --> get average on calculated field with currency_conversion
I'm trying to calculate the average of a currency field in abap cds per faktura.
Since @DefaultAggregation: #AVG is not working, I've figured out another way to do this using this guide:
Calculate ...
- 1,233
0
votes
2
answers
6k
views
How i can set a default value in a cds view for a smarttable
i have a question how i can set a default value in a cds view for a fiori elements app(based on annotations) what i tryed. I want to have the current date as a default value.
@Consumption.filter: { ...
- 489
3
votes
2
answers
777
views
SAP Runtime error when showing Multiple parents of an entity using CDS hierarchy in the SAPUI5 Tree table
I'm using CDS parent child hierarchy to get multiple parents of an entity.
There is no problem with the data that has a single parent.
But when I try to display the data that has multiple parents, it'...
- 356
0
votes
1
answer
1k
views
SAP RAP Function DDIC Type as Import Parameter
I am trying to create a OData function import via RAP.
When I use an abstract CDS view to define my parameter like this it works just fine:
static function XXX parameter YYY result [0..*] $self;
...
- 625
2
votes
0
answers
1k
views
What are the supported frontends for CDS parameter annotation @Consumption.derivation?
When annotating an input parameter to a CDS view, which is consumed via oData in a Fiori Elements List Report App, I tried using the @Consumption.dervivation annotation to preset a parameter with a ...
- 125
0
votes
1
answer
777
views
Issue to automize download of data with cds api
I'm trying to download data from CMIP6 climate projections ( https://cds.climate.copernicus.eu/cdsapp#!/dataset/projections-cmip6?tab=form ) with the cds.api extension on python.
The problem is that I ...
1
vote
0
answers
785
views
How to make analytical table display more rows SAP FIORI
I made a SAP Fiori app from template with an analytical table in it.
The table however only displays 4 rows. It looks really small.
Im looking for a way to make the table show maybe 10 rows or ...
- 11
0
votes
1
answer
1k
views
How to download multiple NC files of ERA5 data using CDS API in python?
I want to download multiple files for a specific area, one file daily for an specific variable like total rainfall in one month. I'm having problems with the for loop and changing the output file name ...
- 11