Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
;
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?
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.