topic Re: function module for opening balance? in Application Development and Automation Discussions

function module for opening balance?

Former Member — Fri, 15 Mar 2013 06:20:01 GMT

Hi Experts,

I have created a customer outstanding report in which the balance calculation is wrong. The client wants opening balance in the top and then opening balance + debit - credit and then closing balance in the last. And I have just done the debit - credit. Is there any function module to calculate it?

The purpose of the customer outstanding report is that in standard report there is only one column for balance. Client wants to separate it in debit and credit. Please guide.

I have created a cash journal report earlier in which there was opening and closing balance. I copied RFCASH20 into a customized report and made changes according to the user.

Regards

Purnand

Re: function module for opening balance?

Former Member — Fri, 15 Mar 2013 12:12:03 GMT

Anyone?

Re: function module for opening balance?

Former Member — Fri, 15 Mar 2013 12:19:32 GMT

Hi, check BAPI_AR_ACC_GETKEYDATEBALANCE.

Re: function module for opening balance?

Former Member — Fri, 15 Mar 2013 12:26:40 GMT

Hello,

Please refer following thread.It might help you

http://scn.sap.com/thread/694963

Regards

Re: function module for opening balance?

Former Member — Fri, 22 Mar 2013 11:56:29 GMT

Hi,

I followed some other procedure to do it but it failed. I have not worked on bapi's. Can you please elaborate the answer or steps to do that?

Regards

Purnand

Re: function module for opening balance?

Former Member — Fri, 22 Mar 2013 12:45:46 GMT

Hello, using a BAPI is same as using the function module. You can see it in SE37. Pass the input parameters and get the output data. As simple as that!

Re: function module for opening balance?

Former Member — Fri, 22 Mar 2013 16:04:17 GMT

Hi,

Thank you for the response. I will get back to you tomorrow on this. One thing I want to ask. How to find the BAPI for the particular task? Like for opening balance how did find the aove bapi?

Thanks

Purnand

Re: function module for opening balance?

Former Member — Fri, 22 Mar 2013 16:38:18 GMT

BAPI: BAPI_AR_ACC_GETOPENITEMS (Customer Account Open details)

To find BAPI, follow the below steps,

1) Go to T-code "BAPI"

2) Navigate though the process tree to find your application

3) Choose the appropriate options in the tree and get the name of the Function Module in the right side of the screen.

For details, go through this below demo

http://www.youtube.com/watch?v=uEan8s9S8w8

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 05:21:44 GMT

Hi,

I am using BAPI for the first time. Following is my code:

   types: begin of ty_final,
      bukrs type bukrs,
       kunnr type kunnr,
       budat type budat,
       wrbtr type wrbtr,
       belnr type belnr_d,
       shkzg type SHKZG,
        budat1 type budat,
       wrbtr1 type wrbtr,
       dr type p decimals 2,
       cr type p decimals 2,
       sno type sy-tabix,
       name1 type kna1-name1,
       name2 type kna1-name2,
       name3 type kna1-name3,
       balance type p decimals 2,
       op_bal type i,
     end of ty_final.

   CALL FUNCTION 'BAPI_AR_ACC_GETOPENITEMS'
EXPORTING
    COMPANYCODE       = s_bukrs
    CUSTOMER          = s_kunnr
    KEYDATE           = s_date
*   NOTEDITEMS        = ' '
*   SECINDEX          = ' '
* IMPORTING
*   RETURN            =
TABLES
    LINEITEMS         = it_final

The code is giving dump at LINEITEMS. I do not know how to use it. I checked some formats on net also but its written:

TABLES

lineitems = " bapi3007_2 Line items

. " BAPI_AR_ACC_GETOPENITEMS

I checked the documentation also but I did not get it. Can anyone explain me.

I created a structure with only opening balance and passed its internal table in line items but again its giving dump.

Regards

Purnand

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 05:56:10 GMT

Hi,

I just checked se37 also but I could not understand.

Regards

Purnand

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 06:03:33 GMT

What have you declared it_final? What is the runtime error that your getting?

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 06:42:33 GMT

Hi,

Thank you for the reply. I have declared it_final in the report itself and please check the following screenshot:

Regards

Purnand

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 11:51:36 GMT

Anyone?

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 14:17:30 GMT

It's a clear flaw, your declarations it_final is not compatible with bapi lineitems. Your structure should be as in bapi lineitems. Please check with associate type of lineitems in the FM.

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 15:45:59 GMT

Hi,

Thank you for the reply. I understand that its a clear flaw. But the question is what should I give in the lineitems,

I am out of office right now. I wrote this sample code but its also giving dump:

report zrough.

tables: bsad, bsid.

data: it_bsad type STANDARD TABLE OF bsad,

it_bsid type STANDARD TABLE OF bsid.

data: wa_bsad type bsad,

wa_bsid type bsid.

data: it_final type STANDARD TABLE OF BAPI3007_2,

wa_final type bapi3007_2.

SELECT-OPTIONS: so_bukrs for bsad-bukrs,

so_kunnr for bsad-kunnr,

so_budat for bsad-budat.

BREAK-POINT.

CALL FUNCTION 'BAPI_AR_ACC_GETOPENITEMS'

EXPORTING

companycode = so_bukrs

customer = so_kunnr

keydate = so_budat

* NOTEDITEMS = ' '

* SECINDEX = ' '

* IMPORTING

* RETURN =

tables

lineitems = it_final.

loop at it_final into wa_final.

write:/ wa_Final-lc_amount.

endloop.

I just want the value of lc_amount in my report. How should I get it?

Regards

Purnand

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 15:55:44 GMT

Do you remember the fields inside the tables associated structure for lineitems which bapi3007_2??

So, your li_final should be declared in this way....

data: it_final type bapi3007_2. My doubt is that do you have a field to get amount in this structure bapi3007_2? Have you checked on that?

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 16:09:15 GMT

Hi,

I just checked that in ides there is a field with the name lc_amount. I want this in the report. Kindly tell me where I am lacking.

Regards

Purnand

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 16:22:05 GMT

Ok fine..

Now declare it_final as; data: it_final type bapi3007_2,

And then pass it to the FM. Try this and let me know if you find any complexity.

Also take a screenshot of your code and upload it here in case of further assistance.

Thanks

Jula

Re: function module for opening balance?

Former Member — Sat, 23 Mar 2013 16:31:08 GMT

Hi,

Sorry, cannot attach the screenshot but following is the code:

report zrough.

tables: bsad, bsid.

data: it_bsad type STANDARD TABLE OF bsad,

it_bsid type STANDARD TABLE OF bsid.

data: wa_bsad type bsad,

wa_bsid type bsid.

data: it_final type STANDARD TABLE OF BAPI3007_2,

wa_final type bapi3007_2.

SELECT-OPTIONS: so_bukrs for bsad-bukrs,

so_kunnr for bsad-kunnr,

so_budat for bsad-budat.

BREAK-POINT.

CALL FUNCTION 'BAPI_AR_ACC_GETOPENITEMS'

EXPORTING

companycode = so_bukrs

customer = so_kunnr

keydate = so_budat

* NOTEDITEMS = ' '

* SECINDEX = ' '

* IMPORTING

* RETURN =

tables

lineitems = it_final.

loop at it_final into wa_final.

write:/ wa_Final-lc_amount.

endloop.

How to get the value of lc_amount?

Thanks

Purnand

Re: function module for opening balance?

Sijin_Chandran — Mon, 25 Mar 2013 06:16:14 GMT

Hi Purnand ,

For getting Opening Balance Date wise for a particular Customer the Function Module to be used is BAPI_AR_ACC_GETKEYDATEBALANCE

Now let me clear you some concepts about Opening.

Consider your below example :

Suppose you want opening for Customer ( Creditors Analysis ) say 0000000004 on Posting Date 01.04.2012 ,

Opening will be the balance of this Customer just the day before i.e balance of that customer on 31st march 2012 will be the opening for 1st april.

Now next question is how to find Balance of a customer based on a date , for that there is a very famous and mostly used Standard Report which is FBL5N .

Now the Function Module which provides the functionality of FBL5N is BAPI_AR_ACC_GETKEYDATEBALANCE .

Now see the below case :

FBL5N

Input fields :

Output :

The above highlighted figure is balance of Customer 121 as on 25.03.2013.

Now the BAPI

Execute it and you will get the below output :

This will help you out.

Do take care while passing parameters to BAPI in your Report Code.

Thanks ,

Sij