Skip to Content
avatar image
Former Member

Problem with STARTDATE of opportunity in search criteria

HI

I have added a field called 'STARTDATE' of the table 'CRMD_OPPORT_H' to search criteria of Opportunity.

I have added this field to below structures

CRMST_QUERY_OPP_BTIL & CRMST_QUERY_R_OPP_BTIL.

Also I have selected few operators in 'CRMVC_DQ'.

But when I'm trying to search opportunities system is throwing the below error and this error is appearing for all the operators

except for 'IS'( EQ).

"The operator 'EQ' is the only one supported for the single value field STARTDATE".

Could you please let me know why this error is appearing ?

Best Regards

Anil Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 27, 2010 at 12:39 PM

    Hi Anil,

    the reason is you named your CUSTOM field in the name space of SAP. There already is a field called STARTDATE in the OneOrder Search. In table CRMC_Q1O_FIELDS it is marked as SINGLE_VALUE. The search logic checks this table and sees: This field should only contain 'EQ' as OPTION and throws the error message you mentioned.

    Rename your custom field in customer namespace and you will be fine. Additionally you will need to take care of the rest of the search logic for this field to work...

    Probably you should use the EEWB/AET to make additions to the tables and searches. It will take care of all the necessary things.

    cheers Carsten

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Carsten,

      Adding 'STARTDATE' to search structure is considered as a custom field addition provided it follows the customer namespace (ZSTARTDATE). I assumed it is prefixed with Z. In this case only the standard data element is reused which won't cause any problem, and in order to implement the search the badi must be implemented. This will be a simple solution, i agree with you if the field added doesnt follow customer namespace.

      Regards,

      Arun