cancel
Showing results for 
Search instead for 
Did you mean: 

BOL - CRM - Query Parameters

Former Member
0 Kudos

Hi All,

I need your help for the following issue.

TX -> GENIL_BOL_BROWSER

CONPONENT SET -> BTBP

SEARCH OBJECT -> BTQSrvOrd

The problem is that when I search with the parameter CHANGED_AT the query is not working.

But others parameters are working OK, for example BU_PARTNER.

When I search by CHANGED_AT, the result are all Service Orders.

But I need filter orders that was modified from any date.

Any Idea?

Thanks!

Accepted Solutions (0)

Answers (1)

Answers (1)

CarstenKasper
Active Contributor
0 Kudos

Hello Nicol,

seems as if SAP allows search criteria that can not be handled by the search.

Just checked in the debugger:

- CHANGED_AT is not allowed at all in the Reporting Framework

- CHANGED_AT_RANGE is possible, but you have a maximum of 5 characters. It is a date rule. Check valuehelp of field DATE_RANGE of table CRMT_ACC_1O_CUST to see what is possible.

I checked that CHANGED_AT_I_RANGE would be possible. In it you can just write the date and it is correctly transferred to the SELECT on the database. However it is not working out of the box. I assume you have to add it to the attribute structure CRMST_QUERY_SRVO_BTIL of the search before you can use it in BOL browser.

cheers Carsten

Former Member
0 Kudos

Hi Kasper,

Thank you very much for your reply.

I need filter Service Orders by CHANGED_AT from table CRMD_ORDERADM_H.

So I need add this filter in Search Structure of BTQSrvOrd

¿How I can do this? ¿I should use Easy Enhancement Workbench?

I did not find any example of this type.¿Or I should implement any BADI?

Thanks!!

CarstenKasper
Active Contributor
0 Kudos

Hi Nicol,

as mentioned above I did not try it myself and do not know if it will work directly. My approach would be to:

  • Create an APPEND to structure CRMST_QUERY_SRVO_BTIL
  • In the APPEND give the field CHANGED_AT_I_RANGE with data element CRMT_REPORT_CHANGED_AT_DATE

No BAdI implementation. Nothing else. Just go to GENIL_BOL_BROWSER and test if it works.

cheers Carsten

Former Member
0 Kudos

Hi Kasper,

This new field is working fine, but It is for changes in the positions of the order.

CHANGED_AT from table CRMD_ORDERADM_I. ¿Did you find in the debugger this field?


¿There is any way to Filter CHANGED_AT from table CRMD_ORDERADM_H (Service Order Header)?

Thanks a Lot!

CarstenKasper
Active Contributor
0 Kudos

According to the Reporting Framwork there is a field CHANGED_AT. Meaning it can be selected from the database.

What you would have to do is:

  • Go to table CRMC_Q1O_FIELDS and copy entry CHANGED_AT_I_RANGE to CHANGED_AT

Please keep in mind that this is considered by SAP as a modification. It might be overwritten by service packs and Notes. In my opinion this is no problem, as they already put the field in the Query structure and it is only an entry in a table. Include it in a transport request!

cheers Carsten

Former Member
0 Kudos

Hi Kasper,

I add the New Entry in table CRMC_Q1O_FIELDS, but It´s not Working.

I check the Degug, and It is filternig other field.

--------------------------------

Another important field is for filter is STATUS of the order.

I fill the status with STATUS_COMMON Filter.


But do not know why the program searchs STATUS PROFILE = ""

The Status Profile of the service order is Z.

¿How I Custimize this?

Thanks and Regards,

0 Kudos

Hi Nicol,

To set the Z Status Profile created you must assign it to the Transaction Type.In this case the Transaction Type is Service Order.

Follow the below steps to assign the Status Profile to the Transaction Type:

Goto SPRO->Customer Relationship Management->Transactions->Basic Settings->Define Transaction Types

Select the Transaction Type for which you want to set the Status Profile.

Click on Details button.

Under Profiles you can assign the Z Status Profile created corresponding to the Status Profile field.

Regards.

Deepak Ramchandran.

Former Member
0 Kudos

Thanks Deepak,

I have already achieved Filter by Status via STATUS_COMMON.

I concatenate STAT and STSMA.

Any Idea to Filter CHANGED_AT from table CRMD_ORDERADM_H (Service Order Header)?

Regards,