Customer Business Partner Change Log History Query

2 months ago 13

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

Read Entire Article