Locating the fields "Last Changed On" and "Completed on… - Approval date" in SAP Sales CDS view.

[SAPSupport]

To create a custom report, we need to locate 2 specific fields from the CDS view tables from Sales apps. 

The fields requested are Last Changed On and Completed on… - Approval date, both fields are available in the My Outbox app, however I can't seem to find the correct view which contains these 2 fields.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello SAP Community,

One of the fields requested (Last Changed On) can be located in the I_SalesDocument CDS View, you can confirm this by accessing the SAP API Portal and searching for LastChangeDate.

The other field requested "Completed on… - Approval date" is more complex, this information is located in the WorkflowTask tables and you can find further details in the I_WorkflowStatusDetails CDS view, the field name is WrkflwTskCompletionUTCDateTime, both of them can be located in the API Portal link above.

Best Regards,
SAP Support