Buenas Tardes Comunidad SAP.
Estoy haciendo un query para sacar los proveedores que tienen facturas pendientes por pagar. pero me están solicitando por ejemplo que quieren ver algunos proveedores que escojan. Adjunto el query que tengo
SELECT T1."U_HBT_TipDoc" AS "Tipo Identificacion", T1."LicTradNum" AS "Numero de Identificacion", T0."CardName" AS "Nombre", T1."BankCode" AS "Codigo Banco", 'CA' AS "Tipo Producto", T1."DflAccount" AS "Numero de Producto", (T0."DocTotal"-T0."PaidToDate") AS "Saldo Factura",
T0."DocEntry" AS "Abrir Documento", T0."DocNum" AS "N° de Factura", T0."NumAtCard" AS "N° de Factura Proveedor",
CASE
WHEN T0."CANCELED" = 'C' AND T0."DocStatus" = 'C' THEN 'Cerrado'
WHEN T0."CANCELED" = 'N' AND T0."DocStatus" = 'C' THEN 'Cerrado'
WHEN T0."CANCELED" = 'N' AND T0."DocStatus" = 'O' THEN 'Abierto'
WHEN T0."CANCELED" = 'Y' AND T0."DocStatus" = 'C' THEN 'Cancelado'
END "Estado Factura",
T0."DocDate", T0."DocDueDate", T0."CardCode", T0."CardName", T0."DocTotal" AS "Total Factura", T0."PaidToDate" AS "Abonado", (T0."DocTotal"-T0."PaidToDate") AS "Saldo Factura", T1."BankCode", T2."BankName", T1."DflAccount", T1."U_HBT_TipDoc", T3."U_HBT_TipoDocICa", T1."LicTradNum" AS "RUT"
FROM OPCH T0
INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
LEFT JOIN ODSC T2 ON T1."BankCode" = T2."BankCode"
LEFT JOIN "CONCRELABP"."@HBT_TIPODOC" T3 ON T1."U_HBT_TipDoc" = T3."Code"
WHERE T0."CANCELED" = 'N'
AND T0."CardCode" IN ('[%0%]','[%1%]')
AND T0."DocStatus" = 'O'
La idea que tengo es que en el criterio de selección salgan como un check de los proveedores que quiero revisar.
Muchas Gracias por el apoyo brindado.
David Sepulveda
