CRM Table(s) for Order Pricing

light111CRM Table that stores order pricing procedure and order item price conditions


If you look what is the pricing procedure determined for a order in CRM. Just get the transaction number and execute report – CRM_ORDER_READ

1

Get the header GUID.

2

3

Open the table – CRMD_LINK and provide the header GUID. Object Type-18  indicates pricing. Get the Guid Set. This Guid set [ type-18] is the pricing document number.

4

Open table – PRCD_HEAD and with the above GUID set search. The field KALSM provide the pricing procedure.

5

Table- PRCD_ITEM shows the details of item pricing.

6

Table- PRCD_COND shows all the price elements/price conditions of the item(s).

7


 

Leave a Reply