Skip to Content
0

Help for MM invoices table

May 10, 2017 at 07:09 AM

136

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Ricardo Inácio May 10, 2017 at 08:45 AM
1
Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
May 10, 2017 at 09:12 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Sadaf Faheem May 10, 2017 at 07:23 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Pablo Casamayor May 10, 2017 at 08:05 AM
0

Hi,

have you tried using fm MRM_INVOICE_READ?,

i believe all the information needed is there.

Best regards,

Pablo

Share
10 |10000 characters needed characters left characters exceeded