SAP Knowledge Base Article - Public

2963864 - You Are Unable To Get CreatedOn And CreatedBy Of The BTD Reference Via OpportunityBusinessTransactionDocumentReferenceCollection

Symptom

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.

Environment

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)

Cause

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).

Resolution

It is expected system behaviour.

Keywords

BTD creation date, OpportunityBusinessTransactionDocumentReferenceCollection, CreatedOn, CreatedBy, BTD reference, referenced document, , KBA , LOD-CRM-OPP , Opportunity Management , AP-RC-ODF , OData framework (C4C Only) , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions