How To Fix W8718 - Creation/deletion of records in table & checked

SAP Error Message - Details

• Message type: E = Error

• Message class: W8 - Workflow: Expressions, data flow

• Message number: 718

• Message text: Creation/deletion of records in table & checked

What causes this issue?

You have specified the field <ZH>KEY</> for table &V1&. This results in
the following "special treatment":

System Response

In event creation, the system checks for added or deleted fields in
table &V1&. When table records are added or deleted in the change
document, the keys of the table records created or deleted are logged,
not the individual fields.
Example:
If a plant segment is created for a material, a record is created for
table MARC in the change document.

How to fix this error?

If you specify <ZH>KEY</> as field name in the field restrictions for a
table name, you can define a concatenated key of this table as "new
value". Positions in the key can be masked with the character '*'.
The field restriction is fulfilled if a table record of this key is
logged.
Example:
If the event <ZH>MATERIAL PLANT_CREATED</> is to be created when a
material segment is added for plant 0099, the following entries are
required.
Change document object,,MATERIAL
Business object type,,MATERIAL
Event,,PLANT_CREATED
Trigger event upon Change Create Delete,,X
With:
Table,,MARC
Field name,,KEY
Old value ,,*
New value,,*********************0099
In the object reference with which the event is created, and which is
described as "new value", the fields MARC-MANDT (3 characters) and
MARC-MATNR (18 characters) are masked.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message W8718 - Creation/deletion of records in table & checked ?

  SAP Error Message:
  
  W8718 - Creation/deletion of records in table & checked
  
  Meaning / Cause:
  This warning message appears when there is an attempt to create or delete records directly in a database table that is protected or checked by SAP. The system is informing you that the operation you are trying to perform on the table is restricted or monitored because it could affect data integrity or system consistency.
  Typically, this message occurs in scenarios such as:
  
  Direct modification (insertion/deletion) of entries in a table that is controlled by SAP application logic.
  Attempting to bypass standard SAP transactions or function modules that handle data changes.
  The table has specific checks or locks to prevent unauthorized or unsafe changes.
  
  
  Common Causes:
  
  Trying to insert or delete records directly via SE16N, SE11, or custom programs without using the proper SAP APIs or BAPIs.
  The table is a customizing or application table with integrity checks.
  The table is buffered or has special buffering settings that restrict direct changes.
  The system has table maintenance restrictions or authorization checks.
  
  
  Solution / How to Resolve:
  
  
  Use Standard SAP Transactions or APIs:
  
  Always use the standard SAP transactions, function modules, or BAPIs designed to modify the data in the table. These ensure that all necessary checks and related updates are performed.
  
  
  Check Authorizations:
  
  Ensure you have the correct authorizations to modify the table data. Sometimes the warning is triggered due to missing authorizations.
  
  
  Avoid Direct Table Changes:
  
  Avoid direct inserts or deletes in the table via SE16N or direct SQL unless you are absolutely sure about the consequences and have a valid reason.
  
  
  Use Table Maintenance Generator:
  
  If you need to maintain the table manually, check if a Table Maintenance Generator (SM30) exists and use it.
  
  
  Consult SAP Notes:
  
  Sometimes SAP provides notes or patches if this warning is related to a known issue.
  
  
  Check Table Buffering:
  
  If the table is buffered, direct changes might not be allowed or might cause inconsistencies. Use appropriate methods to update buffered tables.
  
  
  
  Additional Information:
  
  
  The message text usually looks like:
  
  Creation/deletion of records in table & checked
  
  where & is replaced by the table name.
  
  
  This is a warning (W) message, not an error, so the system allows you to continue but warns you about potential risks.
  
  
  If you are developing custom programs, always use the SAP-provided interfaces for data manipulation.
  
  
  For critical tables, SAP enforces these checks to maintain data consistency and prevent corruption.
  
  
  
  Example:
  If you try to delete a record directly from a table like VBAK (Sales Document Header) using SE16N, you might get this warning because deleting sales documents directly is not allowed; you should use transaction VA02 or appropriate BAPIs.
  
  If you provide the exact table name or context, I can help with more specific guidance.