Skip to Content
avatar image
Former Member

Help for MM invoices table

Hello All,

I have a requirement to have MM invoices pulled into SAP BW.

The extractor used is 0FI_AP_4. We have a Y function module for this DS to have customizations/filling Z fields.

As per the research done so far, I see that BKPF will give me MM invoices(AWKEY) when its AWTYP=RMRP.

I would also like to have the invoice item which I do not find in BKPF/BSEG.

Any other tables you guys can suggest which would give me MM invoices+line items.

Thanks.

Sadaf

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 10, 2017 at 08:45 AM
    Add comment
    10|10000 characters needed characters exceeded

  • May 10, 2017 at 09:12 AM

    The MM invoice header is still in table RBKP and not in BKPF which is an accounting table

    And RBKP links to RSEG pretty simple on the fields BELNR and GJAHR

    A good way to find tables of an object is via the archiving object in transaction DB15 which can tell you all tables from which data is archived if you archive e.g. MM Invoices with its archiving object MM_REBEL

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 10, 2017 at 07:23 AM

    Additional info-

    I am performing a select on BKPF with belnr as key to get the AWKEY(invoice)

    For fetching Invoice Items(BUZEI) , I am thinking if I can use RSEG with BKPF-AWKEY = RSEG-BELNR

    Any suggestions on how I can link BKPF and RSEG?

    Add comment
    10|10000 characters needed characters exceeded

  • May 10, 2017 at 08:05 AM

    Hi,

    have you tried using fm MRM_INVOICE_READ?,

    i believe all the information needed is there.

    Best regards,

    Pablo

    Add comment
    10|10000 characters needed characters exceeded