Extracting data from cross client application component

[Former Member]

Hi Experts,

I am currently extracting HR Travel management information I have basically 2 issues.

issue number 1:  I need to extract the information about the employee who took the advance for travel and still unpaid to the company. and the calculation for ageing is target return date to office + 7 days. now the problem is that the out standing information I am extracting from ECC FI - BSIK which is client 100

and the target return date information I need to extract from ECC HR table - which is the client is 200. and there is some common field like com. Code and staff number in both system so I can merge this two DSO? can I try endroutine? please suggest me. please suggest with coding.

issue number2:

the Trip number in ECC -FI -table starts with TVM*, where else in ECC HR table it start with 0 so kindly let me know how to wright to add TVM on trip number in start routine?

Thanks

Rajesh

[Former Member]

Advances are stored in cluster TE (Transaction PRTE). If you als can see here if this is "unpaid" depends on your process. Normally the traveller will get an advance and after that he will do the submit his expenses. If this is not done (you can check in history table) so than you will get all data out for your reporting.

Trip number cannot start with TVM in SAP Travel Management. Only digits allowed. So please explain in more detail where you have a trip no. with TVM.