topic Re: fico-issue in Application Development and Automation Discussions

fico-issue

Former Member — Mon, 28 Jul 2008 07:14:56 GMT

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,

Re: fico-issue

Former Member — Mon, 28 Jul 2008 07:23:12 GMT

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.

Re: fico-issue

Former Member — Mon, 28 Jul 2008 07:27:30 GMT

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.

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.

Re: fico-issue

Former Member — Wed, 30 Jul 2008 21:10:59 GMT

Hi Durai,

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

Thanks,

Lin-Lin Li