索引变体产品时出现问题

2020-09-22 12:45发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)您好,我有一个包含一些其他产品的...

         点击此处--->   EasySAP.com群内免费提供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排序"

替代文字

如何避免这种情况?

谢谢

(229.2 kB)
5条回答
Climb_Ma
2020-09-22 13:34

谢谢,Ramy,这非常有帮助,我做的完全一样,但是仍然无法正常工作,我不明白这是什么错误

这些变体已在我的impex中定义:

  INSERT_UPDATE ApparelSizeVariantProduct; code [unique = true]; $ catalogVersion; $ baseProduct; supercategories(code,$ catalogVersion); unit(code)[default ='pieces'] ;;;;  $ approved; $ taxGroup
  ; SB0000015_SIZE_36 ;; SB0000015; Gucci,泵浦;件;;;
  ; SB0000015_SIZE_37 ;; SB0000015; Gucci,泵浦;件;;;
  ; SB0000015_SIZE_38 ;; SB0000015; Gucci,泵浦;件;;;
  ; SB0000015_SIZE_39 ;; SB0000015; Gucci,泵浦;件;;;
  ; SB0000014_SIZE ;; SB0000014; Gucci,泵浦;件;;;
  ; SB0000013_SIZE ;; SB0000013; Gucci,泵浦;件;;;
  ; SB0000014_SIZE_36 ;; SB0000014; Gucci,泵浦;件;;;
  ; SB0000014_SIZE_37 ;; SB0000014; Gucci,泵浦;件;;;
  ; SB0000014_SIZE_38 ;; SB0000014; Gucci,泵浦;件;;;
  ; SB0000014_SIZE_39 ;; SB0000014; Gucci,泵浦;件;;;
  ; SB0000013_SIZE_36 ;; SB0000013; Gucci,泵浦;件;;;
  ; SB0000013_SIZE_37 ;; SB0000013; Gucci,泵浦;件;;;
  ; SB0000013_SIZE_38 ;; SB0000013; Gucci,泵浦;件;;;
  ; SB0000013_SIZE_39 ;; SB0000013; Gucci,泵浦;件;;;
  ; SB0000012_SIZE_XS ;; SB0000012; Gucci,T恤衫; pieces ;;;
  ; SB0000012_SIZE_S ;; SB0000012; Gucci,T恤衫;件;;;
  ; SB0000012_SIZE_M ;; SB0000012; Gucci,T恤衫;件;;;
  ; SB0000012_SIZE_L ;; SB0000012; Gucci,T恤衫;件;;;

  

并且我已将分组配置如下:

替代文字

一周热门 更多>