Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  BOM Change Upload Process

    Posted 10-15-2018 11:05

    One of the Supply Chain managers sent me this message regarding BOM changes.  My expertise has been in writing and running queries to extract data but I recall from  some initial training in WS the functionally to upload is also quite powerful and fairly straightforward.

     

     

    "With you being the resident Winshuttle expert I have a question for you. Would you know how to extract BOM information for various FG sku's so that they could be changed or maintained and then uploaded back into the system?"

     

    Looking for guidance on where to educate myself on WS upload process.

     

    Thank you.

     

     

     

    david goris

    C: (201) 388-7837

    Sr Supply Chain Project Manager

    E: dgoris@proximospirits.com

     

    333 Washington St., 4th Floor, Jersey City, NJ 07302

     

     

    Disclaimer: This message contains confidential information and is intended only for the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.


  • 2.  RE: BOM Change Upload Process

    Posted 10-16-2018 03:51
    ​Hi there

    Yes, there are 2 diffrent techniques that can be applied here as far as I see it.
    Transaction is the main-script that you would use to CREATE a BOM, and that is pretty much equal to a query, apart from that you are actually pushing data to SAP,
    Now, what you are saying is that you would like to CREATE or CHANGE an excisting BOM is slightly more complex even thou I would questioning changeing a BOM due to GS1-regulations, but that is another chapter.
    Anyhow, in order to be able to change AND create a BOM, I would go for a BAPI-script and that is diffrent from a normal script.
    Winshuttle has a very good script-template for create and change of Alternative unit of measure, and even thou this is not for BOM, it is using the same technique that you would need to apply

    Open up a ticket an reply with

    "Hello Winshuttle Support, I would like to request this template:

    MM02: Add alternate units of measure

    ID #29083

    https://www.winshuttle.com/sap-module-template/mm02-add-alternate-units-of-measure/"

    Hope this helps



    ------------------------------
    Henrik Axell Master Data Analyst
    Essity Hygiene and Health
    ------------------------------



  • 3.  RE: BOM Change Upload Process

    Posted 10-26-2018 10:11
    Thank you Henrik, Martin and Sigrid for the replies to my question. I've since learned that timing is early first quarter 2019 so we will be determining next steps later this year and will reach out again when the inevitable next questions arise.

    ------------------------------
    David Goris | Sr Supply Chain Manager
    Proximo Spirits | [City] | 201-630-7839
    ------------------------------

    Original Message


  • 4.  RE: BOM Change Upload Process

    Posted 10-16-2018 04:20

    I created a linked Transaction to change a component in a BOM using the following: -

     

    Script 1 (Transaction CS02) to remove the particular component.

    Enter the Valid from Date

    Locate the SKU to be removed using the "Position" function and read the quantity

     

    Script 2 (Transaction CS02)

    Add the new product to the bottom line reading and using the quantity obtained from Script 1

     

    The template consists of: -

    Column A – BOM SKU

    Column B – Valid from Date

    Column C – Component to remove

    Column D – Component Add

    Column E – Quantity. This is read from Script 1 and written into script 2

    Column F – Log Column

     

    I hope this helps?

     

    Kind regards,

     

    Martin Burrage
    Master Data Manager
    CMS Distribution Ltd



    Disclaimer

    The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

    This email has been scanned for viruses and malware, and may have been automatically archived. To find out more about email security, ransomware, anti-malware, spam filtering and archiving solutions from CMS Distribution, either on-premise or in-cloud, please click here.



    ------Original Message------

    One of the Supply Chain managers sent me this message regarding BOM changes.  My expertise has been in writing and running queries to extract data but I recall from  some initial training in WS the functionally to upload is also quite powerful and fairly straightforward.

     

     

    "With you being the resident Winshuttle expert I have a question for you. Would you know how to extract BOM information for various FG sku's so that they could be changed or maintained and then uploaded back into the system?"

     

    Looking for guidance on where to educate myself on WS upload process.

     

    Thank you.

     

     

     

    david goris

    C: (201) 388-7837

    Sr Supply Chain Project Manager

    E: dgoris@proximospirits.com

     

    333 Washington St., 4th Floor, Jersey City, NJ 07302

     

     

    Disclaimer: This message contains confidential information and is intended only for the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.


  • 5.  RE: BOM Change Upload Process

    Employee
    Posted 10-16-2018 12:53
    Hi David

    Am attaching an example read BOM bapi using a standard rFM that SAP provides. 

    Queries are possible, however getting the right combination for effectivity is tricky.  There is a valid from but not a valid to date.  And if you search on revision or change number, you'll only get components added for that revision/change number, not all components valid for that revision/change number.  So it's much simpler to use the BAPI.  

    For updating a BOM, I have an example CS02 transaction, where I recorded an action to ADD a component, UPDATE a component, DELETE a component or REPLACE a component.  Then I used IF logic around those parts of the script.  We use Excel data validation to provide a drop down "action code", and your script runs off of the "action code" on each component row.  If that would be helpful, I can share it, too, just let me know.

    Hope it's helpful​,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle North America
    ------------------------------