topic Re: Fetch FI document no in Application Development and Automation Discussions

Fetch FI document no

Former Member — Thu, 20 Nov 2008 09:52:21 GMT

Given GRN no for 105 movement in mseg ,how can i know FI document ?

Re: Fetch FI document no

Former Member — Thu, 20 Nov 2008 10:21:47 GMT

Hi,

aditya use BKPF-BELNR

and try to access it using BSEG_BELNR.

Hope magic Works!

Regards,

Purvesh Patel.

Re: Fetch FI document no

Former Member — Thu, 20 Nov 2008 10:26:21 GMT

How can i do i am having GRN say 5000377301,i cant pass it to bkpf or bseg.I want FI doc no itself

that you are asking me to pass.

Re: Fetch FI document no

JozsefSzikszai — Thu, 20 Nov 2008 10:30:17 GMT

mseg-belnr = bseg-belnr

mseg-buzei = bseg-buzei

Re: Fetch FI document no

Former Member — Thu, 20 Nov 2008 10:33:04 GMT

Sorry eric doesnot work here.It is conceptually also not ok.

Re: Fetch FI document no

christine_evans — Thu, 20 Nov 2008 10:39:28 GMT

1. Query the goods receipt in tcode MB03.

2. Switch on ST05 performance trace in another session.

3. Click on the MB03 option to display accounting document.

The trace will show you how to find the accounting document.

Re: Fetch FI document no

JozsefSzikszai — Thu, 20 Nov 2008 10:40:23 GMT

It is conceptually also not ok.

what do you mean?

then identify a document-pair (one from MSEG, one from BSEG) and search for common fields (for example check BKPF-AWKEY, usually that is some kind of concatenation of relevant document numbers + company code + plant). Unfortunately there is no MM where I am, so I cannot check on my own

Re: Fetch FI document no

Former Member — Thu, 20 Nov 2008 10:46:19 GMT

I was coming to that the field AWKEY ie YYYYGRNNO.

Here i find if i try querying the table BKPF by giving AWKEY ,BUKRS ,GJAHR,retrieval is damn slow.

Infact it is better to retrieve all FI docs of complete year and then filter internal table matching that AWKEY within ABAP scope.

Here can anybody give a better tip to optimize fast retrievaL

Re: Fetch FI document no

SuhaSaha — Thu, 20 Nov 2008 11:04:21 GMT

Hello Aditya,

May be you can use AWTYP = 'MKPF'. Hope this will reduce data fetch time )

I donot think selecting all the docs for the CoCd & Fiscal Yr and filtering will be a good idea.

Plz correct me if i am wrong.

BR,

Suhas

Re: Fetch FI document no

JozsefSzikszai — Thu, 20 Nov 2008 11:07:06 GMT

just check what is the value for BKPF-AWTYP (will be the same all the time for all documents come from MSEG) and hardcode that in the selection (there is a secondary index for AWTYP, AWKEY, ... for BKPF)

SELECT ...

INTO...

FROM bkpf

WHERE awtyp EQ '...'

AND AWKEY EQ ....

Re: Fetch FI document no

Former Member — Thu, 20 Nov 2008 12:42:19 GMT

Thanx to both....

Re: Fetch FI document no

Former Member — Tue, 25 Nov 2008 09:59:43 GMT