Skip to Content
avatar image
Former Member

How to manage cable and wire lengths

We purchase cables and wire in meter and stock in the same unit. However cables in physical stock would be in cut pieces and not as continuous length which we are unable to show in stock list.

While MRP run if the available quantity is less than the required lenghts, still the available lengths get pegged and planned orders are generate for partial requirement which may not be useful as continuous lengths may be required.

Kindly help us to know, how to maintain cut piece lenghts in stock and how to restrict system to peg only desire lengths.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 23, 2017 at 03:09 AM

    Dear,

    In our company we use to store cables and wires in Batches. So if some batch is sold partially the remaining stock is showing in the system with same batch number with reduced quantity. In future if some cut piece returns from the same batch the Warehouse person inform us that this is cut piece returns from the customer and it is in good condition to be offer to sales, so in this case we need to crate new batch with '+' and serial 1, 2 etc at the end in order to show this is cut piece. e.g. batch 20183/17 cut twice and returns so we will create 20183/17+1, 20183/17+2 etc.

    In second scenario, on the recommendation of the warehouse and further inspection, we will transfer the cut piece in a separate location called 'Scrap' because it is perceived as 'not sell-able', so the material will be scrapped in future due e.g. damaged sheathing, inferior quality, very short piece etc. So by putting material in separate location the said scrap will not considered in the report again.

    Hope it helps.

    Regards,

    Farhan Malik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi A. Brijees,

      1. You should maintain the stock of cables in Batches, for this you should maintain the batches at material management level. If you go to MM02 for any cable item code and go to 'accounting tab' check is there 'x' in from of batch management. If there is no 'x' it mean the stock is not maintained in batches. So you have to create new codes for the items in order to make sure the system will not consolidate the quantity.

      2. In order to exclude few Batches stock from MRP, SAP has come up with different categories of stock like blocked stock, restricted-use stock etc. you can transfer these stock into blocked/restricted use stock and enable the respective check box in T-code: OPPQ in "Available Stocks'Option (Maintain Plant Parameters screen). After transfer of stock & Check Box enabled in OPPQ, execute MRP, system will not consider the stock (cut pieces).

      Regards,
      Farhan

  • avatar image
    Former Member
    Oct 25, 2017 at 02:28 PM

    Thanks Farhan. Further I would like to detail it,

    1. We have more than 500 types of cables and our stock shows consolidated qty. Can I show individual types with cut piece lenghts available?

    2. While MRP run system checks only consolidated qty and even partial requirements are pegged to sale orders and planned orders are created for partial qty which may not be useful. Can system check stock in batches and generate planned orders accordingly?

    Add comment
    10|10000 characters needed characters exceeded