Skip to main content

DataServicesReadTable@1

Node DataServicesReadTable@1 creates a new SAP PM notification within Plant Maintenance (PM) module.

SAP function module: /SAPDS/RFC_READ_TABLE

Adapter Prerequisites​

Node Configuration​

For fields path, targetPath, targetValueWriteMode, and targetValueKind, see Overview.

  transformations:
    - type: DataServicesReadTable@1 # reads the table using SAP Data Services
      tableName: SFLIGHT # name of the table to read
      fields: # fields to read
        - PRICE
        - MANDT
        - PLANETYPE
        - CONNID
      filters: # filters to apply, more filters can be added using AND or OR operators, see SAP documentation
        - CONNID EQ '0017'
      targetPath: "$.flights"

The result object is constructed as an array of objects, each object represents a row in the table. The property names are used from the fields configuration.

Complete sample of pipeline configuration​

This sample receives a message from a distributed event hub, sets the values to query data from a table, logs in to SAP and reads the table data from SFLIGHT table. It is searched for flights with connection id 0017, and the result is saved in the $.flights path. Fields PRICE, MANDT, PLANETYPE, and CONNID are read.

  triggers:
    - type: FromPipelineDataEvent@1
      description: Retrieve from distributed event hub message
  transformations:
    - type: SetPrimitiveValue@1
      value: 000010000571
      targetPath: $.tablename
    - type: SapLogin@1
      sapConfiguration: mmtest
    - type: DataServicesReadTable@1
      tableName: SFLIGHT
      fields:
        - PRICE
        - MANDT
        - PLANETYPE
        - CONNID
      filters:
        - CONNID EQ '0017'
      targetPath: "$.flights"