Has anyone of you worked with replicating or creating a Qlik Data Model using SAP BW.
I am trying to connect the below tables.
Any help is much appreciated.
What is the issue?
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.
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;
SUBSELECT BUKRS BELNR GSBER WRBTR SAKNR GJAHR BUZEI BUZID AUGDT
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 T001WHERE (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, TXT50FROM SKATWHERE (SPRAS = 'EN' OR SPRAS = 'E') and KTOPL = '0010';
LOAD GSBER as [Business Area], GTEXT as [Business Area Description];
SELECT GSBER, GTEXT FROM TGSBT;
What is the error you are getting?
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.
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.