Skip to Content

How to insert into ORCM table


I want to insert some recommendation data into ORCM table in SAP B1. I tried inserting by C# sql connection, but it doesn't look proper way. How can I insert data into Recommendation Data-ORCM table by using DI API?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 09, 2018 at 11:18 AM

    Hi Hatice Kose Ziyali,

    Refer to SAP Note 1320484 which clearly mentions: "Do not directly Update/Delete/Insert SAP Business One tables within the procedures."

    Refer to SAP Note 896891 which clearly mentions: "SAP will not support any database, which is inconsistent, due to SQL-Queries, which modify datasets or the datastructure of the SAP Business One Database. This includes any update-, delete- or drop-statements executed via SQL-Server Tools or via the the query interface of SAP Business One.

    This is stated in the support contract between SAP and the SAP Business Partner also."

    For the guidelines on modifying SAP Business One Data refer to the following blog post:

    Guidelines for Modifying SAP Business One Data

    Kind regards,


    SAP SME Support

    Add comment
    10|10000 characters needed characters exceeded