Database table for business volume data is stored for a condition contract

[priya_sshekhar]

Hi Team,

Below are the questions i need support on if anyone has worked on custom changes in condition contract settlement process.

Q1.What is the database table in which the Business Volume data is stored for a condition contract(The billing documents and quantities).I need to build a custom logic to fetch the data and perform some calculations on it but i am struggling to fine.

Q2.If we create custom fields in a condition contract header, is it possible to use those fields in a pricing routine or the fields absolutelty need to be part of the pricing structure?

Thanks, 

[HariBoyapati2]

Hi Priya,

Is your solution working for the requirement?

Regards

Hari

[HariBoyapati2 · Accepted solution]

Hi Priya,

Q1: Business volume will be stored in Business volume profile table. For Standard sales rebate, business volume table is VWB2_VBRKVBRP_1. To fetch the business volume for specific agreement, you need to pass the Business Volume selection criteria into this table.

Q2: Needs more info. If your business is using the Accruals posting from the customer billing document, then the custom field should be in the billing document and settlement document. If not, custom should be only in settlement document for the price calculation. Check if you want to add the custom field into Condition Contract header or Business volume selection criteria or the Pricing structure as the architecture of the condition contract is bit different from the ECC rebates.

Table to get the business volume selection criteria: WB2_D_BUSVOLBASE

Regards

Hari 

Regards

Hari

[priya_sshekhar · Accepted solution]

Hi Hari,

Thanks for your response.

The field has been added in the condition contract header and in the business scenarios we have activated the copying into settlement document.

Since the field is now available on the settlement document, is it mandatory to add the field into the pricing structure or the routine can pick it up from the header?

Thanks

[HariBoyapati2 · Accepted solution]

Hi Priya,

May i know the business requirement for the custom field in the condition contract header. Condition contracts settlement will be based on the data from business volume(Sales document/Purchase docs). I am not clear on why you are fetching a field from condition contract into settlement document.

Regards

Hari

[priya_sshekhar · Accepted solution]

The requirement is to have the rebate eligibility based on a different material and the rebate based on a different material.If the customer purchases 100EA of Material A ,only then he is eligible for a rebate on Material B at a 5% rate.So we are trying to store the Material A and Quantity 100 EA in custom fields. Based on these fields we are planning to check for eligibility in the pricing routine.Both Material A and Material B will be added in the business volume selection critieria.

[HariBoyapati2 · Accepted solution]

Hi Priya,

In this case custom field need not be in the Pricing structure. You should be able to fetch it into the Pricing routine from the settlement document.

Regards

Hari