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.
- MySQL Cannot Add Foreign Key Constraint
- How to select rows with no matching entry in another table?
- Stuck at (erno: 150 "Foreign key constraint is incorrectly formed,")
- How to make a relation between two tables without foreign key
- How can i create a relation beetwen two models and pass the model info on to the view through the controller?
- How can I know if a table column is a foreign key in Laravel through Model?
- Enforcing two M2M relationships with FK with SQL Server
- In Yii2, is it possible to get the unique objects in a hasMany relation via another hasMany relation?
- Cascade Delete in SqlAlchemy One-to-Many relationship made without relationships()
- Maintaining Foreign Key references while migrating data using T-SQL
- Adding foreign key to existing table gives error 1050 table already exists
- How can I filter an optional model inside include in Entity Framework Core
- List SQLite Foreign Key Violations C++
- Foreign keys on partitioned tables
- Tools for discovering de facto foreign keys in databases?
- Entity with UUID relationship error: a foreign key constraint fails. java spring
- Laravel HasMany through composite key
- Liquibase erroring when creating foreign key - relation "person" does not exist
- Custom cascade delete stored procedure for temporal tables in SQL Server
- Copy rows and foreign key rows, keep relation/order
- fix Foreign Key constraint in this SQLite3 database?
- Laravel - add foreign key on existing table with data
- Select Rows Based On Foreign Key In One-To-Many Relationships In SQL
- How to prevent self (recursive) selection for FK / MTM fields in the Django Admin
- foreign key constraint naming scheme
- best solution for Django Composite primary-key from foreign-keys
- How to list table foreign keys
- SQLAlchemy cannot find referenced table via foreignkey in many-to-many relationship
- How to access set of objects in reverse Foreign Key in Django
- Laravel how do I access the data in a one to many relationship