Customer Business Partner Change Log History Query

[kedalenechong]

Hi All

Please help to improve my Query to show 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

[kedalenechong]

Happy to know new Audit Trial Change Log History report is delivered in new patch 2408.

[LoHa]

Hi Kedalene,

have a look here

SELECT 
TOP 1 
 UserSign AS [CreateUser]
,CreateDate 
,CreateTS
,UserSign2 [UpdateUser]
,UpdateDate
,UpdateTS
,* 
FROM OCRD

You can join to OUSR for UserName

regards Lothar

[kedalenechong]

Hi Lothar I cannot find Creator or Updater UserSign in OCRD or ACRD Table