Error deAmbigüedad

2020-09-06 15:10发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

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


EstimadosSeñores,

SAP B1的结果查询错误和错误

错误: 1)。 [SAP AG] [LIBODBCHDB32 DLL] [HDBODBC32]常规错误;模糊定义了268列:名称:第56列第47行'Alertas recibidas'(OAIB) (位于pos 3891)

查询:

选择" ItemCode"为" Codigo_SAP"," U_EXX_CGET"为" Codigo_GET"," U_EXX_CBAR"为" Codigo_Barra","名称"为" Categoria"," U_EXX_FE_UNSPSC","名称"为" Marca",
 " ItemName"作为" Descripcion"," UgpCode"作为" UM"," AvgPrice"作为" Costo S/。"," U_HAK_COSDOS"作为" Costo USD",
 (MAX(" ROW_NUM" = 2则" OnHand"为ELSE 0 END的情况)+
   MAX(" ROW_NUM" = 4则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 23则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 14则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 9则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 16则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 20,然后" OnHand"为ELSE 0 END的情况)+
   MAX(" ROW_NUM" = 17则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 18则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 19则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 12则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 15则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 22则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 24则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 25则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 13则为" OnHand",否则为0 END的情况))
  作为"库存总额",
 "已提交"为" Comprometido",
 (IFNULL((SELECT SUM(TX。" OpenQty")FROM POR1 TX WHERE TX。" LineStatus" ='O'AND TX。" ItemCode" = AA。" ItemCode"),0)
 + IFNULL((SELECT SUM(TX。" OpenQty")来自TX的PCH1 TX内连接选项。" DocEntry" = TY。" DocEntry" WHERE TX。" LineStatus" ='O'和TY。" isIns" ='  Y'AND TX。" ItemCode" = AA。" ItemCode"),0))
 作为" En Transito"," ItmsGrpNam"作为" Linea de Negocio",
   MAX(" ROW_NUM" = 2,然后" OnHand"为ELSE NULL END的情况)为" CALLAO",
   MAX(" ROW_NUM" = 6,然后" OnHand"为ELSE NULL END的情况)为" RESERVADOS",
   MAX(" ROW_NUM" = 4,然后" OnHand"为ELSE NULL END的情况)为" CALLAO-RESEMIN",
   MAX(" ROW_NUM" = 23,然后" OnHand"为ELSE NULL END的情况)为" RESEMIN",
   MAX(" ROW_NUM" = 14,然后" OnHand"为ELSE NULL END的情况)为" LIMA-BLENDING",
   MAX(" ROW_NUM" = 9,然后" OnHand"为ELSE NULL END的情况)为" LIMA-RANSA",
   MAX(" ROW_NUM" = 16,然后" OnHand"为ELSE NULL END的情况)为" CHIMBOTE-CD",
   MAX(" ROW_NUM" = 20,然后" OnHand"为ELSE NULL END的情况)为" TRUJILLO-CD",
   MAX(" ROW_NUM" = 17,然后" OnHand"为ELSE NULL END的情况)为" AREQUIPA-CD",
   MAX(" ROW_NUM" = 18,然后" OnHand"为ELSE NULL END的情况)为" ILO-CD",
   MAX(" ROW_NUM" = 19则为" OnHand",否则为NULL END的情况)为" ILO-SOUTHERN",
   MAX(" ROW_NUM" = 12,然后" OnHand"为ELSE NULL END的情况)为" PIURA-KMMP",
   MAX(" ROW_NUM" = 15,然后" OnHand"为ELSE NULL END的情况)为" PIURA-AG CHIRA",
   MAX(" ROW_NUM" = 22,然后" OnHand"为ELSE NULL END的情况)为" ANTAPACCAY",
   MAX(" ROW_NUM" = 24,然后" OnHand"为ELSE NULL END的情况)为" COSAPI",
   MAX(" ROW_NUM" = 25,然后" OnHand"为ELSE NULL END的情况)为" KITENI",
   MAX(" ROW_NUM" = 13,然后" OnHand"为ELSE NULL END的情况)为" LAS BAMBAS"
 从
 (
 选择T0。" ItemCode",T2。" U_EXX_CGET",T2。" U_EXX_CBAR",T6。"名称",T2。" U_EXX_FE_UNSPSC",T3。"名称",
 T2。" ItemName",T4。" UgpCode",T2。" AvgPrice",T2。" U_HAK_COSDOS",T2。" OnHand" AS" En_Stock",T2。" IsCommited",T2。" OnOrder",T5。" ItmsGrpNam  ",T0。" WhsCode",T0。" OnHand",
 row_number()超过(PARTITION BY T0。" ItemCode" ORDER BY T1。" createDate",T1。" WhsCode")作为" ROW_NUM"
 来自" SBO_MARCO_PE"。" OITW" T0
 内联接" SBO_MARCO_PE"。" OWHS" T1在T0上。" WhsCode" = T1。" WhsCode"
  内连接" SBO_MARCO_PE"。" OITM" T2在T0上。" ItemCode" = T2。" ItemCode"
  左外联接" SBO_MARCO_PE"。" @ EXX_CAT2" T3在T2上。" U_EXX_CAT2" = T3。"代码"
                             左外联接" SBO_MARCO_PE"。" @ EXX_CAT3" T6在T2上。" U_EXX_CAT3" = T6。"代码"
  内连接" SBO_MARCO_PE"。" OUGP" T4在T2上。" UgpEntry" = T4。" UgpEntry"
  内部联接" SBO_MARCO_PE"。" OITB" T5在T2上。" ItmsGrpCod" = T5。" ItmsGrpCod"
  T1。" WhsCode"与" 01"和T2类似。" frozenFor" ='N'AND SUBSTRING(T2。" ItemCode",0,1)='A'
  按T0排序。" ItemCode"
 )AA
 GROUP BY" ItemCode"," U_EXX_CGET"," U_EXX_CBAR","名称"," U_EXX_FE_UNSPSC","名称"," ItemName"," UgpCode"," AvgPrice"," U_HAK_COSDOS"," En_Stock","已提交"  " OnOrder"," ItmsGrpNam"
 ORDER BY" ItemCode"
 

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

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


EstimadosSeñores,

SAP B1的结果查询错误和错误

错误: 1)。 [SAP AG] [LIBODBCHDB32 DLL] [HDBODBC32]常规错误;模糊定义了268列:名称:第56列第47行'Alertas recibidas'(OAIB) (位于pos 3891)

查询:

选择" ItemCode"为" Codigo_SAP"," U_EXX_CGET"为" Codigo_GET"," U_EXX_CBAR"为" Codigo_Barra","名称"为" Categoria"," U_EXX_FE_UNSPSC","名称"为" Marca",
 " ItemName"作为" Descripcion"," UgpCode"作为" UM"," AvgPrice"作为" Costo S/。"," U_HAK_COSDOS"作为" Costo USD",
 (MAX(" ROW_NUM" = 2则" OnHand"为ELSE 0 END的情况)+
   MAX(" ROW_NUM" = 4则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 23则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 14则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 9则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 16则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 20,然后" OnHand"为ELSE 0 END的情况)+
   MAX(" ROW_NUM" = 17则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 18则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 19则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 12则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 15则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 22则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 24则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 25则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 13则为" OnHand",否则为0 END的情况))
  作为"库存总额",
 "已提交"为" Comprometido",
 (IFNULL((SELECT SUM(TX。" OpenQty")FROM POR1 TX WHERE TX。" LineStatus" ='O'AND TX。" ItemCode" = AA。" ItemCode"),0)
 + IFNULL((SELECT SUM(TX。" OpenQty")来自TX的PCH1 TX内连接选项。" DocEntry" = TY。" DocEntry" WHERE TX。" LineStatus" ='O'和TY。" isIns" ='  Y'AND TX。" ItemCode" = AA。" ItemCode"),0))
 作为" En Transito"," ItmsGrpNam"作为" Linea de Negocio",
   MAX(" ROW_NUM" = 2,然后" OnHand"为ELSE NULL END的情况)为" CALLAO",
   MAX(" ROW_NUM" = 6,然后" OnHand"为ELSE NULL END的情况)为" RESERVADOS",
   MAX(" ROW_NUM" = 4,然后" OnHand"为ELSE NULL END的情况)为" CALLAO-RESEMIN",
   MAX(" ROW_NUM" = 23,然后" OnHand"为ELSE NULL END的情况)为" RESEMIN",
   MAX(" ROW_NUM" = 14,然后" OnHand"为ELSE NULL END的情况)为" LIMA-BLENDING",
   MAX(" ROW_NUM" = 9,然后" OnHand"为ELSE NULL END的情况)为" LIMA-RANSA",
   MAX(" ROW_NUM" = 16,然后" OnHand"为ELSE NULL END的情况)为" CHIMBOTE-CD",
   MAX(" ROW_NUM" = 20,然后" OnHand"为ELSE NULL END的情况)为" TRUJILLO-CD",
   MAX(" ROW_NUM" = 17,然后" OnHand"为ELSE NULL END的情况)为" AREQUIPA-CD",
   MAX(" ROW_NUM" = 18,然后" OnHand"为ELSE NULL END的情况)为" ILO-CD",
   MAX(" ROW_NUM" = 19则为" OnHand",否则为NULL END的情况)为" ILO-SOUTHERN",
   MAX(" ROW_NUM" = 12,然后" OnHand"为ELSE NULL END的情况)为" PIURA-KMMP",
   MAX(" ROW_NUM" = 15,然后" OnHand"为ELSE NULL END的情况)为" PIURA-AG CHIRA",
   MAX(" ROW_NUM" = 22,然后" OnHand"为ELSE NULL END的情况)为" ANTAPACCAY",
   MAX(" ROW_NUM" = 24,然后" OnHand"为ELSE NULL END的情况)为" COSAPI",
   MAX(" ROW_NUM" = 25,然后" OnHand"为ELSE NULL END的情况)为" KITENI",
   MAX(" ROW_NUM" = 13,然后" OnHand"为ELSE NULL END的情况)为" LAS BAMBAS"
 从
 (
 选择T0。" ItemCode",T2。" U_EXX_CGET",T2。" U_EXX_CBAR",T6。"名称",T2。" U_EXX_FE_UNSPSC",T3。"名称",
 T2。" ItemName",T4。" UgpCode",T2。" AvgPrice",T2。" U_HAK_COSDOS",T2。" OnHand" AS" En_Stock",T2。" IsCommited",T2。" OnOrder",T5。" ItmsGrpNam  ",T0。" WhsCode",T0。" OnHand",
 row_number()超过(PARTITION BY T0。" ItemCode" ORDER BY T1。" createDate",T1。" WhsCode")作为" ROW_NUM"
 来自" SBO_MARCO_PE"。" OITW" T0
 内联接" SBO_MARCO_PE"。" OWHS" T1在T0上。" WhsCode" = T1。" WhsCode"
  内连接" SBO_MARCO_PE"。" OITM" T2在T0上。" ItemCode" = T2。" ItemCode"
  左外联接" SBO_MARCO_PE"。" @ EXX_CAT2" T3在T2上。" U_EXX_CAT2" = T3。"代码"
                             左外联接" SBO_MARCO_PE"。" @ EXX_CAT3" T6在T2上。" U_EXX_CAT3" = T6。"代码"
  内连接" SBO_MARCO_PE"。" OUGP" T4在T2上。" UgpEntry" = T4。" UgpEntry"
  内部联接" SBO_MARCO_PE"。" OITB" T5在T2上。" ItmsGrpCod" = T5。" ItmsGrpCod"
  T1。" WhsCode"与" 01"和T2类似。" frozenFor" ='N'AND SUBSTRING(T2。" ItemCode",0,1)='A'
  按T0排序。" ItemCode"
 )AA
 GROUP BY" ItemCode"," U_EXX_CGET"," U_EXX_CBAR","名称"," U_EXX_FE_UNSPSC","名称"," ItemName"," UgpCode"," AvgPrice"," U_HAK_COSDOS"," En_Stock","已提交"  " OnOrder"," ItmsGrpNam"
 ORDER BY" ItemCode"
 
付费偷看设置
发送
1条回答
骆驼绵羊
1楼-- · 2020-09-06 15:44

Hola,

La columna"名称"是"从名称中选择",然后从FROM中选择como en lacláusula。

将" ItemCode"选择为" Codigo_SAP"
 ," U_EXX_CGET"为" Codigo_GET"
 ," U_EXX_CBAR"为" Codigo_Barra"
 ,"名称"为"类别"/img/* <----- */
 ," U_EXX_FE_UNSPSC"
 ,"名称"为"马卡"/img/* <----- */
 ," ItemName"为" Descripcion"
 ," UgpCode"为" UM"
 ," AvgPrice" AS" Costo S/"。
 ," U_HAK_COSDOS"为" Costo USD"
 ,(MAX(CASE WHEN" ROW_NUM" = 2 THEN" OnHand" ELSE 0 END)+
   MAX(" ROW_NUM" = 4则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 23则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 14则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 9则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 16则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 20,然后" OnHand"为ELSE 0 END的情况)+
   MAX(" ROW_NUM" = 17则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 18则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 19则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 12则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 15则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 22则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 24则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 25则为" OnHand",否则为0 END的情况)+
   MAX(" ROW_NUM" = 13则为" OnHand",否则为0 END的情况))
  作为"库存总额",
 "已提交"为" Comprometido",
 (IFNULL((SELECT SUM(TX。" OpenQty")FROM POR1 TX WHERE TX。" LineStatus" ='O'AND TX。" ItemCode" = AA。" ItemCode"),0)
 + IFNULL((SELECT SUM(TX。" OpenQty")来自TX的PCH1 TX内连接选项。" DocEntry" = TY。" DocEntry" WHERE TX。" LineStatus" ='O'和TY。" isIns" ='  Y'AND TX。" ItemCode" = AA。" ItemCode"),0))
 作为" En Transito"
 ," ItmsGrpNam"为" Linea de Negocio",
   MAX(" ROW_NUM" = 2,然后" OnHand"为ELSE NULL END的情况)为" CALLAO",
   MAX(" ROW_NUM" = 6,然后" OnHand"为ELSE NULL END的情况)为" RESERVADOS",
   MAX(" ROW_NUM" = 4,然后" OnHand"为ELSE NULL END的情况)为" CALLAO-RESEMIN",
   MAX(" ROW_NUM" = 23,然后" OnHand"为ELSE NULL END的情况)为" RESEMIN",
   MAX(" ROW_NUM" = 14,然后" OnHand"为ELSE NULL END的情况)为" LIMA-BLENDING",
   MAX(" ROW_NUM" = 9,然后" OnHand"为ELSE NULL END的情况)为" LIMA-RANSA",
   MAX(" ROW_NUM" = 16,然后" OnHand"为ELSE NULL END的情况)为" CHIMBOTE-CD",
   MAX(" ROW_NUM" = 20,然后" OnHand"为ELSE NULL END的情况)为" TRUJILLO-CD",
   MAX(" ROW_NUM" = 17,然后" OnHand"为ELSE NULL END的情况)为" AREQUIPA-CD",
   MAX(" ROW_NUM" = 18,然后" OnHand"为ELSE NULL END的情况)为" ILO-CD",
   MAX(" ROW_NUM" = 19则为" OnHand",否则为NULL END的情况)为" ILO-SOUTHERN",
   MAX(" ROW_NUM" = 12,然后" OnHand"为ELSE NULL END的情况)为" PIURA-KMMP",
   MAX(" ROW_NUM" = 15,然后" OnHand"为ELSE NULL END的情况)为" PIURA-AG CHIRA",
   MAX(" ROW_NUM" = 22,然后" OnHand"为ELSE NULL END的情况)为" ANTAPACCAY",
   MAX(" ROW_NUM" = 24,然后" OnHand"为ELSE NULL END的情况)为" COSAPI",
   MAX(" ROW_NUM" = 25,然后" OnHand"为ELSE NULL END的情况)为" KITENI",
   MAX(" ROW_NUM" = 13,然后" OnHand"为ELSE NULL END的情况)为" LAS BAMBAS"
 从
 (
 选择T0。" ItemCode"
 ,T2。" U_EXX_CGET"
 ,T2。" U_EXX_CBAR"
 ,T6。"名称"/img/* <----- */
 ,T2。" U_EXX_FE_UNSPSC"
 ,T3。"名称",/* <----- */
 T2。" ItemName"
 ,T4。" UgpCode"
 ,T2。"平均价格"
 ,T2。" U_HAK_COSDOS"
 ,T2。" OnHand"为" En_Stock"
 ,T2。"已提交"
 ,T2。" OnOrder"
 ,T5。" ItmsGrpNam"
 ,T0。" WhsCode"
 T0。" OnHand",
 row_number()超过(PARTITION BY T0。" ItemCode" ORDER BY T1。" createDate",T1。" WhsCode")作为" ROW_NUM"
 来自" SBO_MARCO_PE"。" OITW" T0
 内联接" SBO_MARCO_PE"。" OWHS" T1在T0上。" WhsCode" = T1。" WhsCode"
  内连接" SBO_MARCO_PE"。" OITM" T2在T0上。" ItemCode" = T2。" ItemCode"
  左外联接" SBO_MARCO_PE"。" @ EXX_CAT2" T3在T2上。" U_EXX_CAT2" = T3。"代码"
                             左外联接" SBO_MARCO_PE"。" @ EXX_CAT3" T6在T2上。" U_EXX_CAT3" = T6。"代码"
  内连接" SBO_MARCO_PE"。" OUGP" T4在T2上。" UgpEntry" = T4。" UgpEntry"
  内部联接" SBO_MARCO_PE"。" OITB" T5在T2上。" ItmsGrpCod" = T5。" ItmsGrpCod"
  T1。" WhsCode"与" 01"和T2类似。" frozenFor" ='N'AND SUBSTRING(T2。" ItemCode",0,1)='A'
  按T0排序。" ItemCode"
 )AA
 GROUP BY" ItemCode"," U_EXX_CGET"," U_EXX_CBAR","名称"," U_EXX_FE_UNSPSC","名称"," ItemName"," UgpCode"," AvgPrice"," U_HAK_COSDOS"," En_Stock","已提交"  " OnOrder"," ItmsGrpNam"
 ORDER BY" ItemCode"
 

Saludos

Johan

一周热门 更多>