Contract Rel Order-PO : Price change in contract

[former_member377111]

Hi,

Is there any std program to find:when i change the Contract Price , it will find all the PO releases impacted by the contract price change.

Also,

When I create a contract with Netprice as 10USD/PC.now, i create a contract release order, which is nothing but a PO.Now, the netprice in PO is adopted from the Contract as 10usd/pc.

I change the contract price as 9.60usd/pc. In this case, should i cancel the PO Created earlier(with 10usd/pc) and recreate another release order-PO, SUCH THAT THE NEW NETPRICE OF 9.6usd/pc gets reflected???

Pls help me on this!

Is there any std program to find:when i change the Contract Price , it will find all the PO releases impacted by the contract price change.

Regards,

N

Edited by: Neliea on May 28, 2008 10:52 AM

[former_member377111]

Hi,

I'm developing a report: i change the Contract Price , it will find all the PO releases impacted by the contract price change.

Pl help me to fetch the logic.

1. I want to fetch the Contract document/Line item firstly, for which there has been a Net price/unit/currency change.

2. Then, for that Contract No, the system should find all the related Contract rel Orders-The PO No/line item, which has been affected by this price change.

3. The selection screen Inputs will be Material/vendor/Plant/Pur Org/Document change date/Transaction code-ME32K,MEK1.(Hardcoded)/Document type(MK,WK).

The output will show old price, new price, old unit,new unit,old currency,new currency.

Can you pl help me fetch the logic for points 1 & 2, mainly-tables and fields.

Thanks in advance!

N

[Former Member]

Hi

I want to fetch the Contract document/Line item firstly, for which there has been a Net price/unit/currency change.

For this you need to use the CDPOS & CDHDR tables

use the table name EKPO & the relevant fields of Value

2. Then, for that Contract No, the system should find all the related Contract rel Orders-The PO No/line item, which has been affected by this price change.

Based on the Contract & Contract line item from the first step , use the data to retreive the Relase orders from Table EKAB - Release Documentation, fields KONNR - Number of Principal Purchase Agreement, KTPNR - Item Number of Principal Purchase Agreement.

check if the PO exits in EKBE, if PO exists no change in value. IF PO does not exists in EKBE, then Change the PO item net price .

Hope this helps...

Thanks & Regards

Kishore

[Former Member]

Hi

Once the release order or PO is created aginst a contrcat , the price changes in the Contrcat will not have any effect on the release order, as the PO is created before the Prices are changed, if you want to change the Prices as per the Contract, then you can Click on the Update icon in the Conditions tab of the PO, & click on Carry out new pricing

There is no standard program find the PO releases impacted by the contract price change.

[former_member377111]

Thank You,Kishore.

In case I need to develop a program to find all the PO Releases impacted by that Contract price change,

Pls help me wiyth the Tables-fileds and logic in general

[Former Member]

Hi

The Relase orders for a contract can be found out from table

EKAB Release Documentation

From here you can list down the Release orders & check the PO's which can get effected . The PO's whcih are Open will only be effected by the Price change

So using tables EKKO, EKPO, EKAB, EKBE you can derive the Logic

Thanks & Regards

Kishore