Custom Code Text Reading Issue in SAP CDS View

[huny]

Hello Guru!

In Custom Fields and Logic, custom Code and TEXT were added as shown below.
And I posted it with a custom code in the Accounting journal entry app. I also confirmed that the corresponding code was saved in the I_GLACCOUNTLINEITEMRAWDATA table (CDS view).

In a custom development report that reads the I_GLACCOUNTLINEITEMRAWDATA table (CDS view)
I want to read the text corresponding to the custom code.

It cannot be read because the API State is Cannot be set.

YY1_ACTIVITYCODE_W

Please help me with how to read the text of Custom Code.

thank you

Huny

[OwenLiu]

Added Finance tag.

[Meghana · Accepted solution]

Hi,

For the input value in custom field on an Accounting Document (I_GLACCOUNTLINEITEMRAWDATA), to read the corresponding description, please try sample code in this manner:

SELECT SINGLE Description

FROM YY1_ACTIVITYCODE_W

INTO @DATA(lv_desc)

WHERE Code = @LS_glaccountlineitemrawdata-yy1_activitycode_cob AND Language = ‘EN’.

ls_glaccountlineitemrawdata is a single item data structure from Accounting Document.

Instead of hardcoding EN, you can also try to extract logon user language or please check in the custom development, if user language is available.

Best regards,

Meghana