Transparent table storing details about Order/Contract Relationship

[former_member188001]

Hello all,

I want to know where I can find the data stored for the order/contract relationship. On the contract tab, I have 5 different contracts.

When I look at the Details Tab, I see one of the contract numbers coming there. This information can be seen in JHAGA table. But then what about the other 4 contracts ? Where are they stored ?

Thanks,

Salil

[Former Member · Accepted solution]

Hi,

Some Relevant Tables:

JHAK IS-M/AM: Order-Publishing-Media (Header Data)

JHAP IS-M/AM: Order-Publishing-Media (Item Data)

JHTVB IS-M/AM: Contract Requirements

JHTVKO IS-M/AM: Contract

JHTVPO IS-M/AM: Contract Item

JJTMXB IS-M: Media-Mix Package Element

JJTMXK IS-M: Media-Mix Package Header

JJTMXP IS-M: Media-Mix Package Element

Best Regards,

Chandramohan

[Former Member]

Hi Salil,

The relationship between contract and order(BDS level) is maintained in table contract access table JHTVABRUF.

This table is filled after contract determination.

Hope this information helps.

Regards

Suthan

[former_member188001]

Hi Suthan,

Thanks for the response. The table you suggested is helping me a bit. Now I have another question on the same scenario. Do you have any idea, as to where is the relationship stored between contract number and Valuation Key ie Condition Type ?

P.S. How are u doing ? Are u on AOL project with Sundar ?

Regards,

Salil

[former_member188001]

I think the problem is solved based on Suthans response.