Hi Gourav Sikka,
I'm working with Qlikview and SAP, I use the connector QvSAPBAPIConnector.dll (64) (Are in the script's option of data base)
I use this to connect Qlikview with SAP. You will pass the id, user, psw, etc
Once have this, then I load the table of SAP in Qlikview.
Will be something like this, in this case I load the table MPLA of SAP (preview configuration of SAP connector and connection succes with SAP)
[MPLA]: // Plan de mantenimiento
Load
MANDT & WARPL AS %KEY_MPLA_MANDT_WARPL,
[MANDT] as [Mandante_MANDT.MPLA],
[WARPL] as [Plan mant.prev._WARPL.MPLA],
[ERKNZ] as [Ind.creac._ERKNZ.MPLA],
[AEKNZ] as [Ind.modific._AEKNZ.MPLA],
[ERSDT] as [Creado el_ERSDT.MPLA],
[ERNAM] as [Creado por_ERNAM.MPLA],
[AEDAT] as [Modificado el_AEDAT.MPLA],
[AENAM] as [Modificado por_AENAM.MPLA],
[WPTXT] as [Txt plan MT_WPTXT.MPLA],
[STRAT] as [Estrategia_STRAT.MPLA],
[ABRHO] as [Intervalo toma_ABRHO.MPLA],
[EQUNR] as [Equipo_EQUNR.MPLA],
[TPLNR] as [Ubic.técn._TPLNR.MPLA],
[KUNUM] as [Cliente_KUNUM.MPLA],
[LTKNZ] as [Ind.txt.expl._LTKNZ.MPLA],
[LVORM] as [Bloqueado_LVORM.MPLA],
[ANZPS] as [Ctd.posiciones_ANZPS.MPLA],
[ABNUM] as [Número de toma_ABNUM.MPLA],
[LANGU] as [Idioma_LANGU.MPLA],
[VSPOS] as [Concl.retrasada_VSPOS.MPLA],
[VSNEG] as [Concl.anticip._VSNEG.MPLA],
[TOPOS] as [Tolerancia (+)_TOPOS.MPLA],
[TONEG] as [Tolerancia (-)_TONEG.MPLA],
[SFAKT] as [Factor dilatac._SFAKT.MPLA],
[STICH] as [Ind.programac._STICH.MPLA],
[TGOON] as [Seguir program._TGOON.MPLA],
[HORIZ] as [Horizonte-apert_HORIZ.MPLA],
[HORIZ_DAYS] as [Horizonte-apert_HORIZ_DAYS.MPLA],
[HORIZ_QUALIFIER] as [Clase de cálculo_HORIZ_QUALIFIER.MPLA],
[ANDOR] as [Clase conexión_ANDOR.MPLA],
[KNAUT] as [Reserva_KNAUT.MPLA],
[BEGRU] as [Grupo autoriz._BEGRU.MPLA],
[OBJNR] as [Nº objeto_OBJNR.MPLA],
[MPTYP] as [Tp.pl.manten._MPTYP.MPLA],
[HUNIT] as [Un.interv.toma_HUNIT.MPLA],
[STADT] as [Inicio de ciclo_STADT.MPLA],
[SZAEH] as [ValInicContador_SZAEH.MPLA],
[CALL_CONFIRM] as [Sujeto a concl._CALL_CONFIRM.MPLA],
[PLAN_SORT] as [Campo clasif._PLAN_SORT.MPLA],
[FABKL] as [Cal-fábrica_FABKL.MPLA],
[PUFFP] as [Holgura adel._PUFFP.MPLA],
[PUFFN] as [Holgura retraso_PUFFN.MPLA],
[START_DATE] as [Fecha de inicio_START_DATE.MPLA],
[START_TIME] as [Hora inicio_START_TIME.MPLA],
[CALL_UPDATE_IND] as [Ajuste fe.extre_CALL_UPDATE_IND.MPLA],
[IND_MPLA_API] as [PMP vía API_IND_MPLA_API.MPLA],
[MCP_SF] as [Fact.decal.PMM_MCP_SF.MPLA];
SQL Select MANDT LANGU AEDAT ERNAM AENAM OBJNR BEGRU
EQUNR TPLNR PUFFP KUNUM WARPL ABNUM START_DATE START_TIME
HORIZ MPTYP LVORM FABKL STADT ERSDT STRAT ANZPS PUFFN ERKNZ
AEKNZ WPTXT ABRHO LTKNZ VSPOS VSNEG TOPOS TONEG SFAKT STICH
TGOON KNAUT IND_MPLA_API SZAEH PLAN_SORT HUNIT CALL_CONFIRM
HORIZ_DAYS HORIZ_QUALIFIER ANDOR CALL_UPDATE_IND MCP_SF
from MPLA
;
I hope that help you,
Regards, Agustín
