- SQL Tutorial
- SQL - Home
- SQL - Overview
- SQL - RDBMS Concepts
- SQL - Databases
- SQL - Syntax
- SQL - Data Types
- SQL - Operators
- SQL - Expressions
- SQL - Create Database
- SQL - Drop Database
- SQL - Select Database
- SQL - Create Table
- SQL - Drop Table
- SQL - Insert Query
- SQL - Select Query
- SQL - Where Clause
- SQL - AND & OR Clauses
- SQL - Update Query
- SQL - Delete Query
- SQL - Like Clause
- SQL - Top Clause
- SQL - Order By
- SQL - Group By
- SQL - Distinct Keyword
- SQL - Sorting Results
- Advanced SQL
- SQL - Constraints
- SQL - Using Joins
- SQL - Unions Clause
- SQL - NULL Values
- SQL - Alias Syntax
- SQL - Indexes
- SQL - Alter Command
- SQL - Truncate Table
- SQL - Using Views
- SQL - Having Clause
- SQL - Transactions
- SQL - Wildcards
- SQL - Date Functions
- SQL - Temporary Tables
- SQL - Clone Tables
- SQL - Sub Queries
- SQL - Using Sequences
- SQL - Handling Duplicates
- SQL - Injection
No error while inserting record in child table with no match in master table in SAP
Note that when you perform an insertion using an ABAP program, there is no check on foreign key constraint. Even when you define checks in data dictionary SE11 still there is no check at database level.
When you execute using an ABAP code, this checks consistency at application level and not at database level. Errors you see in SE16 shows record rejected at application level.
You need to perform validation by checking record from master table with foreign key of child table and incase sy-subrc is not initial then record shouldn’t be inserted to the child table and shows an error message.
- Related Articles
- Display an error while inserting duplicate records in a MySQL table
- Inserting data in table in SAP HANA
- Error while connecting to SAP server from Java application: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path
- Query returning no data in SAP Business One using Table Relationship
- Inserting data in a table in SAP HANA
- Inserting an Array to a table in SAP HANA database
- Inserting rows to an internal table through debug in SAP ABAP
- Fix Error in MySQL syntax while creating a table column with name “index”?
- What are the different ways to maintain data integrity in child table when the record is deleted in parent table?
- Insert record in a MySQL table with Java
- Error occurs when table name “references” is set while creating a table
- Can we use INTERVAL keyword while inserting date records in a MySQL table?
- How to fix the incorrect datetime value while inserting in a MySQL table?
- Transaction Jobs with no access to SM36 in SAP system
- Error while connection SAP HANA with .NET
Advertisements