VPRS CONDITION TYPE

[Former Member]

Dear Guru's,

In the billing documents when I see the item level conditions I find VPRS conditions are repeated Neumerous number of times.

Can you suggest what could be the possible reasons ?

header Conditions are working FIne.

regards,

Amlan

[former_member184555 · Accepted solution]

Hi

If it is happening in the order also, then the problem is not while creating the billing document. Please check whether the system is taking Moving average price or standard price. Plese check the field CONDITION CATEGORY in the VPRS condition type, whether it is configured for determining for Moving average price or standard price.

Thanks,

Ravi

[Former Member · Accepted solution]

Dear Friend,

The Problem is appearing in the billing documents and in the valuation feilds ...

The price is given for the moving average nad the sdtandard Price.

But it is determing the same from the Standard Price of the MMR.

• the problem is with the billing documents the order and the delivery is working fine,.

regards,.

Amlan Sarkar

[Former Member · Accepted solution]

Dear Guru's ,

Any Solutions.

I am facing serious problem Now.

When I scroll down in the Item conditions of the billing documents.

The Conditions are disappearing and when I give the ZPR0 Consdition type then there is repeatation of the ZPR0 condition type at least 10 times.

What could be the possible reasons....

regards,

A. S.

[Lakshmipathi · Accepted solution]

Dear Amlan

On going through your comments

[The price is given for the moving average nad the sdtandard Price]

[But it is determing the same from the Standard Price of the MMR]

I am unable to understand exactly. If I have understood your comments correctly, you are telling that though in MMR, in the field Price Control, you have maintained V, still the system is picking standard price.

Sorry to putforth so many questions !!!!!

thanks

G. Lakshmipathi

[jpfriends079 · Accepted solution]

Hello Amlan Sarkar,

Can u forward me ur pricing procedure analysis screen shot for item level?

Regards - JP

[Former Member · Accepted solution]

Hi Amlan

What is the price control "V" or "S" in the material master in Accounting 1 view. If it is S, then system will take the Standard price. So if it is so, then chsnge it to V so that moving avarage price will be taken.

I hope it may be helpful.

Regards

[Former Member · Accepted solution]

The Price control is S Standard price in the MMR.

I have only given the Standard Price of the document.

I am sending you all the screen shorts of my problem .

Please help me out.

Thanks !

Amlan Sarkar

[Former Member · Accepted solution]

Dear Experts !

The Problem in the screen I have sent...

What is happening Now is when I am going to the Item condition of the billing documents

& scrolling the screen the Conditions are disappearing and when I am entering the Base prices condition types .

Many of the Conditions inclusing VPRS is getting repeated.

Is there any technical fault Whether I should consult SAP for this.

If you can provide me the email IDS i can send the screen shots accross.

regards,

Amlan Sarkar

[Lakshmipathi · Accepted solution]

Dear Amlan

I have gone through your mail attachment. I feel there is something wrong with your tax codes which you had maintained in UTXJ.

To check that go to VK12, input UTXJ and check whether for multiple combinations, you have maintained the same tax code. For information, in UTXJ, you would be maintaining different Key combinations. You should maintain the tax codes only to a particular combination and by mistake, if you maintain tax codes for multiple Key combinations, then in sale order / billing, conditions would repeatedly be flowing.

So first check your UTXJ and ensure that the tax codes are maintained only for one combination.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Dear Lakshmipathi,

I have checked the UTXJ condition records.

Only one access:

Country/Country/Plant/Tax Cal. Material/Tax. Cla. Customer/Customer Group.

Tax code S2 .

All the other Records I have delimited.

I am really tired of this problem. Is there any other way I can find out the probable solutions of this.

Thanks all out you for your input.

regards,

Amlan Sarkar

[Lakshmipathi · Accepted solution]

Dear Amlan

Why I had suggested is that long time back, I had also faced a similar problem where one particular condition type was repeatedly flowing in sale order and after breaking my head, I could find the solution. By mistake, for different Key combinations, one particular tax code was maintained and after removing one combination, it worked for me.

So if you have removed any combination after this suggestion, please try to create a new sale order and post the feed back.

Will revert if any alternate suggestion struck my mind.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Dear Lakshmipathi,

What I have done with the UTXJ is there is now only one access and only one record for the same.

The access is JDUM= 100% copy

Country/ Country. Tax ind /Tax Ind customer/tax code.

Its really taking the peace out of my life.

I have changed the pricing type as "G" in the copy control .

regards,

Amlan Sarkar

[Lakshmipathi · Accepted solution]

Dear Amlan

Go to V/06, select UTXJ and see what Access Sequence you have maintained. It should have been JIND.

Will try to keep on asking questions

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Dear Lakshmipathi ,

I have changed the Access to JDUM to JIND. But Still there is the problem of one or two condition types getting repeated.

strange thing which is happening is when I scroll up or down all the condition records are disappearing in the Billing item & header and Update terminate is hapenning

i am attaching the update terminate message

Update was terminated

*System ID.... MRD

Client....... 100

User..... PWC

Transaction.. VF01

Update key... BE944DDDC5AEF1338261001635B0CD06

Generated.... 09.07.2008, 14:25:50

Completed.... 09.07.2008, 14:25:50

Error Info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC*

i strongly now feel there is some technical problem with the VF01 transaction itsely?

I have taken many fresh order done all the transactions to billing but still the conditions are disappearing .

Thanks all of you for taking intrest in my problem I think it has to be posted to SAP.

Edited by: A. S. SAP SD on Jul 9, 2008 3:00 PM

[Lakshmipathi · Accepted solution]

Dear Amlan

Have u created a new sale order and billing after changing the Access sequence ?? If not, please try and if still problem persists, I feel you have to take it up with SAP, as whatever struck my mind, I have asked almost all questions.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Only one USER EXIT IS there.

I am attaching the code of the Userexit.

***INCLUDE RV60AFZC.

************************************************************************

• *

• This include is reserved for user modifications *

• Forms for invoicing *

• The name of modification modules should begin with 'ZZ'. *

• *

************************************************************************

• USEREXIT_NUMBER_RANGE_INV_DATE *

• USEREXIT_FILL_VBRK_VBRP *

************************************************************************

----

---

• FORM USEREXIT_NUMBER_RANGE_INV_DATE *

----

---

• This userexit can be used to determine the numberranges for *

• the internal document number. This userexit can be used when *

• the number_ranger should impact the invoice date via table *

• TVFKD. *

• If this userexit is active the USEREXIT_NUMBER_RANGE is not *

• processed anymore, that means this userexit has priority. *

• US_RANGE_INTERN - internal number range *

• This form is called from form LV60AU02 and LV60AU11 *

----

---

FORM USEREXIT_NUMBER_RANGE_INV_DATE USING US_RANGE_INTERN.

• Example: Number range from TVFK like in standard

• US_RANGE_INTERN = TVFK-NUMKI.

ENDFORM.

----

---

• FORM USEREXIT_FILL_VBRK_VBRP *

----

---

• This userexit can be used to fill fields in VBRK and VBRP *

• Be aware, that at this time the work areas KUAGV KURGV *

• KUWEV and KUREV are not filled. *

• This form is called from FORM VBRK_VBRP_FUELLEN. *

----

---

FORM USEREXIT_FILL_VBRK_VBRP.

• Example: change Tax country

• VBRK-LANDTX = T001-LAND1.

*{ INSERT MRDK900206 1

*if sy-tcode = 'VF01'.

• read table xkomv with key kschl = 'ZTOD'.

• if sy-subrc <> 0.

• clear xkomv.

• xkomv-kschl = 'ZTOD'.

• append xkomv.

• endif.

*endif.

*----Commented

• READ TABLE XKOMV WITH KEY KSCHL = 'ZTOD'.

• IF SY-SUBRC <> 0.

• CLEAR XKOMV.

• XKOMV-KSCHL = 'ZTOD'.

• APPEND XKOMV.

• ENDIF.

*----End of comment

*} INSERT

ENDFORM.

*eject

regards,

Amlan Sarkar

[Former Member · Accepted solution]

Dear All,

Thanks for your Valuable Help.

I could solve the Problem....The Problem was with My Userexit...

One Of the Feild was Appened twice.

Regards,

Amlan Sarkar

Edited by: EXPLORING MULTIDIMENSIONAL SAP on Aug 4, 2008 12:00 PM

[Former Member]

Thanks For your Help.

Regards,

Amlan Sarkar

[former_member184555]

Hi

Is it happening in the corresponding order also. Please check the order and see if the VPRS is determined more than once.

Thanks,

Ravi

[Former Member]

Dear Sankar Ravi

I have checked for more than 5 orders the VPRS condition is apperaring many times.

This is leading to UPdate terminate :

following Message.

Update was terminated

System ID.... MRD

Client....... 100

User..... PWC

Transaction.. VF01

Update key... 67EF4BDD1110F1F68261001635B0CD06

Generated.... 07.07.2008, 12:11:59

Completed.... 07.07.2008, 12:11:59

Error Info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

[Lakshmipathi]

Dear Amlan

Can you please confirm whether you r treating VPRS as a pricing condition type or only cost in your pricing procedure ??

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi,

It is general Costs conditions it does not have any Access attached. It is taking the price from the MMR.

Please suggest what is to be done.

In the Item Level I find 6-7 times the VPRS conditions are appearing.

Pricing type : G in Delivery to Billing copy control.

This is resulting in Update terminate.

regards,

Amlan Sarkar

[Lakshmipathi]

Dear Amlan

Not sure but please check the following

- In VOV7, for the item category, check whether [Determine Cost] is checked

- In V/06, for VPRS, ensure that following are maintained

Cond. class:::::::B

Calculat.type:::::C

Cond.category:::::G

Item condition::::X

Group condition:::(should be blank)

No Access sequence

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi

The VPRS is standard there is no change in it.

The following things are there I have checked.

Cond. class:::::::B

Calculat.type:::::C

Cond.category:::::G

Item condition::::X

Group condition:::(should be blank)

No Access sequence

Thanks,

Amlan Sarkar

[Lakshmipathi]

Dear Amlan

How about VOV7 which I asked you to check ??

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi,

The Determine Costs is checked.

It is all standard.

What else should I try.

regards,

Amlan

[Former Member]

I have gone through the analysis :

VPRS appearing 10 times says

" VPRS 216 Condition value has been taken from preceding document".

What should I do with This ?

regards,

Amlan Sarkar

[Former Member]

Hi Amlan

Could you please check if some routine is attached agains VPRS in your pricing procedure

Manu

[Former Member]

No routine is attached to VPRS condition type.

It is sub total B and requiremsnts 4.

The header of the Billing document ZIDS( Allias F2) is coming correctly but in the item Level It is getting repeated and Update Termanite problem is there.

regards,

Amlan Sarkar

[Former Member]

My billing is not getting Saved it says pricing error, ..in the copy control i have given the pricing type as G ....

from delivery to billing.

regards,

Amlan Sarkar