Skip to content

/AWS1/CL_CRMINTERMEDIATETABLE

Contains the details of an intermediate table in Clean Rooms. An intermediate table stores a query definition and its materialized results within a collaboration.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_id TYPE /AWS1/CRMUUID /AWS1/CRMUUID

The unique identifier of the intermediate table.

iv_arn TYPE /AWS1/CRMINTERMEDIATETABLEARN /AWS1/CRMINTERMEDIATETABLEARN

The Amazon Resource Name (ARN) of the intermediate table.

iv_name TYPE /AWS1/CRMDISPLAYNAME /AWS1/CRMDISPLAYNAME

The name of the intermediate table.

iv_membershiparn TYPE /AWS1/CRMMEMBERSHIPARN /AWS1/CRMMEMBERSHIPARN

The Amazon Resource Name (ARN) of the membership that contains the intermediate table.

iv_membershipid TYPE /AWS1/CRMUUID /AWS1/CRMUUID

The unique identifier of the membership that contains the intermediate table.

iv_collaborationarn TYPE /AWS1/CRMCOLLABORATIONARN /AWS1/CRMCOLLABORATIONARN

The Amazon Resource Name (ARN) of the collaboration that contains the intermediate table.

iv_collaborationid TYPE /AWS1/CRMUUID /AWS1/CRMUUID

The unique identifier of the collaboration that contains the intermediate table.

iv_createtime TYPE /AWS1/CRMTIMESTAMP /AWS1/CRMTIMESTAMP

The time the intermediate table was created.

iv_updatetime TYPE /AWS1/CRMTIMESTAMP /AWS1/CRMTIMESTAMP

The time the intermediate table was last updated.

iv_status TYPE /AWS1/CRMINTMDTABLESTATUS /AWS1/CRMINTMDTABLESTATUS

The current status of the intermediate table.

io_populationanalysisconf TYPE REF TO /AWS1/CL_CRMPOPNANALYSISCONF /AWS1/CL_CRMPOPNANALYSISCONF

The analysis configuration that defines the query used to populate the intermediate table.

Optional arguments:

iv_description TYPE /AWS1/CRMRESOURCEDESCRIPTION /AWS1/CRMRESOURCEDESCRIPTION

The description of the intermediate table.

it_childresources TYPE /AWS1/CL_CRMCHILDRESOURCE=>TT_CHILDRESOURCELIST TT_CHILDRESOURCELIST

The child resources that depend on this intermediate table.

iv_statusreason TYPE /AWS1/CRMSTRING /AWS1/CRMSTRING

The reason for the current status of the intermediate table.

iv_kmskeyarn TYPE /AWS1/CRMKMSKEYARN /AWS1/CRMKMSKEYARN

The Amazon Resource Name (ARN) of the KMS key used to encrypt the intermediate table data.

iv_retentionindays TYPE /AWS1/CRMINTEGER /AWS1/CRMINTEGER

The number of days that populated data is retained before expiring.

it_tabledependencies TYPE /AWS1/CL_CRMINTMDTABLEDEPNDNCY=>TT_DEPENDENCYLIST TT_DEPENDENCYLIST

The list of base tables that this intermediate table depends on.

io_intermediatetableversion TYPE REF TO /AWS1/CL_CRMINTMDTABLEACTVRS /AWS1/CL_CRMINTMDTABLEACTVRS

The details of the currently active version of the intermediate table.

it_analysisruletypes TYPE /AWS1/CL_CRMIMDTBLALYRLTYLST_W=>TT_INTMDTABLEALYRULETYPELIST TT_INTMDTABLEALYRULETYPELIST

The types of analysis rules associated with the intermediate table.

io_schema TYPE REF TO /AWS1/CL_CRMINTMDTABLESCHEMA /AWS1/CL_CRMINTMDTABLESCHEMA

The schema of the intermediate table, containing column definitions. Available after the table has been successfully populated.


Queryable Attributes

id

The unique identifier of the intermediate table.

Accessible with the following methods

Method Description
GET_ID() Getter for ID, with configurable default
ASK_ID() Getter for ID w/ exceptions if field has no value
HAS_ID() Determine if ID has a value

arn

The Amazon Resource Name (ARN) of the intermediate table.

Accessible with the following methods

Method Description
GET_ARN() Getter for ARN, with configurable default
ASK_ARN() Getter for ARN w/ exceptions if field has no value
HAS_ARN() Determine if ARN has a value

name

The name of the intermediate table.

Accessible with the following methods

Method Description
GET_NAME() Getter for NAME, with configurable default
ASK_NAME() Getter for NAME w/ exceptions if field has no value
HAS_NAME() Determine if NAME has a value

description

The description of the intermediate table.

Accessible with the following methods

Method Description
GET_DESCRIPTION() Getter for DESCRIPTION, with configurable default
ASK_DESCRIPTION() Getter for DESCRIPTION w/ exceptions if field has no value
HAS_DESCRIPTION() Determine if DESCRIPTION has a value

membershipArn

The Amazon Resource Name (ARN) of the membership that contains the intermediate table.

Accessible with the following methods

Method Description
GET_MEMBERSHIPARN() Getter for MEMBERSHIPARN, with configurable default
ASK_MEMBERSHIPARN() Getter for MEMBERSHIPARN w/ exceptions if field has no value
HAS_MEMBERSHIPARN() Determine if MEMBERSHIPARN has a value

membershipId

The unique identifier of the membership that contains the intermediate table.

Accessible with the following methods

Method Description
GET_MEMBERSHIPID() Getter for MEMBERSHIPID, with configurable default
ASK_MEMBERSHIPID() Getter for MEMBERSHIPID w/ exceptions if field has no value
HAS_MEMBERSHIPID() Determine if MEMBERSHIPID has a value

collaborationArn

The Amazon Resource Name (ARN) of the collaboration that contains the intermediate table.

Accessible with the following methods

Method Description
GET_COLLABORATIONARN() Getter for COLLABORATIONARN, with configurable default
ASK_COLLABORATIONARN() Getter for COLLABORATIONARN w/ exceptions if field has no va
HAS_COLLABORATIONARN() Determine if COLLABORATIONARN has a value

collaborationId

The unique identifier of the collaboration that contains the intermediate table.

Accessible with the following methods

Method Description
GET_COLLABORATIONID() Getter for COLLABORATIONID, with configurable default
ASK_COLLABORATIONID() Getter for COLLABORATIONID w/ exceptions if field has no val
HAS_COLLABORATIONID() Determine if COLLABORATIONID has a value

childResources

The child resources that depend on this intermediate table.

Accessible with the following methods

Method Description
GET_CHILDRESOURCES() Getter for CHILDRESOURCES, with configurable default
ASK_CHILDRESOURCES() Getter for CHILDRESOURCES w/ exceptions if field has no valu
HAS_CHILDRESOURCES() Determine if CHILDRESOURCES has a value

createTime

The time the intermediate table was created.

Accessible with the following methods

Method Description
GET_CREATETIME() Getter for CREATETIME, with configurable default
ASK_CREATETIME() Getter for CREATETIME w/ exceptions if field has no value
HAS_CREATETIME() Determine if CREATETIME has a value

updateTime

The time the intermediate table was last updated.

Accessible with the following methods

Method Description
GET_UPDATETIME() Getter for UPDATETIME, with configurable default
ASK_UPDATETIME() Getter for UPDATETIME w/ exceptions if field has no value
HAS_UPDATETIME() Determine if UPDATETIME has a value

status

The current status of the intermediate table.

Accessible with the following methods

Method Description
GET_STATUS() Getter for STATUS, with configurable default
ASK_STATUS() Getter for STATUS w/ exceptions if field has no value
HAS_STATUS() Determine if STATUS has a value

statusReason

The reason for the current status of the intermediate table.

Accessible with the following methods

Method Description
GET_STATUSREASON() Getter for STATUSREASON, with configurable default
ASK_STATUSREASON() Getter for STATUSREASON w/ exceptions if field has no value
HAS_STATUSREASON() Determine if STATUSREASON has a value

kmsKeyArn

The Amazon Resource Name (ARN) of the KMS key used to encrypt the intermediate table data.

Accessible with the following methods

Method Description
GET_KMSKEYARN() Getter for KMSKEYARN, with configurable default
ASK_KMSKEYARN() Getter for KMSKEYARN w/ exceptions if field has no value
HAS_KMSKEYARN() Determine if KMSKEYARN has a value

populationAnalysisConfiguration

The analysis configuration that defines the query used to populate the intermediate table.

Accessible with the following methods

Method Description
GET_POPULATIONANALYSISCONF() Getter for POPULATIONANALYSISCONF

retentionInDays

The number of days that populated data is retained before expiring.

Accessible with the following methods

Method Description
GET_RETENTIONINDAYS() Getter for RETENTIONINDAYS, with configurable default
ASK_RETENTIONINDAYS() Getter for RETENTIONINDAYS w/ exceptions if field has no val
HAS_RETENTIONINDAYS() Determine if RETENTIONINDAYS has a value

tableDependencies

The list of base tables that this intermediate table depends on.

Accessible with the following methods

Method Description
GET_TABLEDEPENDENCIES() Getter for TABLEDEPENDENCIES, with configurable default
ASK_TABLEDEPENDENCIES() Getter for TABLEDEPENDENCIES w/ exceptions if field has no v
HAS_TABLEDEPENDENCIES() Determine if TABLEDEPENDENCIES has a value

intermediateTableVersion

The details of the currently active version of the intermediate table.

Accessible with the following methods

Method Description
GET_INTERMEDIATETABLEVERSION() Getter for INTERMEDIATETABLEVERSION

analysisRuleTypes

The types of analysis rules associated with the intermediate table.

Accessible with the following methods

Method Description
GET_ANALYSISRULETYPES() Getter for ANALYSISRULETYPES, with configurable default
ASK_ANALYSISRULETYPES() Getter for ANALYSISRULETYPES w/ exceptions if field has no v
HAS_ANALYSISRULETYPES() Determine if ANALYSISRULETYPES has a value

schema

The schema of the intermediate table, containing column definitions. Available after the table has been successfully populated.

Accessible with the following methods

Method Description
GET_SCHEMA() Getter for SCHEMA