Qlik Community

QlikView Connector for SAP

Discussion Board for collaboration related to the QlikView Connector for SAP.

Highlighted
Not applicable

Need help with setting up a SAP model in QlikSense

Hi Team,

Has anyone of you worked with replicating or creating a Qlik Data Model using SAP BW.

I am trying to connect the below tables.

BKPF

BSEG

T001

TGSBT

CEPCT

FAGL_011PC

FAGL_011QT

Any help is much appreciated.

Tags (1)
5 Replies
shraddha_g
Honored Contributor III

Re: Need help with setting up a SAP model in QlikSense

What is the issue?

Not applicable

Re: Need help with setting up a SAP model in QlikSense

I have been unable to successfully link BSEG, T001, SKAT and TGSBT with FAGL_011PC tables.

How do I link the parent child nodes ?

my load query is below.

FACT:

Load

BUKRS as [Company Code],

BELNR as [Document Number],

GSBER as [Business Area],

WRBTR as [Amount],

SAKNR as [GL Account Number],

GJAHR as [Fiscal Year],

BUZEI as [Item Number],

Month(AUGDT) as Month,

Year(AUGDT) as Year;

SQL

SUBSELECT BUKRS BELNR GSBER WRBTR SAKNR GJAHR BUZEI BUZID AUGDT

FROM BSEG

WHERE BUKRS BELNR GJAHR IN ( SELECT BUKRS BELNR GJAHR FROM BKPF );

Left Join (FACT)
LOAD
BUKRS as [Company Code],
BUTXT as [Company Name],
SPRAS as [Language];

SELECT
BUKRS,
BUTXT,
SPRAS,
FROM T001
WHERE (SPRAS = 'EN' OR SPRAS = 'E') and KTOPL = '0010';


LOAD
SPRAS as [Language],
    SAKNR as [GL Account Number],
TXT50 as [GL Account Description];

SELECT
SPRAS,
    SAKNR,
    TXT50
FROM SKAT
WHERE (SPRAS = 'EN' OR SPRAS = 'E') and KTOPL = '0010';


LOAD
GSBER as [Business Area],
GTEXT as [Business Area Description];

SELECT
GSBER,
GTEXT
 
FROM TGSBT;

shraddha_g
Honored Contributor III

Re: Need help with setting up a SAP model in QlikSense

What is the error you are getting?

Re: Need help with setting up a SAP model in QlikSense

Hmmm, I think you'll have a better chance at getting useful feedback if you ask this question in an SAP forum. There are hundreds of them.

Re: Need help with setting up a SAP model in QlikSense

For example, at the center of the SAP world:

SAP Answers - SAP Answers

and select "Ask a Question" from the +Actions menu in the top right corner.