You added a survey questionnaire to an opportunity at a particular date. You are trying to get this information from the OData Service OpportunityBusinessTransactionDocumentReferenceCollection. But you are unable to get the CreatedOn and the CreatedBy of the BTD reference.
SAP Cloud for Customer
Reproducing the Issue
Execute GET call: myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/OpportunityBusinessTransactionDocumentReferenceCollection?$filter eq YYYYYY (where XXXXXX is the Tenant URL and YYYYYY is the opportunity)
When (CreatedOn) and who (CreatedBy) of the BTD reference do not exist in the business object Opportunity. The CreatedOn and CreatedBy are available only for the header and item (main BO Nodes) but not for other dependent BO nodes like BTD references, Parties (which is the same also for other business objects like sales quote, contract, etc). But whenever some change is made on the BTD references or Parties, the LastChangedOn and LastChangedBy of the opportunity header will be updated. This is the reason why the LastChangedOn of the opportunity header is added in the OData Entity of Opportunity BTD Reference.
When and who of the referenced document do not belong to the BTD Reference data. It exists only in the header of the referenced document. Therefore, this must be queried directly from the referenced document based on the referenced document ID (using the same odata c4cdataapi).
It is expected system behaviour.
BTD creation date, OpportunityBusinessTransactionDocumentReferenceCollection, CreatedOn, CreatedBy, BTD reference, referenced document, , KBA , LOD-CRM-OPP , Opportunity Management , AP-RC-ODF , OData framework (C4C Only) , Problem