Skip to Content
0

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

Sep 20, 2017 at 01:24 PM

134

avatar image
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;
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Luc Vanrobays Sep 20, 2017 at 02:49 PM
0
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) .
Share
10 |10000 characters needed characters left characters exceeded
Luc Vanrobays Sep 21, 2017 at 12:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded