ABAP DDIC names of CDS Views

[Tom1-2-3]

Hi friends

I would be thankful if you can provide me the ABAP DDIC names of the following Cloud CDS views:

I_MfgOrderItemSerialNumber

I_ManufacturingOrder

I_MfgOrderWithStatus

I_SerialNumberManufacturingOrd

Many thank!

Tom

[Sandra_Rossi]

Just display the CDS views to see their definitions and eventual DDIC view names (if any).

[junwu]

why not open the cds yourself?

[Edrilan_Berisha · Accepted solution]

Hi Tom,

as already mentioned by Sandra, you can do that yourself.

I still quickly did it for you:

I_MfgOrderItemSerialNumber -> IPPMFGORDITMSERN

I_ManufacturingOrder -> IMFGORDER

I_MfgOrderWithStatus -> IMFGORDERWSTTS

I_SerialNumberManufacturingOrd -> this is not a CDS view but an entity view?

Best,

Edrilan Berisha

SAP S/4HANA Cloud Financials Development

[Tom1-2-3 · Accepted solution]

Thanks Edrilan, we don't have ADT Cloud in our Eclipse due to contract reasons. Where in S4H Public cloud can I check the ABAP DDIC names? Is there an app to check this? Best, Tom

[Tom1-2-3 · Accepted solution]

okay, I found it now in the CDS view app under "annotations". Why can I not consume this CDS view in BW4H, I am getting 0 result when trying to create a new datasource on that view.

[Edrilan_Berisha · Accepted solution]

Hi Tom, which CDS view do you mean now?

[Sandra_Rossi · Accepted solution]

@Tom1-2-3 Maybe you should ask it as a BW question "Why can I not consume this CDS view in BW4H, I am getting 0 result when trying to create a new datasource on that view", as you incorrectly thought that CDS views were all DDIC-based (https://en.wikipedia.org/wiki/XY_problem).

[Tom1-2-3 · Accepted solution]

Hi Edrilan, sorry I meant this view IPPMFGORDITMSERN.

[Sandra_Rossi · Accepted solution]

@Tom1-2-3 You should never consume the "CDS-managed DDIC View" directly, it's forbidden since 7.50. Instead, just access the CDS view itself. Source: https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abencds_database_view...

[Tom1-2-3 · Accepted solution]

Thanks Sandra, I am not getting the clue of your last answer. But I have now created a custom CDS view with scenario "Data Extraction". CDS View: I_MfgOrderItemSerialNumber. I am getting this log entry when checking or publishing the view. What can I do? I need the data from this view into BW4H. Data extraction for CDS entity YY9_2B425D6251CD3CED3C0193 not possible Message no. RSODP_ABAP_CDS318 Diagnosis Data extraction for CDS entity YY9_2B425D6251CD3CED3C0193 is not possible. System Response Data extraction is possible for a CDS entity which is either C1 released or released as an API for use in Key User App or was created by Key User App and marked for use by other Key User Apps Procedure Please ensure that the CDS Entity is either C1 released or released as an API for use in Key User App or, if created by Key User App, it should be marked for use by other Key User Apps to enable data extraction

[Sandra_Rossi · Accepted solution]

@Tom1-2-3I don't understand what you don't understand. You are trying to use IPPMFGORDITMSERN which is the "CDS-managed DDIC View" of the CDS view I_MfgOrderItemSerialNumber (defined in the annotation @AbapCatalog.sqlViewName). I doubt that a standard application (B/4HANA in your case) permits using CDS-managed DDIC views, instead you should refer to the CDS view (and better use the CDS view entity if it exists).

ABAP CDS - CDS-managed DDIC Views:

The CDS-managed DDIC view should not, however, be used in ABAP. It can be used wherever DDIC database tables or DDIC database views can also be specified using its name CDS_DB_VIEW, such as after the TYPE addition, in ABAP SQL read statements and also in Native SQL, AMDP, or after the TABLES statement. But this is not recommended. More particularly, the use of the CDS-managed DDIC view in ABAP SQL read statements is obsolete and forbidden in strict mode from ABAP release 7.50.

(CDS_DB_VIEW is taken from the obsolete language syntax "SELECT ... FROM cds_db_view ...")