SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

function module to determine the credit balance or if there is an open ite

Former Member
0 Kudos

Hi All ,

Can anyone please let me is there any function module to determine the credit balance orr if there is an open standing request / open standing request /paid but not yet refunded security deposit .

Requirement :

Purpose -This report shows a list of u201Cinactiveu201D contract accounts and the amounts to be refunded (credit balance, paid security deposit) to customers. This report also shows any open standing requests in customersu2019 contract accounts.

Note: SAP does not have a concept of u201Cinactiveu201D contract accounts. All contract accounts are active in SAP.

We do have customers who pay several months in advance (when they are out of town and donu2019t want to have their services disconnected).

Logic to retrieve the u201Cinactiveu201D accounts:

The inactive accounts can be identified by the Move-In/Out dunning procedure. If the mov-in/out dunning procedure is not empty, that means this account has moved out and the account is inactive.

Business Logic and Flow

For each contract account

{

Go through each installation and check if it is disconnected

{

If (one is active)

{

move to the next contract account

}

else (all is disconnected)

{

check to see if there is a credit balance or if there is an open standing request

{

If (credit balance)

{Display contract account, customer number and information, and credit balance for refund}

If (open standing request)

{Display contract account, customer number and information, standing request number to be closed}

If (paid but not yet refunded security deposit)

{Display contract account, customer number and information, current balance and security deposit amount}

}

}

}

}

Thanks in advance

Rahul

2 REPLIES 2

Former Member
0 Kudos

Hi Rahul,

To find out the credit balance relating to security deposits you can use BAPI_ACCOUNT_GETBALANCES. On execution of this BAPI with BP and Contract Account Number, it will return the net balance with different segments like open, due, credit and likewise security deposit amount.

To find out if there is any open standing request standing against the customer you can use BAPI_CTRACCONTRACTACCOUNT_GOI. You have to execute this BAPI by providing BP or Contract Account number in Main Selections table and Main and Sub Transaction of Security Deposit Request transaction in Value Selection table. This BAPI will fetch all open items with the main and sub transactions specified and display.

Thanks

Ganesh

Former Member
0 Kudos

solved it own