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.
Question
Hi,How to do AP process and P2P process in one analysis. Requirement is some of kpi's belongs to P2P process and AP process, want to see these AP and P2P process kpi's in One analysis.Regards,Dinesh.D
+7
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.