Skip to Content
0
Former Member
Oct 18, 2011 at 06:43 PM

How do I map different versions of PTRV_HEAD/PTRV_PERIO to BKPF doc#

141 Views

We are trying to build a report to show how long a trip is processed end to end (average number of days from entry to approval, approval to posting, posting till payment, etc). I wanted to know how I can map the different versions of the record in PTRV_HEAD to the BKPF table if posted multiple times. So if I have version 99, 98, 97 in PTRV_PERIO and I posted it 3 times, I know I have 3 document numbers in BKPF for the same trip. But what field maps whichs document to which entry in PTRV_PERIO? Is there a middle table I need to use to join these 2 tables?

I was able to map PTRV_PERIO and BKPF this way:

PTRV_PERIO:RUNID = PTRV_DOC_HD:RUNID

PTRV_DOC_HD:AWREF = BKPF:AWREF

Is this correct?

Thank you

Edited by: Jinny C on Oct 18, 2011 9:25 PM