SLED by customer/ material

[Former Member]

Hello Gurus,

I have a problem in my client. They have a rule to check ATP by SLED of materials.

Every customers have for each material one SLED available. For example, Customer X only order material Y with 30 days to expiration date, and so on....

Do you know if we have any place in master data to assign the availability experiration date for materials by client in R/3?

Do we have any way to make ATP by SLED?

Thank you very much

Lina

[Former Member · Accepted solution]

Hi,

I would say you need to use batch management for that. You set up an access sequence and condition records for combination of material and customer and put in a selection class in which you put in the minimum shelf life of the material required by the customer.

Do you use batch management already?

Regards,

MdZ

[Former Member]

I don't use batch management and the idea is to continue like this.

We can´t use the batch determination because that management is made by the other system.

In SAP R/3 we only create sales order, availabilty check (by SLED) , create deliveries, we porpose for shipment then we have an Interface to the other system (Warehouse management) and the return to SAP is the batch and picking.

The idea in ATP is to check quantities by plant but only inside the number of days available for that material/customer:

Example: For customer 249 and material AA31263 the SLED is 30 days available

We have 1000 Kg of AA31263 in the plant, but only 500 Kg have SLED available for 30 days.

The customer 249 need 800 Kg of AA31263, so when in SAP we create the sales order the system must say thar only 500 kg are available.

You think this is impossible to make this management in standard?

Thank you

Lina

[csaba_szommer]

Lina,

1.

I don't use batch management and the idea is to continue like this....We have 1000 Kg of AA31263 in the plant, but only 500 Kg have SLED available for 30 days. 

If you don't use batch management where do you know that you have 500 kg from AA31263 with 30 days remaining shell life (whilst total stock of this product is 1000kg)???

2.

In SAP R/3 we only create sales order, availabilty check (by SLED) , create deliveries...

How can you do ATP check based on shelf life?

According to my best knowledge, you can't you SLED in MRP & ATP (in SAP APO it is possible to use SLED in planning process).

As it was told properly by MdZ, you could use expiration date (customer specific) via batch determination.

Regards,

Csaba

Edited by: Csaba Szommer on Mar 18, 2009 8:58 PM

[Former Member]

Hi,

You could have the batches determined in the sales order already. You then might have an better (indirect) link in what is available and what not. Are the batches known in SAP or only in the external WM?

Is this applicable for all your customers or only for a few? You could set up a specific order type and only do batch determination for this specific order type for this / these specific customers.

Regards,

MdZ

[Former Member]

Hello Mdz,

We have the batches on SAP R/3 and we can determined on order or delivery, but this could only be a porpose to interface to other WM (other system).

Our first idea was to create an include in user exit RV03VFZZ with this determination. we can´t use the standard batch determination because we want to consider the ATP by batch. We think that we can only make this control in ATP user exit.

You think there is another way to get ATP by batch using standard functionalities?

This is a rule for all customer and all materials.

Lina

[Former Member]

Hello Lina

The requirement you said is very much possible in SAP with standard functionality of Batch Management. When you assign chracteristics to batches and create condition record for your required customers, for every customer you can mention the SLED time parameter to select batches. Also as you are using ATP this is also possible while determining batches as per the availability and criteria of batches in system. i am not sure, being a standard functionality what is the reason to go for EXIT?

Regards

Amol

[Former Member]

Hello Amol,

So you are saying that we can have a condition record by customer/material/sled time?

And system can make automaticaly the determination of the correct batch?

But how can i make a connection with ATP functionality, with a checking rule i can make the reservation by batch?

Thank you for you help

Lina

[Former Member]

Hi Lina,

As soon as you have batch determination set to automatically determine batches according to your selection criteria per customer, it will determine the corresponding batches (meeting requirements from the condition records) and thus you have your ATP. If it does not determine enough batches / quantity to meet the quantity required, you know that you cannot fulfill the order. You then follow the normal ATP procedure of forward scheduling for the remainder or liaise with customer whether he accepts batches with shorter SLED if available.

I think there is no standard condition table for material/ customer / SLED but you can simply create that.

MdZ

[Former Member]

Hello Mdz,

So you are saying that if the line item in order or delivery have one batch determined, the availability check reduce quantity by material/plant/batch. My question is, if i assigne one batch in one line item to order, the ATP will reduce the quantity in batch, if another customer will order teh same material and have the same rule to determine the batch, ATP will have in count the reduce quantities made before?

Thanks

Lina

[Former Member]

Hi Lina,

What I expect is that if you setup a selection class and conditino per customer/ material and SLED, and activate automatic batch determination in the SD order, the system will check first whether there is sufficient stock, regardless of the batches. Then batch determination takes place and will assign only those batches that fulfill the criteria from the condition records.

So assume yuo have 100 pieces on stock:

25 pieces batch 1 SLED 1 week

25 pieces batch 2 SLED 4 weeks

50 pieces batch 3 SLED 8 weeks

Your customer requires 75 pieces of material that has SLED more than 5 weeks.

When entering an order, you will enter material and quantity and according to the condtions and selection criteria, system promise 75 pieces as you have more than 75 pieces in stock (regardless of batches). Then batch determination takes place and only 50 pieces will be assigned a batch, as only 50 pieces have a SLED over 5 weeks.

I expect (not sure), that either system will correct the confirmed quantity to 50 pieces or you will manually adjust the quantity to 50 as for only 50 pieces a batch is found. It might result in an error, This you would need to test. There might even be settings to auto adjust but not sure.

In any case, batch split will only be created for 50 pieces which will trigger the user or system that there is not sufficient stock matching criteria of the customer.

And if system does not auto correct, you will probably have an SD user exit which will help you automate this.

MdZ

Edited by: MdZ on Mar 20, 2009 12:59 PM

[Former Member]

Hi Mdz,

Thanks, i think this could solve my problem.

So, with you example:

If customer requires 75 and only 50 pieces will assigned a batch because this one only has a SLAD over 5 weeks, then if another customer requires 20 pieces and his SLED is 5 weeks as well, the system will result on an error? Even if i haven´t already confirmed the quantities in WM? The system will reduce quantities to alert in order only if batch is assigned in sales order?

Lina

[Former Member]

Hi,

I am not 100% sure whether the quantities will be corrected to the quantity of assigned batches but a user exit or badi might be able to do that for you.

WM only comes into picture after delivery creation so you wont have issues there. Batches will be forwarded from the order to the delivery and from delivery to WM. So no batch determination in WM.

MdZ

[Former Member]

Hi,

Thanks, i will test what you have told.

Just another doubt: when you tol before: "I think there is no standard condition table for material/ customer / SLED but you can simply create that". The SLED field is standard in those catalogs of filed assigned in that structure?

Lina

[Former Member]

Ok, sounds good.

Good luck with testing.

MdZ

[Former Member]

But tell me, SLED is a standard field in struture of conditions records in batch determination?

I can say in an easy way to get the batch where the batch SLED is "inside" the SLED customer? Only with a table with SLED customer?

Lina

[Former Member]

Hi,

It is not a standard field.

MdZ

[Former Member]

Hi

SLED will apply as below scenario.

You maintain batch data in MSC1N. Here you maintain production date and shelf life in material master. On this basis it will calculate SLED. Now in condition record if you mention the batches to be picked should be less than LSED date for a particular customer then at the time of delivery system will check the condition record, criteria maintained in condition record and then it will check the available stock in system which is having date less than SLED. if the quantity is sufficient that batches will get picked in delivery.

hope you got this scenario

Amol

[Former Member]

Hello Amol,

Thank you for your answer.

Just tell me another thing, can i have this view in transaction MD04?Can i have a stock/requirement list by batch/SLED?

The ATP can be assigned only on delivery? Or need to bem in sales order? I have this doubt because with this ATP determination i can only have an batch split in delivery...

Thank you

Lina

[Former Member]

Lina -

You can not have batches to view in MD04. Also batches are not allocated at the time of sales order, they get assigned only at the time of delivery. This is because at the time of creating sales order the stock may not be available but at the time of creating delivery the stock should be availabe. So at the time of creating deliveries only according to condition record and batch search criteria it will get picked in the delivery.

Amol