Automate

 View Only
  • 1.  CA02 modify component allocation

    Posted 04-08-2022 13:26
    Hello Te@m,

    Need your lights in order to loop or multi loop with transaction CA02 to assign new allocation for several component in a Bill of Material

    You will find attached the screen shot with sequence in sap , the Winshuttle script and the excel file targeted for upload

    The question is how to proceed to place correctly the loop or multi loop in that case and have a working script to upload/assign new activity for several components of the Bill of Material

    Thanks in advance for your attention and support

    Kind regards

    ------------------------------
    Jerome gaden | [Logistic analyst]
    Atlas Copco Power Tools Distribution N.V. | 330240802063
    ------------------------------


  • 2.  RE: CA02 modify component allocation

    Employee
    Posted 04-08-2022 17:25
    Hi Jerome,
    Your screen shots are helpful, but the question is, were are you doing more than 1 of something, i.e. what do we need to loop around?

    I believe these are your steps in CA02
    1. open bom
    2. select component allocation
    3. re-enter bom info
    4. find and select component
    5. new assignment - assign to activity
    So one BOM, component allocation and multiple component assignment changes, i.e. loop through 4 & 5?  Or is there more looping, i.e. multiple selections in component allocation AND multiple find and select components with new assignments? 

    Right now I believe you have a loop around 2-5, if I'm not mistaken.  So that's one pass through for everything. 

    One quick tip at the start, your Loop on the Expert mode tab is pointing to column L, but your Loop ID in Excel is in column A.  You should update that

    Please advise.

    Sigrid

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



  • 3.  RE: CA02 modify component allocation

    Posted 04-11-2022 10:04
    Hello Sigrid,

    Indeed, i have modified script and template accordingly but still get an error.

    My loop seems not relevant and may be i need multi loop in that case but not sure to do that for this example

    Your time and support is kindly appreciate

    Regards

    ------------------------------
    Jerome gaden | [Logistic analyst]
    Atlas Copco Power Tools Distribution N.V. | 330240802063
    ------------------------------

    Attachment(s)



  • 4.  RE: CA02 modify component allocation

    Employee
    Posted 04-11-2022 10:08
    Hi Jerome
    In order to help you with your multi-loop question, I need an answer to mine - copying here again.

    I believe these are your steps in CA02
    1. open bom
    2. select component allocation
    3. re-enter bom info
    4. find and select component
    5. new assignment - assign to activity
    So one BOM, component allocation and multiple component assignment changes, i.e. loop through 4 & 5?  Or is there more looping, i.e. multiple selections in component allocation AND multiple find and select components with new assignments? 

    Please advise on the steps and where you might need to handle multiple.

    Best Regards,
    Sigrid

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



  • 5.  RE: CA02 modify component allocation

    Posted 04-11-2022 11:02
      |   view attached
    Hi Sigrid,

    Sorry for inaccuracies

    I believe these are your steps in CA02
    1. open bom : (yes)
    2. select component allocation :  (yes, button as per screen shot attached)
    3. re-enter bom info : (yes, Bom header, plant, usage, Bom number, alternative Bom)
    4. find and select component (yes)
    5. new assignment - assign to activity (yes)
    So one BOM, component allocation and multiple component assignment changes, i.e. loop through 4 & 5?  Or is there more looping, i.e. multiple selections in component allocation AND multiple find and select components with new assignments?

    Several Bom header will be to upload, meaning select all components 5,6 ore more depending of the structure of the Bom  and to adress /assign new activity per each component selected, i have attached new template accordingly. Hope i'm more clear don't hesitate to ask me more, your expertise is kindly appreciate




    Thanks in advance


    ------------------------------
    Jerome gaden | [Logistic analyst]
    Atlas Copco Power Tools Distribution N.V. | 330240802063
    ------------------------------

    Attachment(s)

    xlsx
    CA02_NEWASSIGNMENT3.xlsx   5 KB 1 version


  • 6.  RE: CA02 modify component allocation

    Posted 04-11-2022 11:06
    new

    ------------------------------
    Jerome gaden | [Logistic analyst]
    Atlas Copco Power Tools Distribution N.V. | 330240802063
    ------------------------------

    Attachment(s)

    Txr
    CA02_TEST2 (1).Txr   368 KB 1 version


  • 7.  RE: CA02 modify component allocation

    Employee
    Posted 04-11-2022 18:39
    Hi Jerome

    If I look at the data, everything is the same until you get to component number and activity.

    So the Material number and plant are repeated, you find a BOM (single BOM), and then you are looping through finding components and updating the activity.

    So therefore, your loop starts at the find component portion.

    If, in fact, you are looping through multiple BOMs for each material/plant, and then multiple components of each BOM, then you would ADD the above loop to the script you have - creating a nested loop.  If you have a nested loop, you can either use the same loop id column and choose another identifier, or add a loop id column.   It might look something like this

    Data looking something like this

    HTH,
    Sigrid

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



  • 8.  RE: CA02 modify component allocation

    Posted 04-12-2022 09:32
    Hello Sigrid,

    Ok i tried nested loop as suggested but i still got an error as attached 

    May be my misunderstanding is coming from how to use correctly the nested loop with the template here.

    Is it correct to have the second loop with H on column I and D same as D in column 1 or should it be different or placed differently

    Moreover the error message about multiple allocations not allowed is not clear enough for me as normally we can change activity number as we want with transaction ca02 as showed in the screen shot .doc attached



    Thanks for your support

    BR

    ------------------------------
    Jerome gaden | [Logistic analyst]
    Atlas Copco Power Tools Distribution N.V. | 330240802063
    ------------------------------

    Attachment(s)

    Txr
    CA02_TEST2 (1) (3).Txr   369 KB 1 version
    docx
    CA02 new allocation.docx   398 KB 1 version


  • 9.  RE: CA02 modify component allocation

    Employee
    Posted 04-12-2022 09:50
    Hi again Jerome

    I do not have this scenario to try it, so please try to help yourself by running in debug mode to see where any issues occur and make adjustments.

    In general:
    • Outside of the loop, you are opening an object.  So all of the steps to open that object and go to the right screen/tab have to happen outside of the loop.
    • For looping, you have to think of it like this - the script can't see the screen.  So you have to ensure that the loop has all of the steps it needs inside the loop to find and and process your objects:
      1. find an object (component for you)
      2. take an action (update assignment)
      3. in case you have changed screens or tabs, go back to the place where you can find the next one
    • Then to wrap it out, outside of the loop you save, and exit if needed.

    Again, please run in debug mode and see where things are not working.  If you are still stuck after that, if it's a product error, please open a support ticket, and if you need more specific guidance, please reach out to your account rep for options to engage with our services team.  

    Best Regards,
    Sigrid


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



  • 10.  RE: CA02 modify component allocation

    Posted 14 days ago

    Jerome,

    Reviewing what work you have done on component allocation. I would like to connect with you on how you are extracting component allocation and how your process matured over the past 2 years in this area. In turn I would share my years of in this knowledge. 



    ------------------------------
    Benjamin Kielas
    Supervisor SAP Master Data
    Generac Power Systems, Inc.
    WAUKESHA WI
    ------------------------------