Here are more exercises on SAP Pricing for students of our SAP Training March 2011 Batch. This will complement other SAP Pricing Training exercises. As usual, refer back to the condition technique slideshow that has been discussed in the class to solve this exercise. The menu paths to configure all the pricing elements ( 7 steps ) is available at SAP Pricing Condition Technique Exercise
Pricing Master Data Required : The following master data needs to be created to complete this exercise. Please do not proceed further without successfully creating these. You can always refer back to the respective links to know more about creating them.
- Create a SAP Customer master exactly similar to 1400 – say 123456
- Create a new SAP Document Pricing Procedure. It’s just 1 character, so please ensure you don’t tread on other students.
- Create a new SAP Customer Pricing Procedure. Once again its just 1 character, so please be careful.
If you are confident you can use an existing pricing procedure, please use it.
Other Configuration : Please finish the following configuration as well.
- Create a new SAP Sales Document type ( as a copy of OR ) – say ZYYY
- Create a new SAP item category ( as a copy of TAN ) – say ZXXX
- Make sure the following combination exists .
- ZYYY + NORM = ZXXX
Business Scenario : ABC Computers wants to price its desktop range of products ( material group 00200 ) and has decided on the following Logic. All prices are in USD.
Logic : First pricing should be checked for Customer-Material Combination. If such a price is not found, then look for customer group specific price for the material ( ie. if the material is found under a certain customer group, then select that price list ). If such a price is also not found, then default to the Base Price List. Find below the examples of their price lists. Please understand that these Price lists are different from the SAP Pricelist type field in the SAP Customer Master.
Base Price List
Material | Price |
M-01 | 100 |
M-02 | 120 |
M-03 | 130 |
M-04 | 140 |
Customer Specific Price List
Material | Customer ( sold-to ) | Price |
M-01 | 1400 | 90 |
M-02 | 1400 | 100 |
M-03 | 1400 | 110 |
M-04 | 1400 | 120 |
SAP Customer Group Specific Price List
Material | Customer Group | Price |
M-01 | 01 | 95 |
M-02 | 02 | 85 |
M-03 | 03 | 80 |
M-04 | 04 | 130 |
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
- The SAP Pricing Condition type you have configured
- The SAP Access Sequence you have configured
- The SAP Pricing Condition tables you have configured
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
- Provide the SAP Pricing Procedure you have created
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
- Give the SAP Sales Order Number
- How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
Addendum :
How to find out the technical names in the SAP Condition Table
Sir,
While doing Pricing Condition Technique Practice Questions,
I created condition table 983.
Now I am trying to create access sequence ZA93, its showing red button beside sold-to-party field saying as “Select a document field for KUNAG”
Please see the attached screenshot and help me with that…
Regards,
Vikas
LikeLike
Check the Addendum in the blog that contains a link “How to find out the technical names in the SAP Condition Table” The fields you have chosen are wrong. Instead of KUNAG, choose KUNNR_V or KUNNR if you are looking for sold-to.
LikeLike
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
1. The SAP Pricing Condition type you have configured
ANS:- ZSR5
2. The SAP Access Sequence you have configured
ANS:- ZSR5
3. The SAP Pricing Condition tables you have configured
ANS:-
692- Customer/material
693- material/material group
691- material
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
1. Provide the SAP Pricing Procedure you have created
ANS:- ZSRI05
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
ANS:-
By assigning the following
100/10/00+~+S= ZSRI05 (Sales area+ DCUPP+CuPP = customer pricing procedure)
and also the condition records for condition tables (692- Customer/material,
693- material/material group,691- material) are maintained via vk11.
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
1. Give the SAP Sales Order Number
Ans:- Sales order # 16141
2. How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
ANS:- As per the pricing analysis the pricing procedure ZSRI05 is determined and price assigned to condition record (customer/material) was selected which was assigned to condition type ZSR5.
LikeLike
Perfect Answers Sri. Good job !
LikeLike
Hi Siva
I am having problems with the below exercise
I have completed the entire process but the pricing for Line item 10 is incorrect and for line items 20, 30 and 40 are not reflected.
An excel document with all the customisations done by me is attached for your perusal.
Can you please check and inform me.
Regards
Shiv
http://blog.magnatraining.com/wp-content/uploads/2011/03/prcing-exrecise1.xls
LikeLike
Hi Yogesh
I checked out the plant ZAUT. It was not available. As you can see below, there is no ZAUT Plant defined. Hence the error.
Can you email me the screenshot of the error that you get when you create the material master ?
Trainer
SAP Training
LikeLike
Hi Shiv
There is an issue with field level mapping in the Access Sequence. As you can see from the picture below ( SAP Pricing Analysis at the line item level of the sap sales order you mentioned ), fields for the Access sequence are missing.
I checked out the Access Sequence and found out that there were 2 problems in it.
1. The flag “Exclusive” is not checked. We have discussed the importance of it.
2. The fields have not been mapped. The tables 770,771 should all be grayed out if they would have been mapped. You would have seen me doing this as part of the demo in the class. All you have to do is select the condition table row and double-click on Fields in the left.
You will get a warning message like so but you can ignore it.
I did not save it – so go ahead and play with it and do the changes as specified. Please comment if you have questions. Also, going forward, please use the forum to post your questions. If there is a file to be attached , you can send me the same.
Good luck with the exercise.
LikeLike
Sir,
I have completed all the steps mentioned in the Pricing Exercise. But when I am creating Standard Order, its not reflecting pricing for any of the line items.
Please see it once. Attached is the excel sheet with customization details. I tried to do the analysis but I was not able to understand the problem.
Please help me with that.
http://blog.magnatraining.com/wp-content/uploads/2011/03/prcing-exrecise-2.xls
Regards
Vikas
LikeLike
Configuration:
Customer Master – 4040
Doc Pricing Proced – $
Cust Pricing Proced – &
Sales Doc – RMOR
Item Cat – RMIC
RMOR + NORM = RMIC – Done
QUESTION 1:
1. Pricing Condition Type – ZAPR
2. Access Sequence – ZROJ
3. Pricing Condition Tables:
879 – Cust/Material
894 – Material/Mat Grp
895 – Material
QUESTION 2:
1. Pricing Procedure – ZAPRIL
QUESTION 3:
OVKK > 1000 > 10 > 00 > $ > & > ZAPRIL > ZAPR
QUESTION 4:
1. Order# 16158
2. VA03 > Highlight line item > Select ‘Item Conditions’ > my condition type ‘ZAPR’ appears with the correct pricing I provided via VK11
LikeLike
Answers:
Create a SAP Customer master exactly similar to 1400: Created 99991 (1000/10/00)
Create a new SAP Document Pricing Procedure. It’s just 1 character: Created ‘ ” ‘
Create a new SAP Customer Pricing Procedure. It’s just 1 character: Created ‘^’
Other Configuration :
Create a new SAP Sales Document type ( as a copy of OR ) – Created ZORV
Create a new SAP item category ( as a copy of TAN ) – Created ZTAV
ZORV + NORM = ZTAV
Condition tables created: 606/ 607/ 608
Access Sequence created ZA67
Condition Type: PR66
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following:
Ans:
The SAP Pricing Condition type you have configured: PR66
The SAP Access Sequence you have configured: ZA67
The SAP Pricing Condition tables you have configured: 606 (Customer Specific), 607 (Material Group Specific), 608 (Material/ Base Price)
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above. Provide the SAP Pricing Procedure you have created:
Ans: RVAA66
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
Ans:
Configured Customer Pricing Procedure for customer 99991 to ^ (Done via transaction XD02)
Pricing procedure Determination: SOrg 1000/ DChl 10/ Dv 00/ DoPr “/ CuPP ^/ PriPr RVAA66/ CTyp PR66
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
Give the SAP Sales Order Number
How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
Ans:
Created order 16159, click ‘item condition’ by selecting the desired line item.
Condition type PR66 appears to be correct with correct pricing.
LikeLike
1) Created 3 condition tables :
Material – 766
Customer/Material – 767
Material Group – 768
2) Created two access sequences
ZB13 – Has only Material (766)
ZB14 – Has both 767 (marked as exclusive) and 768
3) Created two condition types
ZB13 – Copied from PROO. No alterations. Access sequence set to ZB13
ZB14 – Copied from PROO. Changed condition class to Discount and Calculation type to Fixed Value
Also changed the Plus/Minus to Negative. Access Sequence set to ZB14
4) Defined a pricing procedure ZBGN00 copied from RVAA01. Listed three entries
2 – ZB13
4 – ZB14
5 – Just a total from 2 to 4
5) Created a new Doc and Cust. pricing procedure (&). Also created a new Document ZGPN from OR
6) Created 2 new customers 63 and 64
7) Assigned pricing procedure 1000,10,00 + & + & = ZBGN00
8) Since M-01 thru M-04 are under the same material group 00207, created a new material X-01 copying from M-01.
Assigned X-01 under a different material group 00200
9) Condition record
For ZB13 – M-01 thru M-04 (€ 100, 120, 130, 140) and X-01 (€230)
For ZB14 – Customer/Material, 63/M-01 thru M-04 (€ 10, 20, 20, 20), X-01 (€19)
– Material Group, 00207 (€13)
10) Created 4 sales orders
13357 – With customer 63, material M-01 thru M-04
13358 – With customer 64, material M-01 and M-02
13359 – With Customer 63, material X-01
13360 – With Customer 64, material X-01
LikeLike
By the way I didnt create that icon with coolers. It must have got transferred from my word document. If at ll I had to put some icon it should ve been a head with no hair.
LikeLike
no worries. makes the site look cool as well 🙂 thanks for that
LikeLike
Scenario 1 :
The SAP Pricing Condition type you have configured
Ans:Z928
The SAP Access Sequence you have configured
Ans:Z928
The SAP Pricing Condition tables you have configured
Ans:928,929,931
Scenario 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above.Provide the SAP Pricing Procedure you have created
Ans: Z928PR
Scenario 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is
created, the pricing procedure will be determined. List the configuration to do the same below.
Ans: Pricing Procedure is assigned to Sales area plus Cust. Pric. Proc. plus Doc. Pric. Proc.
Scenario 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
Give the SAP Sales Order Number
Ans:Standard Order 14355 has been saved
How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
Ans: Double click on item and check conditions tab.
Addendum :
How to find out the technical names in the SAP Condition Table
Ans: By clicking the technical view
LikeLike
cust – 30006
doc p.pro – 7
cust p.pro- 7
s.doc.typ – ZORD
Item cat – ZTN6
tables – 979 (cus+mat), 981 (mat+ mat grp), 982 (mat)
acc seq – Z979
con typ – Z979
p.proc – Z979PR and then updated C.typ PR00 to Z979
P. proc determination added.
Cond records -using VK11 for cus+mat, mat+ mat grp, mat
S.order – 14404 cust 30006, priced picked correctly from (cust+mat)
S.O – 14405 create for differnt cust 30003, pricing was pulled
from correct condition recards( mat table)
S.O – 14406 created for differnt cust 30003, m-02 ( mat grp-
00207),price picked form condition recards (mat+mat grp table.)
LikeLike
customer 78787 created
sales doc type zkor created
Item category zkan created
doc pricing proce +
customer pricing proc 7
tables 751(material),752(material+customer) and 753 (material+material group) created
access table z751 created
condition type z751 created
LikeLike
zkka01- pricing procedure
LikeLike
created order no 14409 and 14410 but could not get the prices .Pl look into it and tell me where i am wrong
LikeLike
PRICING EXERCISE
Create a SAP Customer master exactly similar to 1400 – say 123456
Answer: 55667
Create a new SAP Document Pricing Procedure. It’s just 1 character, so please ensure you don’t tread on other students.
Answer: ” 3 ” wp pricing
Create a new SAP Customer Pricing Procedure. Once again its just 1 character, so please be careful.
Answer: ” 3 ” store customer
If you are confident you can use an existing pricing procedure, please use it.
Other Configuration : Please finish the following configuration as well.
Create a new SAP Sales Document type ( as a copy of OR ) – say ZYYY
Answer: Sale Doc Type ZSM1
Create a new SAP item category ( as a copy of TAN ) – say ZXXX
Answer: Item category YSM1
Make sure the following combination exists,
ZYYY + NORM = ZXXX
Answer: ZSM1 + NORM = YSM1
Condition Technique
1. Condition Table – Tcode: V/03
776-condition table ABC computers sales area, material
777-condition table ABC computers salea area, customer, material
778-condition table ABC computers salea area, material, material group
2. Access Sequence – Tcode: V/07
Answer Acces Sequence = ZABC
3. Condition Type – Tcode V/06
Answer: ZABP
4. Pricing Procedure – Tcode V/08
Answer: ZABCCP pricing procedure assign the condition type ZABP
5. Assign procing procedure to sales document type – Tcode OVKK
Answer sales Area + Doc PP + Customer PP = Pricing Procedure
1000-10-00 + 3 + 3 = ZABCCP
6. Condition Condition – This job is preformed by the end user – Tcode VK11
Answer Condition type zABP—–Material
Material
M-01———-100
M-02———-120
M-03———-130
M-04———-140
Creating a sales order using ” ZSM1 ”
Customer 55667
sales Order 13338
—————————————————–
Customer Specfic Price List
Answer Condition type ZABP——–Material / Customer
Material Customer
M-01————-55667————90
M-02————-55667————100
M-03————-55667————110
M-04————-55667————120
Creating a sales order using ” ZSM1 ”
Customer 55667
sales Order 13339
—————————————————–
—————————————————–
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the
SAP Pricing Condition tables that can cater to the scenario above and provide the following
A.The SAP Pricing Condition type you have configured
Answer: ZABP
B.The SAP Access Sequence you have configured
Answer: ZABC
C.The SAP Pricing Condition tables you have configured
Answer: 776 — 777 — 778
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
A.Provide the SAP Pricing Procedure you have created
Answer: ZABCCP Pricing Procedure
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of
type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
Answer: Sale Area + Doc PP + Customer PP = Pricing Procedure
1000–10-00 + 3 + 3 = ZABCCP,
where sales order ZSM1 and custoemr 55667
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
A.Give the SAP Sales Order Number
Answer: 13338 and 13339
B.How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction
Answer: Go to the Condition view and click Analysis (Price Log)
Question 5 : How to find out the technical names in the SAP Condition Table
Answer : In the create condition table field overview screen on the menu path there Technical View option which gives you technical names
LikeLike
Customer No-67754 and 98768
Sales doc type ZDPR
SAP item category ZGP2
Condition table-
A875 SALES AREA + CUSTOMER + MATERIAL
A876 SALES AREA + MATERIAL GROUP + MATERIAL
A877 SALES AREA + CUSTOMER + MATERIAL
ACCESS SEQUENCE-ZGD2 as per following
10 A875 SALES AREA + CUSTOMER + MATERIAL
20 A876 SALES AREA + MATERIAL GROUP + MATERIAL
30 A877 SALES AREA + CUSTOMER + MATERIAL
COND TYPE—ZD82
PRICING PROCEDURE ZGPRC
ZGPRC IS ASSIGNED TO 1000+10+00+A+A
14370/ZDPR is created for the customer 67754–it is talking the correct price as per the customer
14378/ZDPR is created for the customer 98768 –it is taking the price from mat group/material and base price.
M-01=======price from base price as the mat group was different
M-02=======price from mat group/material as the material group for the material was as per the set u;p
By going to the Analysis tab, one could see the pricing procedure being picked up.
LikeLike
◦Create a SAP Customer master exactly similar to 1400.
ANSWER : Customer 12125
◦Create a new SAP Document Pricing Procedure. It’s just 1 character, so please ensure you don’t tread on other students.
ANSWER : Customer Pricing procedure ” $ ” is Created.
◦Create a new SAP Customer Pricing Procedure. Once again its just 1 character, so please be careful.
ANSWER : Customer Pricing procedure ” T ” is Created.
Other Configuration : Please finish the following configuration as well.
◦Create a new SAP Sales Document type ( as a copy of OR ) – say ZYYY.
ANSWER : New Document Type ” ZAWA ” is Created.
◦Create a new SAP item category ( as a copy of TAN ) – say ZXXX.
ANSWER : New Item category ” ZOOO ” is created.
◦Make sure the following combination exists .
◦ZYYY + NORM = ZXXX
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
A.The SAP Pricing Condition type you have configured
ANSWER A: Pricing Condition Type ” YAAZ ” is created.
B.The SAP Access Sequence you have configured
ANSWER B: Access Sequence ” ZORE ” is created
C.The SAP Pricing Condition tables you have configured
ANSWER C: Condition Tables A541, A542 and A543 are created.
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
A.Provide the SAP Pricing Procedure you have created
ANSWER Q2: Pricing Procedure ” Zahid3″ is created.
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
ANSWER Q3: Zahid3 is created.
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
A.Give the SAP Sales Order Number
ANSWER A: Order # 14418
B.How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
ANSWER B: Go to the header of the order and click on to the sales tab there u can
see pricing procedure ZAHID3.
LikeLike
Siva Sir,
My order # 14418 is picking up my pricing condition YAAZ but it is giving me the error message as follows
“Pricing Error: Mandatory Condition MWST is missing. I have gone back to my Pricing Procedure and have seen MWST under the controls…but I have not been able to figure it out.
I know that MWST is about out put tax. Plz help me whenever u can.
Thanks
LikeLike
Siva Sir,
My order # 14418 is picking up my pricing condition YAAZ but it is giving me the error message as follows
“Pricing Error: Mandatory Condition MWST is missing”.
I have gone back to my Pricing Procedure and have seen MWST under the controls…but I have not been able to figure it out.
I know that MWST is about out put tax. Plz help me whenever u can.
Thanks
LikeLike
◦Create a SAP Customer master exactly similar to 1400 – say 123456
ANSWER: Customer ” 20205 ” is created by copying 1400
◦Create a new SAP Document Pricing Procedure. It’s just 1 character, so please ensure you don’t tread on other students.
ANSWER : New Document Pricing Procedure ” # ” is created
◦Create a new SAP Customer Pricing Procedure. Once again its just 1 character, so please be careful.
ANSWER : New Customer Pricing Procedure ” # ” is created
◦Create a new SAP Sales Document type ( as a copy of OR ) – say ZYYY
ANSWER : ” YAAR ” is created
◦Create a new SAP item category ( as a copy of TAN ) – say ZXXX
ANSWER : ” ZAYO ” is created = YAAR + NORM
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
A.The SAP Pricing Condition type you have configured
ANSWER: Condition type ” PROV ” is created
B.The SAP Access Sequence you have configured
ANSWER: Access Sequence ” Z514 ” is created
C.The SAP Pricing Condition tables you have configured
ANSWER: These pricing tables are Created A531,A532 and A533
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
A.Provide the SAP Pricing Procedure you have created
ANSWER 2: New Pricing Procedure ” Zahid4 ” is created
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
ANSWER 3: Sales Org = 3000
Dist. Channel = 10
Division = 00
doc.Pric.proc = #
Cust. pric.proc = #
Pricing Procedure = Zahid4
Condition Type = PROV
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
A.Give the SAP Sales Order Number
ANSWER A: Order # 14424
B.How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
ANSWER B: Pricing Procedure Zahid4 was given the Condition type PROV that was
assigned the condition table(material/customer) which is picked up by the order type
YAAR.
LikeLike
HI SIVA, PLEASE CHECK MY ANSWERS AND NEED SOME EXPLANATION ON HOW TO DO VK11 FOR DIFFERENT MATERIAL GROUPS FOR DIFFERENT MATERIALS?
I HAVE DONE THAT WITH USING SAME MATERIAL GROUP FOR M-01 , M-02, M-03 , M-04. REST OF THE STUFF IS FINE WITH ME.
ANSWERS:
1) CREATED CUSTOMER 61625 COPIED FROM 1400
2) CUSTOMER PRICING PROCEDURE CREATED: 7
3)DOCUMENT PRICING PROCEDURE CREATED: &
4) NEW DOCUMENT TYPE CREATED : ZJOR
5) NEW ITEM CATEGORY CREATED : ZTA
6) ZJOR+NORM= ZTA
7) fOLLOWING CONDITION TABLE HAS BEEN CREATED
A622: CUSTOMER/ MATERIAL
A623: mATERIAL GRUP/MATERIAL
A624: MATERIAL
8) ACCESS SEQUENCE: Z82 ASSIGN ALL THE TABLE
10 : 622
20 : 623
30: 624
9) condition type created from PR00: Z821 ALSO ASSIGNED ACCESS SEQUENCE Z82 WITH IT.
10) PRICING PROCEDURE: Z8210 CREATED
11) PRICING PROCEDURE DETERMINATION:
1000+10+00+&+7=Z8210= Z821
12) END USER’S TRANSACTION VK 11
Z821
1)FOR CUSTOMER : 61625
M-01: 90, M-02: 100, M-03: 110, m-04:140 . SALES ORDER CREATED 14509/ZJOR CORRECT PRICE DETERMINED
2*) Z821
MATERIALGROUP: 00200(USED M-04 GO TO THE M-02 AND CHANGED BASIC DATA OR CREATE NEW MATERIALBY COPYING M-02)
MATERIAL:
M-01; 95, m-02: 85, M-03: 80, M-04:130
ORDER CREATED : 14511/ZJOR. CORRECT PRICE DETERMINED.FOR CUSTOMER 61624.
3*) z821
Material Base price for 61624(assigned customer pricing doc type)
M-01:100, M-02: 120, M-03:130, M-04:140
SALES ORDER CREATED: 14510/ZJOR. CORRECT PRICE DETERMINED
QUESTION: HI SIVA, HOW WOULD I USE VK11 FOR DIFFERENT MATERIAL GROUP ? I AM BIT CONFUSED IN THAT.
LikeLike
Create a SAP Customer master exactly similar to 1400 – say 123456
ANSWER: Customer ” 000001503 ” is created.
◦Create a new SAP Document Pricing Procedure. It’s just 1 character, so please ensure you don’t tread on other students.
ANSWER : New Document Pricing Procedure ” ¬ ” is created
◦Create a new SAP Customer Pricing Procedure. Once again its just 1 character, so please be careful.
ANSWER : New Customer Pricing Procedure ” ¬” is created
◦Create a new SAP Sales Document type ( as a copy of OR ) – say ZYYY
ANSWER : ” ZEVI ” is created
◦Create a new SAP item category ( as a copy of TAN ) – say ZXXX
ANSWER : ” ZEVI ” is created = ZEVI + NORM
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
A.The SAP Pricing Condition type you have configured
ANSWER: Condition type ” ZEVI ” is created
B.The SAP Access Sequence you have configured
ANSWER: Access Sequence ” ZEVI ” is created
C.The SAP Pricing Condition tables you have configured
ANSWER: These pricing tables are Created A835, A836 and A737
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
A.Provide the SAP Pricing Procedure you have created
ANSWER 2: New Pricing Procedure ” ZEVI01 ” is created
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
ANSWER 3: Sales Org = 1000
Dist. Channel = 10
Division = 00
Doc.Pric.proc = ¬
Cust. pric.proc = ¬
Pricing Procedure = ZEVI01
Condition Type = ZEVI
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
A.Give the SAP Sales Order Number
ANSWER A: Order # 25039
B. How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
ANSWER B: Pricing Procedure Zahid4 was given the Condition type ZEVI that was
assigned the condition table(material/customer) which is picked up by the order type
ZEVI.
LikeLike
Have redone again for ZSIG01 procedure without discount or freight. Havent tried limit of manual price setting.
Create a SAP Customer master exactly similar to 1400 – say 123456
o Ans: 1505 Created
o Create a new SAP Document Pricing Procedure
o Ans: N Created and assigned to ZSIG
o Create a new SAP Customer Pricing Procedure.
o Ans: N Created and Assigned to 1505
If you are confident you can use an existing pricing procedure, please use it.
Other Configuration : Please finish the following configuration as well.
o Create a new SAP Sales Document type ( as a copy of OR ) – say ZYYY
o Ans: ZSIG Created
o Create a new SAP item category ( as a copy of TAN ) – say ZXXX
o Ans: ZSIG
o Make sure the following combination exists .
o ZSIG + NORM = ZSIG + Manual ones…..
o
Business Scenario : ABC Computers wants to price its desktop range of products ( material group 00200 ) and has decided on the following Logic. All prices are in USD.
Logic : First pricing should be checked for Customer-Material Combination. If such a price is not found, then look for material group specific price for the material ( ie. if the material is found under a certain material group, then select that price list ). If such a price is also not found, then default to the Base Price List. Find below the examples of their price lists. Please understand that these Price lists are different from the SAP Pricelist type field in the SAP Customer Master.
Base Price List
Material Price
M-01 100
M-02 120
M-03 130
M-04 140
Customer Specific Price List
Material Customer ( sold-to ) Price
M-01 1400 90
M-02 1400 100
M-03 1400 110
M-04 1400 120
SAP Material Group Specific Price List
Material Material Group Price
M-01 00103 95
M-02 00207 85
M-03 00200 80
M-04 00200 130
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
The SAP Pricing Condition type you have configured
Ans: ZSIG
The SAP Access Sequence you have configured
Ans: ZSIG
10 835 Customer/Material
20 939 Material/Matl Group
30 938 Material
The SAP Pricing Condition tables you have configured
Ans: 835 Customer/Material
939 Material/Matl Group
938 Material See Above
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
Ans: Pricing Procedure ZSIG01 Created from RVAA01.
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZSIG is created, the pricing procedure will be determined. List the configuration to do the same below.
Ans: 1000 + 10 + 00 + N + N = ZSIG01 Determined.
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
3. Sales Order 25042 Created.
4. How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction ?
I created condition records for M-02, M-03 and M-04 in a way that in case on M- 02 it fails in Sequence 10, 20 but picks 30, in case of M-03, fails in sequence 10, but gets at 20 and in case of M-04 gets the pricing record at sequence 10. I checked the item level condition records and the analyzed for confirmation. It all works perfect.
LikeLike
Siva,
Can you take a look at cust 25002 and try changing the CPP to
? ( Ravi CPP). It shows up possible list of values and but when I
select it, the field is still empty and keeps prompting me
to fill in the Pricing Procedure field. I am not able to save the Customer
Master with the new PP.
Thanks,
Ravi
LikeLike
Looks like “?” is a reserved character. I just saw it in the error message. Try to use another character.
LikeLike
Hi Siva,
When I Input stocks in the plant, I get the following error:
“Account determination for entry INT GBB ____ BSA 7920 not possible:
Plz help me out….details are:
Plant: 9090
Storage location: 9090
Materials: HN-01, HN-02, HN-03 & HN-04
Your help is appreciated!
LikeLike
Siva,
Can you please check the pricing for sales order (OR) 25131 and for M-04 there is scale based price for PR00 as follows
01 – £200
10 – £180
20 – £160
100 -£150.
I wanted to achieve for order quanity 100 to pickup the price £150, but insteas it is bring PR00 4 Times in the condition view of item pricing. Where it is going wrong siva?
LikeLike
In relation to 25131, I tried group condition and changing scale basis values in CT and other value combinations. Please advise.
LikeLike
Hi Siva,
The following link is not working, can you please fix it.
How to find out the technical names in the SAP Condition Table
http://blog.magnatraining.com/2011/03/16/how-to-createchange-sap-pricing-condition-tables-sap-training-march-2011-batch/
Thanks,
Mital
LikeLike
done. Thanks for the corrections Mital.
LikeLike
Hi Siva,
Pricing Master Data Required: The following master data needs to be created completing this exercise. Please do not proceed further without successfully creating these. You can always refer back to the respective links to know more about creating them.
• Create a SAP Customer master exactly similar to 1400 – say 123456
• Create a new SAP Document Pricing Procedure. It’s just 1 character, so please ensure you don’t tread on other students.
• Create a new SAP Customer Pricing Procedure. Once again its just 1 character, so please be careful.
If you are confident you can use an existing pricing procedure, please use it.
Answer: Go to XD01 and created new customer 9904 (As a Copy of 1400) – 1000/10/00, company code -1000 customers. Account group: 0001
Go to VOK0 and created Document pricing procedure:”@” and customer pricing procedure: “N”
Other Configuration: Please finish the following configuration as well.
• Create a new SAP Sales Document type (As a Copy of OR ) – say ZYYY
• Create a new SAP item category ( as a copy of TAN ) – say ZXXX
• Make sure the following combination exists .
• ZYYY + NORM = ZXXX
Answer: Go to VOV8 and created new sales Document type “ZYMR” (As a Copy of “OR”)
Go to VOV7 and created new item category “ZXM” (As a Copy of “TAN”)
Go to SPRO-IMG-Sales and Distribution-Sales-Sales Documents-Sales Document item-Assign Item Category- “ZYMR”+”NORM”=”ZXM”
Business Scenario : ABC Computers wants to price its desktop range of products ( material group 00200 ) and has decided on the following Logic. All prices are in USD.
Logic : First pricing should be checked for Customer-Material Combination. If such a price is not found, then look for material group specific price for the material ( ie. if the material is found under a certain material group, then select that price list ). If such a price is also not found, then default to the Base Price List. Find below the examples of their price lists. Please understand that these Price lists are different from the SAP Pricelist type field in the SAP Customer Master.
Base Price List
Material Price
M-01 100
M-02 120
M-03 130
M-04 140
Customer Specific Price List
Material Customer ( sold-to ) Price
M-01 1400 90
M-02 1400 100
M-03 1400 110
M-04 1400 120
SAP Material Group Specific Price List
Material Material Group Price
M-01 00103 95
M-02 00207 85
M-03 00200 80
M-04 00200 130
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
1. The SAP Pricing Condition type you have configured
Answer: Go to VOK0 and under condition type created new condition type: “Z949” (As a Copy of “PROO”) and assign Access sequence “Z949” to it.
2. The SAP Access Sequence you have configured
Answer: Go to VOK0 and under condition type created new Access sequence: “Z949” and assign three condition tables as follow “A949”, “A953” and “A954”
3. The SAP Pricing Condition tables you have configured
Answer: Go to VOK0 and under environment and condition table- created new condition table: “A949” (Customer/Material), “A953” (Material/Material Group) and “A954” (Material”)
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
1. Provide the SAP Pricing Procedure you have created
Answer: GO to VOK0 and under pricing procedure – created new pricing procedure “Z94901”and configure condition type”Z949” in control section under procedure section.
Also under pricing procedure go to pricing determination and configure 1000/10/00 (sales org., dist. Chan and division), Document pricing procedure:”@”, customer pricing procedure: “N”, pricing procedure “Z94901” and condition type “Z949”.
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 123456, when a sales order of type ZYYY is created, the pricing procedure will be determined. List the configuration to do the same below.
Answer: Go to XD02 and modify customer 9904 – go to sales area data and under sales tab – assign customer pricing procedure “N”
Go to VOV8 and modify document type “ZYMR” – Assign document pricing procedure “@”.
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
1. Give the SAP Sales Order Number
Answer: Sales order: 13404
2. How did you determine in the transaction that the pricing procedure you have configured is being used in the transaction?
Answer: Go to Line item level – condition tab – you can see condition type “Z949” and if you want to analysis than click on analysis button. And it will take you to condition analysis screen and you can find pricing procedure “Z94901” with other details information like which condition table use for pricing etc.
Thank,
Mital
LikeLike
Siva,
I am doing something wrong here. I created the condition tables 947 (using the existing ones), 959 and 960. Now I have created an access key ZMKP and assigned the tables to this. When I tried to see the assigned fields it says that the field assignment is not made. Can you help me where I went wrong. Appreciate your help.
Murali
LikeLike
I think it was a warning and I pressed enter and it took care of itself. Please correct me if I have done anything wrong.
LikeLike
You have absolutely done the right thing. I hope you remember from the class that Access Sequence in Pricing is a 2 step hierarchical structure – In the second step when the field assignment is made initially, you get the warning, You just have to press enter to ignore it. You will not get it again once the assignments are done.
LikeLike
Question 1 : Configure an SAP Pricing Condition type and corresponding SAP Access Sequence and associate it to the SAP Pricing Condition tables that can cater to the scenario above and provide the following
The SAP Pricing Condition type you have configured — ZMK2
The SAP Access Sequence you have configured — ZMKP
The SAP Pricing Condition tables you have configured — 947,960,959
Question 2 : Configure a new SAP Pricing Procedure and include the configuration you have done on Q.1 above
Provide the SAP Pricing Procedure you have created — ZMKPR2
Question 3 : Configure the SAP Pricing Procedure Determination so that for Customer 62, when a sales order of type ZPR1 is created, the pricing procedure will be determined. List the configuration to do the same below.
Question 4 : Create an SAP Sales Order and ensure that the pricing procedure has been determined
Give the SAP Sales Order Number 13905
The pricing procedure is determined.
LikeLike
Existing customer pricing procedure ‘A’ is used and created a new doc pricing procedure ‘(symbol single quote)
Created a SAP Customer Master exactly similar to 1400 -> 126 and has cust.pp – A
Created a new document type – ZBCO copy of OR and has doc.pric.proc ‘
Created a new Item category ZBCO copy of TAN and assigned item category for ZBCO doc type + Item cat group NORM.
Created condition tables for Basic Material pricing list, Customer/Material pricing list, Material/Material group
937 – Condition table – Material
938 – Condition table – Material/Customer
943 – Condition table – Material/Material group
ZBPL – Access sequence created with all above condition tables
ZBPL – Condition type (copy of PR00) created and assigned the above sequence
ZBPL01 – Pricing procedure for the condition type ZBPL
A – cust.pp , ‘ – doc.pp are used
Determined pricing procedure for sales area 1000/10/00, A (cpp), ‘ (dpp) with ZBPL01 and condition type ZBPL
Saved condition records for mat/material group (0207) m-01 material a price of 20.00 eur
Now created an order – 14186 for material m-01. Pricing 20.00 eur of mat/mat group combination which has item cat ZBCO and pricing condition type ZBPL is determined, since there are no mat or cust/mat pricing records.
From analysis of condition records, we can determine what the pricing procedure has been determined.
Again created a condition record for Cust/Material combination for condition type ZBPL – of price per unit 33.00 eur
Now created 14187 another order for m-01, since the sequence of cust/mat has precedence over a mat/mat group, cust/mat pricing is determined.
LikeLike
Hi Siva,
Does changing a condition table for which a price determination is already done and a sales order is created but not yet invoiced. Will affect the pricing determination in this case when the condition table is modified?
Regards,
Raghava
LikeLike