Supplier BOM import interface - Voith by lanyuehua

VIEWS: 0 PAGES: 3

									Bill of Material including spare and wear parts upload interface                                                                                                             Codeword:              Template PM1                                               Date:    03.03.2011     Prices valid until:          2xxx-xx-xx                                                                                                                                                                                                                                                                        Voith Paper
 NUM(2)    NUM(8)       CHAR(10)    NUM(6)      CHAR(3)                              C(40)                 C (40)          CHAR(32)   CHAR(100)           CHAR(30)                NUM(4)                   CHAR(18)         CHAR(18)                CHAR(30)            CHAR(30)         CHAR(30)                CHAR(30)            CHAR(30)          CHAR(30)      CHAR(2)                NUM(10)               CHAR(13/3)         CHAR(60)         NUM(11,2)    NUM (2       CHAR(3)        NUM(6)              NUM(8)                        CHAR(30)                 CHAR(30)               CHAR(30)




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Import code number for
                                                                                                                                                                                                                                                                                                                                                                      Spare partindicator



                                                                                                                                                                                                                                                                                                                                                                                            spare part quantity
                                                                                                                                                          Assembly drawing
                                                  Unit de: ST; en, pt: PC




                                                                                                                                        Open dimensions




                                                                                                                                                                                 Part No. in ass.




                                                                                                                                                                                                                                                                                                                                                                                              Recommended




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Commodity code /
                                                                                                                                                                                                                             Industry standard
                                                                                                                                                                                                                               characteristic
                                                                                                                                                                                                                                                                         Basic




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     foreign trade
                                                                                                                                                                                                                                                                                                             Manufacturer´s      Product name (if                                                                                                                                          Delivery time




                                                                                                                                                                                     drawing
                                                                                                                                                              number
 Level    Item No.
                     Voith SAP       Quantity                               Designation (english)
                                                                                                    Designation (local
                                                                                                                         Dimensions                                                                 Industry Standard No.                        Basic material
                                                                                                                                                                                                                                                                       material /
                                                                                                                                                                                                                                                                                      Manufacturer           material number      different from    Product - type
                                                                                                                                                                                                                                                                                                                                                                                                                  Weight
                                                                                                                                                                                                                                                                                                                                                                                                                               Remarks (item text)
                                                                                                                                                                                                                                                                                                                                                                                                                                                     Price per    Pricing
                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Currency      to Voith
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         PIC Plant Identification      DIC Device             LIC Location
                     Material No.                                                                      language)                                                                                                                                                       Industry                                                                                                                                    [kg]                                 unit       unit                                                                          Code               Identification Code    Identification code
                                                                                                                                                                                                                                                                                                              (ID number)          designation)                                                                                                                                              [weeks]
                                                                                                                                                                                                                                                                       standard

  level     posnr        matnr      menge        meins                            benennung_en          benennung_loc       groes     open_dim              mtbvm                  mtbtm                    norm_nr         normmkl                   werkst            werkst_norm        mnf                    mnf_id             prod_name          prod_type     erskz                 etmenge                  gew               potx             price     price_unit    currency    Lieferzeit_zu_V   stat_warennummer                    akz_kd                   bmk_kd                 okz_kd




                     06.06.2013                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      1/3
Bill of Material including spare and wear parts upload interface                                                                                                                                 Codeword:              Example PM1                                                  Date:    03.03.2011              Prices valid until:          03.03.2012                                                                                                                                                                                                                                                                                        Voith Paper
 NUM(2)    NUM(8)           CHAR(10)    NUM(6)          CHAR(3)                               C(40)                C (40)                  CHAR(32)   CHAR(100)              CHAR(30)                 NUM(4)                   CHAR(18)         CHAR(18)                  CHAR(30)            CHAR(30)                 CHAR(30)                 CHAR(30)            CHAR(30)                   CHAR(30)    CHAR(2)                NUM(10)               CHAR(13/3)         CHAR(60)         NUM(11,2)    NUM (2           CHAR(3)        NUM(6)                  NUM(8)                        CHAR(30)                 CHAR(30)               CHAR(30)




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Import code number for
                                                                                                                                                                                                                                                                                                                                                                                                            Spare partindicator



                                                                                                                                                                                                                                                                                                                                                                                                                                  spare part quantity
                                                                                                                                                                              Assembly drawing
                                                          Unit de: ST; en, pt: PC




                                                                                                                                                        Open dimensions




                                                                                                                                                                                                     Part No. in ass.




                                                                                                                                                                                                                                                                                                                                                                                                                                    Recommended




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Commodity code /
                                                                                                                                                                                                                                                 Industry standard
                                                                                                                                                                                                                                                   characteristic
                                                                                                                                                                                                                                                                                               Basic




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   foreign trade
                                                                                                                                                                                                                                                                                                                                            Manufacturer´s      Product name (if                                                                                                                                                     Delivery time




                                                                                                                                                                                                         drawing
                                                                                                                                                                                  number
                         Voith SAP       Quantity                                                           Designation (local                                                                                                                                                               material /                                                                                                                                                 Weight                             Price per    Pricing                                                                        PIC Plant Identification      DIC Device             LIC Location
 Level    Item No.                                                                  Designation (english)                             Dimensions                                                                        Industry Standard No.                         Basic material                             Manufacturer               material number      different from           Product - type                                                             Remarks (item text)                                 Currency      to Voith
                         Material No.                                                                          language)                                                                                                                                                                     Industry                                                                                                                                                    [kg]                                 unit       unit                                                                                  Code               Identification Code    Identification code
                                                                                                                                                                                                                                                                                                                                             (ID number)          designation)                                                                                                                                                         [weeks]
                                                                                                                                                                                                                                                                                             standard

  level     posnr            matnr      menge            meins                            benennung_en          benennung_loc               groes     open_dim                  mtbvm                  mtbtm                    norm_nr         normmkl                    werkst             werkst_norm                mnf                     mnf_id             prod_name                  prod_type    erskz                 etmenge                  gew               potx             price     price_unit        currency    Lieferzeit_zu_V       stat_warennummer                    akz_kd                   bmk_kd                 okz_kd
                     1                              1   PC                          Pneumatic valve         Pneumatikventil                                                                                                                                          OHNE EINTRAG                           BOSCH REXROTH                   0821 003 051                                                   E1                                   1                                                                    1   EUR
                     2                              1   PC                          Motor                   Motor                                                                                                                                                    OHNE EINTRAG                           SIEMENS                         1LA9 131-2KA60 Z A11                                           E1                                   1                                             412,76                 1   EUR
                     3                              1   PC                          Pressure switch         Drucktaster                                                                                                                                              OHNE EINTRAG                           SIEMENS                         3SB3201-0AA11                                                  E1                                   1                                                                    1   EUR                                                           55H960761                  55-ZS-4070D            551986792
                     4    H01.045374                1   PC                          Shaft seal ring         Wellendichtring   110X140X13                                  1.22-999999                     101           VN 3057                                      NBR NRST                                                                                                                              V                                  0,1                                              25,00                 1   EUR
                     5    H01.118602                1   PC                          Hexagon bolt            Sechskantschraube M 30X120                                    1.22-100000                     102           DIN 7968                                     12.9                    ISO 898-1                                                                                                     V                                    1                                              15,00                 1   EUR
                     6                              1   PC                          Gearbox                 Getriebe             2400x400x600                             1.22-999999                     112                                                        Edelstahl                              Flender                         F 24-48 B3                             FZG                     E1                               120                                             2800,00                  1   EUR
                     7    H84.075816                1   PC                          Lighting                Beleuchtung                                                   1.22-999999                     221           ISO 4711                                                                            Rittal                          PS 4155.100                                                    E2                                 0,1                                                2,50                1   EUR                            1
                     8                              3   PC                          Gear shaft              Zahnwelle            100x120                                  1.21-999999                     102                                                        Kunstoff                               Festo                           F001.1589-1234                         K-GW10/12               E1                                   15                                            100,00                 1   EUR
                     9    412.527.000               1   KG                          Glue                    Leim                                                          1.21-999999                     107                                                        Synthetic resin                        Voith                           412.527.000                                                    C                                    10                                             15,00                 1   EUR




                         06.06.2013                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                2/3
 This interface is used to import supplier´s bill-of-materials (BOM) / spare part lists
 into the SAP ERP system of Voith to establish a complete BOM of the machine.

 Rule for file name:                       Supplier name & Voith purchase order number &"_"& Voith purchase order item number&".xls"
 Example:                                  ExampleCompany_4500607579_10.xls

 Rule for Excel sheet name:                "BOM_" & Voith purchase order number & "_" & Voith purchase order item number
 Example:                                  BOM_4500607579_10

 Rules for content
                                           Identification and technical data of parts

                                           Each single part needs an unique identification number.
                                           Using this number it must be possible to purchase this part at any time for spare part business.
                                           The part data must be accurate enough to recognize identical parts clearly.

                                           Minimum requirements:

                                           - Designation
                                           - for industry standard parts: industry standard, basic material, dimensions
                                           - for engineered parts: dimensions, basic material, weight

                                           - Manufacturer and manufacturer´s material number are required to identify the part for the supply chain
                                              - for identification of OEM parts (catalog parts):
                                                the OEM manufacturer, product type and manufacturers material number
                                                "OEM manufacturer" designs and produces the product and displays his name on the label.
                                                The "manufacturer" is the "brand". Not the vendor, the dealer or the external manufacturing plant.

                                              - for identification of engineered parts
                                                "Manufacturer" is the supplier of the component, who is responsible for
                                                 Engineering of the complete component.
                                                 In this case a unique identification number of the supplier´s order processing
                                                 system is required as manufacturer´s material number

                                           After a vendor received Voith SAP material numbers for the parts the first time,
                                           Voith expects to receive these material numbers in future lists.

                                           Completeness of BOM

                                           The bill of material needs to contain the single parts, no raw material.

                                           Minimum requirements:
                                           - recommended spare parts
                                           - recommended wear parts
                                           - EC&I devices
                                           - loose parts to be mounted
                                           - fastening material
                                           - parts which are disassembled and reassembled during dismantling and installation of spare and wear parts
                                           - parts which are marked with part numbers in assembly drawings according to DIN ISO 6433
                                           - devices / function units that are worth refurbishing, which are fixed, not discarded, when defective
                                              (for example rolls, dryers, cleaning devices, doctors, single machines, scanners, guides,...)

                                           Recommended spare and wear parts

                                           Recommended spare and wear parts as well as consumables are included in the complete BOM.
                                           They need to be marked with spare part indicator "E1", "E2", "E3"; wear parts with "V" as well as consumables with "C"
                                           Details see comment in the table´s column header.

                                           Plant Identification Code / Device Identification Code / Location Identification Code

                                           For EC&I products like hydraulic units the individual parts are labelled with PIC, DIC and LIC.
                                           If filled, quantity must be 1 because each label describes one individual part.
                                           Numbering system as agreed with the customer for the current project (project guideline).
                                           (Either according to customer´s mill standard or to Voith Paper standard as defined in VN1900)

                                           Usage of levels

                                           Most of the BOMs imported with this interface are flat lists of single parts.
                                           In this case the column "level" stays empty.

                                           BOMs of complex units may contain various levels of assemblies and sub-assemblies.

                                           Example:
                                           Level
                                           1     Assembly 1 (headline)
                                           2      Sub-assembly 11 (headline)
                                           3       Single part
                                           3       Single part
                                           2      Sub-assembly 12 (headline)
                                           3       Single part
                                           3       Single part
                                           3       Single part
                                           3       Single part
                                           1     Assembly 2 (headline)
                                           2      Sub-assembly 21 (headline)
                                           3       Single part
                                           3       Single part
                                           2      Sub-assembly 22 (headline)
                                           3       Single part




06.06.2013                                                                                                                                                          3/3

								
To top