cancel
Showing results for 
Search instead for 
Did you mean: 

How to use DDCDS_CUSTOMER_DOMAIN_VALUE_T?

mustafa_74199
Participant
0 Kudos
3,954

Hi,
In a RAP education video i have seen an example and i am trying to do the same steps to be able to learn RAP.

In the video a CDS view entity was created and it gets the fix values inside a domain from DDIC.


I did the same but when i try "Open with -> Data Preview", i get nothing.


These are the values inside the domain.


I have seen a comment about the solution which recommends to add an entry in the table ABAP_LANGU_SWCMP. But i have no idea how to do it and which entry to create.

If you share any idea i would appreciate.

Best Regards

Accepted Solutions (0)

Answers (5)

Answers (5)

janithi
Participant

Hi,
This is a workaround provided by @developer_Shakya in the you tube video of this Link, since this Standard CDS is not working for many users.

Create a new CDS view with a parameter to fetch the Domain values

 

define view entity Z_DOMAIN_VALUE_T 
with parameters p_domain_name:  abap.char(30) --sxco_ad_object_name
as select from dd07t
{
    key domname as domain_name,
    key valpos as value_position,
    key ddlanguage as language,
    domvalue_l as Value,
    @Semantics.text: true
    ddtext as Description
}
where domname = $parameters.p_domain_name and dd07t.as4local = 'A'

 

 

Sandra_Rossi
Active Contributor
0 Kudos
I guess the reason of your statement "this Standard CDS is not working for many users" is explained in this answer: https://community.sap.com/t5/technology-q-a/how-to-use-ddcds-customer-domain-value-t/qaq-p/12652584/...
mfrommherz
Explorer

Customer domains can be found in View DDCDS_CUSTOMER_DOMAIN_VALUE and _T, when the domain is in a package, which itself is preferably part of a cloud ready SW-Component.

The reason is, that the underlying View  ARS_OBJECTS_ALL_SW_COMP_SCP only finds objects which are in a  customer software component. 

IN 2020 only customer domains that belong to a cloud ready package are found, not every defined domain.

The package could for example belong to Z_CUSTOMER_DEVELOPMENT.

The Software component should also be ZCUSTOM_DEVELOPMENT. I used good old se80 to assign the SW-Component.

se80_adjust_package.png

To check if that assigning is needed, please use underlying view ARS_OBJECTS_ALL_SW_COMP_SCP if your object is listed using SQL Console in ADT. If it is NOT listed, adjust as described.

TO check in sql console if the object can be found:
SELECT

ARS_OBJECTS_ALL_SW_COMP_SCP~PROGRAM_ID,

ARS_OBJECTS_ALL_SW_COMP_SCP~OBJECT_TYPE,

ARS_OBJECTS_ALL_SW_COMP_SCP~OBJECT_NAME,

ARS_OBJECTS_ALL_SW_COMP_SCP~PACKAGE_NAME,

ARS_OBJECTS_ALL_SW_COMP_SCP~SOFTWARE_COMPONENT,

ARS_OBJECTS_ALL_SW_COMP_SCP~IS_LOCAL_SOFTWARE_COMPONENT,

ARS_OBJECTS_ALL_SW_COMP_SCP~IS_INSTALLED_COMPONENT

FROM

ARS_OBJECTS_ALL_SW_COMP_SCP

where object_name = '<ZZ_MY_OBJECT>'

AND OBJECT_TYPE = 'DOMA'.

adt_ars_objects_all_sw_com_scp.png

 So finally, DDCDS_CUSTOMER_DOMAIN_VALUE should give back a result:

mfrommherz_1-1715619082779.png

For more details, see the comments on top of view ARS_OBJECTS_ALL_SW_COMP_SCP.

Ramjee_korada
Active Contributor

Hi ,

It seems that you are missing access to see the results.

Please check in SU53 missing authorization and get it added to your user id and then test it.

Best wishes,

Ramjee Korada

RastkoJokic
Discoverer
0 Kudos

Hello, so the solution is to either assign the same software component for that package. This is because in order for the domain to be seen by your package both of them need to be within same software component. As someone previously mentioned this can be done by using the transaction se80 and then adjusting the software component. Now, if you are using local object for your project or for following the tutorial you can simply create the same GENDER domain by yourself. You just have to click on the local package new and then domain and then you can just copy the same values that are located within your domain that is not accessible because it is located in the different software component.

RastkoJokic_0-1724936967162.png

 

suzanne_alivand
Explorer
0 Kudos

Hi Mustafa,
if you still couldn't find an answer, maybe this helps:
reading domain With CDS

mustafa_74199
Participant
0 Kudos

Hi Suzanne,

Thanks for your reply. I will check it.