SAP Helpdesk

Run this query to identity where the item has been used （on SQL table level）

declare @ItemCode nvarchar(50)
set @ItemCode = 'AAA'
select TA.* from
(SELECT 'OITT'[Type], COUNT(1) [Records]  FROM  OITT T0  WHERE T0.[Code] = @YourItemCode
UNION ALL
SELECT 'ITT1'[Type], COUNT(1) [Records]  FROM  ITT1 T0  WHERE T0.[Code] = @YourItemCode
UNION ALL
SELECT 'OCLG'[Type], COUNT(1) [Records]  FROM  OCLG T0  WHERE T0.[DocType] = ('4')  AND  T0.[DocNum] = @YourItemCode
UNION ALL
SELECT 'OIVL'[Type], COUNT(1) [Records]  FROM  OIVL T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'OITL'[Type], COUNT(1) [Records]  FROM  OITL T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'QUT1'[Type], COUNT(1) [Records]  FROM  QUT1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'RDR1'[Type], COUNT(1) [Records]  FROM  RDR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'POR1'[Type], COUNT(1) [Records]  FROM  POR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'OWOR'[Type], COUNT(1) [Records]  FROM  OWOR T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'WOR1'[Type], COUNT(1) [Records]  FROM  WOR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'DRF1'[Type], COUNT(1) [Records]  FROM  DRF1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'DPI1'[Type], COUNT(1) [Records]  FROM  DPI1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'DPO1'[Type], COUNT(1) [Records]  FROM  DPO1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'ORCM'[Type], COUNT(1) [Records]  FROM  ORCM T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'OSCL'[Type], COUNT(1) [Records]  FROM  OSCL T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'OINS'[Type], COUNT(1) [Records]  FROM  OINS T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CTR1'[Type], COUNT(1) [Records]  FROM  CTR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'OSLT'[Type], COUNT(1) [Records]  FROM  OSLT T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'DLN1'[Type], COUNT(1) [Records]  FROM  DLN1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'RDN1'[Type], COUNT(1) [Records]  FROM  RDN1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'INV1'[Type], COUNT(1) [Records]  FROM  INV1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'RIN1'[Type], COUNT(1) [Records]  FROM  RIN1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'PDN1'[Type], COUNT(1) [Records]  FROM  PDN1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'RPD1'[Type], COUNT(1) [Records]  FROM  RPD1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'PCH1'[Type], COUNT(1) [Records]  FROM  PCH1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'RPC1'[Type], COUNT(1) [Records]  FROM  RPC1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'IPF1'[Type], COUNT(1) [Records]  FROM  IPF1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CIN1'[Type], COUNT(1) [Records]  FROM  CIN1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CSI1'[Type], COUNT(1) [Records]  FROM  CSI1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CSV1'[Type], COUNT(1) [Records]  FROM  CSV1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CPI1'[Type], COUNT(1) [Records]  FROM  CPI1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CPV1'[Type], COUNT(1) [Records]  FROM  CPV1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'WTQ1'[Type], COUNT(1) [Records]  FROM  WTQ1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'PQT1'[Type], COUNT(1) [Records]  FROM  PQT1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'IQI1'[Type], COUNT(1) [Records]  FROM  IQI1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'IQR1'[Type], COUNT(1) [Records]  FROM  IQR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'WTR1'[Type], COUNT(1) [Records]  FROM  WTR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'IGN1'[Type], COUNT(1) [Records]  FROM  IGN1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'IGE1'[Type], COUNT(1) [Records]  FROM  IGE1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'PRQ1'[Type], COUNT(1) [Records]  FROM  PRQ1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'OAT1'[Type], COUNT(1) [Records]  FROM  OAT1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'CPN2'[Type], COUNT(1) [Records]  FROM  CPN2 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'INC1'[Type], COUNT(1) [Records]  FROM  INC1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'ACQ1'[Type], COUNT(1) [Records]  FROM  ACQ1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'MDP1'[Type], COUNT(1) [Records]  FROM  MDP1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'FTR1'[Type], COUNT(1) [Records]  FROM  FTR1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'ACD1'[Type], COUNT(1) [Records]  FROM  ACD1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'RTI1'[Type], COUNT(1) [Records]  FROM  RTI1 T0  WHERE T0.[ItemCode] = @YourItemCode
UNION ALL
SELECT 'FAR1'[Type], COUNT(1) [Records]  FROM  FAR1 T0  WHERE T0.[ItemCode] = @YourItemCode
) TA
where TA.Records <> 0