difference b/w cmir and listing & exclusion

[Former Member]

hi

what is the difference between customer material information record and Material listing & exclusion? i mean major?

please help me

regards

murali krishna

[Former Member · Accepted solution]

hi

CMIR in VD51 tcode

Data on a material defined for one specific customer is stored in the customer material information records. This data includes

the customer-specific material number

the customer-specific material description

customer-specific data on deliveries and delivery tolerances

If a customer manages a material with a number that differs from the one your company uses, a customer-material information record is created.

Steps:

Use the following steps to create a customer-material information record:

In the SD Master Data Screen select, Agreements ® Cust.-material info ® Create.

You reach the Create Customer-Material Info Record screen.

Enter the customer number, the sales organization and a distribution channel. Thus, you can specify to which part of your organization the information record applies.

Press ENTER.

You reach the Create Customer-Material Info Record: Overview screen

Edit the data screen by entering data in the following fields:

– In the field Material enter the number which identifies the material in your company.

– In the field Customer material enter the number that the customer uses to identify the material.

Press ENTER.

The system adds the material description used in your company.

Press Info record details to display the items created, and to enter shipping data, as well as partial delivery agreements.

If you want to maintain a text, select Goto ® Texts in the Overview screen

You reach the Text screen, where you can enter your text.

If you want to enter several lines of text, mark the text lines and select Edit ® Detail, to get to the SAPscript editor.

Save your text after maintaining it in the SAPscript editor. You return to to the Text screen of the sales information record using Goto ® Back.

Save the data record.

In the message line, you receive the message that customer-material info record was saved.

If, for example, one of your customers uses a number for a material, which differs from the number your company uses to identify it, you can store the material number used by the customer in the customer material information record.

Features

During order entry, items can be entered by specifying the material number used by the customer. You also enter a customer material number in the order view of the sales order. You can then use both material numbers during the order entry, the material number your company uses or the one defined by the customer, because the system can carry out allocation automatically.

Data on the delivery and the individual delivery tolerances agreed upon with the customer for the material in question can also be checked and transferred to the sales order item.

You can also store a text in the customer material information record. It is copied to the relevant SD document items during text determination. In Customizing, the text type Customer Material Text is provided for this.

we need to mantain this record when the customers are having their own names for the materials rather than the original names.

we need to enter the customer materila number in the sales order on the "ordering party tab page" when we enter the CMIR in the sales order the system will take the original materila number or name

Material listing and exclusion lets you control which materials specific customers may or may not buy. For example, if you create a material listing for a specific customer, the customer can only order products from that list. You can also create a master record for material exclusion for a particular customer. Then the customer can not order excluded materials from you.

Material listing applies to two partner functions in Sales & Distribution: the sold-to party and the payer.

In the standard version of the SAP R/3 system, when the sold-to party and payer are different, the material listing check is as follows:

If the sold-to party has a material listing, the system only checks this listing (no other check takes place).

The material listing for a sold-to party can include materials that do not appear in the material listing for the payer (for example, in the case of materials that are rarely ordered or only in exceptional cases)

If there is no listing for the sold-to party, but a listing has been created for the payer, the system automatically checks the payer’s listing.

If no material listing data exists for either the sold-to party or payer, then the customer may order any material.

materila listing in VB01

materila listing A restriction that controls the sale of specific materials to a customer.

Customers can only buy materials included in the material listing assigned to them. The system does not allow you to enter materials that are not included in the material listing in a sales document for a customer.

materila exclusion

A restriction that prevents the sale of specific materials to a customer.

The system does not allow you to enter materials that have been excluded from sale to a customer in sales documents for the customer.

[Former Member]

Hi,

<b>CMIR - customer material information record:</b>

You sell the customer say material <b>"abcd"</b>. This is the material code of the finished product that you sell to your customer. The customer may identify this material as <b>"1234"</b> for his/her own convinience.

Suppose I am a machine manufacturer and there are 50 parts in my machine all different. I will give a coding to all the 50 parts for identification purpose. You are the parts supplier and manufacture all parts and you have different coding for the parts. In <b>"VD51"</b> you will maintain the material information record for me. Whenever I give you the order I will specify My part no. and your part number.

For your part no. "A" customer "X" will call it as "1" & customer "Y" will call it as "2".

<b>Listing & Exclusion:</b>

You manufacture 10 different products - 1,2,3,4,5,6,7,8,9,10. I am your customer and I only buy items 3 & 5. So for me you will include items 3&5 only. If i try to order any other item then the system will throw message that material is not listed.

Now say I am buying all items except 3&5. So instead of including all items It will be better if you exclude items 3&5 for me. So when i try to order items 3&5 the system will give an error that items are excluded.

Listing & Exclusion is done in IMG - sales & distribution - basic functions - listing/exclusion. The condition record for this is maintained in transaction code <b>"VB01"</b>. For listing it is <b>A001</b> - listing & B001 - Exclusion.

Reward points if solution helps.

Regards,

Allabaqsh G. Patil

[former_member227476]

dear murali

CMIR is how customer will recognise the product

for Ex: in the point of business a fridge is:- LTSDFK098

but customer cont recognise with that code but he will come and say he want

150 Lt, fridge. when business enter 150 lt freidge it should take LTSDFK098

this we will maintain in CMIR

and listing and exclusion is some material we dont want to sell to some people

and some material we want to sell for perticular people only

Ex: explosive material

in these cases we will use listing and exclusion

hope i have clarified ur issue

rewards if it helps

siva

[Former Member]

HI,

Data on a material defined for one specific customer is stored in the customer material information records. This data includes

<b>If, for example, one of your customers uses a number for a material, which differs from the number your company uses to identify it, you can store the material number used by the customer in the customer material information record.</b>

<b>Material listing/Exclusion:</b>

Material listing and exclusion lets you control which materials specific customers may or may not buy. For example, if you create a material listing for a specific customer, the customer can only order products from that list. You can also create a master record for material exclusion for a particular customer. Then the customer can not order excluded materials from you.

Suppose a company develops products for both domestic & defenece purpose.Hence defenece products should be sold to normal customer, for this customer listing/exclusion is used.

We can use exclusion or listing for customer ie., either of these one

regards,

Arun prasad

[Manoj_Mahajan78]

Murali,

MATERIAL LISTING-

we need to mantain this record when the customers are having their own names for the materials rather than the original names.

we need to enter the customer materila number in the sales order on the "ordering party tab page" when we enter the CMIR in the sales order the system will take the original materila number or name

materila listing in VB01

materila listing A restriction that controls the sale of specific materials to a customer.

Customers can only buy materials included in the material listing assigned to them. The system does not allow you to enter materials that are not included in the material listing in a sales document for a customer.

materila exclusion

A restriction that prevents the sale of specific materials to a customer.

The system does not allow you to enter materials that have been excluded from sale to a customer in sales documents for the customer.

REWARD IF U FINDS THIS AS USEFUL....

Regds'

MM

[Former Member]

Hi Murali,

First of all CMIR and Material Listing & Exclusion are defferent.

<b>About CMIR:</b>

Customer uses a number or description for a material, which differs from the number or description of your company uses to identify it, you can store the material number or description used by the customer in the customer material information record.

Menu path: Easy Access- Logistics- SD- Master Data- Agreements- Customer mat info- Create/ change / display.

T. Code: VD51.

Customer material info record is information on a material that applies to a specific customer. This data includes:

• The customer-specific material number

• The customer-specific material description

• Customer-specific data on deliveries and delivery tolerances.

• Plant

• Delivery Priority

• Minimum Delivery Quantity.

• Item Usage

The data in the customer material info record has priority when master data is copied into SAP. In the sales order the customer material must be entered in the customer material field.

Make sure the relevant indicator is set on the sales doc type in order for the system to read the cust mat info record.

<b>Material Listing & Exclusion:</b>

Material Listing & Exclusion lets you control which materials specific customer may or may not buy. Example company has got materials- A, B, C, D, E. Company decided to sell only A, B, C materials to Customer X, by using listing and exclusion compnay can restrict to buy only those to the customer X.

• Exclusion is given preference over listing.

• The system will check the listing or exclusion for the sold to party first and if it finds, then no other check takes place, other wise it checks for payers listing & exclusion.

Hope this will give you and insight of both CMIR and Listing & Exclusion.

Reward points if helpful.

Bye,

Vamsi P

[Former Member]

Hi

<b>Customer-Material Information </b>

Data on a material defined for one specific customer is stored in the customer-material information record. This data includes

• the material number used by the customer

• the material description used by the customer

• customer-specific data on deliveries and delivery tolerances

If, for example, one of your customers uses a number for a material, which differs from the number your company uses to identify it, you can store the material number used by the customer in the customer-material information record.

Use

During order entry, items can be entered by specifying the material number used by the customer. Thus, you can use both material numbers during the order entry, the material number your company uses or the one defined by the customer, because the system is able to identify the numbers and to match them.

The data on the delivery and the individual delivery tolerances agreed upon with the customer for the material in question, can be checked and transferred to the sales order item as well. This can be defined by the system administrator.

You can also store a text in the customer-material information record. It is copied to the relevant SD document items during text determination. In Customizing, text category Customer-Material-Text is intended for this.

<b>Material Listing and Exclusion </b>

Use

Material listing and exclusion lets you control which materials specific customers may or may not buy. For example, if you create a listing of products for an individual customer, the customer may only order products on the list. You can also specify material exclusion for a particular customer. The customer may not order excluded materials from you.

Partner Functions in Material Listing

Material listing applies to two partner functions in Sales & Distribution: the sold-to party and the payer. For more information about partner functions, see the R/3 SD online guide on Basic Functions and Master Data.

In the standard version of the SAP R/3 system, when the sold-to party and payer are different the system checks material listing as follows:

• If the sold-to party has a material listing, the system checks only this listing (in other words, it does not check further).

The material listing for a sold-to party can include products that do not appear in the material listing of the payer (for example, in the case of items that are ordered only rarely, or as exceptions)

• If the sold-to party has no specific material listing but the payer does, then the system automatically takes the material listing of the payer into account.

• If no material listing data exists for either the sold-to party or payer, then the customer may order any material.