Automate

 View Only

  • 1.  Creation of a query for structure KKB_DUMM

    Posted 02-09-2026 16:40

    Hi,

    An user wants to extract field Total Value(KKB_DUMM-KKB_WERT)when process in tcode CK11N is done, the message that appears after running the script is the message that appears in SAP. Any suggestion how we extract this information?

    BR,

    Ketrine Giha



    ------------------------------
    Ketrine Giha
    Consultant
    PepsiCo (Business Solutions Group)
    Winston Salem
    ------------------------------


  • 2.  RE: Creation of a query for structure KKB_DUMM

    Employee
    Posted 9 days ago

    Hi Ketrine

    Regarding your request, please see below.You can achieve this by following one of the below option.

    1. GUI Scripting Mode (Recommended)

    Use GUI scripting mode during recording to attempt capturing the message or popup containing the Total Value field. This method provides more flexibility in capturing complex screen elements that standard recording cannot access.

    2. Manual Field Mapping in Expert Tab

    If the Total Value appears in a popup or message window after posting:
    • Open your script in the Expert Tab of the Mapper
    • Manually add the field reference: KKB_DUMM-KKB_WERT
    • Map this field to your output file (Excel or Access)
    • This approach works similarly to capturing document numbers from popup screens

    3. Query Script Method

    Create a follow-up query script that retrieves the Total Value after the transaction completes:
    • Run the CK11N transaction script first
    • Immediately execute a query script
    • Use search criteria like SAP username and transaction date to retrieve the posted data
    • Query the appropriate table containing KKB_DUMM-KKB_WERT field

    4. BAPI or Function Module Approach

    Consult with your SAP team to identify if there's a BAPI or function module that can retrieve the calculated Total Value for the cost estimate, which would be more reliable than message extraction.

    Should you have further queries you can create support ticket on support.precisely.com

    Thanks

    Archana



    ------------------------------
    Archana Chandar
    *Precisely Software Inc.
    ------------------------------