Skip to Content
Personal Insights
Author's profile photo Narasimha Prasad Bhat

ChatGPT gives wrong answers for simple table search

Purpose: To caution, especially newcomers to SAP, on relying on ChatGPT blindly.

 

Have you ever blindly believed the outputs of AI language models like ChatGPT for SAP-related queries?

Well, here’s a cautionary tale for you!

I recently had an interesting chat with ChatGPT on a seemingly simple question – the SAP table for the link between a material and a master recipe. However, ChatGPT did not get it right till the end, providing me with incorrect table names and field attributes despite several attempts.

This just goes to show that as much as we rely on technology to provide us with accurate answers, we still need to exercise caution and use our own knowledge and expertise to validate these outputs.

So the next time you encounter an AI language model for your SAP queries, don’t blindly believe its outputs. Always double-check and verify to ensure the accuracy and reliability of the information you receive.

#sap #sapcommunity #AI #Chatbots #

————–Here is the chat —————————————-
My Question– what is the sap table for master recipe to material assignment? table and Attribute both.

ChatGPT : The SAP table for the master recipe to material assignment is STPO (SAP Standard Task List Operations), and the relevant field is MATNR (Material Number).

In the STPO table, the field MATNR refers to the material number that is assigned to the relevant operation in the task list. This assignment specifies which material is required for the operation to be executed.

Note that the STPO table is used for task lists, which are used to define the production process for materials in SAP. If you are looking for the master recipe to material assignment for a recipe in SAP, the table and field may be different depending on the specific SAP module being used

My Reply : stpo is bom table , not recipe

ChatGPT reply: I apologize for the confusion. You are correct that the STPO table is a Bill of Materials (BOM) table, not a recipe table. The correct SAP table for master recipe to material assignment is PLKO (SAP Planned Order Header Data) and the relevant field is MATNR (Material Number).

In the PLKO table, the field MATNR refers to the material number that is assigned to the relevant master recipe. This assignment specifies which material is used in the master recipe.

Please let me know if you have any further questions or if there is anything else I can help you with.

My reply: again wrong – PLKO doesn’t have MATNR attribute

—Then series of wrong answers by ChatGPT–

My final Question after feeding right answer: If anyone queries you to give a right sap table for material and master recipe link what will you give now ?

ChatGpt :The correct SAP table for the link between a material and a master recipe is the MAPL table (Material to BOM Link).

In the MAPL table, the field PLNNR refers to the master recipe number, and the field MATNR refers to the material number. This table stores the link between a material and the master recipe that defines how the material should be used in the production process.

 

 

I posted this on LinkedIn and got a few interesting comments, which I have pasted in the comment section.  Do share your experience in the comment to help other SAP users.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Narasimha Prasad Bhat
      Narasimha Prasad Bhat
      Blog Post Author

      Comments on Linkedin- https://www.linkedin.com/feed/update/urn:li:activity:7059347281002582016/