How to find active contracts in table level (SRM)

[former_member288713]

Dear Friends,

How to find active contracts in SRM and which field indicate active flag in table level?,

Actually i want to display all active contracts by a report.

Thanks & Advance,

Srinivas

[former_member288713 · Accepted solution]

Hi Friends,

After more analysis on Neelima post i found that there is a field called VERSION_TYPE(BBP_PDHGP)

VERSION_TYPE field indicate about active contracts.

relationship of table like

CRMD_ORDERADM_H-GUID = BBP_PDHGP-GUID.

Thanks,

Srinivas

[former_member228602 · Accepted solution]

Hello Srinivas,

     The version_type field is specific to version that exists in SRM.This is to distinguish the version of the document is active,historical or change version. This does not specify the active contracts. For a single you can multiple version one of which will be active and any number of change and historical versions.

     I would suggest you use vper_end and additionally look for the statuses locked and deleted to get the exhaustive list.

Thanks and Regards.

Veera

[former_member288713 · Accepted solution]

Thanks Veeraraghavan  and I approached as same as the way you have mentioned above

I have completed my requirement,

Thanks to all

[venkatakrishna]

Hi,

select single * from crm_jest into wa_crm_jest
        where objnr =  guid of the contract
        and stat = 'I7202' ( System status texts table    TJ02T)
        and inact = '  '.

Regards,

Venkat

[Former Member]

Hi Srinivas,

Do you mean you want  to display all the contracts which have not expired.?

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

Regards

Neelima

[former_member288713]

Thanks Neelima,

As per your reply i understood that BBP_PDHGP & BBP_PDIGP table holds validity of Purchase Contracts data,

Your answer is helpful.

Thanks,

Srinivas P.