First we have created AP process and added tables which are required for Kpi's of P2P process. Extraction part is done, but we have stucked in data model.
Page 1 / 1
Hello Dinesh,
1) About keys: EKPO (PO items) can be joined to RSEG (Goods Receipts data) having EKPO-EBELN and EBELP as reference document. RSEG items can be connected to BKPF and BSEG tables having reference of both RSEG-MBLNR and EKPO-EBLEN,EBELP.
2) About having both P2P and AP mixed activities / analysis: use multi-event log, however in that case it seems to work best if case tables are connected to each other (can be done by joins to BKPF from RSEG). You can also try to use MERGE_EVENTLOG() function in PQL if you don't want to have merged activity tables.
Best Regards,
Mateusz DUdek
Best Regards,
Mateusz Dudek
Hi,
Thanks Mateusz DUdek, it's really helpful.
Regards,
Dinesh.D
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.