点击此处--->   群内免费提供SAP练习系统（在群公告中）

加入QQ群：457200227（SAP S4 HANA技术交流） 群内免费提供SAP练习系统（在群公告中）

您好，我有一个包含一些其他产品的新产品目录，我只想在搜索中显示基本产品。 我添加了此查询索引，但我已经看到了所有变体：

" SELECT DISTINCT tbl.pk ，tbl.code FROM（{{SELECT DISTINCT {p： PK} AS pk，{p：code} AS代码来自{Product AS p左联接CustomerReview AS cr ON {cr：product} = {p：PK}}，其中{p：varianttype}为NULL AND（{p：modifiedtime} > =？lastIndexTime或{cr：modifiedtime}> =？lastIndexTime）}}联合{{选择DISTINCT {p：PK} AS pk，{p：code} AS代码来自{VariantProduct AS p JOIN产品AS bp1 ON {p： baseProduct} = {bp1：PK}左加入CustomerReview AS cr on {cr：product} = {bp1：PK}} {p：varianttype}为NULL并且（{bp1：modifiedtime}> =？lastIndexTime或{cr：modifiedtime }> =？lastIndexTime）}}联合{{选择DISTINCT {p：PK} AS pk，{p：code} AS代码来自{VariantProduct AS p JOIN VariantProduct AS bp1 ON {p：baseProduct} = {bp1：PK} JOIN 产品AS bp2 ON {bp1：baseProduct} = {bp2：PK}左加入CustomerReview AS cr ON {cr：product} = {bp2：PK}} WHERE {p：varianttype}为NULL AND（{bp2：modifiedtime}> = ？lastIndexTime或{cr：modifiedtime}> =？lastIndexTime） }}联盟{{选择{p：PK} AS pk，{p：code} AS代码来自{Product AS p}在{p：code} IN位置（{{选择DISTINCT {sl：productCode}来自{StockLevel AS sl} {sl：modifiedtime}> =？lastIndexTime}}）}}））tbl按tbl.code排序"

如何避免这种情况？

谢谢