ibp master data v1
DESCRIPTION
IBP Master Data V1TRANSCRIPT
Master Data DescriptionProduct Master Data Material MasterCustomer Master Data Customer MasterCustomer Product Master Data Customer Product
Customer Source Master Data Customer SourceLocation Master Data Location
Location Product Master Data Location Product
Location Source Master Data Location Source
Resource Location Master Data Resource Location
Porduction Source Master Data Production Source Master
Production Source Item Data Production Souce Item
Production Resource Master Data Production Resource MasterUOM Conversion Master DataDSI RM Master Data
ECC TerminologyMaterial MasterCustomer MasterCustomer Material
Plant
Plant Material
WorkCenter Plant
Source-Production Version
Source-Production Version
Production Version/Workcenter
RemarkMaterial MasterTo be taken from ECC (its only end customer)To be Provided in excel
Location master means either Production Plant or DC or Trading Plant
This table should have unique combination Product and Alternate UOMThis table should have unique combination Plant and Classification of (Class + Type)
Customer - Plant link should be used to maintain cusomter - Product to Plant -Product link
This table should have unique combination of Locations and Products mainly to be transferred from ECC for existing fields
This table should have unique combination of Product,Location and Source Location to be loaded as excel upload
This table should have unique combination resources- Plants (workcenters from ECC)
This table should have unique combination of Product,Location and PV to be loaded as excel upload
This table should have unique combination of Component to Production relation , Basically BOM data
This table should have unique combination of Resource and Production Source ID ( Basically from Routing Master data)
Source ECC Fields Excel Fields StatusECC/Excel 16 46 DoneECC/Excel 13 2 Open QuestionsExcel 3 NA
ECC/Excel 3 6 Done
ECC/Excel 32 9 Open Questions
Excel 4 Open Questions
ECC/Excel 7 12 Done
ECC 5 Done
ECC 4 Done
ECC 3 DoneExcel 3Excel 4
83 89
Requirement Collected From
KSA/DUBAIKSAKSA
KSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSA
KSAKSAKSAKSAKSADUBAI TRADINGDUBAI TRADINGDUBAI TRADINGDUBAI TRADINGDUBAI TRADINGDUBAI PLANTDUBAI PLANTDUBAI PLANT
KSAKSAKSAKSAKSAKSAKSAKSA
KSA
DUBAI Production Plant DUBAI Production Plant DUBAI Production Plant
Attributes
Product Material DescMaterial Type
Material Group
DPGMaterial Group descColorAmp Rating # of Waysstandard, switch/socket/others,Product HierarchyVoltage, wattage,Small box,Pallet,ABC , Material status,packing type, Packing length,Trading type, Material CostSPGSub materail groupNo of GangsNo of CoresNo of PolesSizeInsulation typeBreaker TypeBreaker NameTemperatureDivisionBusiness unit Non SASOOLD Class New material code
New launch materialNo of PhasesManufacturing strategy Storage Capcity Consumpion Base UOMMouting Plate type Color type Standard or Non StandardNew material code No of Units a palletOld material NumFG hierarchy to be given(Pending from Dubai Plant)COGS (Product cost of Goods manufactured)
Component / RM Material groupComponent /SFG ProcessStorage type BUOMAlert crtical ComponentComponent ABC indicator Component supply type Base Metal for FG
SFG Process
Commodity (RM)Commodity typeAll Attributes related to commoditiy hierarchy to be given
Component Related attributes by KSA Production Plants
SFG Related attribures by KSA Prodcution Plants
Component Related attributes by Dubai Production Plant
Source Technical Name
ECC MARA-MATNRECC MAKT-MAKTXECC MARA-MTART
ECC MARA-MATKLExcelECC T023T-WGBEZExcelExcelExcelExcelExcelECC MARA-PRODHExcelExcelExcelExcelExcelExcelExcelExcelExcelECC of a Production plant MBEW-STPRSExcelExcelExcelExcelExcelExcelExcelExcelExcelExcelECC MARA-SPARTExcelExcelExcelExcel
ExcelExcelExcelExcelECC MARA-MEINSExcelExcelExcelExcelExcelECC MARA-BISMT
ECC MBEW-STPRS
ECC MARA-MATKLECC MARA-EXTWGExelECCExelExelExelExel
ECC
EXCELEXCELEXCEL
Fert , MCFE,ZRM2,HALB
SPRAS (language) = "EN"
*For some material its moving price and some material its standard price wrt to price control indicatorFor Switchgear from external material group
material group for all other,External material group desc for Switchgear(MARA -EXTWG NE " " ,MARD-WERKS = "AE05" ).*As discussed not to take External material group..19 jan 16..jabir
E.g. OR,(orrange)
Old material Num
Product cost mm03 account1 view(SAME LOGIC AS ABOVE)
Map from Material group field in ecconly for cables ( plant AE06)E.g. Covered , Unconvered,Silo , Base unit of measure
Import / Local/Domestic /intraplant alfanarCopper/ Alluminium (if MCFE code starts with A or W = Allumium , if C , T , R= Copper )
External material group - only for cable
e.g. Checmical , Hardware, metal.E.g. Steel, Copper
CUSTOMER Master Data To be taken from ECC (its only end customer)
Requirement Collected From KSA/DUBAIKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSA
CUSTOMER PRODUCT Master Data To be Provided in excel
Requirement VALID FORKSA/DUBAIKSA/DUBAIKSA/DUBAI
CUSTOMER SOURCE Master Data Customer - Plant link should be used to maintain cusomter - Product to Plant -Product link
Requirement VALID FORKSA/DUBAIKSA/DUBAIKSA/DUBAI
LOCATION Master Data Location master means either Production Plant or DC or Trading Plant
Requirement Collected From KSAKSAKSAKSAKSA, Dubai Trading KSA Cable Plant KSA Cable Plant KSA Cable Plant KSA Cable Plant
Dubai Production Plant Dubai Production Plant
LOCATION - PRODUCT Master data Requirement Collected From KSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSAKSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants
KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants KSA Production Plants Dubai Production Plant KSA Production Plants KSA Production Plants KSA Production Plants
LOCATION - SOURCE Master data This table should have unique combination of Product,Location and Source Location to be loaded as excel upload
Requirement Collected From Valid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAI
RESOURCE LOCATION Master data This table should have unique combination resources- Plants (workcenters from ECC)
Requirement Collected From Valid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAI
Valid for KSA,DUBAIValid for KSA,DUBAI
Valid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIFrom DubaiFrom DUBAI (For Labour )From DUBAI (For Labour )From DUBAI (For Labour )Valid for KSA
PRODUCTION - SOURCE Master data This table should have unique combination of Product,Location and PV to be loaded as excel upload
Requirement Collected From Valid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAI
Valid for KSA,DUBAI
PRODUCTION - SOURCE ITEM master dataRequirement Collected From
This table should have unique combination of Component to Production relation , Basically BOM data
Valid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAI
PRODUCTION - RESOURCE master dataRequirement Collected From Valid for KSA,DUBAIValid for KSA,DUBAIValid for KSA,DUBAI
UOM Conversion Master dataThis table should have unique combination Product and Alternate UOM
Requirement Collected From KSA cable Plant KSA cable Plant KSA cable Plant
DSI RM Master data
This table should have unique combination of Resource and Production Source ID ( Basically from Routing Master data)
This table should have unique combination Plant and Classification of (Class + Type)
Requirement Collected From
KSA Production PlantsKSA Production PlantsKSA Production PlantsKSA Production Plants
CUSTOMER Master Data To be taken from ECC (its only end customer)
Attributes DescriptionCustomer IDCustomer NameDistribution ChannelCustomer HierrachyCustomer ClassCustomer Sales AreaSales Rep-File NoSales Rep- by NameCustomer PlantCustomer Country Customer Country NameSales DivisionTeritorySales office (Branch)Customer Prioriry (Penality Used fore reschduling Orders)
CUSTOMER PRODUCT Master Data To be Provided in excel
AttributesCustomer IDProduct IDPrice
CUSTOMER SOURCE Master Data Customer - Plant link should be used to maintain cusomter - Product to Plant -Product link
AttributesCustomer IDProduct IDSource Location IDSourcing Ratio
LOCATION Master Data Location master means either Production Plant or DC or Trading Plant
DescriptionLocation ID,Location DescPlant TypeMRP ControllerStorage Capacity (in Pallets)Open Storage Capacity in M3Closed Storage Capacity in M3Silo Capacity in KGStockyard OpenStorage
FG Storage Capacity (in Pallets)RM Storage Capacity ( In Pallets)
LOCATION - PRODUCT Master data Attributes Location IDProduct IDABC indicator PDT(planned Delivery time)MRP ControllerInventory Strategy Rounding Procurement typeSpeical Procurement Key (Source type)Production Supervisor/Scheduler Production Storage LocationStorage Location ABC indicator (Component)Purchase GroupSpecialProcurement Key Profit centerMRP Controller Procurement typePlanned Delivry timeSafety stock (Inventory Strategy days)Safety stock (Fixed qty)Lot size
This table should have unique combination of Locations and Products mainly to be transferred from ECC for existing fields
Minimum lot size (finished good)MRP type Re-order Point MRP Strategy groupBase Qty for storage consumotionConsumption in Cubic Meters Crtical RM check indicatory Planning Plant Rounding Discontinuity indicatorFollowup materialEffective out dateVendor attribute for DSI-MCBVendor wise DSI Vendor Supplying capacity Pallet Qty (This to be given for FG by material wise)Consumption history weigthage for RM inventory strategy Requirement weigthage for RM inventory strategy Shipment type
LOCATION - SOURCE Master data This table should have unique combination of Product,Location and Source Location to be loaded as excel upload
Attributes Product Location Source Location Sourcing Ratio
RESOURCE LOCATION Master data This table should have unique combination resources- Plants (workcenters from ECC)
Attributes Resource IDLocation Resource Desc
Costcenter
Capacity in HRs from ECC (reference)
Crtical ResourceCapaccity cateogyNo of Working days ResourceNo. of Working Hours in a Shift (Per Resource)No. Working Shifts in a Day (Per Resource)Resource Working Efficiency Planned maintainence time Breaktime No of individual capacities Average Loss of Setup time in Hrs Per Month No of LaboursShift hour Capacity calculated (No of Labours * Shift hour )Resource underutilization threshold for alert
PRODUCTION - SOURCE Master data This table should have unique combination of Product,Location and PV to be loaded as excel upload
Attributes Location Product Source IDOutput Product Coefficient
Production Ratio
PRODUCTION - SOURCE ITEM master dataAttributes
This table should have unique combination of Component to Production relation , Basically BOM data
Source IDComponent ID Component CoefficientSource Item ID
PRODUCTION - RESOURCE master dataAttributes Source IDResource IDCapacity Consumption Rate
UOM Conversion Master dataThis table should have unique combination Product and Alternate UOM
Attributes Product IDAlternative UOM UOM Conversion Factor
DSI RM Master data
This table should have unique combination of Resource and Production Source ID ( Basically from Routing Master data)
This table should have unique combination Plant and Classification of (Class + Type)
Attributes
Plant ABC classification Form of Procurement DSI Days
CUSTOMER Master Data To be taken from ECC (its only end customer)
SourceECCECCECCECCECCECCECCECCECCECCECCECCExcelECCExcel
CUSTOMER PRODUCT Master Data To be Provided in excel
Source EXCELEXCELEXCEL
CUSTOMER SOURCE Master Data Customer - Plant link should be used to maintain cusomter - Product to Plant -Product link
Source
By Default 1 (meaning 100%)
LOCATION Master Data Location master means either Production Plant or DC or Trading Plant
SourceECCECCExcelECCExcelExcelExcelExcelExcel
1200 pallets600 Pallets
LOCATION - PRODUCT Master data Source
ECCECCECCECCECCExcelECCECCECCECCECCECCECCECCECCECCECCECCECCExcelECCECC
This table should have unique combination of Locations and Products mainly to be transferred from ECC for existing fields
ECCECCECCECCEXCELEXCELEXCELECCECCECCECCECCECCECCECCEXCELEXCELEXCELEXCEL
LOCATION - SOURCE Master data This table should have unique combination of Product,Location and Source Location to be loaded as excel upload
SOURCEEXCELEXCELEXCELEXCEL
RESOURCE LOCATION Master data This table should have unique combination resources- Plants (workcenters from ECC)
SOURCEECCECCECC
ECCECC
ECCECCEXCELEXCELEXCELEXCELEXCELEXCELEXCELEXCELEXCELEXCELEXCELEXCEL
PRODUCTION - SOURCE Master data This table should have unique combination of Product,Location and PV to be loaded as excel upload
SOURCEECCECCECCECC
ECC
PRODUCTION - SOURCE ITEM master dataSOURCE
This table should have unique combination of Component to Production relation , Basically BOM data
ECCECCECCECC
PRODUCTION - RESOURCE master dataSOURCEECCECCECC
UOM Conversion Master dataThis table should have unique combination Product and Alternate UOM
SOURCENeed to check with Suresh Need to check with Suresh Need to check with Suresh
DSI RM Master data
This table should have unique combination of Resource and Production Source ID ( Basically from Routing Master data)
This table should have unique combination Plant and Classification of (Class + Type)
SOURCE
EXCELEXCELEXCELEXCEL
CUSTOMER Master Data To be taken from ECC (its only end customer)
Technical NameKNA1-KUNNRKNA1-NAME1KNVV-VTWEG
KNA1-KUKLAKNVV-VKORG/VTWEG/SPARTKNVP-Parvw-"VE"NumberKNVP-Parvw-"VE"NameKNVV-VWERKKNA1-LAND1T005T-LANDXKNVV-SPART
KNVV-VKBUR
CUSTOMER PRODUCT Master Data To be Provided in excel
CUSTOMER SOURCE Master Data Customer - Plant link should be used to maintain cusomter - Product to Plant -Product link
Technical NameT001W-WERKST001W-NAME1
T024D-DISPO
LOCATION - PRODUCT Master data
MARC-WERKSMARC-MATNRMARC-MAABCMARC-PLIFGMARC-DISPO
MARC-BSTRFMARC-BESKZMARC-SOBSLMARC-FEVORMARC-LGPROTBDMARC-MAABC-DUPLICATEDMARC-EKGRPDUPLICATEDMARC-PRCTRDUPLICATEDDUPLICATEDDUPLICATED
MARC-EISBEMARC-DISLS
This table should have unique combination of Locations and Products mainly to be transferred from ECC for existing fields
MARC-BSTMIMARC-DISMMMARC-MINBEMARC-STRGR
TBDDUPLICATEDMARC-KZAUSMARC-NFMATMARC-AUSDTTBDTBDTBD
LOCATION - SOURCE Master data This table should have unique combination of Product,Location and Source Location to be loaded as excel upload
RESOURCE LOCATION Master data This table should have unique combination resources- Plants (workcenters from ECC)
CRHD-ARBPLCRHD-WERKSCRTX-KTEXT
Value to get based on calculation CRCO-KOSTL
CRHD-RASCHKAKO-KAPART
PRODUCTION - SOURCE Master data This table should have unique combination of Product,Location and PV to be loaded as excel upload
MKAL-WERKSMKAL-MATNRMKAL-VERIDSTKO-BMENG
PRODUCTION - SOURCE ITEM master data
COMBINATION OF PLANT,MAT,VERSION ,COPY FIRST PRODUCTION VERSION IN THIS FIELD
This table should have unique combination of Component to Production relation , Basically BOM data
STB-IDNRKSTB-MNGLGSTB-POSN
PRODUCTION - RESOURCE master data
MKAL-VERID
OPR_TAB-BMSCH/Time in operation(Hrs)
UOM Conversion Master dataThis table should have unique combination Product and Alternate UOM
EXCELEXCELEXCEL
DSI RM Master data
This table should have unique combination of Resource and Production Source ID ( Basically from Routing Master data)
OPR_TAB-VORNR->OPR_TAB-ARBID->CRHD-ARBPL
Time in operation = CRHD-ARBPL->CRHD-VERWE(0001,0003)0001-OPR_TAB-VGW02 ,VGE02(Convert In Hrs)0002-OPR_TAB-VGW03 ,VGE03(Convert In Hrs)
CUSTOMER Master Data To be taken from ECC (its only end customer)
Filter
*Need to map sales orgHigh Level Node = KNVH-HKUNNRCustomer classfication
**New Attribure addedE.g under Project sales , BII, Utility, OGP, OEM
*Need to map sales org
CUSTOMER PRODUCT Master Data To be Provided in excel
E.g. C1P120
CUSTOMER SOURCE Master Data Customer - Plant link should be used to maintain cusomter - Product to Plant -Product link
LOCATION - PRODUCT Master data
Filter it by Plant Specific material status "blank"
Filter by material staus.
Rounding for all (mainly for MTS)
Production Supervisor
Storage Location ABC indicator ---DUPLICATEDPurchase GroupSpecialProcurement Key Accounting 2 view from Material master
Procurement typePlanned Delivry time
Safety StockLot size
Not consumption cannot be given for SFGs , hence they will be reduced
This table should have unique combination of Locations and Products mainly to be transferred from ECC for existing fields
Minimum lot sizeMRP type Re-order Point MRP Strategy group
XPlanning Plant Planning Plant Distconitunity indicator in MRP4 ( mainlly for RM for except cables)Followuo materialEffective out date
E.g. I for Interplant, L for Local , F for Foreign
LOCATION - SOURCE Master data This table should have unique combination of Product,Location and Source Location to be loaded as excel upload
E.g.P1AD12AD111
RESOURCE LOCATION Master data This table should have unique combination resources- Plants (workcenters from ECC)
This capacity cannot be changed in S&OP
Field finalized (AS PER DISCUSSED WITH RAVI ,(SET UP TYPE KYE IN DEFAULT)CRHD->CRCA->KAKOused in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP"used in calculation of "Available Capacity S&OP" for Labour resource used in calculation of "Available Capacity S&OP" for Labour resource used in calculation of "Available Capacity S&OP" for Labour resource
PRODUCTION - SOURCE Master data This table should have unique combination of Product,Location and PV to be loaded as excel upload
Source Field
Production Version Consider only Active version(MKSP = " ")Base quantity of BOM
1 for First PV
PRODUCTION - SOURCE ITEM master dataRID
Basically BOM data
Item in Bill of Material BOM qty for each component Item number in the BOM
PRODUCTION - RESOURCE master dataSource Field I/P->MKAL-MATNR,WERKS,STATUS(un locked),O/P->GROUP,GROUPCOUNTERFM-CARO_ROUTING_READ)I/P PLNTY ="N"From Routing Consumption (FM-CARO_ROUTING_READ)I/P PLNTY ="N"
UOM Conversion Master dataThis table should have unique combination Product and Alternate UOM
Source Field
From Routing Consumption
DSI RM Master data
PV FM-CS_BOM_EXPL_MAT_V2
Routing Master data)
This table should have unique combination Plant and Classification of (Class + Type)
E.g
Cable Plant Code A ( A class ), B (B class), C (C class)L (for Local Procurement ), I (Intra Plant Breakers), F(Foreign Procurement)50
Filtering Condition for Customer ID (Which is Unique in Customer Master)
Filtering Condition for Customer ID (Which is Unique in Customer Master)To be Provided in excel filtered values
Name of Price need to corrected
Speicific to cables Speicific to cables Availabity check alert will be given only if X indicator is maintained
ABC caluclaion for MCB facory How many days