POPULATEINTERMEDIATETABLE()`¶

About PopulateIntermediateTable¶

Executes the stored query of an intermediate table to materialize data into managed storage. With this operation, you can perform initial population and subsequent refreshes. Each call creates a new version. The returned analysis ID can be tracked using GetProtectedQuery. Only the intermediate table owner can call this operation.

Method Signature¶

METHODS /AWS1/IF_CRM~POPULATEINTERMEDIATETABLE
  IMPORTING
    !IV_INTMDTABLEIDENTIFIER TYPE /AWS1/CRMINTMDTABLEIDENTIFIER OPTIONAL
    !IV_MEMBERSHIPIDENTIFIER TYPE /AWS1/CRMMEMBERSHIPIDENTIFIER OPTIONAL
    !IT_PARAMETERS TYPE /AWS1/CL_CRMPARAMETERMAP_W=>TT_PARAMETERMAP OPTIONAL
    !IO_COMPUTECONFIGURATION TYPE REF TO /AWS1/CL_CRMINTMDTABLECOMPCONF OPTIONAL
    !IV_ANALYSISPAYERACCOUNTID TYPE /AWS1/CRMACCOUNTID OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_crmpopulateimdtblout
  RAISING
    /AWS1/CX_CRMACCESSDENIEDEX
    /AWS1/CX_CRMCONFLICTEXCEPTION
    /AWS1/CX_CRMINTERNALSERVEREX
    /AWS1/CX_CRMRESOURCENOTFOUNDEX
    /AWS1/CX_CRMSERVICEQUOTAEXCDEX
    /AWS1/CX_CRMTHROTTLINGEX
    /AWS1/CX_CRMVALIDATIONEX
    /AWS1/CX_CRMCLIENTEXC
    /AWS1/CX_CRMSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING¶

Required arguments:¶

`iv_intmdtableidentifier` `TYPE /AWS1/CRMINTMDTABLEIDENTIFIER` `/AWS1/CRMINTMDTABLEIDENTIFIER`¶

The unique identifier of the intermediate table to populate.

`iv_membershipidentifier` `TYPE /AWS1/CRMMEMBERSHIPIDENTIFIER` `/AWS1/CRMMEMBERSHIPIDENTIFIER`¶

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

Optional arguments:¶

`it_parameters` `TYPE /AWS1/CL_CRMPARAMETERMAP_W=>TT_PARAMETERMAP` `TT_PARAMETERMAP`¶

The runtime parameter values that override the defaults in the stored query.

`io_computeconfiguration` `TYPE REF TO /AWS1/CL_CRMINTMDTABLECOMPCONF` `/AWS1/CL_CRMINTMDTABLECOMPCONF`¶

The compute configuration for the population query execution.

`iv_analysispayeraccountid` `TYPE /AWS1/CRMACCOUNTID` `/AWS1/CRMACCOUNTID`¶

The account ID of the member that pays for the analysis compute costs.

RETURNING¶

`oo_output` `TYPE REF TO /aws1/cl_crmpopulateimdtblout` `/AWS1/CL_CRMPOPULATEIMDTBLOUT`¶

Examples¶

Syntax Example¶

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->populateintermediatetable(
  io_computeconfiguration = new /aws1/cl_crmintmdtablecompconf(
    io_querycomputeconfiguration = new /aws1/cl_crmworkercomputeconf(
      io_properties = new /aws1/cl_crmworkercompconfprps(
        it_spark = VALUE /aws1/cl_crmsparkproperties_w=>tt_sparkproperties(
          (
            VALUE /aws1/cl_crmsparkproperties_w=>ts_sparkproperties_maprow(
              key = |string|
              value = new /aws1/cl_crmsparkproperties_w( |string| )
            )
          )
        )
      )
      iv_number = 123
      iv_type = |string|
    )
  )
  it_parameters = VALUE /aws1/cl_crmparametermap_w=>tt_parametermap(
    (
      VALUE /aws1/cl_crmparametermap_w=>ts_parametermap_maprow(
        key = |string|
        value = new /aws1/cl_crmparametermap_w( |string| )
      )
    )
  )
  iv_analysispayeraccountid = |string|
  iv_intmdtableidentifier = |string|
  iv_membershipidentifier = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_analysisidentifier = lo_result->get_analysisid( ).
  lv_populateintermediatetab = lo_result->get_analysistype( ).
  lv_uuid = lo_result->get_versionid( ).
ENDIF.

/AWS1/IF_CRM=>POPULATEINTERMEDIATETABLE()¶