Ansicht
Dokumentation

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

Vendor Master (General Section)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Functionality

This function module finds the top 3 house banks by calculating the planning amount in the company code's currency for all house banks and sorting them in order.

This function module also finds the top 3 currencies by filtering only on the top 3 banks found in the previous step. It calculates the top 3 currencies for each of the banks in the previous top 3 banks list. This is achieved by calculating the planning amount for each G/L account of each bank in company code's planning currency and sorting them in order but displaying the Planning amount in transaction currency of that G/L account by maintaining the order and displaying the description for each G/L account also.

Example

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 Account 2.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 entries in the output table.

Further information

Input Parameters: IV_COMPCODE

Output Parameters: ET_TAB_BANK_ACC (Table with company code, G/L account, Planning amount, Description, Planning currency, House Bank information).

Parameters

ET_TAB_BANK_ACC
IV_COMPCODE

Exceptions

Function Group

SMB_UIE_FIN_CP_LF

ABAP Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 1794 Date: 20240523 Time: 105554     sap01-206 ( 37 ms )