1. SAP Glossary
  2. Supply Network Collaboration
  3. ad hoc query


What is ad hoc query in SAP SCM-ICH - Supply Network Collaboration?


SAP Term: ad hoc query

  • Component: SCM-ICH

  • Component Name: Supply Network Collaboration

  • Description: Type of query without pre-defined selection criteria. The selection criteria for an ad-hoc query can be determined in the following ways: The user enters selection criteria manually. When the user navigates from one screen to another, the system uses the data from the source screen as the selection criteria for the ad-hoc query on the target screen. Queries of this type are not used for regular monitoring of SAP SNC objects. For regular monitoring activities, for example using a worklist, the queries use pre-defined selection criteria instead.


Smart SAP Assistant

  • Key Concepts: 
    Ad hoc query is a feature of the Supply Network Collaboration (SCM-ICH) component of SAP. It allows users to quickly and easily create queries to search for specific information in the system. The queries can be used to search for data related to orders, deliveries, invoices, and other related information. 
    
    How to use it: 
    Ad hoc query can be accessed from the SCM-ICH menu. Once in the query screen, users can enter their search criteria and select the fields they want to search for. The query results will be displayed in a table format, allowing users to quickly view and analyze the data. 
    
    Tips & Tricks: 
    When creating an ad hoc query, it is important to use the correct syntax and keywords. This will ensure that the query returns accurate results. Additionally, users should save their queries so that they can be reused in the future. 
    
    Related Information: 
    Ad hoc query is just one of many features available in SAP's SCM-ICH component. Other features include order management, delivery management, invoice management, and more.
    • Do you have any question about this SAP term?


      Upgrade now to chat with this SAP term.

Related SAP Glossary Terms

Click the links below to see the following related SAP glossary terms:
Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker