Is it possible to trigger a cascading delete for a table with a foreign key relation to another table? DDIC allows defining foreign key relations, which could (in theory) be used to implement cascading delete.
Is there a way to get automatic cascading delete for DDIC-tables?
71 views Asked by Michael Koval At
1
There are 1 answers
Related Questions in ABAP
- ABAP convert Database char to lowercase
- sorting some column of an internal table that meet a condition
- how to make certain editable field as non editable in alv report for custom field
- Absolute path of a child element within nested structure
- Update info record in purchase orders
- Is there a way to search the application log (SLG1) for a particular message?
- Read dynamic table by index
- Dynamically Create Nested Structure
- Is it possible to access and extract data from a field in a structure?
- How to get a value from a deeply-nested structure
- Difference between the classes CL_GUI_DOCKING_CONTAINER and CL_GUI_SPLITTER_CONTAINER
- Update/refresh Custom Control to reflect new data
- API to read extensions in a CDS view
- How to establish a connection with SAP ABAP workbench with SSIS
- BAPI_ADDRESSORG_CHANGE does not work correctly
Related Questions in OPENSQL
- Intersect of two tables fails in SAP ABAP CDS
- SQL select in 1 line
- ABAP/SQL: How do I get classification of specific Column Values based on IDs and on multiple conditions on ID?
- Select List of Columns INTO List of variables comma without preceding colon
- Is there a way to get automatic cascading delete for DDIC-tables?
- ABAP select - pattern matching with trailing asterisks
- How can I transform a SELECT with FOR ALL ENTRIES statement into a JOIN?
- Is a DELETE followed by an Insert faster than a Single MODIFY?
- How to correctly check that the table contains both values in ABAP?
- ABAP Open SQL - What is the function to return current date?
- Problem with Query: "SQL Error SQL CODE: 4"
- ABAP Open SQL SELECT statement displaying all linked materials to my documents
- What would be the best way to insert records with ABAP to a custom table
- How to export SQL query results to file in ABAP ADT?
- ABAP SQL statement with WHERE BETWEEN clause problem
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
There are no database triggers in SAP. So you can't react to an operation on a database immediately. However you could create a job that runs from time to time to check the foreign keys.
I wouldn't recommand doing this with standard tables, though. You never know what kind of operations are allowed in the SAP standard, where there might be a foreign key relation without the key beeing defined in the other table. SAP is just weird sometimes.
If you wanna do it for your custom developments and expand on it dynamically, sure. You can check the DB
DD08Lfor foreign key relations. However the table also holds all structures which have checktables, so you'd have to filter those. The DBDD02Lcan help with that (fieldTABCLASSdefines the kind of object).