Skip to Content
avatar image
Former Member

HANA CDS Views Import failed after transport to next system

Hello Everyone,

We are having a scenario where we need to have sub selects and nested selects as part of HANA CDS views. We are creating separate views for each sub select/nested select and using it as joins in main CDS Views within the same HDBDD file.

When HDBDD file is transported, if we have HANA CDS Views consuming views/tables which are already activated in the system then the import is successful. If we have a scenario where we are using other CDS views in the same HDBDD file and that dependent view (v_equi) is not activated yet in the system then the import is failed.

e.g.

First View: VIEW v_equi AS

SELECT FROM "EQUI" AS "EQUI"

INNER JOIN "MARA" AS "MARA"

ON "EQUI"."MANDT" = "MARA"."MANDT"

AND "EQUI"."MATNR" = "MARA"."MATNR" {

"EQUI"."EQUNR",

"EQUI"."INVNR",

WHEN "MARA"."MTART" = 'SOME Conditional logic'

THEN 'X'

ELSE ''

END AS "FILTER" }

WHERE "MARA"."MTART" in ('SOME conditional logic'); //Allowed material types

Second View: VIEW v_EQUI_FILTERED AS

SELECT FROM "v_equi" AS "EQUI" {

"EQUI"."EQUNR",

"EQUI"."INVNR",

} WHERE "EQUI"."FILTER" = 'X';

-

Would like to know if this is a standard behavior and how to overcome this transport failure issue .

-

Thanks & Regards

Santhosh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 20, 2017 at 06:47 PM

    How is v_equi created? Is it created via hdbview? How is the syntax in the HDBDD that references the V_EQUI view done? Do you have a USING statement in the HDBDD file?

    Add comment
    10|10000 characters needed characters exceeded