foreign-keysabapsap-data-dictionary
How to auto-populate field via foreign key relation in SM30?
Sorry if my title doesn't make sense but I found it hard to describe! I have a Z table in SAP TM:
With a foreign key relationship to the standard table /SAPAPO/LOC
But I want to have an SM30 maintenance where the user populates the /SAPAPO/LOC-LOCNO field (i.e. the depot) and the LOCID is hidden and auto populated. Is this possible? Here is my view:
But in SM30 the depot is blanked out after entering. I think I can get it to work by messing around with the auto-generated screen but I would prefer to follow SAP standard.
Solution
I decided to go a different route by having LOCNO in my Z table instead of LOCID and then creating a custom check table (copied from /SAPAPO/LOCNO_V). So the user enters the depot name and this is validated against /SAPAPO/LOC.
- SET CONSTRAINTS ALL DEFERRED not working as expected
- use the returned value of the query as a foreign key without starting a new transaction or dropping foreign key constraint
- SQL table design with foreign key
- Laravel migration "Cannot add foreign key constraint" error with MySQL database
- EntityFramework: 1:0..1 relation deserialized as collection
- I am getting a error: everse for 'genre' with arguments '('',)' not found. 1 pattern(s) tried: ['genres/(?P<genre_id>[0-9]+)\\Z']
- How to I show a list of ForeignKey reverse lookups in the Django admin interface?
- sql:need to change constraint on rename table?
- Django - dynamically update a count model field when related objects are added or removed
- How to truncate a foreign key constrained table?
- Migration: Cannot add foreign key constraint
- Multiple foreign keys from one table to same field in another table in Laravel
- PostgreSQL array of elements that each are a foreign key
- Generic Foreign Key on unsaved model in Django
- How do I automatically insert the auth user id when creating a new model with a foreign key in Laravel?
- MySQL DROP all tables, ignoring foreign keys
- get unprocessed rows that have no association in processed table
- Delete rows with foreign key in PostgreSQL
- Add Foreign Key to existing table
- Laravel Relationship Using An OR Condition on the joining field
- How to change a default setting temporarily in PostgreSQL?
- JPA is duplicating a column when inserting. Multiple columns as primary and foreign key
- PostgreSQL zero-or-one to zero-or-one relationship
- How to resolve circular foreign key constraints with NOT NULL in Hibernate
- Does Foreign Key improve query performance?
- Get ID from Master table When Doing Input for Detail Table (Laravel 8)
- How to add a link to a foreign key object in the Django admin?
- Does SQL Server ALWAYS enforce referential integrity with foreign key constraints?
- MySQL Cannot Add Foreign Key Constraint
- How to select rows with no matching entry in another table?