In what table in SRM can i see the purchasing contracts? We need to see "expired" contracts in the table. Please help.thanks a lot

[Former Member]

We are only seeing all contracts in table CRM_JEST with the corresponding GUID of the contracts, what we need to figure out is how does that table identify if it is already in expired status? Thanks a lot!

[laurent_burtaire · Accepted solution]

Hello,

using Contract header guid, you can check field VPER_END from BBP_PDHGP table.

Regards.

Laurent.

[Former Member · Accepted solution]

thanks..another thing, what is th program or BADI responsible in saving the contracts in table CRMD_JEST? thanks again!

[Former Member]

Hi Williams,

Hope these below threads would be useful in solving your queries -

1.     http://help.sap.com/saphelp_bw30b/helpdata/en/6c/8a568832e85d4082c306df14e7cbf1/content.htm

2.     http://scn.sap.com/thread/1930298

Thanks.

From RBEI,

Snehal

[Former Member]

Thanks a lot guys!

[Former Member]

Hi,

CRMD_JEST is the status table where entry will be created when a contract is turned into deleted status from Released. As Laurent mentioned VPER_END from BBP_PDHGP is the field to determine contract status whether it is released / expired.

Regards,

Govardhan