topic Re: SAP MRP Messages Extraction in QlikView

SAP MRP Messages Extraction

kstroupe — Mon, 26 Jan 2026 16:26:21 GMT

Is anyone using the SAP Extractor to get MRP Messages without using SAP BW?

Re: SAP MRP Messages Extraction

Anonymous — Thu, 02 Jan 2014 17:48:22 GMT

We are using both.

What do you mean by MRP messages? which module/business process?

Yaniv

Re: SAP MRP Messages Extraction

kstroupe — Mon, 06 Jan 2014 22:36:26 GMT

Yaniv,

I don't work in the buisness area but from what I have spoken to them about when MRP runs and has issues such as a Material doesn't have a routing assigned then it may kick out a Message stating that a routing has to be set up. In order for us to read these messages we run a function module called

BAPI_MATERIAL_MRP_LIST which doesn't write to a table that I know of.

Re: SAP MRP Messages Extraction

Anonymous — Tue, 07 Jan 2014 06:32:04 GMT

Hi Kim

I am not sure that I understood your requirement but -

You are able to execute this BAPI using the SAP BAPI Connector

Yaniv

Re: SAP MRP Messages Extraction

kstroupe — Tue, 07 Jan 2014 17:40:04 GMT

Yaniv,

Thanks for not giving up on me. LOL I am not an SAP User but I think I understand how to connect the pieces. So I believe if we kick off the SAP BAPI function module then it produces data in a screen on SAP which the users could download. What we would like to do is run the SAP BAPI function module and then extract the data to a file (QVD) automatically. Is the SAP BAPI Connector included with the Qlikview SAP Connector or is this something that just comes with SAP Application?

Thanks for all your help.

Kim

Re: SAP MRP Messages Extraction

Anonymous — Wed, 08 Jan 2014 07:36:24 GMT

Hi Kim

The SAP BAPI connector is included in the QlikView SAP connector suite.

It enables the QlikView developer to extract output data of BAPI into QlikView (and store it in QVD)

Thanks

Yaniv

Re: SAP MRP Messages Extraction

kstroupe — Wed, 08 Jan 2014 15:47:54 GMT

Yaniv,

Awesome... Thank you so much for this information. Have a great Year (2014)

Re: SAP MRP Messages Extraction

Wed, 04 Jun 2014 16:28:43 GMT

Yaniv, I am trying to use the BAPI_MATERIAL_MRP_LIST, as suggested, however the BAPI doesn't create table output. It only returns a message and results in a script error. I also tried BAPI_MATERIAL_STOCK_REQ_LIST it should also return exception messages but it also does not create output tables. The script does not create an output parameter for any tables. I have successfully extracted tables from other BAPIs.

Re: SAP MRP Messages Extraction

Anonymous — Wed, 04 Jun 2014 17:22:33 GMT

Hi Jamie

What's your exact question?

Re: SAP MRP Messages Extraction

Wed, 04 Jun 2014 17:29:22 GMT

How to extract mrp exception message using the SAP connector.

Re: SAP MRP Messages Extraction

Anonymous — Wed, 04 Jun 2014 17:42:00 GMT

Hi Jamie

I executed BAPI_MATERIAL_MRP_LIST in my SAP system (t-code SE37)

I entered a single Material number and a Plant.

After I got good results , I created a QV script (using the wizard) to extract the data with the BAPI connector. I entered the same Material number and Plant and got good results.

Do you enter Material and Plant? are they formatted correctly?

Thanks

Yaniv

Re: Re: SAP MRP Messages Extraction

Wed, 04 Jun 2014 18:13:29 GMT

Yaniv,

I did the same thing so there must be something wrong with my script. I have attached a test app. The output from the BAPI connector wizard is loaded. I did not modify it in the editor. I appreciate your help.

Re: Re: Re: SAP MRP Messages Extraction

Anonymous — Thu, 05 Jun 2014 04:20:37 GMT

Hi Jamie

I pasted the script that I have in an additional tab in your file (attached).

The script is generated with BAPI connector wizard. I have version 5.7 SR2 installed

Thanks

Yaniv

Re: Re: Re: Re: SAP MRP Messages Extraction

Thu, 05 Jun 2014 13:58:27 GMT

Hi Yaniv,

Thanks for the example. We are using version 5.8 and it appears to work a little differently. I did discover how to get the table listed as output, however in this version it doesn't list out the fields. I am still getting a script error. It is the sap message returned to Qlikview. It is a 'positive result' message but must still cause QV an issue. I wonder if this is something QV needs to look at. I used your script with my input params and got the same result. I have attached the script error I receive. Any insight would be appreciated.

Thanks,

Jamie

Re: SAP MRP Messages Extraction

Anonymous — Thu, 05 Jun 2014 14:14:33 GMT

Hi Jamie

I don't recognize the error message. However I suggest you check the connector log (it's a separate file than the .qvw log).

The connector log files are generated in the local computer where you load the .qvw file:

C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log

Please send the log file - maybe it will help to shed some light

Yaniv

Re: Re: SAP MRP Messages Extraction

Thu, 05 Jun 2014 16:59:14 GMT

Hi Yaniv,

Attached is the log. The message is a standard SAP msg that just says the MRP list was created. QV, however, is treating it like a hard stop error message. I wonder if there is configuration somewhere where this message can be set to be ignored?

Re: SAP MRP Messages Extraction

Anonymous — Fri, 06 Jun 2014 04:45:04 GMT

Hi Jamie

I analyzed your log.

It seems that the QV side of the connector interprets that return message (MD52, type S) as Error.

I analyzed my log and the message doesn't appear in the connector log.

This leads to conclude that further debugging of the connector needs to be done.

I would contact QlikView support and send them the connector log , this may be a bug.

Thanks

Yaniv

Re: SAP MRP Messages Extraction

Fri, 06 Jun 2014 17:16:45 GMT

Yaniv,

Thank you for your assessment. I will follow up with QV support.

Jamie