FI - opening balance

[Former Member]

Hi all...

I want to develop FI Cash Book Journal,

can anyone help me to find the table-field for opening balance value & closing balance value for articular time period...

Plz help me....

Thanks in advance..

[GauthamV]

hi,

use these tables.

TCJ_DOCUMENTS

TCJ_POSITIONS

TCJ_MAX_AMOUNT.

[former_member181995]

There are pleanty of report for cash flow already but unforunatly these are for other countries,so you can just copy these report and make them accoring to IN.

S_ALR_87012264 Cash flow (Slovakia)
S_ALR_87012268 Cash flow: Czech Republic
S_ALR_87012269 Balance using C/S (German Trade Law)
S_ALR_87012270 Profit and Loss Statement(Per.Acctg)
S_ALR_87012271 Cash Flow (Direct Method)
S_ALR_87012272 Cash Flow (Indirect Method) Variant
S_ALR_87012273 Cash Flow (Indirect Method) Variant
S_ALR_87012274 Cash Flow (AJI-03 Form)

for getting Opening balances you may use FM:

FCJ_GET_TABLE_BALANCES

FCJ_GET_LAST_BALANCE

FCJ_GET_LATEST_ARCH

FCJ_GET_ALL_BALANCES

FCJ_GET_HIST_BALANCE

FCJ_GET_PERIOD_BALANCES

[Former Member]

hi amit..

Do u have example of 'FCJ_GET_PERIOD_BALANCES' Fm..../

[former_member181995]

See Fm:

FCJ_UPD_PERIOD_BALANCES

Line 19.

you will get some idea.

Amit.

[Former Member]

Hi amit

there is no such FM...

Plz help me

[GauthamV]

hi,

check this fm.

FCJ_GET_PERIOD_BALANCES.

[former_member181995]

>

> Hi amit
> 
> there is no such  FM...
> 
> Plz help me

How wonder is this?

As i can see FCJ_UPD_PERIOD_BALANCES in both 4.6E and ECC6.

see at Line 19.

check again .

Amit.

[Former Member]

Hi all...

Thanks for Reply...

From table 'FAGLFLEXA ' GETTING ALL DATA...

SO USE THIS TABLE...

[Former Member]

Hi Ankita,

Check this thread, this might help you.

Regards,

Chandra Sekhar

[Former Member]

BKPF - Accounting Document Header           
                        BSEG - Accounting Document Segment        
                        SKAT - G/L Account Master Record (Chart of  
                                 Accounts: Description)               
                          SKB1 - G/L account master (company code)    
                          T001 - COMPANY CODES                        
                          KNA1 - Customer maser data                  
                          LFA1 - Vendor master data  


we are using a BAPI 

CALL FUNCTION 'BAPI_GL_GETGLACCPERIODBALANCES'
    EXPORTING
      COMPANYCODE      = P_BUKRS
      GLACCT           = V_HKONT
      FISCALYEAR       = V_OPENGJAHR
      CURRENCYTYPE     = C_10
    TABLES
      ACCOUNT_BALANCES = I_OPENBAL[].

Hope it will be helpful