Automate

 View Only

  • 1.  Query: Criteria as comparing two SAP fields

    Posted 06-13-2022 02:24

    Hello community,

    I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

    I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

    Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

    Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

    Thank you for your comments!



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


  • 2.  RE: Query: Criteria as comparing two SAP fields

    Employee
    Posted 06-15-2022 09:43
    Hi Henri
    That's not currently supported in Query.  You could look into creating an SAP query in SQVI, and then with permission accessing it via Query (Choose Infosets) as a workaround.
    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------



  • 3.  RE: Query: Criteria as comparing two SAP fields

    Posted 06-16-2022 01:43
    Thank you for your reply. I see, what a shame. I probably don't have the time to find out how to use the SQVI. I may try to use WS Query but extract the materials in parts, maybe based on PH. Then compare the weights in Excel. Let's see.

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

    Original Message


  • 4.  RE: Query: Criteria as comparing two SAP fields

    Employee
    Posted 06-16-2022 11:08
    Hi Henri,
    Feel free to open a support ticket to request an enhancement for this feature.  I'm sure there are others who want the same thing.
    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: Query: Criteria as comparing two SAP fields

    Posted 06-17-2022 02:02
    I could suggest that (and something else as well). Are there instructions somewhere how to request an enhancement?

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

    Original Message


  • 6.  RE: Query: Criteria as comparing two SAP fields

    Employee
    Posted 06-17-2022 09:16
    Hi Henri

    Please open a support ticket: https://support.winshuttle.com/hc/en-us/requests/new
    Under Case Reason choose Feature Request

    Example:
    Please include details, including use case(s), as it will help the team reviewing it.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 7.  RE: Query: Criteria as comparing two SAP fields

    Posted 06-30-2022 06:57
    Apparently your customer service contacted my company's Winshuttle provider about this. They in return contacted your WS customer service again, who told that creating a query like this is not possible. I wonder why my WS provider was brought into this. Maybe I didn't create the enhancement request correctly or the process isn't completely defined.

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

    Original Message