SAPConsumption Table

This table stores the data related to the definition of SAP consumption data.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SAPConsumption table

Database Column

Details

SAPConsumptionID

Type: integer. Key. Generated ID

The unique identifier for the SAP consumption.

SAPUserID

Type: integer. Key

Foreign key to the SAP user that the consumption belongs to.

TimePeriodStartDate

Type: datetime. Key

The date and time of the consumption

AccountObject

Type: text (max 40 characters). Key

The account object

AccountObjectDetails

Type: text (max 40 characters). Key

The account object details

EntryType

Type: text (max 1 characters). Key

The consumption entry type

TaskType

Type: text (max 2 characters). Key

The consumption task type

CPUTime

Type: decimal. Key. Nullable

CPU usage in seconds

MemoryUsed

Type: big integer. Nullable

Memory used

PrivateMemoryUsed

Type: big integer. Nullable

Private memory used

AccessCount

Type: integer. Nullable

Number of times the object has been used/accessed.