{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["QS-702AA Intro","Sharepoint","QS-702C HAWA OCP-Trading Goods"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":310,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"QS-702AA Intro","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Select the type of material you want to create and click on it to proceed to the correct Material Request Form"]

{"sheet":"Sharepoint","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",'QS-702C HAWA OCP-Trading Goods'!B3,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,\"\"))))))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",'QS-702C HAWA OCP-Trading Goods'!I6,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,\"\"))))))","v":{"$error":"#REF!"}},null,null,null,"Waiting for:"]
[null,{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",'QS-702C HAWA OCP-Trading Goods'!I3,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,IF(#REF!>\"\",#REF!,\"\"))))))","v":{"$error":"#REF!"}},{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",COUNTA('QS-702C HAWA OCP-Trading Goods'!I6:XX6),IF(#REF!>\"\",COUNTA(#REF!),IF(#REF!>\"\",COUNTA(#REF!),IF(#REF!>\"\",COUNTA(#REF!),IF(#REF!>\"\",COUNTA(#REF!),IF(#REF!>\"\",COUNTA(#REF!),\"\"))))))","v":{"$error":"#REF!"}}]
[null,"Responsible:","Total fields:","Filled in:","Result %",100]
[null,"Product Developer",{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",COUNTIFS('QS-702C HAWA OCP-Trading Goods'!$F$6:$F$251,\"x\",'QS-702C HAWA OCP-Trading Goods'!$G$6:$G$251,B7),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7),\"\"))))))","v":{"$error":"#REF!"}},{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",COUNTIFS('QS-702C HAWA OCP-Trading Goods'!$F$6:$F$251,\"x\",'QS-702C HAWA OCP-Trading Goods'!$G$6:$G$251,B7,'QS-702C HAWA OCP-Trading Goods'!$I$6:$I$251,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B7,#REF!,\">\"\"\"),\"\"))))))","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR(IF(C7>0,D7*(100/C7),\"\")),\"\",IF(C7>0,D7*(100/C7),\"\"))","v":""},{"$f":"IF(B7<>\"\",IF(E7<$F$6,B7,\"\"),\"\")","v":""}]
[null,"MRP Planner",{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",COUNTIFS('QS-702C HAWA OCP-Trading Goods'!$F$6:$F$251,\"x\",'QS-702C HAWA OCP-Trading Goods'!$G$6:$G$251,B8),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8),\"\"))))))","v":{"$error":"#REF!"}},{"$f":"IF('QS-702C HAWA OCP-Trading Goods'!$I$6>\"\",COUNTIFS('QS-702C HAWA OCP-Trading Goods'!$F$6:$F$251,\"x\",'QS-702C HAWA OCP-Trading Goods'!$G$6:$G$251,B8,'QS-702C HAWA OCP-Trading Goods'!$I$6:$I$251,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8,#REF!,\">\"\"\"),IF(#REF!>\"\",COUNTIFS(#REF!,\"x\",#REF!,B8,#REF!,\">\"\"\"),\"\"))))))","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR(IF(C8>0,D8*(100/C8),\"\")),\"\",IF(C8>0,D8*(100/C8),\"\"))","v":""},{"$f":"IF(B8<>\"\",IF(E8<$F$6,B8,\"\"),\"\")","v":""}]
[null,"RA Officer",null,null,"",""]
[null,"BU",null,null,"",""]
[null,"Purchase Officer",null,null,"",""]
[null,"QA Officer",null,null,"",""]
[null,"Cost Accountant",null,null,"",""]
[null,"Budget Planner",null,null,"",""]
[null,"Logistics Planner",null,null,"",""]
[null,"Logistics Planner (Plant)",null,null,"",""]
[null,"C&V Officer",null,null,"",""]
[null,"MDG Specialist",null,null,"",""]
[null,"Sales Branch",null,null,"",""]
[null,"SHE Expert",null,null,"",""]
[null,"-",null,null,"",""]
[null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(E7:E21)/100),\"\",AVERAGE(E7:E21)/100)","v":""}]

{"sheet":"QS-702C HAWA OCP-Trading Goods","index":2,"n_rows":205,"n_cols":9,"rows_kept":205,"cut":false,"hidden":true,"merged":[[2,1,2,7],[179,1,179,8],[194,1,194,8],[204,1,204,7],[4,1,4,8],[79,1,79,8],[114,1,114,8],[137,1,137,8],[169,1,169,8],[191,1,191,8]]}
[]
[]
[null,"MATERIAL CREATION AND MAINTENANCE FORM: Trading Goods (purchased FP) OCP to be handled by BU",null,null,null,null,null,null,"HAWA"]
[null,"View","Technical Field","J-Sox Relevant","Impact on EWM","Mandatory","Data Owner","Field Description","Value"]
[null,"Initial and Basic Data"]
[null,"Initial Screen","MARA.MATNR","x",null,"X","Product Developer","Material Number (Max 18 char and based on suppliers code)"]
[null,"Additional Data - Descriptions Z1","MAKT.MAKTX (Z1)","x",null,"X","Product Developer","Product code, item reference for customer (code on label = Z1)"]
[null,"Additional Data - Descriptions Z2","MAKT.MAKTX (Z2)",null,null,"X","MDG Specialist","Product code as on Casemark by manufacturer (code Z2),                                  if no special Casemark Z2= Z1",{"$f":"I7","v":0}]
[null,"Initial Screen","MARA.MTART","x",null,"X","MDG Specialist","Material Type","HAWA"]
[null,"Initial Screen","MARA.MBRSH",null,null,"X","MDG Specialist","Industry sector","Pharmaceutical"]
[null,"Organizational Levels","MARC.WERKS","x",null,"X","MDG Specialist","Plant","P010 - Terumo Europe NV"]
[null,"Organizational Levels","MARC.WERKS",null,null,null,"MRP Planner","Plants additional 1 (P160, P110) NOT possible if active device"]
[null,"Organizational Levels","MARC.WERKS",null,null,null,"MRP Planner","Plants additional 2 (P160, P110) NOT possible if active device"]
[null,"Organizational Levels","MVKE.VKORG",null,null,"X","MDG Specialist","Sales Organization","ALL (Recommended)"]
[null,"Organizational Levels","MVKE.VTWEG",null,null,"X","MDG Specialist","Distribution Channel","01"]
[null,"Organizational Levels","MARD.LGORT",null,null,"X","MDG Specialist","Storage Location (for Genk= 1088,1089,1099, S098 & S099)","based on Plants"]
[null,"Organizational Levels","MLGN.LGNUM",null,null,null,"MDG Specialist","Warehouse Number / Warehouse Complex"]
[null,"Organizational Levels","MBEW.BWKEY",null,null,"X","MDG Specialist","Valuation Area (based on plants selected)","Based on selected plants"]
[null,"Basic Data 1","MAKT.SPRAS",null,null,"X","MDG Specialist","Language Key","All"]
[null,"Additional Data - Basic Data Text EN","TDID.GRUN (EN)","x",null,"X","Product Developer","Product type (type + brand) (EN) (Guideline of 30 char)"]
[null,"Additional Data - Basic Data Text DE","TDID.GRUN (DE)",null,null,"X","MDG Specialist","Product type (type + brand) (DE) (Guideline of 30 char)"]
[null,"Additional Data - Basic Data Text FR","TDID.GRUN (FR)",null,null,"X","MDG Specialist","Product type (type + brand) (FR) (Guideline of 30 char) "]
[null,"Additional Data - Basic Data Text IT","TDID.GRUN (IT)",null,null,"X","MDG Specialist","Product type (type + brand) (IT) (Guideline of 30 char) "]
[null,"Additional Data - Basic Data Text NL","TDID.GRUN (NL)",null,null,"X","MDG Specialist","Product type (type + brand) (NL) (Guideline of 30 char) "]
[null,"Additional Data - Basic Data Text ES","TDID.GRUN (ES)",null,null,"X","MDG Specialist","Product type (type + brand) (ES) (Guideline of 30 char)"]
[null,"Additional Data - Descriptions EN","MAKT.MAKTX","x",null,"X","Product Developer","Material Description (EN) - specifications (Max 40 char) "]
[null,"Additional Data - Descriptions DE","SKTEXT.MAKTX (DE)",null,null,"X","MDG Specialist","Material Description (DE) - specifications (Max 40 char)"]
[null,"Additional Data - Descriptions FR","SKTEXT.MAKTX (FR)",null,null,"X","MDG Specialist","Material Description (FR) - specifications (Max 40 char)"]
[null,"Additional Data - Descriptions IT","SKTEXT.MAKTX (IT)",null,null,"X","MDG Specialist","Material Description (IT) - specifications (Max 40 char)"]
[null,"Additional Data - Descriptions NL","SKTEXT.MAKTX (NL)",null,null,"X","MDG Specialist","Material Description (NL) - specifications (Max 40 char)"]
[null,"Additional Data - Descriptions ES","SKTEXT.MAKTX (ES)",null,null,"X","MDG Specialist","Material Description (ES) - specifications (Max 40 char)"]
[null,"Basic Data 1","MARA.BISMT",null,null,"X","MDG Specialist","Old Material Number (Max 12 char & pref. equal to Mat number)",{"$f":"I6","v":0}]
[null,"Basic Data 1","MARA.MATKL","x","x","X","RA Officer","Material Group (see sheet \"QS-702M Material group overview\")"]
[null,"Basic Data 1","MARA.MEINS",null,null,"X","Product Developer","Base Unit of Measure","PC"]
[null,"Basic Data 1","MARA.NTGEW",null,"x","X","Product Developer","Net Weight (in gram) for 1 PC"]
[null,"Basic Data 1","MARA.GEWEI",null,null,"X","MDG Specialist","Weight Unit","G"]
[null,"Basic Data 1","MARA.BRGEW",null,"x","X","Product Developer","Gross Weight (in gram) for 1 PC"]
[null,"Basic Data 1","MARA.GEWEI",null,null,"X","MDG Specialist","Weight Unit","G"]
[null,"Basic Data 1","MARA.VOLUM",null,"x","X","MDG Specialist","Volume","To be derived from BOX or CAR"]
[null,"Basic Data 1","MARA.VOLEH",null,null,"X","MDG Specialist","Volume unit","CCM"]
[null,"Basic Data 1","MARM.EAN11",null,"x","X","Product Developer","International Article Number (EAN barcode/UPC) (If Sold Per Piece)"]
[null,"Basic Data 1","MARM.NUMTP",null,null,"X","MDG Specialist","Category of International Article Number (EAN)","ZZ - External EAN numbers"]
[null,"Basic Data 1","MARA.SPART",null,null,"X","MDG Specialist","Division","01"]
[null,"Basic Data 1","MARA.PRDHA","x",null,"X","Budget Planner","Product hierarchy (check with Controlling Team)"]
[null,"Basic Data 1","MARA.MTPOS",null,null,"X","Product Developer","General item category group"]
[null,"Basic Data 1","MARA.XCHPF",null,null,"X","MDG Specialist","Cross Plant Material Status","Y2 - Blocked for use in pr ord"]
[null,"Basic Data 1","MARA.RMATP",null,"x",null,"Logistics Planner","Reference Material for Packaging (EDC Genk to update after arrival in EDC)"]
[null,"Additional Data - 1st AUoM","MARM.MEINH",null,null,"X","Product Developer","Alternative Unit of Measure for Stockkeeping Unit","BOX"]
[null,"Additional Data - 1st AUoM","MARM.UMREZ",null,"x",{"$f":"IF(ISBLANK(I49),\" \",\"x\")","v":" "},"Product Developer","Numerator for Conversion to Base UoM (  # pcs/BOX)"]
[null,"Additional Data - 1st AUoM","MARM.UMREN",null,null,{"$f":"$F$49","v":" "},"MDG Specialist","Denominator for conversion to base units of measure","1"]
[null,"Additional Data - 1st AUoM","MARM.EAN11",null,"x",{"$f":"$F$49","v":" "},"Product Developer","International Article Number (EAN barcode/UPC)"]
[null,"Additional Data - 1st AUoM","MARM.NUMTP",null,null," ","MDG Specialist","Category of International Article Number (EAN)","ZZ - External EAN numbers"]
[null,"Additional Data - 1st AUoM","MARM.LAENG",null,"x"," ","Product Developer","Length (in MM) of BOX"]
[null,"Additional Data - 1st AUoM","MARM.BREIT",null,"x"," ","Product Developer","Width (in MM) of BOX"]
[null,"Additional Data - 1st AUoM","MARM.HOEHE",null,"x"," ","Product Developer","Height (in MM) of BOX"]
[null,"Additional Data - 1st AUoM","MARM.MEABM",null,null," ","MDG Specialist","Unit of Dimension for Length/Width/Height","MM"]
[null,"Additional Data - 1st AUoM","MARM.VOLUM",null,"x"," ","MDG Specialist","Volume","automatic calculated by SAP"]
[null,"Additional Data - 1st AUoM","MARM.VOLEH",null,null," ","MDG Specialist","Volume unit","CCM"]
[null,"Additional Data - 1st AUoM","MARM.BRGEW",null,"x"," ","Product Developer","Gross Weight (in gram) for 1 BOX"]
[null,"Additional Data - 1st AUoM","MARM.GEWEI",null,null," ","MDG Specialist","Weight Unit","G"]
[null,"Additional Data - 1st AUoM",null,null,null," ","Product Developer","Total Weight (in gram) of packaging (On Box level)"]
[null,"Additional Data - 1st AUoM",null,null,null," ","Product Developer","Amount (in gram) of carton in packaging (On Box level)"]
[null,"Additional Data - 1st AUoM",null,null,null," ","Product Developer","Amount (in gram) of plastic in packaging (On Box level)"]
[null,"Additional Data - 2nd AUoM","MARM.MEINH",null,null,"X","Product Developer","Alternative Unit of Measure for Stockkeeping Unit","CARTON"]
[null,"Additional Data - 2nd AUoM","MARM.UMREZ",null,"x","X","Product Developer","Numerator for Conversion to Base UoM ( # pcs/CARTON)"]
[null,"Additional Data - 2nd AUoM","MARM.UMREN",null,null,"X","MDG Specialist","Denominator for conversion to base units of measure","1"]
[null,"Additional Data - 2nd AUoM","MARM.EAN11",null,"x","X","Product Developer","International Article Number (EAN barcode /UPC)"]
[null,"Additional Data - 2nd AUoM","MARM.NUMTP",null,null,"X","MDG Specialist","Category of International Article Number (EAN)","ZZ - External EAN numbers"]
[null,"Additional Data - 2nd AUoM","MARM.LAENG",null,"x","X","Product Developer","Length (in MM) of CARTON"]
[null,"Additional Data - 2nd AUoM","MARM.BREIT",null,"x","X","Product Developer","Width (in MM) of CARTON"]
[null,"Additional Data - 2nd AUoM","MARM.HOEHE",null,"x","X","Product Developer","Height (in MM) of CARTON"]
[null,"Additional Data - 2nd AUoM","MARM.MEABM",null,null,"X","MDG Specialist","Unit of Dimension for Length/Width/Height","MM"]
[null,"Additional Data - 2nd AUoM","MARM.VOLUM",null,"x","X","MDG Specialist","Volume","automatic calculated by SAP"]
[null,"Additional Data - 2nd AUoM","MARM.VOLEH",null,null,"X","MDG Specialist","Volume unit","CCM"]
[null,"Additional Data - 2nd AUoM","MARM.BRGEW",null,"x","X","Product Developer","Gross Weight (in gram) for 1 CARTON"]
[null,"Additional Data - 2nd AUoM","MARM.GEWEI",null,null,"X","MDG Specialist","Weight Unit","G"]
[null,"Additional Data - 2nd AUoM",null,null,null,"X","Product Developer","Total Weight (in gram) of packaging (On Carton level)"]
[null,"Additional Data - 2nd AUoM",null,null,null,"X","Product Developer","Amount (in gram) of carton in packaging (On Carton level)"]
[null,"Additional Data - 2nd AUoM",null,null,null,"X","Product Developer","Amount (in gram) of plastic in packaging (On Carton level)"]
[null,"Characteristics"]
[null,"Classification - Material","Z_001_HAWA.Z_CE",null,null,"X","RA Officer","CE mark"]
[null,"Classification - Material","Z_001_HAWA.Z_GS1_EAN",null,null,"X","MDG Specialist","GS1-EAN Code (= EAN code with 0) only last 13 char to enter"]
[null,"Classification - Material","Z_001_HAWA.Z_LEGAL_MANUF",null,null,"X","RA Officer","Legal Manufacturer"]
[null,"Classification - Material","Z_001_HAWA.Z_REACH_FLAG",null,null,"X","RA Officer","REACH-flag 'SVHC present >0,1% (w/w)'"]
[null,"Classification - Material","Z_001_HAWA.Z_REACH_SUBSTANCE",null,null,{"$f":"IF(I84=\"Y1\",\"X\",\" \")","v":" "},"RA Officer","REACH-SVHC Substance"]
[null,"Classification - Material","Z_001_HAWA.Z_SPARE",null,null,"X","RA Officer","Spare part"]
[null,"Classification - Material","Z_001_HAWA.Z_STER",null,null,"X","RA Officer","Sterile"]
[null,"Classification - Material","Z_001_HAWA.Z_AXEL-G_ITEMCLASS-VALUE",null,null,"X","MDG Specialist","Item Value Class (Axel G-> based on input from TC)"]
[null,"Classification - Material","Z_001_HAWA.Z_PRODUCT_DEVELOPER",null,null,"X","MDG Specialist","Product Developper (who requested material)"]
[null,"Classification - Material","Z_001_HAWA.Z_MRP_CONTROLLER",null,null,"X","MDG Specialist","MRP Controller (who is the Inventory planning contact person)"]
[null,"Classification - Material","Z_001_HAWA.Z_LPP_FR",null,null,null,"Sales Branch","LPP code (+ text) for France (for reimbursable products in France)"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_1",null,null,"X","RA Officer","DG Equipment battery 1 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_1_QTY",null,null,{"$f":"IF(I92=\"No Batteries\",\" \",\"X\")","v":"X"},"RA Officer","DG Equipment battery 1 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_1_WEIGHT",null,null,{"$f":"IF(I92=\"No Batteries\",\" \",\"X\")","v":"X"},"RA Officer","DG Equipment battery 1 - weight"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_2",null,null,null,"RA Officer","DG Equipment battery 2 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_2_QTY",null,null,null,"RA Officer","DG Equipment battery 2 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_2_WEIGHT",null,null,null,"RA Officer","DG Equipment battery 2 - weight "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_3",null,null,null,"RA Officer","DG Equipment battery 3 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_3_QTY",null,null,null,"RA Officer","DG Equipment battery 3 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_3_WEIGHT",null,null,null,"RA Officer","DG Equipment battery 3 - weight "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_4",null,null,null,"RA Officer","DG Equipment battery 4 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_4_QTY",null,null,null,"RA Officer","DG Equipment battery 4 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_4_WEIGHT",null,null,null,"RA Officer","DG Equipment battery 4 - weight "]
[null,"Classification - Material","Z_001_HAWA.Z_LEGACY_TETRA_MMITCL",null,null,"X","C&V Officer","Legacy Interface TETRA - Product Group"]
[null,"Classification - Material","Z_001_HAWA.Z_FDA",null,null,"X","RA Officer","FDA related material"]
[null,"Classification - Material","Z_001_HAWA.Z_DUAL_USE",null,null,"X","RA Officer","Dual Use (Reg. No. 428/2009)"]
[null,"Classification - Material","Z_001_HAWA.Z_DUAL_USE_CODE",null,null,{"$f":"IF(I106=\"YES\",\"X\",\" \")","v":" "},"RA Officer","Dual Use Code"]
[null,"Classification - Material","Z_001_HAWA.Z_CHEM_SUBST",null,null,"X","RA Officer","Hazardous Chemical (Reg. No. 649/2012)"]
[null,"Classification - Material","Z_001_HAWA.Z_CHEM_SUBST_CODE",null,null,{"$f":"IF(I108=\"YES\",\"X\",\" \")","v":" "},"RA Officer","Hazardous Chemical CAS number"]
[null,"Classification - Material","Z_001_HAWA.Z_PERC_US_COMP",null,null,"X","Product Developer","How many % of US components contains the material?"]
[null,"Classification - Material","Z_001_HAWA.Z_EQUIPMENT",null,null,"X","RA Officer","Equipment material (Is the material an equipment?)"]
[null,"Classification - Material","Z_001_HAWA.Z_BCP_RELEVANT",null,null,"X","MRP Planner","BCP Relevant"]
[null,"Classification - Batch (if batch managed)","Z_023_FERT.BATCH_NR_DER",null,null,"X","RA Officer","Batch class (with or without Expiry Date: HAWA/HAWA2 or HAWA3)"]
[null,"Classification - Batch (if batch managed)","Z_023_HAWA*.ZCMN",null,null,"X","MDG Specialist","CMN WBS Mandatory","NO"]
[null,"Sales Data"]
[null,"Sales: Sales Org1","MVKE.DWERK",null,null,"X","MRP Planner","Delivering Plant","P010 - Terumo Europe NV"]
[null,"Sales: Sales Org1","MARA.MSTAV",null,null,"X","MDG Specialist","X-distr. Chain status ","11 - Under Development"]
[null,"Sales: Sales Org1","MVKE.AUMNG",null,null,null,"MRP Planner","Minimum Order Quantity"]
[null,"Sales: Sales Org1","MVKE.RDPRF",null,null,"X","MRP Planner","Rounding Profile (not needed if AuOM = Meter): box or Carton level"]
[null,"Sales: Sales Org1","MLAN.ALAND",null,null,"X","MDG Specialist","Departure country (country from which the goods are sent)","automatic based on sales org."]
[null,"Sales: Sales Org1","MLAN.TATYP",null,null,"X","MDG Specialist","Tax category (sales tax, federal sales tax,...)","MWST"]
[null,"Sales: Sales Org1","MLAN.TAXKM",null,null,"X","MDG Specialist","Tax classification material(see sheet\"QS-702N Overview Tax rates\")","value is based on sales org and type of material: implantable device, reimbursable material or not?"]
[null,"Sales: Sales Org2","MVKE.VERSG",null,null,"X","MDG Specialist","Material statistics group","1"]
[null,"Sales: Sales Org2","MVKE.MTPOS",null,null,"X","Product Developer","Item category group on Sales Org                                                                                        (if YNOR ->YMTO for S100)"]
[null,"Sales: Sales Org2","MVKE.PRODH",null,null,"X","MDG Specialist","Product hierarchy  (idem MARA level)",{"$f":"I44","v":0}]
[null,"Sales: Sales Org2","MVKE.KTGRM",null,null,"X","MDG Specialist","Account assignment group","01"]
[null,"Sales: Sales Org2","MVKE.MVGR2",null,null,"X","RA Officer","Material Group 2 (Bebat Melarec)"]
[null,"Sales: Sales Org2","MVKE.MVGR4",null,null,null,"Logistics Planner","Material Group 4  (Preferential Treatment) "]
[null,"Sales: General/Plant","MARA.TRAGR",null,"x","X","Logistics Planner","Transportation Group"]
[null,"Sales: General/Plant","MARA.XCHPF",null,"x","X","RA Officer","Batch Management Requirement Indicator"]
[null,"Sales: General/Plant","MARC.LADGR",null,null,"X","MDG Specialist","Loading Group (including first servicing required or not)","0001-TRMO loading group"]
[null,"Sales: General/Plant","MARC.MTVFP",null,null,"X","MDG Specialist","Checking Group for Availability Check","02"]
[null,"Sales: General/Plant","MARC.SERNP",null,"x","X","RA Officer","Serial Number Profile"]
[null,"Sales: General/Plant","MARC.PRCTR","x",null,"X","MDG Specialist","Profit Center"]
[null,"Foreign Trade Export","MARC.STAWN",null,null,"X","Logistics Planner","Commodity Code/Import Code Number for Foreign Trade"]
[null,"Foreign Trade Export","MARC.HERKL",null,null,"X","Product Developer","Country of origin of the material"]
[null,"Foreign Trade Export","MARC.ITARK",null,null,"X","RA Officer","Military Goods"]
[null,"Purchasing & Production data"]
[null,"Purchasing","MARA.EKWSL",null,null,"X","MDG Specialist","Purchasing Value Key","1"]
[null,"Purchasing","MARC.EKGRP",null,null,"X","MRP Planner","Purchasing Group"]
[null,"Purchasing","MARC.WEBAZ",null,null,"X","MDG Specialist","Goods Receipt Processing Time in Days","0"]
[null,"Purchasing","MARC.KAUTB",null,null,"X","MDG Specialist","Indicator: \"automatic purchase order allowed\"","þ"]
[null,"Purchasing","MARC.KORDB",null,null,"X","MDG Specialist","Indicator: Source list requirement","source list required"]
[null,"Purchasing","MARC.MMSTA",null,null,"X","MDG Specialist","Plant-Specific Material Status","= Cross Plant Material Status"]
[null,"MRP 1","MARC.DISMM",null,null,"X","MRP Planner","MRP Type (Standard Item, Non-Standard Item, manual reorder point)"]
[null,"MRP 1","MARC.DISPO",null,"x","X","MRP Planner","MRP Controller (used for QA release, for OCP default value= 040)","P010 - 040 - EDC materials"]
[null,"MRP 1","MARC.DISGR",null,null,"X","MRP Planner","MRP Group (Important for MRP Run, HAWA=Z001)","Z001 - Rep manufacturing"]
[null,"MRP 1","MARC.MINBE",null,null,{"$f":"IF(I145=\"VB - Manual reorder point planning\",\"X\",\" \")","v":" "},"MRP Planner","Reorder Point"]
[null,"MRP 1","MARC.DISLS",null,null,"X","MRP Planner","LotSize (PO placement frequency)"]
[null,"MRP 1","MARC.BSTRF",null,null,"X","MRP Planner","Rounding Value ( Order multiple for the PO)"]
[null,"MRP 1","MARC.MABST",null,null,null,"MRP Planner","Max_Stock_Level"]
[null,"MRP 1","MARC.BSTMI",null,null,"X","MRP Planner","Minimun LotSize (minimum order qty to vendor)"]
[null,"MRP 1","MARC.BSTMA",null,null,null,"MRP Planner","Maximun LotSize"]
[null,"MRP 1","MARC.FXHOR",null,null,"X","MRP Planner","Planning time fence"]
[null,"MRP 1","MARC.BSTFE",null,null,{"$f":"IF(I149=\"FX - Fixed Lotsize\",\"X\",\" \")","v":" "},"MRP Planner","Fixed LotSize (only applicable if Lotsize = FX)"]
[null,"MRP 2","MARC.PLIFZ",null,null,"X","MRP Planner","Planned Delivery Time in Days"]
[null,"MRP 2","MARC.BESKZ",null,null,"X","MRP Planner","Procurement Type","F - External Procurement"]
[null,"MRP 2","MARC.SOBSL",null,null,"X","MRP Planner","Special procurement type (Stock Transfer Haasrode -> UK)"]
[null,"MRP 2","MARC.LGFSB",null,null,"X","MRP Planner","Default storage location for external procurement","1088 - EDC GENK ROD"]
[null,"MRP 2","MARC.EISBE",null,null,null,"MRP Planner","Safety Stock"]
[null,"MRP 2","MARC.KZECH",null,null,"X","MRP Planner","Determination of batch entry in the production/process order"]
[null,"MRP 2","MARC.FHORI",null,null,"X","MRP Planner","SchedMarginKey","000"]
[null,"MRP 3","MARC.VRMOD",null,null,"X","MRP Planner","Consumption mode","1 - Backward Consumption Only"]
[null,"MRP 3","MARC.VINT1",null,null,"X","MRP Planner","Consumption period: backward","30"]
[null,"MRP 3","MARC.VINT2",null,null,"X","MRP Planner","Consumption period: forward","0"]
[null,"MRP 3","MARC.PERKZ",null,null,"X","MRP Planner","Period Indicator","M"]
[null,"MRP 3","MARC.STRGR",null,null,"X","MRP Planner","Planning strategy group","Z7 - Planning with assembly and final assembl"]
[null,"MRP 3","MARC.MISKZ",null,null,"X","MRP Planner","MIXED MRP Indicator","1 - Subassembly planning with final assembly"]
[null,"MRP 4","MARC.SBDKZ",null,null,"X","MRP Planner","Individual/Collective indicator","2"]
[null,"Plant & Quality Data"]
[null,"Plant Data / Storage 1","MARA.MHDRZ",null,"x","X","MDG Specialist","Minimum Remaining  Shelf Life in DAYS","1"]
[null,"Plant Data / Storage 1","MARA.MHDHB",null,"x","X","RA Officer","Total Shelf Life in DAYS"]
[null,"Plant Data / Storage 1","MARA.WHSTC",null,null,"x","Product Developer","Warehouse Storage Conditions (Temp)"]
[null,"General Plant Data / Storage 1","MARA.RAUBE",null,null,null,"SHE Expert","Hazardous material number"]
[null,"Quality Management","MARA.QMPUR",null,null,"X","MDG Specialist","QM in Procurement is Active (normally not needed for HAWA OCP)","NO"]
[null,"Quality Management","MARC.SSQSS",null,null,{"$f":"IF(I175=\"YES\",\"X\",\" \")","v":" "},"MDG Specialist","Control Key for Quality Management in Procurement (link with QM Proc)"]
[null,"Quality Management","MARC.KZDKZ",null,null,"X","RA Officer","Doc Required","þ"]
[null,"Quality Management","MARC.QMATA",null,null,"X","RA Officer","Material Authorization Group for Activities in QM","TRMO01"]
[null,"Quality Management","MARC.QMATV",null,null,"X","MDG Specialist","Inspection setup type (see tab QS-702AE Inspection type setup)","Z05HU/Z06/Z08U/Z17/Z89"]
[null,"Accounting & Costing"]
[null,"Accounting 1","MBEW.VPRSV",null,null,"X","MDG Specialist","Price control indicator","S"]
[null,"Accounting 1","MBEW.STPRS","x",null,"X","Product Developer","Standard price/piece"]
[null,"Accounting 1",null,"x",null,"X","Product Developer","Currency"]
[null,"Accounting 1","MBEW.PEINH","x",null,"X","MDG Specialist","Price Unit","10000"]
[null,"Accounting 1","MBEW.BKLAS","x",null,"X","MDG Specialist","Valuation Class","3100 - Trading goods"]
[null,"Costing 1","MARC.LOSGR","x",null,"X","MDG Specialist","Lot Size for Product Costing","10000"]
[null,"Costing 1","MBEW.HRKFT","x",null,"X","MDG Specialist","Origin Group as Subdivision of Cost Element"]
[null,"Costing 1","MARC.SOBSK","x",null,"X","MRP Planner","Special Procurement Type for Costing "]
[null,"Costing 1","MBEW.EKALR",null,null,"X","MDG Specialist","Material Is Costed with Quantity Structure","þ"]
[null,"Costing 1","MBEW.HKMAT",null,null,"X","MDG Specialist","Material-related origin","þ"]
[null,"Costing 2","MBEW.ZPLP2",null,null,"X","BU","Deemed Cost (Planned Price 2) (Price per 10.000pcs in Euro).                Only applicable for BU TIS and TCV"]
[null,"Warehousing Data"]
[null,"WM Execution","MARA.SERIAL",null,"x","X","RA Officer","Serial Number Profile (WM)"]
[null,"WM Execution","MARA.QGRP",null,null,"X","MDG Specialist","Quality Inspection Group","0001 - Group for Ad-hoc inspection"]
[null,"Sign off & Data entry"]
[null,"-","-","x",null,"X","Product Developer","Requested By"]
[null,"-","-","x",null,"X","Product Developer","Requested Date"]
[null,"-",null,null,null,"X","Product Developer","Is the material an implantable device that remains in the body?           See also QS-702N Overview Tax rates"]
[null,"-",null,null,null,"X","Product Developer","Is the material subject to a reduced VAT rate in a country?                              See also QS-702N Overview Tax rates or to be checked with branches."]
[null,null,null,null,null,"X","Product Developer","Is this material to be used for Demo, Loaner, Rental flow?"]
[null,"-",null,null,null,null,"Sales Branch","In which country/countries there is a reduced VAT rate?                           If not known branches to be contacted."]
[null,"-","-",null,null,"X","MRP Planner","Vendor Number"]
[null,"-","-",null,null,null,"Product Developer","CAS Nr."]
[null,"-","-",null,null,null,"MDG Specialist","Material created in SAP | Date: ___/___/___"]
[null,null,null,null,null,null,null,null,"Name and Signature "]