topic BAPI_AP_ACC_GETKEYDATEBALANCE in Application Development and Automation Discussions

BAPI_AP_ACC_GETKEYDATEBALANCE

harshsisodia31 — Sat, 28 Sep 2013 04:30:27 GMT

Dear Experts,

I am using BAPI_AP_ACC_GETKEYDATEBALANCE to get opening balance of vendor but is is not returning correct value . I tried debugging the code in bapi but is not returing the correct line items. Below are parameters I m passing to the bapi

CALL FUNCTION 'BAPI_AP_ACC_GETKEYDATEBALANCE'
   EXPORTING
     COMPANYCODE        = PA_BUKRS       "1000
     VENDOR             = PA_LIF                       "100006
     KEYDATE            = SO_DATE-LOW          "20130401

     BALANCESPGLI       = 'X'
     NOTEDITEMS         = 'X'
* IMPORTING
*   RETURN             =
   TABLES
     KEYBALANCE         = OPEN1               "type table of BAPI3008_3

Kindly guide.

Best Regards

Harsh .

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

Former Member — Sat, 28 Sep 2013 06:35:59 GMT

which is the result you expect?

Max

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

Sijin_Chandran — Sat, 28 Sep 2013 08:44:56 GMT

Hello Harsh ,

Actually this BAPI returns 2 lines in the Output Internal Table ( OPEN1 in your case ) , one for Total Credit Balance and Other for Total Debit Balance . You need to Sum up these two amounts in order to get the key date balance ( i.e FBL1N Balance )

Thanks ,

Sijin

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

harshsisodia31 — Sun, 29 Sep 2013 05:23:55 GMT

Hello Experts,

I solved the problem myself, thanks for reply.

Closing this Thread.

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

Former Member — Wed, 09 Oct 2013 05:34:51 GMT

Hi Harsh,

Can you please share the solution. We are facing similar issue.

Regards,

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

harshsisodia31 — Wed, 09 Oct 2013 07:37:40 GMT

Hi Yusuf,

Can u please share the input and what is the result you are expecting ?

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

Former Member — Wed, 09 Oct 2013 09:56:54 GMT

Thanks Harsh. Resolved the issue. The preceding zeroes had been removed from the Vendor code.

Regards,

Re: BAPI_AP_ACC_GETKEYDATEBALANCE

former_member830831 — Wed, 10 May 2023 11:09:42 GMT

Can you give me the solution

Because i have a requirement

for customer opening Balance and All transaction with Closing Balance

Zreport

I need support for this requirement