How to select a composite key as Primary Key while creating VBCS Table
SummaryNeed to select more than one attribute as primary key (composite key)
We developed an ADF VO which has 3 columns makes up a PK (composite key). This VO is entity based and all 3 attributes are selected as "Primary Key" at entity. Now, we enabled REST services on this VO.
When we execute REST API we are able to see all records and looks like ADF BC REST Module generates a unique identifier for each row in this VO. Using which we can filter on this composite key. Attached image shows the composite key at VO level. Also attached the REST API response which shows the unique identifier.