Aprende en Comunidad
Avalados por :
Análise do Consumo de Materiais e Valores no SAP: Relatório de FIFO e Valores Reais.
- Creado 01/03/2024
- Modificado 01/03/2024
- 2 Vistas
SELECT distinct T0."ItemCode" AS "Itemcode",T1."U_UTL_BTNO",T0."DocDate",
T0."Dscription" AS "Item",T3."InvntryUom" as "UoM", T4."ItmsGrpNam",
/*select d."ItmsGrpNam" from oitb d where d."ItmsGrpNam"=[%3]*/
T2."PlannedQty" AS "Std. Qty",
T0."Quantity" AS "Issued Qty",
(T0."Quantity"- T2."IssuedQty" ) AS "Returned Qty",
(T0."Quantity"-(T0."Quantity"- T2."IssuedQty" ) ) AS "Consumption",
(T2."PlannedQty"-(T0."Quantity"- (T0."Quantity"- T2."IssuedQty" ) )) AS "Excess/Shortage",T5."Price",
((T0."Quantity"-(T0."Quantity"- T2."IssuedQty" ))*T0."Price") AS "Item rate",
(T0."Quantity"-(T0."Quantity"-T2."IssuedQty" )) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price") AS "Std Value (FIFO)",
(CASE WHEN ((T2."PlannedQty"-(T0."Quantity"- (T0."Quantity"- T2."IssuedQty" ))) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price")) = 0
THEN (T0."Quantity"-(T0."Quantity"-T2."IssuedQty" )) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price")
ELSE ((T2."PlannedQty"-(T0."Quantity"- (T0."Quantity"- T2."IssuedQty" ))) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price"))
END) AS "Actual Value (FIFO)"
FROM IGE1 T0 INNER JOIN OWOR T1 ON T0."BaseRef"= T1."DocNum" and T0."BaseType"=T1."ObjType"
INNER JOIN WOR1 T2 ON T1."DocEntry" = T2."DocEntry" AND T2."ItemCode" = T0."ItemCode"
INNER JOIN OITM T3 ON T0."ItemCode" = T3."ItemCode"
INNER JOIN OITB T4 ON T4."ItmsGrpCod" = T3."ItmsGrpCod"
INNER JOIN PDN1 T5 ON T5."ItemCode"= T2."ItemCode"
INNER JOIN OPDN T6 ON T6."DocEntry" = T5."DocEntry"
WHERE T4."ItmsGrpCod" IN ('100','101')
AND T0."DocDate" >= [%0] AND T0."DocDate" <= [%1] AND T1."U_UTL_BTNO" =[%2] AND T4."ItmsGrpNam"=[%3]
Sin respuestas
No hay respuestas para mostrar
Se el primero en responder
contacto@primeinstitute.com
(+51) 1641 9379
(+57) 1489 6964
© 2024 Copyright. Todos los derechos reservados.
Desarrollado por Prime Institute