Hi All
Please assistance to amended my Query to amusement SAP User Code and Name who Create Customer BP and SAP User and Name who Updated BP, thanks!
SELECT T0.[CardCode], T0.[CardName], T2.[GroupName],T3.[PymntGroup], T0.[CreateDate], T1.[UpdateDate], T1.[CardName], T1.[GroupCode], T1.[GroupNum], T1.[Currency], T1.[CntctPrsn], T1.[Building], T1.[Cellular], T1.[VatGroup], T1.[BankCode], T1.[BankCtlKey], T1.[DebPayAcct], T0.[OwnerCode], T1.[RepName], T1.[IsDomestic], T1.[IsResident], T1.[OwnerCode], T1.[MandateID], T1.[SignDate], T1.[RepFName], T1.[RepSName] FROM [dbo].[OCRD] T0 INNER JOIN [dbo].[ACRD] T1 ON T0.[CardCode] = T1.[CardCode] INNER JOIN OCRG T2 ON T0.[GroupCode] = T2.[GroupCode] INNER JOIN OCTG T3 ON T0.[GroupNum] = T3.[GroupNum] WHERE T0.[CardCode] =[%0]
Kedalene Chong