Skip to Content
0
Former Member
Jan 17, 2012 at 05:53 AM

Query Trip Data with Zero Amount

75 Views

Dear all,

I have requirement to retrieve every trip record which has zero amount in its total cost. It didn't work when I use TCode S_AHR_PH0_61016401 (General Data Trip) for this query purpose.

I also took effort to make my own query definition using logical database PTRVP. This custom query used table PTRV_HEAD, PTRV_SHDR, PTRV_SREC. Later, I realized that table PTRV_SHDR, which save data for trip total cost, never store any trip record that has zero amount in its total cost.

Is there any configuration to make PTRV_SHDR able store the zero-trip?

I really do appreciate every help here. Thanks a ton! 😀

Regards,

Erwin