Material Master Field Dependencies.ppt

Material Master Data Field Dependencies

Business IT Confidential

3/29/2019

“We Enable Business” 1

Material Master Data Material Code Max. 18 characters. Alphanumeric key uniquely identifying the material. It is used for all MM,SD,FI And PP Related Transactions.

Industry Sector It determines which screen appears and in which order and which industryspecific fields appear on the individual screens.

Material Type The material type controls the features of a material and which data must be maintained for the material.

When a material is created, it must be assigned to a material type. The Valuation Class is dependent on the Material type.

Business IT Confidential

3/29/2019

“We Enable Business” 2

Material Master Data

Material Views The views determine what type of data the Material Master should have viz., data common for all Distribution Channels, Sales Org.wise data, Purchasing Org.-specific data, Production-related data and so on.

Business IT Confidential

3/29/2019

“We Enable Business” 3

Material Master Data

Basic/Common Data

Business IT Confidential

3/29/2019

“We Enable Business” 4

Material Master Data

Distribution Channel The way in which Products or Services reach the customer. You can maintain information about Customers and Materials by Sales Organization and Distribution channel. Within a sales organization you can deliver goods to a given customer through more than one distribution channel.

Business IT Confidential

3/29/2019

“We Enable Business” 5

Material Master Data Division A way of Grouping materials, Products, Material code or Services. A Product or Service is always assigned to just one division. The divisions lets you organize your sales structure around groups of similar products or product lines.

Material Description Text containing up to 40 characters that describes the material in more details. It is is mainly used for

Printing Base Purpose. UOM

Unit of measure in which stocks of the material are managed. The system converts all the quantities you enter in other units of measure (alternative units of measure) to the base unit of measure. In Inventory Management, the base unit of measure is the same as the stockkeeping unit.

Gross Wt. Design

It Signifies the Gross weight of the material and is useful in case of Printing of Orders, Challans, Packing List. Also it is used for calculation of STO condition price.

It represent the number to the Design of the Paper Master Width which will be used for creating Material MasterItand is useful Signifies the in Width of the Paper case of PrintingMaster Orders. and is basically defined in Raw Master of Papers.

Size

Grade/Category If BUOM is mentioned wrong in Material Master and Transaction have been done It represent the Grade/Category against thatand Material Master, then it is not of the Material Master is to change the same. It is basically useful in possible case of Printing Orders. used for Reporting, Stock Keeping and Pricing Purpose.

Weight Unit

Unit referring to the Gross It is useful in case of Printing weight or Net Orders weight of the and most importantly it is used for FA material. And NA Calculation.

Volume Pack

Business IT Confidential

3/29/2019

Auto-calculated for printing of N.A. for Groups together Plywoodmaterials / MDF that require similar packaging materials. It is used in case of export code for Packaging Purpose.

Material Group

It is used for Pricing,NA Calculation, Reporting and its basic Purpose is to help in creation of Material codes.

“We Enable Business” 6

Material Master Data Design No. It represents the Number to the Design of the Paper Master / Laminate / Decowood and is useful in case of Printing Orders and for checking stock in the Plant.

Thickness It represents the Thickness of the Material and is useful in case of Printing Orders and Reporting Purpose.

GSM It Represent the GSM of the Paper Master and it is defined in Material code of Raw Paper Master.

Finish

Design Description

It Represent the Finish of the Paper Master and is mainly used for creating Material codes of Laminates, Decowood and Laminated MDF. It is also used in case of Reporting Purpose and Printing Orders.

It Represent the Description of the Design and is useful in case of Printing Orders and Reporting Purpose.

Business IT Confidential

3/29/2019

“We Enable Business” 7

Material Master Data

Sales Data

Business IT Confidential

3/29/2019

“We Enable Business” 8

Material Master Data Sales Unit Unit of measure in which the material is sold. A value in this field must be entered only if Sales unit differs from the base unit of measure. If the field does not contain an entry, the system

will assume that the unit of measure is same as the base unit of measure.

Tax classifications Conversion Factor 1

Identifies the condition that the system uses to automatically determine country-specific taxes during pricing. You can define Denominator of the quotient that specifies the ratio one or more tax categories for each country. During sales order Variable of the alternative unit of measure to the base unit processing, theSales systemUnit applies the tax category according to: a) of measure. the geographical location of your delivering plant and the Should be ticked if Sales UOM <> Base UOM and location of the customer receiving the goods. b) tax necessary conversion factor has to be maintained. classifications in the customer master record and the material master record.

Conversion Factor 2 Numerator of the quotient that specifies the ratio of the alternative unit of measure to the base unit of measure. The FA

and NA is dependent on it. If it is mentioned Wrong then wrong calculation will occur in P.O and Sales order.

Cash Discount Indicator that specifies whether this material qualifies for a cash discount. If it is not ticked

then Cash Discount will not get reflected in Sales order.

Business IT Confidential

3/29/2019

“We Enable Business” 9

Material Master Data Material Statistics Group

Discount Group

Helps to determine which data the system updates in the logistics information system. Mandatory

A way of grouping materials to which you want to apply the same conditions. It is basically used for defining Discount Structure in SD and Reporting purpose. If it is

for updating Sales Data in documents.

Account Assignment Group mentioned wrong, then wrong Discount Structure would get updated in Sales Order and then in Group of materials with the same Accounting Final Invoice which in turn result in Loss to the Requirements. Used by the system when creating an company.

Accounting Document from a billing document to determine the revenue or sales deduction account. If

Sub Group

Thickness

It represents in Sub-group of the Raw Paper / Laminate / Decowood Master which is purchased from outside. It is

would not get generated during creation of It represents the thickness of Material represents the Finish ofwrongly Material Final Invoice It and if it is mentioned Master in a 3 digit Format which should in a 3entries digit Format which type then would get should be equivalent to the Thickness (in w.r.t mm) MaterialMaster be equivalent to G/L the Finish mentioned in in different accounts. mentioned in Basic Data. It is wrongly posted Basic Data. It is basically used for basically used for Reporting Reporting Purpose. Purpose.

basically used for Reporting and Printing Purpose and for Pricing.

Finish it is kept Blank then the accounting entries

OSD/BSD It represents the Material if it is discontinued / out of range / in range etc. It is basically used for

Reporting Purpose.

Business IT Confidential

3/29/2019

“We Enable Business” 10

Material Master Data Availability Check Transportation Group

This field has two uses: a) Specifies whether and how the system checks availability andGroup ; Pricing b) In Flexible Planning, defines - together

Grouping of materials that share the same route and with the checking rule -the different Its MRP is basically used for Pricing purpose. The elements that make up this key figure. transportation requirements. Transportation groups PricesThe for Material Master are defined based

are used for automatic route scheduling duringsum of these elements gives the key on figure. Pricing Groups in FG / RM / SFG Codes. sales order and delivery note processing. Loading Group A grouping of materials that share the same loading requirements. The system uses the loading group as

well as the Shipping conditions and Management Delivering Batch plant to automatically determine the shipping point for the item. Specifies whether the Material is managed in

Batches. This indicator can be set in the material master record manually or, if batches are valuated individually, it is set automatically for the plants concerned, in which case it cannot be changed.

Profit Center

The indicator cannot be changed if stocks exist in either the current period or in the previous period.

Key which together with the controlling area uniquely identifies a Profit Center. It is directly linked with Cost Centre. If Profit Centre is mentioned wrong, then

the entry would get Posted in wrong Cost Centre.

Business IT Confidential

3/29/2019

“We Enable Business” 11

Material Master Data

Purchasing Data

Business IT Confidential

3/29/2019

“We Enable Business” 12

Material Master Data Purchasing OUoM Purchase Tolerance Group Key defining the reminder days and tolerance limits valid. Used in case of

Raw Material procurement (Paper etc.) and defines the Under delivery and Over delivery Tolerance limits in PO, based on which MIGO can be done.

Specifies the unit of measure in which the material is ordered. A value in this field to be entered only if unit of measure differs from the base unit of measure. If the

field does not contain an entry, the system will assume that the unit ofOrder measure is the base unit Variable Unit of measure.

Should be ticked if Order UOM <> Base UOM and necessary conversion factors are to be maintained.

Purchasing Group Key for a buyer or a group of buyers, who is/are responsible for certain purchasing activities: a) Internally, the purchasing

group is responsible for the procurement of a material or a class of materials. b) Externally, it is the medium through which contacts with the vendor are maintained.

Business IT Confidential

3/29/2019

“We Enable Business” 13

Material Master Data

Production Data

Business IT Confidential

3/29/2019

“We Enable Business” 14

Material Master Data MRP Type

MRP Controller

Specifies the number of the MRP controller or group of MRP controllers for material planning for the material. MRP Controller have Key that determines whether and how the material isresponsible planned. You already been defined for every Factory in SAP. Entered only when have the following options: a) Manual reorder point planning; b)

MRP Type = “PD”. Every SFL, SFG and FG should have an MRP Automatic reorder point planning; c) Forecast-based controller. planning; d) Material requirements planning with forecasts for unplanned consumption. Every SFG And FG Code should have a MRP Type = "PD"(MRP).

Lot Size Key that determines which lot-sizing procedure the system uses within materials planning to calculate the quantity to be procured or produced.

Business IT Confidential

3/29/2019

“We Enable Business” 15

Material Master Data Procurement Type Indicator that defines how the material is procured. The following procurements types are possible: a) The material is produced inhouse b) The material is procured externally and c) The

material can be both produced in-house and procured externally.

The procurement type is defined by the material type you have chosen.

Backflush

Production St. Location In the case of a material produced inhouse, this is the key of the storage location that is copied to the planned order, production order, or run schedule quantity: a) If the material is a

component, it is the issuing storage location to which a backflush is posted. b) If the material is produced, it is the receiving storage location to which the receipt of the material is St. Location for EP posted .

Determines whether the backflush indicator is set In the case of a material procured in the production order. Here, a 3-level hierarchical logic is applied: a) In theexternally, routing, this is the key of the storage location which is copied in MIGO etc. the backflush indicator is set in the

component assignment b) In the material master record, the backflush indicator has the characteristic "Always backflush“ c) In the material master record, the backflush indicator has the characteristic "Work center decides", the indicator being set in the work center.

Business IT Confidential

3/29/2019

“We Enable Business” 16

Material Master Data Period Indicator Indicator specifying the Periods in which the Material's consumption values and forecast values are managed.

Strategy Group The strategy group groups all the planning strategies that can be used for a particular material. The planning strategy represents the procedure used for planning a material and is (technically speaking) controlled by the MRP types.

Consumption Mode

The consumption mode controls the direction on the time axis in which the system consumes requirements

Backward Consumption period Fwd. Consumption period

Determines the consumption period (in workdays) for Determines backward consumption. the consumption period (in Using backward consumption, sales consumption. In workdays) for forward orders, dependent requirements, or sales orders, forward consumption, material reservations are assigned to and dependent requirements or material consume planned independent reservations consume planned requirement quantities which lie within that lie within independent requirements the consumption and before theafter the theperiod consumption period requirements date. The consumption requirements date. period is specified in days and is valid from the current A period between Thedate. consumption period is specified in 1 and 999 daysdays should entered. andbe is valid from the current date. A period between 1 and 999 days should be entered.

Business IT Confidential

3/29/2019

“We Enable Business” 17

Material Master Data Version Indicator Gets ticked automatically when Production Versions are maintained for the Material Master

Repetitive Mfg.

REM Profile

Authorizes the material for Repetitive The repetitive manufacturing profile also Manufacturing. You can only backflush determines: a) how the system deals in Repetitive Manufacturing if you with activities when backflushing b) have set this indicator. If you set

which movement type is used to this indicator, you must also specify post goods receipts and goods issues a repetitive manufacturing profile c) how planned order and run for this material. schedule quantities are reduced in the backflush transaction d) how BOM corrections are made - if errors should occur when posting quantities to be backflushed.

Business IT Confidential

3/29/2019

“We Enable Business” 18

Material Master Data Issue Unit Unit in which the material is issued from the warehouse.

A value in this field is to be entered only if issue unit of measure differs from the base unit of measure. If the field does not contain an entry, the system will assume that the issue unit of measure is same as the base unit of measure.

Production Unit Unit in which the material is issued from the warehouse.

A value in this field is to be entered only if production unit of measure differs from the base unit of measure. If the field does not contain an entry, the system will assume that the production unit of measure is same as the base unit of measure.

Business IT Confidential

3/29/2019

“We Enable Business” 19

Material Master Data

Material Valuation Data

Business IT Confidential

3/29/2019

“We Enable Business” 20

Material Master Data

Valuation Class The Valuation class has the following functions: a)

Allows the stock values of materials of the same material type to be posted to different G/L accounts b) Allows the stock values of materials of different material types to be posted to the same G/L account c) Determines together with other factors the G/L accounts updated for a valuation-relevant transaction (such as a goods movement). Price Control Indicates the price control used to valuate the stock of a material. You have the following options: Standard price or Moving average price. If the material ledger is activated for

the material, this indicator, together with the material's price determination indicator, determines at which of the following prices the material is valuated: Standard price, Moving average price, Periodic unit price.

Business IT Confidential

3/29/2019

“We Enable Business” 21

The End

Business IT Confidential

3/29/2019

“We Enable Business” 22