Query factura proveedores

[Genzam]

Hola, busco ayuda con un query , que de trazabilidad de la factura de proveedores, # pedido relacionado, # oferta proveedores relacionada , fecha creación de la oferta.

El problema que tengo es que el query me da el # pedido, pero no me muestra el numero de la factura real de SAP, me muestra un numero interno.

[MatAlex]

Hola, puedes compartir tu consulta para ver en que podria estar mal, o puedo ayudarte creandola desde cero

[Genzam]

Hola, logre resolverlo de esta forma, cualquier recomendación es bienvenida

SELECT
    -- Información del proveedor y documentos
    T6."CardCode" AS "Codigo Proveedor",
    T6."CardName" AS "Nombre Proveedor",
    T10."PymntGroup" as "Dias Credito PR",
    T0."DocDate" AS "Fecha Contabilizacion OF",
    T0."CreateDate" AS "Fecha Creacion OF",
    T0."DocNum" AS "Num Oferta", --Dejar
    T7."U_NAME" as "Propietario", 
    T3."DocDate" AS "Fecha Contabilizacion Pedido",
    T3."CreateDate" AS "Fecha Creacion Pedido",
    T3."DocNum" AS "Num Pedido",--Dejar
    T5."DocDate" AS "Fecha Contabilizacion Fac",
    T5."CreateDate" AS "Fecha Creacion Fac",
    T5."DocNum" AS "Num Factura",
    T5."DocTotal" AS "Total Factura",
    T5."DocStatus" AS "Status Factura",
    T5."U_VTM_StatusRegistro" as "Status Registro",
    T5."Comments" as "Comentarios Factura",



    -- Información de pagos
    T9."DocNum" AS "No Pago",
    T9."DocDate" AS "Fecha Pago",
    IFNULL(SUM(T8."SumApplied"), SUM(T9."DocTotal")) AS "Pago Aplicado"

FROM 
    "OPQT" T0
INNER JOIN 
    "PQT1" T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN 
    "OPOR" T3 ON T2."TrgetEntry" = T3."DocEntry" AND T2."TargetType" = '22'
INNER JOIN 
    "PCH1" T4 ON T3."DocEntry" = T4."BaseEntry" AND T4."BaseType" = '22'
INNER JOIN 
    "OPCH" T5 ON T4."DocEntry" = T5."DocEntry"
INNER JOIN 
    "OCRD" T6 ON T5."CardCode" = T6."CardCode"
INNER JOIN
    "OUSR" T7 ON T7."USERID" = T0."UserSign"

-- Unir con tablas de pagos
LEFT JOIN 
    "VPM2" T8 ON T5."DocEntry" = T8."DocEntry"  -- Relaciona la factura con detalle de pago
LEFT JOIN 
    "OVPM" T9 ON T8."DocNum" = T9."DocEntry"  -- Relaciona detalle de pago con encabezado de pago
	
	
	--Condiciones de Pago
	
INNER JOIN OCTG T10 ON T6."GroupNum" = T10."GroupNum"

GROUP BY 
    T6."CardCode",
    T6."CardName",
    T10."PymntGroup",
    T0."DocDate",
    T0."CreateDate",
    T0."DocNum",
    T7."U_NAME",
    T3."DocDate",
    T3."CreateDate",
    T3."DocNum",
    T5."DocDate",
    T5."CreateDate",
    T5."DocNum",
    T5."DocTotal",
    T5."DocStatus",
    T5."U_VTM_StatusRegistro",
    T5."Comments",
    T9."DocNum",
    T9."DocDate"