topic Re: Questions re: "ABAP Core Data Services" developer challenge in Application Development and Automation Discussions

Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Wed, 31 Jul 2024 11:39:30 GMT

This discussion thread is for you to ask your questions and discuss issues if you are participating in the August 2024 developer challenge. The topic is "ABAP Core Data Services"

Please use separate discussions created for the submission of your solutions. Keep this thread for your questions only.

Re: Questions re: "ABAP Core Data Services" developer challenge

solankivishal_himmatlal — Tue, 06 Aug 2024 08:05:10 GMT

Hi @Shilpa_Shankar ,

Any update on Task 1. How will it be notified?

Regards,

Vishal Solanki

Re: Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Tue, 06 Aug 2024 09:52:12 GMT

Hi Vishal,

Tasks will be released every Wednesday. Kindly check this blog post for the timeline of the the task and the link to the discussion forum: https://community.sap.com/t5/application-development-blog-posts/sap-developer-challenge-abap-core-data-services/ba-p/13778288

Re: Questions re: "ABAP Core Data Services" developer challenge

tamitdassharma — Thu, 08 Aug 2024 11:52:06 GMT

Hi @Shilpa_Shankar ,

Why do we need to create a new table? why not use a projection consumption view to achieve the same thing?

Re: Questions re: "ABAP Core Data Services" developer challenge

adrianng — Thu, 08 Aug 2024 12:39:21 GMT

Hi @Shilpa_Shankar ,
I have an error while processing authorization checks. I have check every back step and everything looks okey. Could it be Role collection from BTP cockpit?

Re: Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Thu, 08 Aug 2024 12:53:30 GMT

Hi,

Yes, you can create a view directly consuming the table. We just wanted to start from the scratch of creating a Table and an ABAP class to get to know of ABAP Cloud concepts for the ones who are totally new.

Re: Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Thu, 08 Aug 2024 12:54:51 GMT

When do you get this error? During which step of the challenge? See if you can get more information about the error log.

Re: Questions re: "ABAP Core Data Services" developer challenge

adrianng — Thu, 08 Aug 2024 14:33:52 GMT

Hi @Shilpa_Shankar, thanks for your quick response.

I am facing an issue when trying to open a CDS view in ABAP Development Tools (ADT) in Eclipse. The error occurs when performing the Data Preview of the view I created. Below are the steps I followed and the error that appears:

Steps Followed
1.Create the Table ZANG_TRAVEL

@EndUserText.label: 'August developer challenge - "ABAP Core Data Services"'
@AbapCatalog.enhancement.category: #NOT_EXTENSIBLE
@AbapCatalog.tableCategory: #TRANSPARENT
@AbapCatalog.deliveryClass: #A
@AbapCatalog.dataMaintenance: #RESTRICTED
define table zang_travel {

key client : abap.clnt not null;
key travel_id : abap.numc(8) not null;
description : abap.char(40);
total_price : abap.dec(15,2);
currency_code : abap.cuky;
status : abap.char(1);

}
2.Create the ABAP Class to Generate and Update Data

CLASS zcl_anavarro_generate_data DEFINITION
PUBLIC
FINAL
CREATE PUBLIC.

PUBLIC SECTION.
INTERFACES: if_oo_adt_classrun.

METHODS: generate_data,
update_status.

ENDCLASS.

CLASS zcl_anavarro_generate_data IMPLEMENTATION.

METHOD if_oo_adt_classrun~main.
me->generate_data( ).
me->update_status( ).
ENDMETHOD.

METHOD generate_data.
DATA: lt_travel TYPE TABLE OF zang_travel,
ls_travel TYPE zang_travel.

SELECT client, travel_id, description, total_price, currency_code, status
FROM /dmo/travel
INTO TABLE @lt_travel.

LOOP AT lt_travel INTO ls_travel.
INSERT INTO zang_travel VALUES @ls_travel.
ENDLOOP.
ENDMETHOD.

METHOD update_status.
DATA: lt_travel TYPE TABLE OF zang_travel,
ls_travel TYPE zang_travel.

SELECT client, travel_id, description, total_price, currency_code, status
FROM zang_travel
INTO TABLE @lt_travel.

LOOP AT lt_travel INTO ls_travel.
CASE ls_travel-status.
WHEN 'N' OR 'P'.
ls_travel-status = 'O'.
WHEN 'B'.
ls_travel-status = 'A'.
WHEN OTHERS.
ls_travel-status = 'X'.
ENDCASE.
MODIFY zang_travel FROM @ls_travel.
ENDLOOP.
ENDMETHOD.

ENDCLASS.

3.Create the CDS View ZANG_TRAVEL_CDS

@AbapCatalog.sqlViewName: 'ZANG_TRVL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'August challenge'
define view ZANG_TRAVEL_CDS
as select from zang_travel
{
key travel_id as TravelId,
description as Description,
total_price as TotalPrice,
currency_code as CurrencyCode,
status as Status,
@Semantics.currencyCode: true
currency_code as Currency
}
Issue Encountered
When trying to open the CDS view in ADT and perform the Data Preview, the following error appears:

Error while processing authorization checks
The log shows:

Generated SQL: SELECT ZANG_TRVL~MANDT, ZANG_TRVL~TRAVELID, ZANG_TRVL~DESCRIPTION, ZANG_TRVL~TOTALPRICE, ZANG_TRVL~CURRENCYCODE, ZANG_TRVL~STATUS, ZANG_TRVL~CURRENCY FROM ZANG_TRVL
Finished query execution (took 194 ms)

The error occurs only when trying to view the data in the CDS view.

Re: Questions re: "ABAP Core Data Services" developer challenge

adrianng — Thu, 08 Aug 2024 15:43:10 GMT

Hi!

I finally solved the problem. I created an ABAP Project in ABAP Development Tools (ADT) instead of an ABAP Cloud Project. I am going to investigate creating an ABAP Cloud Project because I want to use SAP BTP ABAP Environment or SAP S/4HANA Cloud system.

Thank you!

Re: Questions re: "ABAP Core Data Services" developer challenge

azaharescu70 — Thu, 08 Aug 2024 20:53:03 GMT

Hi @adrianng ,

From the syntax of your CDS View, it seems you choose defineView (which is obsolete) instead of defineViewEntity in your ABAP Cloud Project and see if it works.

Try recreating the proper one in the

Re: Questions re: "ABAP Core Data Services" developer challenge

Jorge_Cervantes1 — Thu, 15 Aug 2024 16:51:56 GMT

A few comments about Task 2:

"Do not post screenshots of the CDS view entity."
It's interesting to note that many participants still share screenshots of their CDS views, a common habit. While this is not ideal for code review, it does highlight a few points worth discussing.
About the screenshots being shared:
One common issue I've noticed is the absence of cardinality specifications in associations, which often leads to warning messages in the CDS editor. While these warnings may seem minor—especially when the results appear correct—consider the impact this could have if additional languages are defined for your texts.
For instance, if Spanish or German translations were added, the entries could be duplicated. This scenario could introduce complexity and unexpected behavior later on.
I recommend revisiting "Using Associations in Path Expressions" to strengthen understanding. Additionally, examining built-in session variables, particularly system_language, might offer insights into avoiding this issue when working with multilingual data.

Re: Questions re: "ABAP Core Data Services" developer challenge

Sayontan_Das — Sun, 18 Aug 2024 07:37:41 GMT

Hi @Shilpa_Shankar

while creating instance in SAP BTP trial account I am getting error like below

and it is coming as abap plan is : shared. Can you please help to resolve this so that I can move to Task1?

NOTE: The issue is resolved now

Re: Questions re: "ABAP Core Data Services" developer challenge

vslakshmi — Wed, 21 Aug 2024 15:01:42 GMT

Hi Shilpa,

I am facing issue in Eclipse to login, the error is shown in the screenshot below,

Earlier also I faced, when I created a new instance with different email ID, it got worked but this time a new ID got created in eclipse & I am not able to access my package.

How to access my package of my previous objects? Is it possible to access it or need to re-create again?Can you pls guide on this?

Regards,

Lakshmi

Re: Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Wed, 21 Aug 2024 16:40:11 GMT

Hi Lakshmi,

The error appears if the login user in BTP trial is not the one that you are using in ADT when you login to the system. Kindly clear the browser cache and try in incognito window or in another browser.
if you are able to login to BTP trial system in ADT, you can add the previously created package as favorite package. Right click on Favotite package and select Add Package.

Re: Questions re: "ABAP Core Data Services" developer challenge

vslakshmi — Thu, 22 Aug 2024 08:22:18 GMT

Hi Shilpa,

I have done the above steps but still facing the same Issue. Secondly all my accounts are merged (Gmail & current employer) then also getting Error like "error occurred during the Service Instance logon"

So I deleted the existing instance & created with other email ID but it created a new C user ID. Please help me to get my packages.

Regards,

Re: Questions re: "ABAP Core Data Services" developer challenge

vslakshmi — Thu, 22 Aug 2024 09:01:22 GMT

Hi Shilpa,

I had the first error: "You were successfully authenticated, but an error occurred during the Service Instance logon. Please ensure that you have a user for the Service Instance".

Unfortunately, the blog did not help:
Initial Configurations for ABAP in the Cloud – Cloud Foundry Environment | SAP Blogs.

In the current version when indicating US East (VA) instead of specifying:
https://api.cf.us10-001.hana.ondemand.com
pointed incorrectly to
https://api.cf.us10.hana.ondemand.com

I had to mark "Region" to the value "Other". From where I guessed. Here was the information.

I found a blog where we have to assign a role

https://community.sap.com/t5/technology-blogs-by-members/sap-btp-abap-environment-and-adt-troubleshooting-guide/ba-p/13527967

But this role is not available in BTP trial account under user->Assign Roles:

Could you please suggest.

Regards,

Re: Questions re: "ABAP Core Data Services" developer challenge

diveshkalra — Fri, 23 Aug 2024 06:57:46 GMT

I am stuck in below point for task 3. Please advise as I am not getting the values in FIORI app. @Shilpa_Shankar @sheenamk

c. Add annotations to provide a value help filter on the ‘Status text’ field based on Overall Status text.

@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'CDS View entity'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{

serviceQuality: #X,

sizeCategory: #S,

dataClass: #MIXED

}

@ui.headerInfo.typeName: 'Travel'

@ui.headerInfo.typeNamePlural: 'Travels'

@Search.searchable: true

@ObjectModel.semanticKey: [ 'Description' ]

define view entity Ztravel_entity5 as select from ztravel_new5

association [0..1] to /DMO/I_Overall_Status_VH as _Status on _Status.OverallStatus = $projection.Status

{

@ui.lineItem: [{ position: 10 }]

@ui.selectionField: [{ position: 10 }]

key

travel_id as TravelId,

@ui.lineItem: [{ position: 20 }]

@Search.defaultSearchElement: true

@Search.fuzzinessThreshold: 0.90

description as Description,

@Semantics.amount.currencyCode: 'CurrencyCode'

@ui.lineItem: [{ position: 30 }]

total_price as TotalPrice,

currency_code as CurrencyCode,

@ui.lineItem: [{ position: 40 }]

concat_with_space( cast ( total_price as abap.char(25) ), currency_code, 1) as NewPriceCurrencyCode,

@ui.lineItem: [{ position: 50 }]

status as Status,

@ui.lineItem: [{ position: 60 }]

@ui.selectionField: [{ position: 20 }]

@Consumption.valueHelpDefinition: [{ entity: {name: 'zhelp_new5', element: 'overallStatus' } }]

_Status._Text.Text as overallStatusText,

_Status

}

Re: Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Fri, 23 Aug 2024 08:19:02 GMT

Hi,

Post the data preview of zhelp_new5. The annotation syntax looks fine.

Re: Questions re: "ABAP Core Data Services" developer challenge

diveshkalra — Fri, 23 Aug 2024 08:27:44 GMT

Hi @Shilpa_Shankar ,

PF data preview of ZHELP_NEW5.

Re: Questions re: "ABAP Core Data Services" developer challenge

Shilpa_Shankar — Fri, 23 Aug 2024 08:35:27 GMT

Try this,

@Consumption.valueHelpDefinition: [{ entity: {name: 'zhelp_new5', element: 'overallStatusText' } }]