Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field not found - <MaterialNo>

hi guys,

I able to connect  SAP R/3 system from Qlikview,

I key in query as like this to get  VRPMA SAP R/3 table data into qlikview,

VRPMA:

Load [MaterialNo],

     [SalesOrg];

SQL Select VRPMA~MATNR AS [MaterialNo] ,

           VRPMA~VKORG AS [SalesOrg]

           from VRPMA ;

but i am geting the following error,i am assuming some thing wrong with the above script.

Field not found - <MaterialNo>

SQL Select VRPMA~MATNR AS [MaterialNo] ,

           VRPMA~VKORG AS [SalesOrg]

           from VRPMA

can u let me know any one?

Rgds

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Did you try not using the table name (there is the only table you are pulling from SAP) or double quoting the name of the fields (the "~" may cause an error):

VRPMA: // without table name

LOAD MATNR AS [MaterialNo],

     VKORG AS [SalesOrg];

SQL SELECT MATNR VKORG FROM VRPMA;

VRPMA: // double quoting

LOAD "VRPMA~MATNR" AS [MaterialNo],

     "VRPMA~VKORG" AS [SalesOrg];

SQL SELECT VRPMA~MATNR VRPMA~VKORG FROM VRPMA;

Are you using the SAP Connector?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

View solution in original post

9 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

  Try this.

  

Load  VRPMA~MATNR AS  [MaterialNo],

     VRPMA~VKORG AS [SalesOrg];

SQL Select VRPMA~MATNR ,

           VRPMA~VKORG

           from VRPMA ;

   The reason of error is your load statement do not find the field MaterialNo.

Regards,

Kaushik Solanki  

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

hi Kaushik,thanking 4 ur reply...,but still have error..

Syntax error, missing/misplaced FROM:

VRPMA:

Load  VRPMA~MATNR AS  [MaterialNo],

      VRPMA~VKORG AS [SalesOrg]

VRPMA:

Load  VRPMA~MATNR AS  [MaterialNo],

      VRPMA~VKORG AS [SalesOrg]

Rgds

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Yes cause you missed ; at the end of the load statement.

    It should be like this

   

VRPMA:

Load  VRPMA~MATNR AS  [MaterialNo],

      VRPMA~VKORG AS [SalesOrg];

SQL Select VRPMA~MATNR ,

           VRPMA~VKORG

           from VRPMA ;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Kaushik, actually ; is thr in edit script ,when i copied the error msg from script execution progress display script error box,that ; not displyed,unfortunately i put that msg here...

but still have same error..

rgds

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Can you please copy the script in txt file and then upload here.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Miguel_Angel_Baeyens

Hi,

Did you try not using the table name (there is the only table you are pulling from SAP) or double quoting the name of the fields (the "~" may cause an error):

VRPMA: // without table name

LOAD MATNR AS [MaterialNo],

     VKORG AS [SalesOrg];

SQL SELECT MATNR VKORG FROM VRPMA;

VRPMA: // double quoting

LOAD "VRPMA~MATNR" AS [MaterialNo],

     "VRPMA~VKORG" AS [SalesOrg];

SQL SELECT VRPMA~MATNR VRPMA~VKORG FROM VRPMA;

Are you using the SAP Connector?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

hi Miguel, ur absolutly right, after fetched 45,096 records i got this error msg again "

Field not found - <VRPMA~MATNR>

SQL SELECT VRPMA~MATNR VRPMA~VKORG FROM VRPMA

"

but fields are displaying in schema.

thanking you..

Miguel_Angel_Baeyens

Hi,

If you are not using the QlikView SAP Connector, then I'd bet for a driver issue, since fields are getting loaded properly (with some or alll the records in the database). Again, you can remove the table name and the "~" sign if all fields come from the same table, and hopefully you will not get any error.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

Thanking u for ur inputs, yes i am using Qlikview Sap Connector.