Hello guys,
I am confused on how exactly to setup Dual-Write mapping for header and detail scenario. So in CDS, I have 2 tables which is Header and Detail, as usual there is a relationship column between the detail table and header table, which usually in detail table there is one column with column name similar as the header table name.
What actually confuse me, during setup mapping for Dual-write, why the integration key for the Detail table suggest me to have another which is same as the key of my header table ?
So for example in my Header table in CDS, I created 2 keys : 1 for Journal ID and another for Description. And in Detail table I have composite keys of Journal ID + Line Number.
In the integration keys of Detail table, after I set keys Journal ID and Line Number, they added "Description" and "Journal ID" again with prefix of my Header table's name. So then in the table mapping section, it will have error message saying "Mapping is missing for integration key -.... [those two fields added]"
Should we set the mapping in Detail with the fields from the Header table as well ? or can I just delete those two additional field in Integration keys setup ? But if I delete those field in Integration keys section, go back to Table mapping section, at first the error gone, and if I click Refresh Table, they will add again the keys.
Please advice,
Thanks
