Stack Overflow
Stack Overflow

Questions tagged [cds]

The ABAP Core Data Services (ABAP CDS) are the implementation of the general CDS concept for AS ABAP. ABAP CDS makes it possible to define semantic data models on the central database of the application server. For questions specific to the HANA CDS implementation, use the tag [hana-cds] instead.

The ABAP Core Data Services (ABAP CDS) are the implementation of the general CDS concept created by SAP for ABAP-based systems. ABAP CDS makes it possible to define semantic data models on the central database of the application server.

Useful links

175 questions
3
votes
1 answer

Use DateTime in CDS

I have got a timestamp that consists of date and time, something like "YYYYMMddhhmmss" and I want to display it as a datetime in the Fiori frontend like "Month dd, YYYY hh:mm PM" and enable the auto DateTimePicker. While there are the tstmp_to_dats…
Stefan Blamberg
  • 816
  • 9
  • 24
2
votes
0 answers

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 value derived from another entity. define view…
Michael Koval
  • 23
  • 5
2
votes
1 answer

SAP ABAP DCL change the cardinality of the CDS VIEW result?

I have a CDS view ZCDS_XXX : define view ZCDS_XXX as select distinct from XXX association [1..*] to ZCDS_YYY as _YYY ... { key a, _YYY } ... I have a DCL ZDCL_XXX : define role ZDCL_XXX{ grant select on ZCDS_XXX …
depth1
  • 135
  • 10
2
votes
0 answers

Annotations are not used in Fiori Elements List Report with TreeTable

I have created a Fiori Elements List Report and set the table type to TreeTable. The table is displayed as a TreeTable but every entity is displayed as a root entity in the table and the following error is in the log: "Neither navigation paths…
Patrick
  • 63
  • 8
2
votes
2 answers

Show output values aka conversion-exit values in CDS?

I've created a CDS view, which reads some data from 2 tables. My problem is, that one of the columns has a conversion policy behind - so if I display the data with SE16n, it shows the "converted value" but within my cds view only the unconverted…
toffler
  • 1,231
  • 10
  • 27
2
votes
1 answer

add columns in a CDS view and fill it with a condition

I have been trying for several days, in a cds view, to convert a row of the acdoca table (here the amount of a debit/credit transaction, the hsl attribute in acdoca), into two columns debit and credit. The amount of a transaction would go into a…
Theo Wicky
  • 41
  • 1
  • 3
2
votes
1 answer

What is the naming convention for fields added to a standard CDS view via custom extension?

SAP didn't include an underlying database table field to the interface view I want to reuse for my custom consumption view. I can easily add it extending the standard CDS, but I'm afraid a future release will include this field and create a conflict…
RaTiO
  • 979
  • 2
  • 17
  • 33
2
votes
1 answer

SEGW warning "Potential data loss" for Edm.DateTime

Is it possible to add Edm.DateTime field based on CDS View Date Source Reference without warnings in SAP Gateway Service Builder? I created simple CDS View based on select from dd07l with Date field just to show this case, code to create date field…
Kamil
  • 21
  • 2
2
votes
3 answers

Add leading zeros only to numeric field in CDS?

In my AS ABAP 7.50 system, I have a table where the material length is 18 and I need to expose it via CDS as if the material length was 40 like in S/4. The material IDs in the system can be numeric (with leading zeros) or alphanumeric. The material…
RaTiO
  • 979
  • 2
  • 17
  • 33
2
votes
1 answer

How to access a two levels deep nested association of an OData V2 service?

I have exposed an OData V2 Service via the ABAP Service Gateway (SEGW) based on a CDS View. The view contains indirect associations to two other views (entity_1 > entity_2 > entity_3 - no direct connection between entity_1 and entity_3). My problem…
mxmlndml
  • 144
  • 2
  • 13
2
votes
1 answer

Notify user about not allowed results via ASPECT pfcg_auth?

In "classic" ABAP authority checks, you would sometimes loop over a result list. If for at least one item the check fails, you'd notify the user about this and show only the items he's entitled to. My question is: How would you do this in CDS using…
Matthias
  • 21
  • 4
2
votes
1 answer

Defining custom Express endpoint for SAP CAP app

I am trying to create a standard SAP CAP (Cloud Platform Application Model) in SAP Business Application Studio and also extending it with additional Express endpoints besides the ones served by CDS services. I have the following project…
Gombos Levente
  • 21
  • 2
2
votes
1 answer

SAPUI5 SmartChart with CDSView Annotations is not Displayed

I am pretty new to the SAP environment and couldn't find a suitable solution to the following problem in the community forum or using the samples/templates/API docs or SAP books, thus I am asking this question. My Problem: I created a CDS-View with…
Philipp
  • 21
  • 2
2
votes
1 answer

How to consume a CDS from ABAP SQL using an association value in the WHERE condition?

I have a CDS view for notifications header with an association to their status define view ZNOTIF as select from qmel as notif association [0..*] to ZNOTIF_STATUS as _status on _status.object_num = notif.objnr { key notif.qmnum as…
RaTiO
  • 979
  • 2
  • 17
  • 33
2
votes
1 answer

Calculated date in WHERE condition of CDS view

I'm trying to get a list of valid system status for the notification object, in order to not check all the notifications in the table, I want to execute the selection by checking only the last 2 years of data. Maybe there is a better solution to my…
RaTiO
  • 979
  • 2
  • 17
  • 33
1
2
3
…
11 12