SAP Function SMB_UIE_FIN_BANK_ACC_BAL - To find top 3 banks n top 3 currencies (GL/acc)

Parameter Reference Type Length Default Optional Text
IV_COMPCODE BUKRS C 4 Company Code

Parameter Reference Type Length Text
ET_TAB_BANK_ACC SMB_UIE_BANK_ACC_BAL_TT h 83 internal tab for pln amt,curr,level,cmpcode,glacc,hsbnk

Functionality
This function module finds the top 3 house banks by calculating theplanning amount in the company code's currency for all house banks andsorting them in order.
This function module also finds the top 3 currencies by filtering onlyon the top 3 banks found in the previous step. It calculates the top 3currencies for each of the banks in the previous top 3 banks list. Thisis achieved by calculating the planning amount for each G/L account ofeach bank in company code's planning currency and sorting them in orderbut displaying the Planning amount in transaction currency of that G/Laccount by maintaining the order and displaying the description for eachG/L account also.

Example
INPUT,,
Company code - 1000,,
OUTPUT
Comp_code,, G/L acc,,Pln curr,,Description,, Pln amt,,House bank
1000,, 281000,,EUR,, Giro Dresdner Bank 1.057.600,00,,DRE
1000,, 280050,,USD,, USD Account2.700,00 ,,DB
1000,, 280000,,EUR Giro Deutsche Bank 82.273
,60- ,,DB

Notes
If any wrong information is given as input then it results in 0 entriesin the output table.

Further information
Input Parameters: IV_COMPCODE
Output Parameters: ET_TAB_BANK_ACC (Table with company code, G/Laccount, Planning amount, Description, Planning currency, House Bankinformation).