Register Login

How to Fetch All the PO based Invoice through BKPF?

Updated May 18, 2018

Hello Experts,

Could you please help me to fetch all the PO based invoice through BKPF? I am confused with the fields GLVOR and AWTYP. I hope RMRP value can be passed through these fields.

Busines wants complete PO based Invoice report. with other details along. So, I am trying to pull all PO based Inv from BKPF. I tried Bus.Trans BKPF-GLVOR and BKPF-AWTYP and find some difference in the number of document pulled out. 

So I am confused. Also, If I take BKPF-AWKEY, I will get all documents (SA, AB etc.) because all these docs will fill in the reference here.

Kindly help, Thanks in advance.


Comments

  • 04 Sep 2015 10:18 am Chandan Singh Parihar Helpful Answer

    Please try to use ME80FN report and see, Execute it and then choose PO HISTORY mode.

    Here you will get the numbers or go to SE16 and check table RSEG.

  • 04 Sep 2015 10:20 am Sugandh Helpful Answer

    Go to BKPF check the Reference Key field where Material document number is updating is updating in BKPF-AWKEY.

  • 04 Sep 2015 10:21 am Sushma

    Hello All.

    I sorted this out. With the use of ACCTIT table passing values BUKRS, GJAHR, and mONAT with AWYTP=RMRP and KTOSL=WRX

    in BKPF with AWTYP=RMRP.

    But ensure that you exclude KP document type, because these are GRIR clearing entries. If you use ACCTIT table, you will get combination of BKPF, BSEG, EKPO etc.

    I am sharing the solution here, for those who though of the same.

    Thanks for your time to review and give the input. Thanks all!


×