Batch wise Price-- Possible ?????

[Former Member]

Dear SAP Gurus,

Is it possible to maintain price for each individual batch in SD or MM??? as for example Plant-material-Vendor-Batch combination.

If not directly possible- any work around??? anybody worked on it?

Regards,

Sarang

[Former Member]

Dear Gourav/Navaneetha,

Thanks for your prompt reply.

I have further clarification to my question. Only valuation type and batchwise inventory value maintainance will not serve my purpose.

I will diffentiate the incoming /outgoing as per Iron content ( a specific range will designate a separate batch) and I need to pay vendor/ charge coustomer based on batch . So I need to pick price based on batch for each vendor and customer.

Need to know if I can include batch in field catalog of condition table??? and subsequently create condition record based on Plant-material-Vendor/custome-batch.

Is it possible? If possible then How?

Thanks for your co-operation, I will give you proper marks while closing the thread.

Regards

[Former Member]

Using condition records including batch has many restrictions as given below:

1. This is only possible if you want to determine batch on Sales Order level.

If so, then you must enable the functionality that Order should not save until correct batch has been identified.

That mean , we will not be able to create Open Orders.

2. Batch may be altered in Delivery, suppose anyone has changed the batch in delivery , then again the calculation will go wrong.

As per your question, I think you can construct such condition tables since field CHARG is already available in catalog.

alternatively you can follow the following :

If you have Batch enabled at Order Level:-

You can catch Batch Cost Price in VPRS or Some Other Condition.

(ii) Then, Add another condition say ZBSP(Batch Specific Price) in your pricing procedure. make it statistical.

add a routine which checks for the value in VPRS, adds relevant margin and and Displays Batch Price.

If you have Batch enabled at Delivery Level:-

in order , you can give some average price value,

Then, In Billing , You will come to know the exact Batch Specific Price.

Hope this information adds to your requirement.

Plz reward if found useful.

Regards,

Gaurav Raghav.

[Former Member]

Using condition records including batch has many restrictions as given below:

1. This is only possible if you want to determine batch on Sales Order level.

If so, then you must enable the functionality that Order should not save until correct batch has been identified.

That mean , we will not be able to create Open Orders.

2. Batch may be altered in Delivery, suppose anyone has changed the batch in delivery , then again the calculation will go wrong.

As per your question, I think you can construct such condition tables since field CHARG is already available in catalog.

alternatively you can follow the following :

If you have Batch enabled at Order Level:-

You can catch Batch Cost Price in VPRS or Some Other Condition.

(ii) Then, Add another condition say ZBSP(Batch Specific Price) in your pricing procedure. make it statistical.

add a routine which checks for the value in VPRS, adds relevant margin and and Displays Batch Price.

If you have Batch enabled at Delivery Level:-

in order , you can give some average price value,

Then, In Billing , You will come to know the exact Batch Specific Price.

Hope this information adds to your requirement.

Plz reward if found useful.

Regards,

Gaurav Raghav.

[Former Member]

Using condition records including batch has many restrictions as given below:

1. This is only possible if you want to determine batch on Sales Order level.

If so, then you must enable the functionality that Order should not save until correct batch has been identified.

That mean , we will not be able to create Open Orders.

2. Batch may be altered in Delivery, suppose anyone has changed the batch in delivery , then again the calculation will go wrong.

As per your question, I think you can construct such condition tables since field CHARG is already available in catalog.

alternatively you can follow the following :

If you have Batch enabled at Order Level:-

You can catch Batch Cost Price in VPRS or Some Other Condition.

(ii) Then, Add another condition say ZBSP(Batch Specific Price) in your pricing procedure. make it statistical.

add a routine which checks for the value in VPRS, adds relevant margin and and Displays Batch Price.

If you have Batch enabled at Delivery Level:-

in order , you can give some average price value,

Then, In Billing , You will come to know the exact Batch Specific Price.

Hope this information adds to your requirement.

Plz reward if found useful.

Regards,

Gaurav Raghav.

[Former Member]

Hi Santosh,

Using condition records including batch has many restrictions as given below:

1. This is only possible if you want to determine batch on Sales Order level.

If so, then you must enable the functionality that Order should not save until correct batch has been identified.

That mean , we will not be able to create Open Orders.

2. Batch may be altered in Delivery, suppose anyone has changed the batch in delivery , then again the calculation will go wrong.

As per your question, I think you can construct such condition tables since field CHARG is already available in catalog.

alternatively you can follow the following :

If you have Batch enabled at Order Level:-

You can catch Batch Cost Price in VPRS or Some Other Condition.

(ii) Then, Add another condition say ZBSP(Batch Specific Price) in your pricing procedure. make it statistical.

add a routine which checks for the value in VPRS, adds relevant margin and and Displays Batch Price.

If you have Batch enabled at Delivery Level:-

in order , you can give some average price value,

Then, In Billing , You will come to know the exact Batch Specific Price.

Hope this information adds to your requirement.

Plz reward if found useful.

Regards,

Gaurav Raghav.

[Former Member]

Dear Santhosh,

It is quite possible and of course it is being used in some places also.

The procedure is

1. Configure/activate Valuation Type in MM according to Batches.

2. At the time of GR, A batch will be valuated as per condition details in PO.

The conditions which to go to inventory and which not to go will be controlled by account keys assignment in MM.

3. Thus the batch will come up with a valuation type.

4. when you will go to MM03, and enter select Accounting1 view:, enter the plant and valuation type here.

then the Batch price will be visible as Moving Price.

If you do not specify Valuation type, it will show Avg. Moving price.

5. This material Batch price will automatically to Sales Cycle (in Order or in billing) via Condition VPRS.

6. In SD , Batch should also be configured at Order/Delivery level.

Revert back if you have any doubts.

Please reward if found useful.

Regards,

Gaurav Raghav.

[former_member183879]

Hi Santosh,

You can very well enable this. For the same you have to enable Batch Determination in MM. Then the batch number for every line items gets updated in the field VBAP-CHARG. Then based on this field, you can create your condition table and enable pricing based on batch number.

But then i really dont know how the condition records be maintained for each batch in VK11.

Rwd if the solution helps.

[Former Member]

HI

You can maintain batch wise pricing for that you have to maintain condition table batch,plant and maintain condition records