¡Caminando hacia el éxito!

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
0
Cargando...

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]

Pedro Pascal
Se unió el 07/03/2018
Pinterest
Telegram
Linkedin
Whatsapp

Sin respuestas

No hay respuestas para mostrar 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

¡Hola! Soy Diana, asesora académica de Prime Institute, indícame en que curso estas interesado, saludos!
Hola ¿Puedo ayudarte?