SAP SD Pricing - Condition Technology

简介: SAP SD Pricing - Condition Technology

Example System: ER9

1, Related Concepts

Tcode: VA03

image.pngimage.png

How to determine Pricing Procedure?


image.pngimage.pngimage.png

The fourth condition: Document Pricing Procedure (related with order type(transaction type)

In this case, we use order type: OR as an example.


image.png


The fifth condition: Customer Pricing Procedure



image.png

How Pricing Procedure, Condition Type and Access sequence work?

One Pricing Procedure has multi Condition Types.


image.png

We use Pricing Procedure (RVAA01), Condition Type (PR00), Access sequence (PR02) as an example to explain how it works.



image.png

System will follow steps from 10,20,30,40 to find the pricing one by one.


image.png


Then what’s in the condition 10?


image.png


Then what’s in the condition 20? Then you can check every condition one by one.


image.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:


image.png

The second way:


image.png


Then I perform a ST05 trace for Access sequence configuration activity and find two series of table T681* and T682*.



image.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.



image.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.


相关文章
|
6月前
|
SQL 数据建模 Serverless
SAP CDS view 的 having Condition 用法
SAP CDS view 的 having Condition 用法
40 0
SAP WM&SD集成之Copy WM Quantity – Not Copy WM qty as delivery qty into delivery But PGI
SAP WM&SD集成之Copy WM Quantity – Not Copy WM qty as delivery qty into delivery But PGI
SAP WM&SD集成之Copy WM Quantity – Not Copy WM qty as delivery qty into delivery But PGI
SAP WM&SD集成之Copy WM Quantity – Copy WM qty as delivery qty into delivery and PGI
SAP WM&SD集成之Copy WM Quantity – Copy WM qty as delivery qty into delivery and PGI
SAP WM&SD集成之Copy WM Quantity – Copy WM qty as delivery qty into delivery and PGI
SAP WM&SD集成之Copy WM Quantity – Copy WM qty as delivery qty into delivery
SAP WM&SD集成之Copy WM Quantity – Copy WM qty as delivery qty into delivery
SAP WM&SD集成之Copy WM Quantity – Copy WM qty as delivery qty into delivery
SAP SD VL02N对STO的交货单执行PGI,报错 -Fld selectn for mvmt type 643 acct 400020 differs for Business Area –
SAP SD VL02N对STO的交货单执行PGI,报错 -Fld selectn for mvmt type 643 acct 400020 differs for Business Area –
SAP SD VL02N对STO的交货单执行PGI,报错 -Fld selectn for mvmt type 643 acct 400020 differs for Business Area –
SAP ME12 修改采购信息记录,系统提示:Condition type P000 does not allow supplementary conditions
SAP ME12 修改采购信息记录,系统提示:Condition type P000 does not allow supplementary conditions
SAP ME12 修改采购信息记录,系统提示:Condition type P000 does not allow supplementary conditions
SAP SD交货单凭证流里的Confirmation of Service初探 II
SAP SD交货单凭证流里的Confirmation of Service初探 II
153 0
SAP SD交货单凭证流里的Confirmation of Service初探 II
SAP SD交货单凭证流里的Confirmation of Service初探
SAP SD交货单凭证流里的Confirmation of Service初探
SAP SD交货单凭证流里的Confirmation of Service初探