Travel Managment - Report

[former_member182377]

Hi SAP Travel Experts,

I need a report in travel management which retrieves Expense type, Name and GL Account ,

is there any standard Ad-hoc query and T-code or table available to get this ,

Can anyone help me out on this please?

Thanks

Sriram

[Former Member]

Hi Sriram,

Please check the below table :

PTRV_DOC_HD

PTRV_DOC_IT

Regards

Madhu

[former_member131723]

Hi Sriram

Did you take a look at these wiki pages?

http://wiki.scn.sap.com/wiki/x/jwDYEw

http://wiki.scn.sap.com/wiki/x/soMCFQ

They were recently updated to the external wiki and deal with our standard reports and also creating an ad-hoc query.

Hope it helps

Sally

[Former Member]

I also have the same need as Sririam requested above. The standard SAP reports, along with the adhoc query you mentioned only seems to return trip or PA data. What we need is the master data from EEM.

Currently, the only way I am able to provide a list of expense types to their mapped GL accounts is to export the following tables and do various queries in Access on primary keys to get the output required:

T706B5 - Expense type name

T706B1 - expense types and settings

T706B1_A - mileage types and settings

T706B4 - expense type to wage type

T706B4_A - mileage type to wage type

T512T - wage type to GL (descr)

T706K - wage type to symbolic account

T030 - symbolic account to GL

This is quite a cumbersome task and can take over an hour to produce. Not to mention, every time we add or remove an expense type, the whole process has to be repeated.

Is there not a way to ad hoc these master data config tables to get just Expense type and GL?