E::000 when activating DDL

[Former Member]

Hi,

I'm trying to activate the following DDL (besides: no error marks in the editor):

@AbapCatalog.sqlViewName: 'ZISS_DET_ZW_SER'

@ClientDependent: true

@AbapCatalog.compiler.CompareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Ext. ZP + OBIS -> Serial + ZW'

define view Ziss_Determine_Zw_AND_SERIAL

with parameters

  iv_ext_zp : ext_zp,

  iv_obis : kennziff,

  iv_due_date : date

as select from euitrans as ezp

        inner join euilzw as lzw on lzw.int_ui = ezp.int_ui and ezp.dateto > :iv_due_date and ezp.datefrom <= :iv_due_date

        inner join etdz as zw on lzw.logikzw = zw.logikzw and zw.kennziff = :iv_obis and zw.bis > :iv_due_date and zw.ab <= :iv_due_date

        inner join egerr as eg on eg.equnr = zw.equnr and eg.bis > :iv_due_date and eg.ab <= :iv_due_date

      {

        zw.zwnummer,

        zw.kennziff,

        zw.stanznac,

        eg.geraet

      }

and just get this:

What's the problem (how to diagnose this further)?

Thanks

ADT; 2.51.1

SAP_BASIS	740	0010	SAPKB74010
SAP_APPL	617	0008	SAPKH61708
SAP_AP	700	0032	SAPKNA7032

[Former Member]

Hi,

I'm trying to activate the following DDL (besides: no error marks in the editor):

@AbapCatalog.sqlViewName: 'ZISS_DET_ZW_SER'

@ClientDependent: true

@AbapCatalog.compiler.CompareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Ext. ZP + OBIS -> Serial + ZW'

define view Ziss_Determine_Zw_AND_SERIAL

with parameters

  iv_ext_zp : ext_zp,

  iv_obis : kennziff,

  iv_due_date : date

as select from euitrans as ezp

        inner join euilzw as lzw on lzw.int_ui = ezp.int_ui and ezp.dateto > :iv_due_date and ezp.datefrom <= :iv_due_date

        inner join etdz as zw on lzw.logikzw = zw.logikzw and zw.kennziff = :iv_obis and zw.bis > :iv_due_date and zw.ab <= :iv_due_date

        inner join egerr as eg on eg.equnr = zw.equnr and eg.bis > :iv_due_date and eg.ab <= :iv_due_date

      {

        zw.zwnummer,

        zw.kennziff,

        zw.stanznac,

        eg.geraet

      }

and just get this:

What's the problem (how to diagnose this further)?

Thanks

ADT; 2.51.1

SAP_BASIS	740	0010	SAPKB74010
SAP_APPL	617	0008	SAPKH61708
SAP_AP	700	0032	SAPKNA7032

[Former Member]

OK, it must be ext_ui not ext_zp (non existing DICT type).

Would be nice to face meaningful error messages/error marks next time....