Zfg2.xlsx

  • Uploaded by: Prasad Ananthm
  • 0
  • 0
  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Zfg2.xlsx as PDF for free.

More details

  • Words: 2,086
  • Pages: 15
Transaction Code: CS01/CS02/CS03 Field Technical Name MATNR Description* Field Description MATERIAL Field Data Type CHAR CHAR Field Length 40 40 Finished or Semifinished Material Code for which BOM is to Material Description* Description is useful for reference be prepared Field Summary purpose only and not reqd while uploading.

31000 31000 31001 31001 31001 31001 31002 31002 31003 31003 31003 31004 31004 31005 31005 31006 31006 31007 31007 31008 31008 31008 31009 31009 31009 31009 31010 31010 31010 31011 31011 31011 31011

Dahi Loose Dahi Loose Gagangiri Dahi - 200 Gm Loose (Cup) Gagangiri Dahi - 200 Gm Loose (Cup) Gagangiri Dahi - 200 Gm Loose (Cup) Gagangiri Dahi - 200 Gm Loose (Cup) Gagangiri Dahi - 200 Gm ( 4.8 Kg. ) Box Gagangiri Dahi - 200 Gm ( 4.8 Kg. ) Box Gagangiri Dahi - 500 gm (Pouch) Gagangiri Dahi - 500 gm (Pouch) Gagangiri Dahi - 500 gm (Pouch) Gagangiri Chhas ( Plain ) 500 Ml Gagangiri Chhas ( Plain ) 500 Ml Gagangiri Chhas ( Masala ) 200 Ml Gagangiri Chhas ( Masala ) 200 Ml Gagangiri Chakka Loose Gagangiri Chakka Loose Gagangiri Lassi 200 ML (Pouch) Gagangiri Lassi 200 ML (Pouch) Gagangiri Lassi 200 ml (Cup) Gagangiri Lassi 200 ml (Cup) Gagangiri Lassi 200 ml (Cup) Gagangiri Shrikhand BP - 100 Gm Box Gagangiri Shrikhand BP - 100 Gm Box Gagangiri Shrikhand BP - 100 Gm Box Gagangiri Shrikhand BP - 100 Gm Box Gagangiri Shrikhand BP - 100 Gm Loose Gagangiri Shrikhand BP - 100 Gm Loose Gagangiri Shrikhand BP - 100 Gm Loose Gagangiri Shrikhand BP - 250 Gm Box Gagangiri Shrikhand BP - 250 Gm Box Gagangiri Shrikhand BP - 250 Gm Box Gagangiri Shrikhand BP - 250 Gm Box

31011 31012 31012 31012 31012 31013 31013 31013 31013 31013 31014 31014 31014 31014 31015 31016 31016 31016 31016 31017 31017 31017 31018 31018 31018 31018 31018 31019 31019 31019 31019 31020 31020 31020 31020 31020 31021 31021 31021 31021 31022 31023 31023 31023 31025

Gagangiri Shrikhand BP - 250 Gm Box Gagangiri Shrikhand BP 250 Gm Loose Gagangiri Shrikhand BP 250 Gm Loose Gagangiri Shrikhand BP 250 Gm Loose Gagangiri Shrikhand BP 250 Gm Loose Gagangiri Shrikhand BP - 500 Gm Box Gagangiri Shrikhand BP - 500 Gm Box Gagangiri Shrikhand BP - 500 Gm Box Gagangiri Shrikhand BP - 500 Gm Box Gagangiri Shrikhand BP - 500 Gm Box Gagangiri Shrikhand BP 500 Gm Loose Gagangiri Shrikhand BP 500 Gm Loose Gagangiri Shrikhand BP 500 Gm Loose Gagangiri Shrikhand BP 500 Gm Loose Gagangiri Shrihand (B.P) Loose Gagangiri Amrakhand - 100 Gm Box Gagangiri Amrakhand - 100 Gm Box Gagangiri Amrakhand - 100 Gm Box Gagangiri Amrakhand - 100 Gm Box Gagangiri Amrakhand - 100 Gm Loose Gagangiri Amrakhand - 100 Gm Loose Gagangiri Amrakhand - 100 Gm Loose Gagangiri Amrakhand - 250 Gm Box Gagangiri Amrakhand - 250 Gm Box Gagangiri Amrakhand - 250 Gm Box Gagangiri Amrakhand - 250 Gm Box Gagangiri Amrakhand - 250 Gm Box Gagangiri Amrakhand - 250 Gm Loose Gagangiri Amrakhand - 250 Gm Loose Gagangiri Amrakhand - 250 Gm Loose Gagangiri Amrakhand - 250 Gm Loose Gagangiri Amrakhand - 500 Gm Box Gagangiri Amrakhand - 500 Gm Box Gagangiri Amrakhand - 500 Gm Box Gagangiri Amrakhand - 500 Gm Box Gagangiri Amrakhand - 500 Gm Box Gagangiri Amrakhand - 500 Gm Loose Gagangiri Amrakhand - 500 Gm Loose Gagangiri Amrakhand - 500 Gm Loose Gagangiri Amrakhand - 500 Gm Loose Gagangiri Amrakhand Loose Gagangiri Dahi - 200 gm (Pouch) Gagangiri Dahi - 200 gm (Pouch) Gagangiri Dahi - 200 gm (Pouch) Gagangiri Chhas ( Plain ) 500 Ml Loose

31025 31026 31026

Gagangiri Chhas ( Plain ) 500 Ml Loose Gagangiri Chhas ( Masala ) 200 Ml Losse Gagangiri Chhas ( Masala ) 200 Ml Losse

WERKS PLANT

STLAN BOM USAGE CHAR CHAR 4 1 Enter Plant code, Purpose of Plant is an BOM Usage: organizational unit 1within a company Production where activities 4-Plant take place. Maintenance 6- Costing

1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

STLAL DATUV POSNR ALTERNATIVE BOM VALID FROM ITEM CHAR DATS CHAR 2 8 4 ITEM NO If only one BOM exists Specifies the Sequential for the material, give 1, start date for the validity numbers starting if more than one BOM period of from 0010 with an exists (alternate), give Material BOM interval of 10 for the 2 for 2nd alt.BOM, 3 the items in the for 3rd Alt BOM. BOM

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018

0010 0020 0010 0020 0030 0040 0010 0020 0010 0020 0030 0010 0020 0010 0020 0010

0020 0010 0020 0010 0020 0030 0010 0020 0030 0040 0010 0020 0030 0010 0020 0030 0040

1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018 01.04.2018

0050 0010 0020 0030 0040 0010 0020 0030 0040 0050 0010 0020 0030 0040 0010 0010 0020 0030 0040 0010 0020 0030 0010 0020 0030 0040 0050 0010 0020 0030 0040 0010 0020 0030 0040 0050 0010 0020 0030 0040 0010 0010 0020 0030 0010

1100 1100 1100

1 1 1

1 1 1

01.04.2018 0020 01.04.2018 0010 01.04.2018 0020

POSTP IDNRK ITEM CATEGORY COMPONENT CHAR CHAR 1 40 If stocked items say 'L', for Non stock Items put 'N' ; Examples: for stocked items: All the materials in Material code for the the BOM; Non-stock items : component of Documents, BOM

10025 55198 10020 10024 55045 55222 31001 55044 10019 10025 55050 10031 55041 10030 55043 10029 55198 10033 55132 10033 55129 55127 10034 55228 55225 55226 10034 55228 55225 10034 55245 55242 55248

55244 10034 55245 55242 55248 10034 55235 55242 55248 55234 10034 55235 55242 55248 10034 10035 55210 55212 55226 10035 55210 55212 10035 55216 55214 55248 55244 10035 55216 55214 55248 10035 55220 55214 55248 55234 10035 55220 55214 55248 10035 10018 10024 55049 10031

55041 10030 55043

Description * Char 40

Component Description

Dahi Loose For Culture Polyliner For Kraft Paper Bag 25 Kg Std. Milk For Dahi Cup Loose Mother culture Cup For Curd 200 Gm Aluminium Foil - For Dahi Cup 95.5 mm Dia Gagangiri Dahi - 200 Gm Loose (Cup) Corrugated Box With One Plate - Dahi 200 Gm Cup Std. Milk For Dahi Pouch Loose Mother culture Polyfilm - Gagangiri Dahi 500g Loose Taak Polyfilm Multilayer Coextruded C I Flexo Printed - Plain Chass 500 ml Masala Chass Loose Polyfilm - Spiced Butter Milk 200 Ml Chakka Loose Polyliner For Kraft Paper Bag 25 Kg Lassi Loose Polyfilm - Gagangiri Shahi Lassi 200 Ml. Lassi Loose Cup - Lassi 200 Ml Aluminium Foil - For Lassi Cup 69.5 mm Dia Shrikhand (B.P.) Loose Cup - Shrikhand Badam Pista 100 Gm Aluminium Foil - For Shrikhand Badam Pista HIPS Cup 69.5 mm Dia Corrugated Box - Shrikhand 100 Gm Cup Shrikhand (B.P.) Loose Cup - Shrikhand Badam Pista 100 Gm Aluminium Foil - For Shrikhand Badam Pista HIPS Cup 69.5 mm Dia Shrikhand (B.P.) Loose Cup - Shrikhand Badam Pista 250 Gm Aluminium Foil - For Shrikhand Badam Pista Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup

MENGE QUANTITY QUAN 13

MEINS UNIT UNIT 3

Quantity of the item in units Unit in which given and for the item is stored base qty (COMPONEN given(COMPON T UOM) ENT QTY)

25 1 1 0.02 5 5 4.8 1 1 0.002 0.0048 1 0.0048 1 0.007 25 1 1 0.007 1 5 5 6 60 60 1 1 10 10 6 24 24 24

KG NOS L L NOS NOS KG NOS L L KG L KG L KG KG NOS L KG L NOS NOS KG NOS NOS NOS KG KG NOS KG NOS NOS NOS

Corrugated Box With One Plate - Shrikhand 250 Gm Cup Shrikhand (B.P.) Loose Cup - Shrikhand Badam Pista 250 Gm Aluminium Foil - For Shrikhand Badam Pista Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Shrikhand (B.P.) Loose Cup - Shrikhand Badam Pista 500 Gm Aluminium Foil - For Shrikhand Badam Pista Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Corrugated Box - Shrikhand 500 Gm Cup Shrikhand (B.P.) Loose Cup - Shrikhand Badam Pista 500 Gm Aluminium Foil - For Shrikhand Badam Pista Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Shrikhand (B.P.) Loose Amrakhand Loose Cup - Amrakhand 100 gm Printing Cylinder - Aluminium Foil Amrakhand Cup 69.5 mm Dia Corrugated Box - Shrikhand 100 Gm Cup Amrakhand Loose Cup - Amrakhand 100 gm Printing Cylinder - Aluminium Foil Amrakhand Cup 69.5 mm Dia Amrakhand Loose Cup & Lid Printed - Amrakhand 250 Gm Aluminium Foil - For Amrakhand Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Corrugated Box With One Plate - Shrikhand 250 Gm Cup Amrakhand Loose Cup & Lid Printed - Amrakhand 250 Gm Aluminium Foil - For Amrakhand Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Amrakhand Loose Cup & Lid Printed - Amrakhand 500 Gm Aluminium Foil - For Amrakhand Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Corrugated Box - Shrikhand 500 Gm Cup Amrakhand Loose Cup & Lid Printed - Amrakhand 500 Gm Aluminium Foil - For Amrakhand Cup 95.5 mm Dia Lid - For 95 mm Dia HIPS Material Cup Amrakhand Loose Std. Milk For Dahi Pouch Loose Mother culture Polyfilm - Gagangiri Dahi 200g Loose Taak

1 1 4 4 4 6 12 12 12 1 1 2 2 2 1 6 60 60 1 1 10 10 6 24 24 24 1 1 4 4 4 6 12 12 12 1 1 2 2 2 1 1 0.002 0.0075 1

NOS KG KG NOS NOS KG NOS NOS NOS NOS KG NOS NOS NOS KG KG NOS NOS NOS KG NOS NOS KG NOS NOS NOS NOS KG NOS NOS NOS KG NOS NOS NOS NOS KG NOS NOS NOS KG L L KG L

Polyfilm Multilayer Coextruded C I Flexo Printed - Plain Chass 500 ml Masala Chass Loose Polyfilm - Spiced Butter Milk 200 Ml

0.0048 1 0.007

KG L KG

BMENG BASE QTY. QUAN 13

BMEIN UNIT UNIT 3

SANKA COSTING RELEVANCY CHAR 1

Base quantity Controls the extent to which of the BOM the item, is included in That means costing the quantity Units for the for which the Base quatity BOM is (HEADER defined(HEA UOM) DER QTY)

25

KG

1

KG

1

BOX

1

KG

1

L

1

L

25

KG

1

L

1

L

1

Box

1

KG

1

Box

1

KG

1

Box

1

KG

1 1

KG BOX

1

KG

1

BOX

1

KG

1

BOX

1

KG

1 1

KG KG

1

L

1

L

More Documents from "Prasad Ananthm"