Query ROI View

This SQL View provides details of ROI generated when running Query scripts.

Back to Reporting SQL Views.

Field Name DB Type Type Nullable Description
AppId uniqueidentifier Guid 0 The ID of the app in which the Query was run.
Client nvarchar String 0 SAP client number.
ClientProduct nvarchar String 0 Studio/ Integration Server. Here Integration Server means run by Worker.
CRMCustomerId nvarchar String 0 Connect CRM customer ID.
CRMLicenseId nvarchar String 0 Connect CRM license ID.
CustomerName nvarchar String 0 Connect customer name.
DateTimeOfRun datetime DateTime 0 Date of run.
DocId uniqueidentifier Guid 0 This is the document ID of this ROI data belongs to.
Env nvarchar String 0

Environment with below values:

Development : For environment activated with development license key.

Testing : For environment activated with testing license key.

Production : For environment activated with production license key.

Id uniqueidentifier Guid 0 Unique ID of this view/table.
IsLogSync bit Boolean 0 Indicated if log have been synced to Connect.
License nvarchar String 0 License used for run.
LogId uniqueidentifier Guid 0 ID of ROI log. ID is created for each entry in the log.
NumberOfRecords bigint Int64 0 The number of records retrieved by the Query.
OpertaionType nvarchar String 0

OperationType with below values:

Run : A run on SAP for data posting or query.

Test : A test run on SAP.

Debug : Debug run on SAP.

Validate : Data validate run on SAP.

Simulate : Simulate run on SAP.
OutputFields nvarchar String 0 Field that are mapped to the result file.
ParentDocId uniqueidentifier Guid 0 This is the document ID of parent document if current document has any parent document. Else it would be empty guid.
ProcessSource nvarchar String 0

Process Source with below value:

Manual – ROI’s source document submitted from the Excel Add-in or Web UI.

SI_API – ROI’s source document submitted from SAP API.

PE_API – ROI’s source document submitted from Digital Access API.
Product nvarchar String 0 Transaction/ Query. In this case Query.
ProductName nvarchar String 0 Product name of license used for the run.
ProductVersion nvarchar String 0 Version of Studio/ Integration Server (Worker).
QueryFileName nvarchar String 0 Query script name.
QueryLogId int Int32 0 Unique log ID. This ID is sequential for maintaining the order of logs.
QueryUnattendedLogId bigint Int64 0 ID of unattended chunks on SAP server. For internal use only.
ReasonForRun nvarchar String 0 Reason for run.
ReferenceId uniqueidentifier Guid 0 ID of the app in which Query was run.
ResultFileName nvarchar String 0 Result file name.
RootDocId uniqueidentifier Guid 0 This is the root document id of current document’s process inheritance or it would be empty guid.
RunType nvarchar String 0 Server/ manual.
SAPSystem nvarchar String 0 SAP system ID.
SAPUser nvarchar String 0 Runner SAP user.
SelectionFields nvarchar String 0 Fields used for criteria.
SolutionId uniqueidentifier Guid 0 This is the solution Id of the current document id. (i.e.Docid).
TablesUsed nvarchar String 0 Tables used in Query.
Tag nvarchar String 0 This is the Solution’s Category value of current document.
TimeToExecute nvarchar String 0 Time required for execution.
UserId uniqueidentifier Guid 0 The Runner user ID.
Username nvarchar String 0 User name of the Runner user.