fico-issue

[Former Member]

In transaction fs10n and fbl3n,what we get the total cum.balance in fs10n,when we check the line items for that total cum.balance in fbl3n is different from fs10n cum.bal.so i want to know the exact DB table from which comes the datafield(i.e. amount field) .Pls help me.

Thanks&Regards,

[Former Member]

Hi,

For FBL3N, you can use the tables BSIS and BSAS. For transaction currency amount refer WRBTR, For Local Currency (Co. Code currency) refer DMBTR and for Group currency DMBE2.

Thanks,

Sriram Ponna.

[Former Member]

Hi Sami,

Check this FM : BAPI_GL_GETGLACCPERIODBALANCES.

If we use this functional module, we will get account balance of corresponding G/L Acc.

(e.g)

CALL FUNCTION 'BAPI_GL_GETGLACCPERIODBALANCES'

EXPORTING

companycode = '1000'

glacct = '0000548101'

fiscalyear = '2007'

currencytype = '10'

IMPORTING

BALANCE_CARRIED_FORWARD = gs_bal-balance

RETURN = v_return

TABLES

account_balances = gt_bal.

OR

Check the following tables which consist of gl balance for corresponding company codes.

BSIS - G/L Accounts ( Open Item table)

BSAS - G/L Accounts (Cleared Items)

Hope it is helps.

Regards,

T.Durai murugan.

[Former Member]

Hi Durai,

This is exactly what I was looking for, thank you very much.

Thanks,

Lin-Lin Li