Skip to Content
avatar image
Former Member

No Reference to PRODUCTID_USED !

Hi Everyone,

I was going through the Chapter 2 from the Book "SAP Webclient : A Comprehensive Guide for Developers".

No doubt its a very good book.

But i found somthing interesting in Chapter 2, The Author gives an example of Creating a Genil Component where in he creates a Search Object with the Search Attribute structure contains follwing fields - GUEST_ID, HOTEL_NAME, LASTCHECKIN and PRODUCTID_USED.

But in the Backend Search API "SEARCH_BOOKINGS" method, there is no where reference to PRODUCTID_USED.

The SELECT query is just based on BOOKINGS table ZBOOKING_RESERV.

what i would have expected in some kind of Join between the Bookings and Product Table and filtering out distinct keys of Bookings Table.

I would request you to kindly confirm on my understandig since i am new to CRM Webui Technology.

Best Rgeards

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 12, 2015 at 06:57 AM

    Hi, I dont have a book nowso i cant tell but u can still relate the Chapter 2 with the below blog.

    you can go through this above link.

    Let me know if you face any doubs.


    Message was edited by: Sumeet Gehlot

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sumeet Gehlot

      Thanks for your response Sumeet, I really Appreciate it.

      READ_PRODUCTS is called inside GET_OBJECTS method and not inside SEARCH_BOOKINS.

      First SEARCH_BOOKINGS is executed which gets Booking(s)

      (Note: Search is based on 3 keys from Header Table and NOT Productid).

      Once Booking(s) are got then GET_OBJECTS gets the Attribute and Related Objects (during which it calls READ_PRODUCTS).

      Also Assume even if READ_PRODUCTS is called during a SEARCH operation, even then in your above SELECT query on Page 120, WHERE clause has no mention to PRODUCTID 😊