How to link PTRV_ROT_AWKEY to PTRV_SREC?

[Former Member]

Hi everyone,

PTRV_ROT_AWKEY contains all the receipts for a certain trip, the same receipt and amount are posted in the FI document BSEG as well (using AWREF+AWLIN). The trip statistics PTRV_SREC group these receipts based on expense type

EXP_TYPE

Travel Expense Type

ZPRT	Printing
ZMAT	Material
ZSTN	Paper & Stationary
ZTEL	Telephone
GAS	Fuel

• Which bridge table(s) should I use to find out how the individual receipt in PTRV_ROT_AWKEY is categorized into which expense type?

• Can a single receipt be allocated 40% to expense type A and 60% to expense type B?

Thanks!

-

---

BTW, if any one knows how to link BSEG to MSEG, please help with [Thread 6035765||BSEG <-> MSEG]

[Former Member]

Hello Eric,

I am also looking for a link between PTRV_ROT_AWKEY and PTRV_SREC. to get the GL account # for a trip number.

Your inputs are helpful.

Thanks

Ritesh Solanki

[former_member501597]

Hi Ritesh,

You can use table PTRV_DOC_HD and PTRV_DOC_IT for link between PTRV_ROT_AWKEY and PTRV_SREC.

Regards,

Gino Spagnolo