topic Re: FI_DOCUMENT_READ usage information. in Application Development and Automation Discussions

FI_DOCUMENT_READ usage information.

former_member216215 — Mon, 03 Feb 2014 16:09:13 GMT

Hi Everybody,

About how to use this function Does anyone have an idea?

I've found it.

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.

But this is not enough.

Best Regards Rasim.

Re: FI_DOCUMENT_READ usage information.

ThomasZloch — Tue, 04 Feb 2014 09:54:24 GMT

Your issue is not clear to me, please provide more information about what you are trying to solve.

Thomas

Re: FI_DOCUMENT_READ usage information.

Former Member — Tue, 04 Feb 2014 10:02:55 GMT

Hi,

It seems, he is trying to fetch the accounting documents for a billing document. ( BKPF-AWKEY = 'VBRK' ).

Regards,

DPM

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 10:10:33 GMT

Thank Zloch

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 .

Regards Rasim

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 10:11:40 GMT

Instead of choosing a long time I want to use a function.

Re: FI_DOCUMENT_READ usage information.

ThomasZloch — Tue, 04 Feb 2014 11:32:22 GMT

In very general, using SAP provided function modules or BAPIs is recommended to retrieve data for a particular document, be it FI document, purchase order or whatever.

However in my experience when you want to retrieve a large chunk of data i.e. thousands of documents, you are often better off by writing your own optimized access (if you know what you are doing, that is).

What is your actual business requirement?

Thomas

Re: FI_DOCUMENT_READ usage information.

ThangaPrakash — Tue, 04 Feb 2014 12:12:03 GMT

Hello Rasim,

No need to pass all datas.... Just pass the type and document number as below and you will get details in the tables.

Regards,

Thanga Prakash T

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 12:21:01 GMT

Thank Thanga ,

How do we do it?

Regards Rasim .

Re: FI_DOCUMENT_READ usage information.

ThangaPrakash — Tue, 04 Feb 2014 12:46:10 GMT

Hello Rasim,

Please refer screenshot in my previous comment, pass I_AWTYP and I_AWREF and the result you will get in the internal tables.

Regards,

Thanga

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 13:09:23 GMT

Ok. Thank you.

Re: FI_DOCUMENT_READ usage information.

RaymondGiuseppi — Tue, 04 Feb 2014 14:46:28 GMT

This FI FM will return accounting documents generated from another application (here SD invoice, so one document most of the time) so the SELECT statement in your answer to Thoma s cannot be fulfilled with this FM. Also if you are on the original system, don't pass AWSYS as it will be initial in BKPF.

Regards,

Raymond

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 15:01:49 GMT

That's it. You're so right. Raymond.

when you read the FI table, I'm looking for function modules can use SELECT instead.

Regards Rasim.

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 15:21:22 GMT

Select Instead, I want to read the function module table with them. BSEG , BKPF , SKAT ,T005T , LFA1 , KNA1 , T001 , BSID ...

Regards Rasim...

Re: FI_DOCUMENT_READ usage information.

ThomasZloch — Tue, 04 Feb 2014 15:46:44 GMT

???

Re: FI_DOCUMENT_READ usage information.

RaymondGiuseppi — Tue, 04 Feb 2014 15:55:15 GMT

If performance is not a problem, you can use the logical databases related to FI with a function module like LDB_PROCESS or use the LDB in report attributes (that's the old way) - ref Calling a Logical Database Using a Function Module.

If performance is a problem, then select data from secondary indexes BS[I,A][S,D,K,M] and either join with required table or use FM like ITEM_DERIVE_FIELDS after a MOVE-CORRESPONDING of data to enrich data in a FBL*N fashion.

Regards,

Raymond

Re: FI_DOCUMENT_READ usage information.

former_member216215 — Tue, 04 Feb 2014 16:52:26 GMT

Thanks Raymond,

Logical Database will save my job.

Regards Rasim.