6 Replies Latest reply: Feb 3, 2012 2:08 AM by Thierry Doppler RSS

    Error loading table T016T

    Thierry Doppler

      Hi the community,

       

      I have the following error if i want to load the sap table T016T with the ODBC connector :

       

      SQL##f - SqlState: S0002, ErrorCode: 4294963292, ErrorMsg: [SAP AG][SQLOD32 DLL][SAP DB] Base table not found;-4004 POS(15) Unknown table name:T016T

      select * from t016t

       

      I reduced the request on the minimun :

       

      load *;

      select * from t016t;

       

      Of course the table is existing an readable withe SE16N

      I have no problems with the others tables, for ex. T151T !

       

      Any Idees ?

       

      Thanks a lot.

       

      Thierry

        • Error loading table T016T
          Thierry Doppler

          Hi,

          Ok i have the response. T016T is a pool-table not a transparent table. No chance with ODBC. Perhaps with an SAP-Connector ?

           

          Thanks

          Thierry

          • Error loading table T016T
            Andres Trejo

            Try this:

            //First your connection to SAP
            CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=192.168.0.213;SYSNR=00;CLIENT=200;XUserId=XSFJZYRNJbaMXUVMXLYIWWdD;XPassword=VMcOSUZNJbYSWQRNZZPA;";

            //Then read table (doesnt matter is its a pool table)
            [T016T]:   // Sectores industriales
            Load
               //BRSCH & MANDT & SPRAS AS %KEY_T016T_BRSCH_MANDT_SPRAS,
               [MANDT] as [Mandante_MANDT],
               [SPRAS] as [Idioma_SPRAS],
               [BRSCH] as [Ramo_BRSCH],
               [BRTXT] as [_BRTXT];
            SQL Select MANDT SPRAS BRSCH BRTXT  from T016T ;

             

            The result its:

            Mandante_MANDT   Idioma_SPRAS    Ramo_BRSCH    _BRTXT

            200                              D                            0001                    Branche 0001

            200                              D                            0002                    Branche 0002                   

            200                              D                            0003                    Branche 0003

            200                              E                             0001                   Industry 0001

            200                              E                             0002                   Industry 0002