SAP Knowledge Base Article - Public

3060461 - Material listing/exclusion doesn't work properly with an additional access sequence for the condition type

Symptom

You have more than one access sequence for your material listing/exclusion, however, when creating the sales order, the system doesn't seem to find one of the condition record and triggers an error message: Material * is not listed and therefore not allowed. Message no. V1118

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP S/4HANA Cloud.

Reproducing the Issue

Let's check based in the following scenario of the material listing:

1. Maintain Access Sequences for Listing/Exclusion -  configuration step 103213

There are two access sequences for condition type ZL01. An access sequence defines the order in which the system reads condition records to find valid data for a condition type, and each access is made using one condition table.

In this example:

The first access sequence uses key combination Customer/Sales Org./Distr. Chl/Material.

The second access sequence uses key combination Customer/Sales Org./Distr. Chl/Mat.Pr.Grp.

2. Go to Reference Material Listing/Exclusion app and you can check the condition records available.

The first condition record is related to the access sequence that uses key combination Customer/Sales Org./Distr. Chl/Material.

The second condition record is related to the access sequence that uses key combination Customer/Sales Org./Distr. Chl/Mat.Pr.Grp.

3. Material TG13 have Material Pricing Group M1 assigned to the respective sales organization:

4. Create a sales order for material TG13. Message will be displayed:

Material TG13 is not listed and therefore not allowed.

The system should follow the access sequences assigned to the condition type ZL01, if the first is not met Customer/Sales Org./Distr. Chl/Material then system should check the next sequence Customer/Sales Org./Distr. Chl/Mat.Pr.Grp. 

Cause

The configuration step 103031 - Activate Listing/Exclusion by Sales Document Type, doesn't have the correct procedure setting.

This procedure defines how the system reacts when several accesses occur:

blank - The first listing of the access sequence is critical

A - The last listing of the access sequence is critical

B - At least one listing must apply

C - All listings must apply

According the scenario in this example, the current setting of the procedure is blank - The first listing of the access sequence is critical. So when processing the material listing, system would only check the condition of first access sequence. 

Resolution

In order to have the second access sequence triggered, set B to Procedure field:

No error message is displayed, access sequence was applied correctly now for the material listing:

Keywords

V1118, V1 118, listing, listing/exclusion, exclusion, condition record, listing type, list type , KBA , SD-MD-MM-LIS , Listing / Exclusion , SD-MD-CM , Conditions and Condition Maintainance , SD-MD-MM-LIS-2CL , Listing / Exclusion (Public Cloud) , How To

Product

SAP S/4HANA Cloud 2105