Skip to Content

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

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;
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 20, 2017 at 02:49 PM
    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) .
    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2017 at 12:40 PM

    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...

    Add comment
    10|10000 characters needed characters exceeded