6 Replies Latest reply: Mar 17, 2010 1:11 AM by smadan RSS

    SAP Connector

    Thom Mumaw

      Hey group quick easy question for you. I am using the SAPCONNECTOR to generate my SQL code here is a sample of my select stmt does anyone see anything wrong with it? Is the table name too long? That is what I am starting to think.

       

       

       

       

       





       

       

      SQL

       

       

      Select MANDT TEXT COSTCENTER MODIFYDATE CREATEDATE EMPLOYEEID

       

      CREATEID

       

       

      MODIFYID COMMENTDATE from

      ZPRDCOMMENTS

      Thanks





       

       

        • SAP Connector
          ivang

          Do you have commas between the fields, or do they just not show in your post?

          • SAP Connector
            Frank Siciliani

            Are you getting an error when try to load?

            Also, have you tried using the script builder to build your queries? It is a wonderful tool.

            Frank

              • SAP Connector
                Thom Mumaw

                Thanks. I am using the SAP Connector to generate the SQL code. What I did find out though CREATID is a reserved word in Qlikview. I changed the name to Z_CREATID and it works fine. Thanks for your help.

                  • SAP Connector

                    Hi all,

                     

                    Sap latest connector not allowing me to picked the cubes records after 2,39,400 3 times i have tested this , can i picked the sap cubes data through any other way out

                    can anyone help me it very urgent. please send me the syntax also my cube is like that.

                    [$0FIAR_C03]:
                    Load *;
                    Select PseudoMDX (
                    Dimensions (

                    [0ACCT_TYPE] (),
                    [0AC_DOC_TYP] (),
                    [0DOC_DATE] (),
                    [0NETDUEDATE] (),
                    [0PMNTTRMS] (),
                    [0POST_KEY] (),
                    [0PSTNG_DATE] (),

                    Measures (

                    [0MEASURES0000000000000000].[0DEB9CRE9LC00000000000000], //Amount in Local Currency with +/- Signs
                    [0MEASURES0000000000000000].[0DSC9AMT9DC00000000000000], //Cash discount amount in document currency
                    [0MEASURES0000000000000000].[0DSC9AMT9LC00000000000000], //Cash discount amount in local currency
                    [0MEASURES0000000000000000].[0CREDIT9DC000000000000000], //Credit amount in foreign currency
                    [0MEASURES0000000000000000].[0CREDIT9LC000000000000000], //Credit amount in local currency
                    [0MEASURES0000000000000000].[0DEBIT9DC0000000000000000], //Debit amount in foreign currency
                    [0MEASURES0000000000000000].[0DEBIT9LC0000000000000000], //Debit amount in local currency
                    [0MEASURES0000000000000000].[0NETTAKEN0000000000000000]), //Net period used
                    From ($0FIAR_C03));

                     

                    Thanks