Script Logic

[tmumaw]

Just wondering if this will work?

Thanks

[ZTRPSTTEMP]:
SQL Select *
FROM ZTRPST
WHERE Right([ZORDER],10) in (Select VBELN from VBAK)
;

[ZTRPST]:  // Time Reports - Spread Time Posted
Load
[ZTICKNO]   as [Ticket],
Left([ZOBJECT],8)  as EmpID,
Right([ZORDER],10) & [ZACTIVITY] as [%ContractItemKey],
Right([ZORDER],10)  as [Contract],
[ZACTIVITY]   as [Contrac Line],
[ZSTATUS]   as [Status], 
[ZWDATE]   as [Date],
ZHOURS   as [Z_Hours],
ceil(ZHOURS, .01)  as [Hours],
round(ZHOURS, .01) as [Hours_Round],
floor(ZHOURS, .01) as [Hours_Floor]
Resident ZTRPSTTEMP
WHERE exists(Right([ZORDER],10), [VBELN])
; 

[vishsaggi]

Yes, so can you see the fields VBELN and %Contract has few same values? Can you snapshot those field names and show us what you see?

[tmumaw · Accepted solution]

I'm so sorry I did not get back to you sooner.  I finally figured it out.  I have attached a copy of my entire script just in case it happens to anyone else.  Thanks for all your help and time.