Help for MM invoices table

[Former Member]

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

[JL23]

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

[Former Member]

Hi;

You can use 2LIS_06_INV

https://help.sap.com/saphelp_nw74/helpdata/en/9a/3070f709f04bbe90b3445f85e2388c/frameset.htm

Regards

[former_member182371]

Hi,

have you tried using fm MRM_INVOICE_READ?,

i believe all the information needed is there.

Best regards,

Pablo

[Former Member]

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?