Contract Price table link

[Former Member]

Hi

What are the tables - fields that link Contract (ME33) and its price condition (MEK3 - PB00).

Thanks

MG

[Former Member · Accepted solution]

Hello Mariusz,

First table to find out the purchasing document (Contract in your case) - EKKO(Purchase document header) -> Pass your document type in field EKKO-BSART and find out your contract document, if you already know you contract document then pass your Purchase document no in table - A016 (Contract item) in the filed A016-EBELN and note down the condition record no A016-KNUMH (Note: if you have as many as line itme in contract document then you will get the same no of record in A016) say if you have three line item in contract then you will get the three record in the A016 filed by passing the contract document no in filed A016-EBELN. Now after getting the condition no from A016-KNUMH pass these condition no in KONP Conditions (Item) table under field - KONP-KNUMH and you will find out the value of each line item wise value of condition of contract document.

So following are the table you can use....

EKKO (Purchase document header) -> EKKO-BSART (Contract document type)

A016 (Contract item) -> A016-EBELN (Contract Document No) & A016-KNUMH (Condition record no)

KONP Conditions (Item) -> KONP-KNUMH (Condition record no)

Hope your query got solved.

Best Regards,

Silky

[former_member197616]

Hi,

I think KONP table will be useful.

Regards,

[Former Member]

Hello Mariusz,

you can find it out easily trough the customizing settings:

Please check in transaction OLME - Conditions - Define Price Determination Process - Define Condition Types which access sequence was assigned to your PB00 condition.

After that go to Define Access Sequences, check for this access sequence the accesses, which contain the tables you are looking for (like A016)....

Regards,

Edit