RSAPReadTable: SAP RFC function calls

Description Usage Arguments Details Value Note Author(s) See Also Examples

View source: R/RSAP.R

Description

Open connections to an SAP System for RFC calls

Usage

1
RSAPReadTable(con, saptable, options=list(), fields=list())

Arguments

con

an Open SAP RFC Conneciton handle

saptable

The Data Dictionary name of a table to read

options

list of string values of SQL WHERE clause statements to apply to the table select

fields

A list of column names that you want returned from the table

Details

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
  con <- RSAPConnect(ashost="nplhost", sysnr="42",
                      client="001", user="developer", 
                      passwd="developer", lang="EN", 
                      trace="1", lcheck="1")

  res <- RSAPReadTable(con, "SFLIGHT2")
  # or use alias
  # res <- readTable(con, "SFLIGHT2")

  print(res)

  RSAPClose(con)
  

Value

Returns a data.frame of the table contents selected

Note

Not much to note here.

Author(s)

Piers Harding

See Also

RSAPConnect, RSAPGetInfo, RSAPInvoke, RSAPClose

Examples

1
2
3
4
5
## Not run: 
# read the flight data demo table
res <- RSAPReadTable(con, "SFLIGHTS2", options=list("CARRID = 'AA'"), fields=list('CARRID', 'CONNID', 'FLDATE', 'PRICE'))

## End(Not run)

RSAP documentation built on May 29, 2017, 1:47 p.m.