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


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s