FI document no of MIGO

[Former Member]

Dear Sirs,

Please help in finding FI document no that was generated by system while doing MIGO fo a particular purchase order.

i.e. let us suppose we had posted 100 MIGO for a particular purchase order, for which system provides two references,

1. material document no of MIGO

2. FI document no. of MIGO

we can access all 100 material document no through purchase order history in purchase document, but how to get all FI document of MIGO.

Nikhil Gupta

[vivek_srivastava12]

Hi,

During MIGO we know below accounting entry happen,

Stock Dr

GR/IR CR

The document type will be "WE"

Now you will be having 3-4 GL Accounts for Raw Material and Trading Goods, take all these GL Account and follow below steps:

1. Go To FBL3N, enter these GL Accounts

2, Click on Dynamic Selections--> Document Type "WE"

3. Execute this screen for a date range for which you want to see the details

4. Enable the Purchasing Document number field and put a filter as Purchasing Document no equal to blank

5. Sort on Purchasing document and create a lay out & Variant for the same

So every time when you run just select the Variant and get the desired result.

Hope this helps!!

Br,Vivek

[Former Member]

I had followed this process, but in purchase document filed nothing is coming.

[iklovski]

Hi,

Via EKBE table, you 'll see the PO history, i.e. GR/IR. Material document numbers are stored in EKBE-BELNR field. Then, with material document number you should go to BKPF table with a key BKPF-AWTYP = 'MKPF' and BKPF-AWKEY = 'material doc. number' + 'year', e.g. '50000003182009' (5000000318 - mat.doc. number and 2009 - year).

You can do all this in Excel or build an ABAP report.

Regards,

Eli

[Former Member]

Tcode: FB03. Click on document list. In parameters Give your comapny code, fiscal year. In field Reference key of parameter enter your MIGO document/s (multiple selection) number followed by fiscal year, for e.g. MIGO doc: 10001 and fiscal year 2012 the in reference key enter 100012011 and execute .You will get all FI documents related to MIGO documents.

[Former Member]

This is a time consuming process, what I want is MIGO doc with reference to a Purchase order.

i.e. list of MIGO doc agaisnt a particular P.O.

[Former Member]

Hi Nikhil,

If this one is a one time requirement, then I will suggest to go to transaction SE16 / SE16N for table BKPF and enter your material document numbers concanated with material docuemnt year in the field Object Key (AWKEY) and in the output you should be able to see the financial accounting doucments.

If this is a recurring request, then you can create a query in SQVI or (SQ01, SQ02, SQ03) and can conbine table MKPF and BKPF to get all the material documents and accounting doucments for pos. (Please refer standard sap helpl documents on how to create queries)

Regards,

Gaurav

[Former Member]

go to display Doc. in MIGO>>Go to Doc. Info>> Click on FI Doc. you will get Accounting Doc.for more details please follow the snap shot.

[Former Member]

Dear Mr. Navin,

Thank you for your response.

As you had said, it will provide me FI document of one MIGO out of 100's MIGO of single P.O.

What I want is all 100's FI document on single screen.

[joao_sousa2]

You don't have a report for this in the standard system as far as I know. You can easily create a custom ALV report which links EKKO, EKBE, MKPF and BKPF.

The link between MKPF and BKPF is achieved through the AWKEY field in BKPF, which is equal to the concatenation of MKPF-MBLNR and MKPF-MJAHR.

[Former Member]

Hi Joao Sousa,

when we save the Migo aginest PO then we go to Document info tab and select the FI Document then u want entry wil display...

Regards,

Nivas

[joao_sousa2]

I'm not saying you will be able to fulfill your requirement from inside the standard transactions, what I said was that you should develop a custom ALV if your requirement is to see all financial documents.

From a SAP perspective your requirement isn't standard because to someone who uses ME21n, the FI documents should be meaningless. If your accounting department needs to see this information, develop a custom ALV report.

[narasimhulu_konnipati]

You can see all the material documents in

MB51   ---   MMBE

Accounting documents in FBL3N

Single Material document in MB03

Accounting documents also can view through FB03 - Menu bar - Go to - Find documents.

Here selection criteria

Tables

MKPF, MSEG    - MIGO

BKPF , BSEG   for Accounting

Thanks