I'm new to this forum. I'm starting a new web development that will export data to SAP. I have a data extraction that comes from some of the tables from SAP. I know the fields and tables. Fields can be changed (Removed or add new).
What I want to do is, Having all the fields in a configuration table and for the data save, not having a physical table. so when saving, it will save in a flat table like below
Key | Field_Name | Value
1 | MAKT|MATKX | TEST1
1 | MARM|MEINH | TEST2
1 | MARM|UMREN | TEST3
will this be practical when having a header table and a detail table?