Finding alternative Contract for same Vendor with a later Contract End Date

Question

I would like to find whether a follow up contract exists for a certain contract based on the vendor in the contract.

All data about the contracts is stored in Contract_Info

Contract Number: "CONTRACT_INFO"."CONTRACT_EBELN"

Contract Vendor: "CONTRACT_INFO"."LIFNR"

Contract Start: "CONTRACT_INFO"."TS_KDATB"

Contract End: "CONTRACT_INFO"."TS_KDATE"

What I would like to see is:

For “Contract Number A” give me “Contract Number B” matched on “Contract Vendor” when “Contract END A” < “Contract END B”

I have tried quite some PQL / PU function, however I am not able to get near to the data I want to see.

.14600103626 · Answer

Hi Mel,

The Easier way to do it in the data model .

select b.<Column_you_need_the_data>,

_case_key

From Contract_info A ,

Contract _info B -- Same table used twice ( Self join )

---- add table to get the case key

Where A.contract_vendor=B.contract_vendor

AND A.contract_end<b.contract_end;

Then link this table to the Process Data Model and Load ...

Then use the same to get what you need.

Hope this helps.

Regards

Ayan

Sign up