topic Function Module to read Fi document in Application Development and Automation Discussions

Function Module to read Fi document

tarangini_katta — Fri, 20 Feb 2009 08:27:15 GMT

Hi All,

I want to read the data from BKPF and BSEG tables by passing the company code, document type and fiscal year.I am able to read using select but i need a function module to read the data.

Can yanybody please give m a function module.

Thanks,

Re: Function Module to read Fi document

GauthamV — Fri, 20 Feb 2009 08:34:08 GMT

use this Fm.

FI_DOCUMENT_READ

Re: Function Module to read Fi document

Former Member — Fri, 20 Feb 2009 08:36:18 GMT

hi,

check these function modules:

for bseg table:

GET_ALL_BSEG : for Retrieval of all line items found by SET_ALL_BSEG

READ_BSEG : for Direct read operation of the line item

SET_ALL_BSEG: for Select all line items for a document

for bkpf table:

READ_BKPF : for Direct read operation of document headers

hope it will help you

regards

Rahul

Re: Function Module to read Fi document

Former Member — Fri, 20 Feb 2009 08:37:18 GMT

use this as a reference:


call function 'FI_DOCUMENT_READ'
exporting
   i_awtyp = 'VBRK'
   i_awref = vbfa_tab-vbeln
   i_awsys = vbrk-logsys
   i_bukrs = vbrk-bukrs
   i_gjahr = vbrk-gjahr
tables
   t_bkpf = xbkpf
   t_bseg = xbseg
exceptions
wrong_input = 1
not_found = 2.

regards,

Mon Magallanes

Re: Function Module to read Fi document

former_member216215 — Tue, 04 Feb 2014 08:04:49 GMT

Hi Edmund ,

more illustrative examples of this function module yet ?

Regards Rasim.

Re: Function Module to read Fi document

former_member216215 — Tue, 04 Feb 2014 09:42:56 GMT

So it makes sense to use a function instead of carrying short is not it?

Examples

SELECT   BUKRS KUNNR UMSKZ ZUONR GJAHR BELNR BUZEI BUDAT
   BLDAT WAERS BLART SHKZG GSBER DMBTR WRBTR SGTXT SAKNR HKONT
   ZFBDT ZBD1T ZBD2T ZBD3T XREF1 XREF2 XREF3
APPENDING TABLE IBSID
FROM BSID
                     WHERE BUKRS EQ BUKRS
                     AND KUNNR IN S_HKONT
                     AND UMSKZ IN S_UMSKZ
                     AND BUDAT LE GV_DATUM
                     AND HKONT NOT IN S_BKONT
                    AND GSBER IN GSBER .

Re: Function Module to read Fi document

former_member216215 — Tue, 04 Feb 2014 09:43:22 GMT

So it makes sense to use a function instead of carrying short is not it?

Examples