SD Pricing - Condition Technology
Example System: ER9
1, Related Concepts
Tcode: VA03
![](https://user-images.githubusercontent.com/5669954/59408942-b713ca00-8de7-11e9-8b55-e7d3d1608407.png)
![](https://user-images.githubusercontent.com/5669954/59408944-b713ca00-8de7-11e9-8752-4ddd1b816b46.png)
![](https://user-images.githubusercontent.com/5669954/59408945-b7ac6080-8de7-11e9-98b0-a4f675071f6e.png)
- How to determine Pricing Procedure?
The fourth condition: Document Pricing Procedure (related with order type(transaction type)
In this case, we use order type: OR as an example.
![](https://user-images.githubusercontent.com/5669954/59408953-b8dd8d80-8de7-11e9-8587-50f192e24376.png)
The fifth condition: Customer Pricing Procedure
![](https://user-images.githubusercontent.com/5669954/59408954-b9762400-8de7-11e9-90fe-5ee28c8064ab.png)
- How Pricing Procedure, Condition Type and Access sequence work?
One Pricing Procedure has multi Condition Types.
![](https://user-images.githubusercontent.com/5669954/59408955-ba0eba80-8de7-11e9-8a62-50cc7bc00b57.png)
We use Pricing Procedure (RVAA01), Condition Type (PR00), Access sequence (PR02) as an example to explain how it works.
![](https://user-images.githubusercontent.com/5669954/59408932-b4b17000-8de7-11e9-90da-e83df14af2fa.png)
System will follow steps from 10,20,30,40 to find the pricing one by one.
![](https://user-images.githubusercontent.com/5669954/59408933-b4b17000-8de7-11e9-9582-f269b1b56ca0.png)
Then what’s in the condition 10?
![](https://user-images.githubusercontent.com/5669954/59408934-b4b17000-8de7-11e9-8621-67ab959de6e6.png)
Then what’s in the condition 20? Then you can check every condition one by one.
![](https://user-images.githubusercontent.com/5669954/59408936-b54a0680-8de7-11e9-973d-984b10232d60.png)
- What’s the DB behind pricing procedure and pricing type?
Condition Table: each condition table mapping with one condition table, for example: A304
Conditions (Item): KONP
Key fields in table KONP:
Key1: KNUMH --Condition record number ( foreign key of Condition Table )
Key2: KOPOS --Sequential number of the condition
How to find underlying transparent table for condition table
One way: Condition table xxx mapping with DB table Axxx.
For example:
![](https://user-images.githubusercontent.com/5669954/59408938-b5e29d00-8de7-11e9-9b12-2e8d5a644255.png)
The second way:
![](https://user-images.githubusercontent.com/5669954/59408939-b67b3380-8de7-11e9-81f2-69ef6cdc9c70.png)
Then I perform a ST05 trace for Access sequence configuration activity and find two series of table T681* and T682*.
![](https://user-images.githubusercontent.com/5669954/59408940-b67b3380-8de7-11e9-8c79-4ff354269800.png)
In table T681 I find what I want: the field KOTAB stores the name of underlying transparent table to store records. Here field KVEWE A means Pricing, and KAPPL V means Sales & Distribution.
![](https://user-images.githubusercontent.com/5669954/59408941-b713ca00-8de7-11e9-9afa-0fb6b2fb5b0a.png)
you can create a report in ER9/001, and paste the following source code to debug:
cl_prc_result_factory=>get_instance( )->get_prc_result( )->get_price_element_db_by_key(
EXPORTING
iv_knumv = '0000069700'
IMPORTING
et_prc_element_classic_format = DATA(hkonv) ).
We will use this price API available in S4/HANA system in the future.
要获取更多Jerry的原创文章,请关注公众号"汪子熙":