点击此处---> 群内免费提供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"
Hola,
La columna"名称"是"从名称中选择",然后从FROM中选择como en lacláusula。
Saludos
Johan
一周热门 更多>