LTVD Table by product number

[Former Member]

Hi gurus,

Trying to create a report for a client. Basically this will be a DNQ report, to notify their customers of products which have been disqualified, which were qualified before. Need to find Customer LTVD's for particular products which were sent out on particular dates. I have found the following tables: /SAPSLL/PREVDH and /SAPSLL/PREVDI, but I have not been able to find the link to the product. Any help on putting the pieces of the logic together would be great!!!

[Former Member · Accepted solution]

Hi Kaveh,

The link between /SAPSLL/PREVDH and the product master is the GUID_PR field.

You can get the GUID_PR by entering the product number in the PRVSY field of table /SAPSLL/PNTPR in SE16.

Once you have the GUID_PR you can then enter it into /SAPSLL/PREVDH and check the number of entries.

There is no direct link between /SAPSLL/PREVDI and the product master but you can link through /SAPSLL/PREVDH using the GUID_PREVDH field.

PNTPR -> (GUID_PR) -> PREVDH -> (GUID_PREVDH) -> PREVDI

Best Regards,

Eoin