SRM ABAP CDS VIEW WITH PARAMETERS : data type conflict in selcetion

[lucdealethea]

I have a Data type conflict in a selection condition, but the view (on SRM CRMD_ORDERADM_H table) activates properly..    
Further the Open with Data Preview doesn't return any results.

Also tried with p_objectid:CHAR10 and with regular :p_objectid invocation instead of $parameter.p_objectid without better resolution.


Any help or idea is welcome...

    @AbapCatalog.sqlViewName: 'ZBI_SRM_ORDERH'
    @AbapCatalog.compiler.CompareFilter: true
    @AccessControl.authorizationCheck: #CHECK
    @ClientDependent: true
    @EndUserText.label: 'Select with param on CRMD_ORDERADM_H'
    define view ZTVP_CRMD_ORDERH
    with parameters 
    p_objectid : CRMT_OBJECT_ID_DB as select from crmd_orderadm_h{
    *
    }
    where object_id =  $parameters.p_objectid;

[lucdealethea]

My fatal mistake:

@ClientDependent: true

If we create CDS @ClientDependent: true in dev environment , chances are few to have data in Transaction Tables...

So returns no data...

[lucdealethea]

The data conflict error message did not relate to the current cds view, but to another incompleted design...
The query executes properly and passes the parameters successfully. It seems more plausible 
than HANA Studio (Version: 2.3.21) is responsible (ADT) for not returning the dataset properly.



Upgrading ADT to 2.80...


2017-09-20 10:42:08 900 - Query successfully executed in 1.7870000 ms (server processing time)
SELECT 
   ZTVP_CRMD_ORDERH~GUID, 
   ZTVP_CRMD_ORDERH~OBJECT_ID, 
   ZTVP_CRMD_ORDERH~PROCESS_TYPE, 
   ZTVP_CRMD_ORDERH~POSTING_DATE, 
   ZTVP_CRMD_ORDERH~DESCRIPTION, 
   ZTVP_CRMD_ORDERH~DESCR_LANGUAGE, 
   ZTVP_CRMD_ORDERH~LOGICAL_SYSTEM, 
   ZTVP_CRMD_ORDERH~CRM_RELEASE, 
   ZTVP_CRMD_ORDERH~SCENARIO, 
   ZTVP_CRMD_ORDERH~TEMPLATE_TYPE, 
   ZTVP_CRMD_ORDERH~CREATED_AT, 
   ZTVP_CRMD_ORDERH~CREATED_BY, 
   ZTVP_CRMD_ORDERH~CHANGED_AT, 
   ZTVP_CRMD_ORDERH~CHANGED_BY, 
   ZTVP_CRMD_ORDERH~HEAD_CHANGED_AT, 
   ZTVP_CRMD_ORDERH~ORDERADM_H_DUMMY, 
   ZTVP_CRMD_ORDERH~OBJECT_TYPE, 
   ZTVP_CRMD_ORDERH~ARCHIVING_FLAG, 
   ZTVP_CRMD_ORDERH~DESCRIPTION_UC, 
   ZTVP_CRMD_ORDERH~OBJECT_ID_OK, 
   ZTVP_CRMD_ORDERH~VERIFY_DATE, 
   ZTVP_CRMD_ORDERH~CRM_CHANGED_AT, 
   ZTVP_CRMD_ORDERH~POSTPROCESS_AT
 FROM 
  ZTVP_CRMD_ORDERH( P_OBJECTID = '3000002844' )
 UP TO 100 ROWS
 INTO TABLE @DATA(LT_RESULT) .