Skip to content

/AWS1/IF_DYN=>RESTORETABLETOPOINTINTIME()

About RestoreTableToPointInTime

Restores the specified table to the specified point in time within EarliestRestorableDateTime and LatestRestorableDateTime. You can restore your table to any point in time in the last 35 days. You can set the recovery period to any value between 1 and 35 days. Any number of users can execute up to 50 concurrent restores (any type of restore) in a given account.

When you restore using point in time recovery, DynamoDB restores your table data to the state based on the selected date and time (day:hour:minute:second) to a new table.

Along with data, the following are also included on the new restored table using point in time recovery:

  • Global secondary indexes (GSIs)

  • Local secondary indexes (LSIs)

  • Provisioned read and write capacity

  • Encryption settings

    All these settings come from the current settings of the source table at the time of restore.

You must manually set up the following on the restored table:

  • Auto scaling policies

  • IAM policies

  • Amazon CloudWatch metrics and alarms

  • Tags

  • Stream settings

  • Time to Live (TTL) settings

  • Point in time recovery settings

Method Signature

METHODS /AWS1/IF_DYN~RESTORETABLETOPOINTINTIME
  IMPORTING
    !IV_SOURCETABLEARN TYPE /AWS1/DYNTABLEARN OPTIONAL
    !IV_SOURCETABLENAME TYPE /AWS1/DYNTABLENAME OPTIONAL
    !IV_TARGETTABLENAME TYPE /AWS1/DYNTABLENAME OPTIONAL
    !IV_USELATESTRESTORABLETIME TYPE /AWS1/DYNBOOLEANOBJECT OPTIONAL
    !IV_RESTOREDATETIME TYPE /AWS1/DYNDATE OPTIONAL
    !IV_BILLINGMODEOVERRIDE TYPE /AWS1/DYNBILLINGMODE OPTIONAL
    !IT_GLOBALSECINDEXOVERRIDE TYPE /AWS1/CL_DYNGLOBALSECINDEX=>TT_GLOBALSECONDARYINDEXLIST OPTIONAL
    !IT_LOCALSECINDEXOVERRIDE TYPE /AWS1/CL_DYNLOCALSECINDEX=>TT_LOCALSECONDARYINDEXLIST OPTIONAL
    !IO_PROVTHROUGHPUTOVERRIDE TYPE REF TO /AWS1/CL_DYNPROVTHROUGHPUT OPTIONAL
    !IO_ONDEMANDTHRUPUTOVERRIDE TYPE REF TO /AWS1/CL_DYNONDEMANDTHROUGHPUT OPTIONAL
    !IO_SSESPECIFICATIONOVERRIDE TYPE REF TO /AWS1/CL_DYNSSESPECIFICATION OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_dynrestoretbltoptin01
  RAISING
    /AWS1/CX_DYNINTERNALSERVERERR
    /AWS1/CX_DYNINVALIDENDPOINTEX
    /AWS1/CX_DYNINVRESTORETIMEEX
    /AWS1/CX_DYNLIMITEXCEEDEDEX
    /AWS1/CX_DYNPTINTIMERECUNAVEX
    /AWS1/CX_DYNTABLEALRDYEXISTSEX
    /AWS1/CX_DYNTABLEINUSEEX
    /AWS1/CX_DYNTABLENOTFOUNDEX
    /AWS1/CX_DYNCLIENTEXC
    /AWS1/CX_DYNSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING

Required arguments:

iv_targettablename TYPE /AWS1/DYNTABLENAME /AWS1/DYNTABLENAME

The name of the new table to which it must be restored to.

Optional arguments:

iv_sourcetablearn TYPE /AWS1/DYNTABLEARN /AWS1/DYNTABLEARN

The DynamoDB table that will be restored. This value is an Amazon Resource Name (ARN).

iv_sourcetablename TYPE /AWS1/DYNTABLENAME /AWS1/DYNTABLENAME

Name of the source table that is being restored.

iv_uselatestrestorabletime TYPE /AWS1/DYNBOOLEANOBJECT /AWS1/DYNBOOLEANOBJECT

Restore the table to the latest possible time. LatestRestorableDateTime is typically 5 minutes before the current time.

iv_restoredatetime TYPE /AWS1/DYNDATE /AWS1/DYNDATE

Time in the past to restore the table to.

iv_billingmodeoverride TYPE /AWS1/DYNBILLINGMODE /AWS1/DYNBILLINGMODE

The billing mode of the restored table.

it_globalsecindexoverride TYPE /AWS1/CL_DYNGLOBALSECINDEX=>TT_GLOBALSECONDARYINDEXLIST TT_GLOBALSECONDARYINDEXLIST

List of global secondary indexes for the restored table. The indexes provided should match existing secondary indexes. You can choose to exclude some or all of the indexes at the time of restore.

it_localsecindexoverride TYPE /AWS1/CL_DYNLOCALSECINDEX=>TT_LOCALSECONDARYINDEXLIST TT_LOCALSECONDARYINDEXLIST

List of local secondary indexes for the restored table. The indexes provided should match existing secondary indexes. You can choose to exclude some or all of the indexes at the time of restore.

io_provthroughputoverride TYPE REF TO /AWS1/CL_DYNPROVTHROUGHPUT /AWS1/CL_DYNPROVTHROUGHPUT

Provisioned throughput settings for the restored table.

io_ondemandthruputoverride TYPE REF TO /AWS1/CL_DYNONDEMANDTHROUGHPUT /AWS1/CL_DYNONDEMANDTHROUGHPUT

OnDemandThroughputOverride

io_ssespecificationoverride TYPE REF TO /AWS1/CL_DYNSSESPECIFICATION /AWS1/CL_DYNSSESPECIFICATION

The new server-side encryption settings for the restored table.

RETURNING

oo_output TYPE REF TO /aws1/cl_dynrestoretbltoptin01 /AWS1/CL_DYNRESTORETBLTOPTIN01

Domain /AWS1/RT_ACCOUNT_ID
Primitive Type NUMC

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->restoretabletopointintime(
  io_ondemandthruputoverride = new /aws1/cl_dynondemandthroughput(
    iv_maxreadrequestunits = 123
    iv_maxwriterequestunits = 123
  )
  io_provthroughputoverride = new /aws1/cl_dynprovthroughput(
    iv_readcapacityunits = 123
    iv_writecapacityunits = 123
  )
  io_ssespecificationoverride = new /aws1/cl_dynssespecification(
    iv_enabled = ABAP_TRUE
    iv_kmsmasterkeyid = |string|
    iv_ssetype = |string|
  )
  it_globalsecindexoverride = VALUE /aws1/cl_dynglobalsecindex=>tt_globalsecondaryindexlist(
    (
      new /aws1/cl_dynglobalsecindex(
        io_ondemandthroughput = new /aws1/cl_dynondemandthroughput(
          iv_maxreadrequestunits = 123
          iv_maxwriterequestunits = 123
        )
        io_projection = new /aws1/cl_dynprojection(
          it_nonkeyattributes = VALUE /aws1/cl_dynnonkeyattrnamels00=>tt_nonkeyattributenamelist(
            ( new /aws1/cl_dynnonkeyattrnamels00( |string| ) )
          )
          iv_projectiontype = |string|
        )
        io_provisionedthroughput = new /aws1/cl_dynprovthroughput(
          iv_readcapacityunits = 123
          iv_writecapacityunits = 123
        )
        io_warmthroughput = new /aws1/cl_dynwarmthroughput(
          iv_readunitspersecond = 123
          iv_writeunitspersecond = 123
        )
        it_keyschema = VALUE /aws1/cl_dynkeyschemaelement=>tt_keyschema(
          (
            new /aws1/cl_dynkeyschemaelement(
              iv_attributename = |string|
              iv_keytype = |string|
            )
          )
        )
        iv_indexname = |string|
      )
    )
  )
  it_localsecindexoverride = VALUE /aws1/cl_dynlocalsecindex=>tt_localsecondaryindexlist(
    (
      new /aws1/cl_dynlocalsecindex(
        io_projection = new /aws1/cl_dynprojection(
          it_nonkeyattributes = VALUE /aws1/cl_dynnonkeyattrnamels00=>tt_nonkeyattributenamelist(
            ( new /aws1/cl_dynnonkeyattrnamels00( |string| ) )
          )
          iv_projectiontype = |string|
        )
        it_keyschema = VALUE /aws1/cl_dynkeyschemaelement=>tt_keyschema(
          (
            new /aws1/cl_dynkeyschemaelement(
              iv_attributename = |string|
              iv_keytype = |string|
            )
          )
        )
        iv_indexname = |string|
      )
    )
  )
  iv_billingmodeoverride = |string|
  iv_restoredatetime = '20150101000000.0000000'
  iv_sourcetablearn = |string|
  iv_sourcetablename = |string|
  iv_targettablename = |string|
  iv_uselatestrestorabletime = ABAP_TRUE
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lo_tabledescription = lo_result->get_tabledescription( ).
  IF lo_tabledescription IS NOT INITIAL.
    LOOP AT lo_tabledescription->get_attributedefinitions( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_keyschemaattributename = lo_row_1->get_attributename( ).
        lv_scalarattributetype = lo_row_1->get_attributetype( ).
      ENDIF.
    ENDLOOP.
    lv_tablename = lo_tabledescription->get_tablename( ).
    LOOP AT lo_tabledescription->get_keyschema( ) into lo_row_2.
      lo_row_3 = lo_row_2.
      IF lo_row_3 IS NOT INITIAL.
        lv_keyschemaattributename = lo_row_3->get_attributename( ).
        lv_keytype = lo_row_3->get_keytype( ).
      ENDIF.
    ENDLOOP.
    lv_tablestatus = lo_tabledescription->get_tablestatus( ).
    lv_date = lo_tabledescription->get_creationdatetime( ).
    lo_provisionedthroughputde = lo_tabledescription->get_provisionedthroughput( ).
    IF lo_provisionedthroughputde IS NOT INITIAL.
      lv_date = lo_provisionedthroughputde->get_lastincreasedatetime( ).
      lv_date = lo_provisionedthroughputde->get_lastdecreasedatetime( ).
      lv_positivelongobject = lo_provisionedthroughputde->get_numberofdecreasestoday( ).
      lv_nonnegativelongobject = lo_provisionedthroughputde->get_readcapacityunits( ).
      lv_nonnegativelongobject = lo_provisionedthroughputde->get_writecapacityunits( ).
    ENDIF.
    lv_longobject = lo_tabledescription->get_tablesizebytes( ).
    lv_longobject = lo_tabledescription->get_itemcount( ).
    lv_string = lo_tabledescription->get_tablearn( ).
    lv_tableid = lo_tabledescription->get_tableid( ).
    lo_billingmodesummary = lo_tabledescription->get_billingmodesummary( ).
    IF lo_billingmodesummary IS NOT INITIAL.
      lv_billingmode = lo_billingmodesummary->get_billingmode( ).
      lv_date = lo_billingmodesummary->get_lastupdtopayperreqdate00( ).
    ENDIF.
    LOOP AT lo_tabledescription->get_localsecondaryindexes( ) into lo_row_4.
      lo_row_5 = lo_row_4.
      IF lo_row_5 IS NOT INITIAL.
        lv_indexname = lo_row_5->get_indexname( ).
        LOOP AT lo_row_5->get_keyschema( ) into lo_row_2.
          lo_row_3 = lo_row_2.
          IF lo_row_3 IS NOT INITIAL.
            lv_keyschemaattributename = lo_row_3->get_attributename( ).
            lv_keytype = lo_row_3->get_keytype( ).
          ENDIF.
        ENDLOOP.
        lo_projection = lo_row_5->get_projection( ).
        IF lo_projection IS NOT INITIAL.
          lv_projectiontype = lo_projection->get_projectiontype( ).
          LOOP AT lo_projection->get_nonkeyattributes( ) into lo_row_6.
            lo_row_7 = lo_row_6.
            IF lo_row_7 IS NOT INITIAL.
              lv_nonkeyattributename = lo_row_7->get_value( ).
            ENDIF.
          ENDLOOP.
        ENDIF.
        lv_longobject = lo_row_5->get_indexsizebytes( ).
        lv_longobject = lo_row_5->get_itemcount( ).
        lv_string = lo_row_5->get_indexarn( ).
      ENDIF.
    ENDLOOP.
    LOOP AT lo_tabledescription->get_globalsecondaryindexes( ) into lo_row_8.
      lo_row_9 = lo_row_8.
      IF lo_row_9 IS NOT INITIAL.
        lv_indexname = lo_row_9->get_indexname( ).
        LOOP AT lo_row_9->get_keyschema( ) into lo_row_2.
          lo_row_3 = lo_row_2.
          IF lo_row_3 IS NOT INITIAL.
            lv_keyschemaattributename = lo_row_3->get_attributename( ).
            lv_keytype = lo_row_3->get_keytype( ).
          ENDIF.
        ENDLOOP.
        lo_projection = lo_row_9->get_projection( ).
        IF lo_projection IS NOT INITIAL.
          lv_projectiontype = lo_projection->get_projectiontype( ).
          LOOP AT lo_projection->get_nonkeyattributes( ) into lo_row_6.
            lo_row_7 = lo_row_6.
            IF lo_row_7 IS NOT INITIAL.
              lv_nonkeyattributename = lo_row_7->get_value( ).
            ENDIF.
          ENDLOOP.
        ENDIF.
        lv_indexstatus = lo_row_9->get_indexstatus( ).
        lv_backfilling = lo_row_9->get_backfilling( ).
        lo_provisionedthroughputde = lo_row_9->get_provisionedthroughput( ).
        IF lo_provisionedthroughputde IS NOT INITIAL.
          lv_date = lo_provisionedthroughputde->get_lastincreasedatetime( ).
          lv_date = lo_provisionedthroughputde->get_lastdecreasedatetime( ).
          lv_positivelongobject = lo_provisionedthroughputde->get_numberofdecreasestoday( ).
          lv_nonnegativelongobject = lo_provisionedthroughputde->get_readcapacityunits( ).
          lv_nonnegativelongobject = lo_provisionedthroughputde->get_writecapacityunits( ).
        ENDIF.
        lv_longobject = lo_row_9->get_indexsizebytes( ).
        lv_longobject = lo_row_9->get_itemcount( ).
        lv_string = lo_row_9->get_indexarn( ).
        lo_ondemandthroughput = lo_row_9->get_ondemandthroughput( ).
        IF lo_ondemandthroughput IS NOT INITIAL.
          lv_longobject = lo_ondemandthroughput->get_maxreadrequestunits( ).
          lv_longobject = lo_ondemandthroughput->get_maxwriterequestunits( ).
        ENDIF.
        lo_globalsecondaryindexwar = lo_row_9->get_warmthroughput( ).
        IF lo_globalsecondaryindexwar IS NOT INITIAL.
          lv_positivelongobject = lo_globalsecondaryindexwar->get_readunitspersecond( ).
          lv_positivelongobject = lo_globalsecondaryindexwar->get_writeunitspersecond( ).
          lv_indexstatus = lo_globalsecondaryindexwar->get_status( ).
        ENDIF.
      ENDIF.
    ENDLOOP.
    lo_streamspecification = lo_tabledescription->get_streamspecification( ).
    IF lo_streamspecification IS NOT INITIAL.
      lv_streamenabled = lo_streamspecification->get_streamenabled( ).
      lv_streamviewtype = lo_streamspecification->get_streamviewtype( ).
    ENDIF.
    lv_string = lo_tabledescription->get_lateststreamlabel( ).
    lv_streamarn = lo_tabledescription->get_lateststreamarn( ).
    lv_string = lo_tabledescription->get_globaltableversion( ).
    LOOP AT lo_tabledescription->get_replicas( ) into lo_row_10.
      lo_row_11 = lo_row_10.
      IF lo_row_11 IS NOT INITIAL.
        lv_regionname = lo_row_11->get_regionname( ).
        lv_replicastatus = lo_row_11->get_replicastatus( ).
        lv_replicastatusdescriptio = lo_row_11->get_replicastatusdescription( ).
        lv_replicastatuspercentpro = lo_row_11->get_rplstatuspercentprgss( ).
        lv_kmsmasterkeyid = lo_row_11->get_kmsmasterkeyid( ).
        lo_provisionedthroughputov = lo_row_11->get_provthroughputoverride( ).
        IF lo_provisionedthroughputov IS NOT INITIAL.
          lv_positivelongobject = lo_provisionedthroughputov->get_readcapacityunits( ).
        ENDIF.
        lo_ondemandthroughputoverr = lo_row_11->get_ondemandthruputoverride( ).
        IF lo_ondemandthroughputoverr IS NOT INITIAL.
          lv_longobject = lo_ondemandthroughputoverr->get_maxreadrequestunits( ).
        ENDIF.
        lo_tablewarmthroughputdesc = lo_row_11->get_warmthroughput( ).
        IF lo_tablewarmthroughputdesc IS NOT INITIAL.
          lv_positivelongobject = lo_tablewarmthroughputdesc->get_readunitspersecond( ).
          lv_positivelongobject = lo_tablewarmthroughputdesc->get_writeunitspersecond( ).
          lv_tablestatus = lo_tablewarmthroughputdesc->get_status( ).
        ENDIF.
        LOOP AT lo_row_11->get_globalsecondaryindexes( ) into lo_row_12.
          lo_row_13 = lo_row_12.
          IF lo_row_13 IS NOT INITIAL.
            lv_indexname = lo_row_13->get_indexname( ).
            lo_provisionedthroughputov = lo_row_13->get_provthroughputoverride( ).
            IF lo_provisionedthroughputov IS NOT INITIAL.
              lv_positivelongobject = lo_provisionedthroughputov->get_readcapacityunits( ).
            ENDIF.
            lo_ondemandthroughputoverr = lo_row_13->get_ondemandthruputoverride( ).
            IF lo_ondemandthroughputoverr IS NOT INITIAL.
              lv_longobject = lo_ondemandthroughputoverr->get_maxreadrequestunits( ).
            ENDIF.
            lo_globalsecondaryindexwar = lo_row_13->get_warmthroughput( ).
            IF lo_globalsecondaryindexwar IS NOT INITIAL.
              lv_positivelongobject = lo_globalsecondaryindexwar->get_readunitspersecond( ).
              lv_positivelongobject = lo_globalsecondaryindexwar->get_writeunitspersecond( ).
              lv_indexstatus = lo_globalsecondaryindexwar->get_status( ).
            ENDIF.
          ENDIF.
        ENDLOOP.
        lv_date = lo_row_11->get_rplinaccessibledatetime( ).
        lo_tableclasssummary = lo_row_11->get_replicatableclasssummary( ).
        IF lo_tableclasssummary IS NOT INITIAL.
          lv_tableclass = lo_tableclasssummary->get_tableclass( ).
          lv_date = lo_tableclasssummary->get_lastupdatedatetime( ).
        ENDIF.
      ENDIF.
    ENDLOOP.
    LOOP AT lo_tabledescription->get_globaltablewitnesses( ) into lo_row_14.
      lo_row_15 = lo_row_14.
      IF lo_row_15 IS NOT INITIAL.
        lv_regionname = lo_row_15->get_regionname( ).
        lv_witnessstatus = lo_row_15->get_witnessstatus( ).
      ENDIF.
    ENDLOOP.
    lo_restoresummary = lo_tabledescription->get_restoresummary( ).
    IF lo_restoresummary IS NOT INITIAL.
      lv_backuparn = lo_restoresummary->get_sourcebackuparn( ).
      lv_tablearn = lo_restoresummary->get_sourcetablearn( ).
      lv_date = lo_restoresummary->get_restoredatetime( ).
      lv_restoreinprogress = lo_restoresummary->get_restoreinprogress( ).
    ENDIF.
    lo_ssedescription = lo_tabledescription->get_ssedescription( ).
    IF lo_ssedescription IS NOT INITIAL.
      lv_ssestatus = lo_ssedescription->get_status( ).
      lv_ssetype = lo_ssedescription->get_ssetype( ).
      lv_kmsmasterkeyarn = lo_ssedescription->get_kmsmasterkeyarn( ).
      lv_date = lo_ssedescription->get_inaccessibleencdatetime( ).
    ENDIF.
    lo_archivalsummary = lo_tabledescription->get_archivalsummary( ).
    IF lo_archivalsummary IS NOT INITIAL.
      lv_date = lo_archivalsummary->get_archivaldatetime( ).
      lv_archivalreason = lo_archivalsummary->get_archivalreason( ).
      lv_backuparn = lo_archivalsummary->get_archivalbackuparn( ).
    ENDIF.
    lo_tableclasssummary = lo_tabledescription->get_tableclasssummary( ).
    IF lo_tableclasssummary IS NOT INITIAL.
      lv_tableclass = lo_tableclasssummary->get_tableclass( ).
      lv_date = lo_tableclasssummary->get_lastupdatedatetime( ).
    ENDIF.
    lv_deletionprotectionenabl = lo_tabledescription->get_deletionprotectionenbd( ).
    lo_ondemandthroughput = lo_tabledescription->get_ondemandthroughput( ).
    IF lo_ondemandthroughput IS NOT INITIAL.
      lv_longobject = lo_ondemandthroughput->get_maxreadrequestunits( ).
      lv_longobject = lo_ondemandthroughput->get_maxwriterequestunits( ).
    ENDIF.
    lo_tablewarmthroughputdesc = lo_tabledescription->get_warmthroughput( ).
    IF lo_tablewarmthroughputdesc IS NOT INITIAL.
      lv_positivelongobject = lo_tablewarmthroughputdesc->get_readunitspersecond( ).
      lv_positivelongobject = lo_tablewarmthroughputdesc->get_writeunitspersecond( ).
      lv_tablestatus = lo_tablewarmthroughputdesc->get_status( ).
    ENDIF.
    lv_multiregionconsistency = lo_tabledescription->get_multiregionconsistency( ).
  ENDIF.
ENDIF.