Skip to Content
author's profile photo Former Member
Former Member

Material Determination

In material determination how we will configure that the system should propose when product A is not available then only system substitute with product B. If A is available 60% quantity. What i have to do in this situation? How i will configured it.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 10:11 AM

    Hi Raja,

    as far as I know it is not possible to trigger the material determination in R/3 based on product availability, what you are looking for is rules based ATP which is only available with SAP SCM. There you can automatically substitute the product or plant based on the availability situation.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2007 at 10:44 AM

    Select alt item while creating master data for Mat det,vb11, in alt mat list maintain a,b etc as per your need

    system will check availability of a, then b

    select reason 0004i.e availability

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 11:03 AM


    go thru this documentation

    Material Determination:


    SAP Easy access ® Logistics ® Sales and distribution ® Master data ® Products

    ® Material Determination ® Create

    IMG ® Sales and Distribution ® Basic Functions ® Material Determination ® Define substitution reasons

    Determining Material:

    Material determination provides you with a tool for automatically exchanging materials in the sales document.

    The condition technique provides you with greater flexibility in material determination. When you process a document, the system automatically searches for valid master records that you created previously in material determination.

    You can assign a substitution reason to every master record in material determination that defines how the material should be determined. You define the substitution rules in Customizing. Examples in the standard system include:

    - Substitution reason 0002: Customized material

    - Substitution reason 0003: EAN number

    You do not need a material master record for the material number that you are replacing.

    During order entry, the material ordered by the customer is replaced by the substitute defined in the master record. The system now continues processing with the substitute (for example, in the availability check, pricing, delivery, billing).

    Note: The item overview for Sales A contains information about the material that was originally entered as well as the reason for substitution.

    Select Product Manually:

    In some sectors of industry, the same products are sold in different packaging materials (for example, packaging for standard and promotion articles). Material master records exist in the system for managing these stocks. When you enter an order, you can use different material numbers for the same product.

    We have extended the functions in manual and automatic product selection so that material determination can support this business practice:

    . Reason for substitution 0005: Manual production selection (list of default values)

    . Reason for substitution 0004 / 0006: Automatic product selection (depending on availability

    in order and delivery)

    In manual production selection, (reason for substitution 0005), the system does not automatically replace the product. Instead, it displays a list of all of the substitution materials and other information in the master record. You can then select the required material from this list.

    To simplify selection, the system displays the material quantities that can be confirmed on the customer's requested delivery date. If a material cannot be confirmed fully for the requested delivery date, the system displays the date on which the material can be completely delivered.

    Master Data:

    Maintain the master records for material determination in the master data menu for Sales and Distribution under Products.

    You can use the condition technique to define the master data for material determination at any level. For example, you can create data records using the material number or a combination of the material and customer numbers.

    When you process master records, you can:

    . Restrict the validity period of a record

    . Maintain separate entries for each key combination

    . Determine reasons for substitution

    . Save one or more substitutes per master record

    If there is more than one material defined in the master record for material determination / product selection, the sequence in which they appear defines the priority that they have.

    Automatic Product Selection:

    In automatic product selection (reasons for substitution 0004 and 0006), the system replaces the entered material automatically if it is not available.

    If automatic product selection is being used, the system may display (based on customizing) the entered and substituted material as main and sub-items in the sales order.

    When you enter an order, the system tries to fill the quantity of the order with the first material in the material determination master record. If there is not enough of this material, it fills the remaining quantity with the next material.

    You can choose whether or not you want to re-run material determination when the delivery is created. If material determination is re-run, the result of the substitution may change due to the new availability situation.

    You can use the product attributes in the material and customer master records to exclude a particular material from product selection. This means, for example, that all the materials that have been rejected in the customer master will not be included by the system when it determines a substitution material.

    The Partial confirmation of product selection allows you to deal with shortfall cases (in which only the available quantity is confirmed, and it is less than the order quantity) by passing the shortfall quantity on to materials planning. In this case, an additional sub-item is generated with a specifically defined material.

    Automatic Product Selection - Master Data:

    The sequence of the substitution materials in the master data influences the result of the automatic product selection in the order.

    If you want the material that is first entered in the order to be included in the substitution, then you must enter it in the substitutions list.

    . Case A: The original material is in the first place in the list, and its available stock is included in the substitution. The system then refers to the available stock for the next material in the master record.

    . Case B: First, the system uses up the available stock for the materials that appear in the master record before the material that has been entered. Only when these stocks have been used up, does it include that material in the substitution.

    Material determination - Condition Technique:

    The condition technique provides more flexibility in modeling material determination and product selection.

    You can assign a material determination procedure to each sales document type. The procedure contains all of the Customizing information that the system needs for material determination. The procedure includes one or more defined condition types

    One access sequence (search strategy) is assigned to each condition type.

    Each access sequence consists of one or more accesses.

    Each access contains exactly one condition table. This represents the search key that the system uses to search for a valid master record.

    You can activate an analysis of the material determination in the sales document. The system then displays detailed information on how the materials were determined.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.