Error while creating sales order : Materail not listed !!!

[Former Member]

Dear All,

While creating a Sales Order, I am getting this message. please let me know. what is listing means.

How to check it.

error message

Material XYYXY is not listed and therefore not allowed

Message no. V1118

Diagnosis

The material entered is not allowed for the transaction because the listing is missing.

Procedure

Check your entries. If they are correct, check whether the listing is complete.

end of errror message.

Thank You.

Regards

Venkat.

Will award points for useful replies.

[Former Member · Accepted solution]

It means you have to check a LISTING previously created for the customer X.

You have to add the material to the listing for the system to allow you to

sell the item.

[Former Member]

Hi,

Hope this will make your fundamentals about listing clearer.

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 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).

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.

Regards

SD

[Former Member]

hi

<b>MATERILA LISTING</b>

wHATEVER THE PRODUCTS THAT ARE PLACED IN LISTING FOR A CUSTOMER HE CAN ACCESS THOSE MATERIALS ONLY.

T CODES

VB01 FOR CREATION

VB02 FOR CHANGE

VB03 FOR DISPLAY

TO CHANGE GOTO VB02

AND ENTER LIST/EXCL TYPE AS "A001"

SELECT THE KEY COMBINATION

ENTER THE CUSTOMER AND MATERIAL

AND IN THE CHANGE LISTING FAST ENTRY SCREEN SELECT THE MATERIAL AND DELETE

NOW U WONT GET THE ABOVE ERROR

REGARDS

[Former Member]

Probably a little more detail will help you

In your sales document as you are trying to enter in the material and you

receive the error message, goto the following menu path in the entry screen:

>Environment>Analysis>Listing/Exclusion. Here it will tell you the

combinations for the condition record access. This will tell you how to

look at the master data and make changes if necessary.

Menu Path:

Logistics>Sales and Distribution>Master Data>Listing and Exclusion>Display

Bill

[Former Member]

Thanks Bill,

This is Good tip, I have just figured that.

I tried to look at

Logistics>Sales and Distribution>Master Data>Listing and Exclusion>Display but I dont see that in my system

Logistics>Sales and Distribution>Master Data.. there is no options like <b><Listing and Exclusion></b>.

Howver I am loooking in other place.

Logistics>Sales and Distribution>Basic Functions>Listing / Exclusion.

I will inform you about status of my progresss.

Thank You. Once gain !!! Points awarded !!

Regards

Venkat

[Chiragvaghela]

hi

I faced the same issue  while creating Sales order for my product but then did the following process and it was solved: THE ISSUE was I forgot to record my products in VB01 i.e Listing of products as per customer/Dist channel

T CODES

GO to  VB01 to create /  VB02 to Change / VB03 to Display

Enter Listing/Excl Type A001 or your created one and Select the key combination as 

Cust & Material 

Now add your products XYYXY which will add those products to particular customer and if you select Exclude in first screen in place of  LISTING then, those products will  be excluded and then the customer will not able to order the same. 

I successfully processed my sales orders after that and I hope you also do the same. 

Regards