Active contracts for a Contract account

[Former Member]

Hi,

For a contract account i need to get the active contracts for the past 180 days. the contracts that have not moveed out.

whats the best way to pick the entries? any FMs available?

rgds.

[AmlanBanerjee · Accepted solution]

Hi

I don' t think there is any standard function module to retrieve the active contracts for a particular contract account.

I would recommend to build a query for your requirement using SQVI.

You need to query EVER table by giving contract account (VKONTO) as input.

Based on the fields Move-in Date(Field name-EINZDAT) and Move-out date (Field name-AUSZDAT) you will be able to retrieve the active contracts -

If AUSZDAT > Current Date, then it's an active contract.

You can use the move-in date to filter out the active contracts for a given period.

Hope it helps...

Thanks,

Amlan

Edited by: Amlan B on Nov 24, 2010 11:05 AM

Edited by: Amlan B on Nov 24, 2010 11:06 AM

[former_member442034]

Hi,

You can use the function module

ISU_ALL_CONTRACTS_OF_ACCOUNT

with following parameters

X_ACTUAL

X_COMMON_INVOICE

X_KEY_DATE

X_ACTIVE_ONLY

X_NO_DIALOG

X_AUTHORIZED_ONLY

As you see you can make flag X_ACTIVE_ONLY which will select only active contracts to the key date.

Best regards

Vlado