topic Re: BAPI_AP_ACC_GETBALANCEDITEMS in Application Development and Automation Discussions

BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Thu, 24 May 2012 06:32:08 GMT

Hi Experts,

I am using following BAPI FM in my z program.

'BAPI_AP_ACC_GETBALANCEDITEMS' with a date range.

I need to fetch clear items for a particular vendor in (01.05.2012 to 24.05.2012). but this fm give me the all value of fiscal year 2009,2010,2011 & 2012.

even I run this fm by Tcode se37 with the same import export parameters. This is giving correct values.

Please Help.

Thanks in advance.

Dinesh

Re: BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Thu, 24 May 2012 06:39:27 GMT

put your code

Re: BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Thu, 24 May 2012 06:44:28 GMT

DATA : lineitems1 like BAPI3008_2 occurs 0.

DATA : lineitems2 like lineitems1 with header line.

DATA : return like bapireturn.

DATA : comp_code like BAPI3008_1-COMP_CODE.

DATA : vendor like BAPI3008_1-VENDOR.

DATA : date_from like BAPI3008-FROM_DATE.

DATA : date_to like BAPI3008-TO_DATE.

DATA : year(4) type c,

month(2) type c,

date(2) type c.

year = s_budat2-low+0(4).

month = s_budat2-low+4(2).

date = s_budat2-low+6(2).

concatenate date month year into date_from.

clear: year , month, date.

year = s_budat2-high+0(4).

month = s_budat2-high+4(2).

date = s_budat2-high+6(2).

concatenate date month year into date_to.

comp_code = s_bukrs.

*key_date = s_budat1.

loop at s_lifnr.

vendor = s_lifnr-low.

CALL FUNCTION 'BAPI_AP_ACC_GETBALANCEDITEMS' "Vendor Account Clearing Transactions in a given Period

EXPORTING

COMPANYCODE = COMP_CODE

VENDOR = VENDOR

DATE_FROM = DATE_FROM

DATE_TO = DATE_TO

IMPORTING

RETURN = RETURN

TABLES

LINEITEMS = LINEITEMS1

. " BAPI_AP_ACC_GETBALANCEDITEMS

APPEND LINES OF LINEITEMS1 TO LINEITEMS2.

endloop.

Re: BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Thu, 24 May 2012 06:56:11 GMT

Hi, you can use the table BSAK to fetch the vendor clreared lines.

Infact the fm 'BAPI_AP_ACC_GETBALANCEDITEMS' also uses the table BSAK to fetch the cleared lines. Try to debug the function module to find what went wrong in your case.

Re: BAPI_AP_ACC_GETBALANCEDITEMS

huseyindereli — Thu, 24 May 2012 11:36:18 GMT

Hi ,

Don't change the date fields and try using FM like below.

CALL FUNCTION 'BAPI_AP_ACC_GETBALANCEDITEMS' "Vendor Account Clearing Transactions in a given Period

EXPORTING

COMPANYCODE = COMP_CODE

VENDOR = VENDOR

DATE_FROM = s_budat2-low

DATE_TO = s_budat2-high

IMPORTING

RETURN = RETURN

TABLES

LINEITEMS = LINEITEMS1.

Re: BAPI_AP_ACC_GETBALANCEDITEMS

former_member282968 — Thu, 24 May 2012 11:45:26 GMT

Instead of concatenating directly assign as below:

DATE_FROM = s_budat2-low

DATE_TO = s_budat2-high

Re: BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Thu, 24 May 2012 11:58:02 GMT

No result found.

s_budat2-low = '20120501'

s_budat2-high = '20120523'

it will take it as DATE_FROM = 20.12.50

DATE_TO = 20.12.05

Re: BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Thu, 24 May 2012 17:09:06 GMT

The correct format of the date is: YYYYMMDD otherwise you will have problems with FMs.

Please try the following:

date_from = s_budat2-low.

date_to = s_budat2-high.

CALL FUNCTION 'BAPI_AP_ACC_GETBALANCEDITEMS' "Vendor Account Clearing Transactions in a given Period

EXPORTING

COMPANYCODE = COMP_CODE

VENDOR = VENDOR

DATE_FROM = DATE_FROM

DATE_TO = DATE_TO

IMPORTING

RETURN = RETURN

TABLES

LINEITEMS = LINEITEMS1

. " BAPI_AP_ACC_GETBALANCEDITEMS

Sorry for my english, it's not my first language.

Thanks!

Re: BAPI_AP_ACC_GETBALANCEDITEMS

Former Member — Fri, 25 May 2012 03:57:28 GMT

Hi Dinesh,

You don't need to concatenate and then pass date_from and date_to as these date are in sy-datum format and perfectly fine to pass directly the to_date and from_date .

date_from = s_budat2-low.

date_to = s_budat2-high.

CALL FUNCTION 'BAPI_AP_ACC_GETBALANCEDITEMS'

EXPORTING

COMPANYCODE = COMP_CODE

VENDOR = VENDOR

DATE_FROM = DATE_FROM

DATE_TO = DATE_TO

IMPORTING

RETURN = RETURN

TABLES

LINEITEMS = LINEITEMS1 .

Please try this & let us know .

Regards,

yukti