Uipath Marketplace
MarketplaceListingsSnippetExtract SAP Table with BAPI

Create your first automation in just a few minutes.Try Studio Web

Extract SAP Table with BAPI

Extract SAP Table with BAPI

by Alfonso De Gea

2

Snippet

Downloads

348

back button
back button
next button
next button

Summary

Summary

Extract data from SAP table using a BAPI (RFC_READ_TABLE)

Overview

Overview

Sometimes you require a direct reading of SAP tables, and in order to do it, we have SAP-supplied function, RFC_READ_TABLE. Its fast and simple, but has some limitations: No check authorization objects, has small size results (512 bytes per row), only works fine with plain text, etc. (See SAP notes 2503119 and 382318)

PREREQUISITES:

- SAP Connection with user granted for S_DEVELOP and S_RFC

INPUT PARAMETERS:

- io_SAP: SAP connection (IConnectionService)

- iv_table: SAP table (Ex.T001)

- iv_fields: comma separated fields (Ex. BUKRS,BUTXT,ORT01,LAND1,WAERS)

- iv_options: where clause (Ex. BUTXT LIKE '%Template%')

OUTPUT PARAMETERS:

- odt_fields: DataTable with fields metadata

- odt_data: DataTable with pipe delimited extract data.

- odt_results: DataTable with results cooked.

EXCEPTIONS:

- SAP.Middleware.Connector.RfcAbapException

DOC: 

https://docs.google.com/document/d/1NGtHMzDdMQYfY0BFw6G95THnbiKIVLzyPWAjUiUjd7Q/edit?usp=sharing

Features

Features

A simple and fast way to extract data from SAP table

Additional Information

Additional Information

Dependencies

UiPath.SAP.BAPI.Activities >= 1.0.0

Code Language

Visual Basic

Publisher

Alfonso De Gea

Visit publisher's page

License & Privacy

BSD

Privacy Terms

Technical

Version

1.0.0

Updated

Feb 18, 2020

Works with

Studio: 19.1 - 22.10

Certification

Silver Certified

Application

SAP

Support

UiPath Community Support

Resources

Similar Listings