Automate

 View Only

  • 1.  Cumulate before extracting to Excel

    Posted 11-13-2019 07:09
    Is it possible to cumulate output, before extracting to Excel.

    ------------------------------
    RonSchmets |
    H&S Group B.V. |
    ------------------------------


  • 2.  RE: Cumulate before extracting to Excel

    Posted 11-14-2019 02:54
    Hi Ron
    ​
    Can you provide a little more detail please? what are you trying to extract? and when you say cumulate, are you talking adding together data within multiple fields so it appears as one field? or something else.

    many thanks

    ------------------------------
    christian stratford |
    Univar Europe Ltd |
    ------------------------------

    Original Message


  • 3.  RE: Cumulate before extracting to Excel

    Posted 11-14-2019 03:22
    For example from LIKP I select a certain date and made a join to LIPS.
    From Lips I need the total from lgmng added per matnr.

    ------------------------------
    RonSchmets |
    H&S Group B.V. |
    ------------------------------

    Original Message


  • 4.  RE: Cumulate before extracting to Excel

    Posted 11-14-2019 03:40
    ​if you have a primary key then Query should be able to link the tables?

    Im not familiar with the LIKP/LIPS fields im afraid, im more the Material master side than Customer.

    ------------------------------
    christian stratford |
    Univar Europe Ltd |
    ------------------------------

    Original Message


  • 5.  RE: Cumulate before extracting to Excel

    Posted 11-14-2019 03:55
    The primary key between the tables is the delivery (vbeln).

    In LIKP, I choose the delivery date (kodat).

    ------------------------------
    RonSchmets |
    H&S Group B.V. |
    ------------------------------

    Original Message


  • 6.  RE: Cumulate before extracting to Excel

    Employee
    Posted 11-14-2019 08:36
    HI Ron

    In general for output:

    1. you can either download a report, which is summarized to the level of detail you need - if it exists.   You can write a script to do this, although often it requires GUI scripting when dealing with the pop-up on where to save it.
    2. you can extract the details and use a pivot table to summarize it.  I've used this option on occasion.  I create a table for the detailed output, then refer the pivot to that table.  Then all you have to do is click refresh data and the pivot will be updated.   Note you can map to the pivot to then run another script, a needed.

    Hope this helps,
    Sigrid

    ------------------------------
    Sigrid Kok
    pse | Winshuttle North America
    ------------------------------

    Original Message