topic Re: Qlikview SAP Query in QlikView

Qlikview SAP Query

panipat1990 — Tue, 29 Mar 2016 12:07:30 GMT

Hi Team,

We have Payable table on SAP ECC system and we have implemented some ABAP code on same system for Getting Month wise Payable Amount for each customer.

After doing this, we have stored that tables in 'Z' TABLE on SAP System. and then we have exported the same table in .xls format. And we are pulling that .xls in our qlikview. That is very time consuming process and long approach.

So, we want to directly Hit SAP system for pulling Same payable table and whatever the ABAP code we have to write , we need to write at qlikview side during extraction time.

I need your help. Please suggest me what is the possible way we can use to write the query on qlikview side.

Thanks

Gourav

Re: Qlikview SAP Query

robert_mika — Tue, 29 Mar 2016 12:28:29 GMT

Did you consider to use:

QlikView Connector for SAP

Re: Qlikview SAP Query

Tue, 29 Mar 2016 13:38:02 GMT

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

Re: Qlikview SAP Query

panipat1990 — Wed, 30 Mar 2016 04:53:26 GMT

Yes Robert, Now we are using SAP connector for extracting tables.

Sales header and Sales detail kind of tables where ABAP code is not written , i am able to extract directly from SAP system.

But for that tables where SAP Guy has implement some ABAP logic , that i need to write that ABAP script for that table on Qlikview side during extraction.

please suggest me the possible way.

Thanks

Gourav Sikka

Re: Qlikview SAP Query

panipat1990 — Wed, 30 Mar 2016 04:58:47 GMT

Thanks Agustin,

Through SAP Connector, the simple table(like [MPLA]) without ABAP logic , i am able to fetch from SAP System.

But my requirement is :-

suppose we have written some ABAP logic on SAP system for [MPLA] table.

i need to write that ABAP code on Qlik end during extraction of this [MPLA] table from SAP System.

Best Regards

Gourav Sikka