Skip to Content
avatar image
Glenn De Groote

SAP C4C - Use KUT field in ABSL query

Nov 23, 2017 at 01:35 PM | 372 Views

Hello experts,

I'm looking for a way to use a custom field defined via KUT in an ABSL query in the Cloud Application Studio.

I've read the following posts, but they don't give a definitive answer:

https://archive.sap.com/discussions/thread/3871694 https://answers.sap.com/questions/215431/sap-c4c-extend-kut-field-to-query-and-using-on-sdk.html

The field is an extension field on the Customer Business Object and is already made available via a .ref file in the Cloud Application Studio.

query2 = Customer.QueryByIdentification;
param2 = query2.CreateSelectionParams();
param2.Add(query2.HeaderExtSubChannel.content, "I", "EQ", this.AccountType.content);
result2 = query2.Execute(param2);

Above code is what I'm trying.

Where "HeaderExtSubChannel" is the extension field defined via KUT.
But... It's not working.

Any suggestions are more than welcome!

Thanks in advance.

C4C Extensibility
SAP Cloud Applications Studio | query | absl | cloud for customer | kut
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Abdul Rasheed Mohammed
    Nov 25, 2017 at 09:26 AM

    Hi Glenn,

    Add the KUT field to the QueryCustomerIn Service by going into KUT field definition -> Services tab. Once field is added to the query, you can check the same in Code completion in SDK as well

    Regards,

    AbdulRasheed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Johannes Schneider
    Nov 24, 2017 at 08:04 AM

    Hello Glenn,

    You have to implement a reference to Customer-Specific Fields. This is an object addable in the add new item Pop-Up.

    There you have to select the Key User Tool created fields.

    Now you should be able to select them.

    Kind Regards,

    Johannes

    Add comment
    10|10000 characters needed characters exceeded

    • Glenn De Groote
      Nov 24, 2017 at 01:24 PM

      Johannes,

      No that's not the problem...

      In code below when I type "query2." and use code completion, the field isn't even showing up.
      While all other extension fields are showing up. That's because they are made with the Studio and are included in the Extension Scenairo.

      param2.Add(query2.HeaderExtSubChannel.content, "I", "EQ", this.AccountType.content);
  • avatar image
    Jens Niemeyer
    Feb 04 at 12:26 PM

    Hello,

    I am using also KUT fields in my QuerybyElements.

    My impression is, that KUT fields are not indexed, so full table scan happens, If I rund a query on such field.

    How can I add the KUT to be indexed by the HANA DB?

    Jens

    Add comment
    10|10000 characters needed characters exceeded