ERP Integrator V2 - Online Help
ERP Integrator V2
Questions / Feedback?

RowData Property

The raw binary data that makes up a row.

Syntax

[VB.NET]
Public Property RowData As String
Public Property RowDataB As Byte()

[C#]
public string RowData {get; set;}
public byte[] RowDataB {get; set;}

Remarks

This is what the SAP system returns, before the component parses the row into individual columns. The RowData will always reflect the current contents of the Columns. If you change data in a column, the RowData will change the next time you retrieve it. Likewise, if you set the RowData, the contents will be parsed into individual Columns.

Internal tables are used for storing and formatting a database table, which is sent to or received from the SAP system. Each table can contain up to 8192 rows, and the maximum possible length of a row is 65535 bytes. Each row is made up of one or more columns. A function on the R/3 system may use multiple tables for input and output.

The GetFunctionInfo method will retrieve the definitions of all of the tables used by the function you're calling. The TableCount property will reflect the total number of tables the function uses, and TableIndex is used to change the table you're looking at. These tables will be empty until you add data yourself or until table data is returned after using the CallFunction method.

To read out data from a table, first set the TableIndex to the table you're interested in. The total number of rows in the table will be reflected by the RowCount property. Walk through the rows using the RowIndex property. You can read the full raw binary contents of the row via the RowData property. However, it is much easier to access this data by using the Columns collection. Each row will have a collection of columns. Each SapColumn has a name, value, type, and maximum length. Only the value can be changed, the other fields were retrieved when you called the GetFunctionInfo method.

The following code shows how to display the results of an RFC function search:

control.FunctionName = "RFC_FUNCTION_SEARCH";
control.GetFunctionInfo();
control.SetRequestParam("FUNCNAME, "RFC*"); // set the search criteria. FUNCNAME is "" by default.
control.CallFunction();
control.TableIndex = 0;
for (int row = 0; row < control.RowCount; row++) {
  control.RowIndex = row;
  for (int col = 0; col < control.Columns.Count(); col++) {          
    SapColumn curr = (SapColumn)control.Columns.ElementAt(col);
    Console.WriteLine(curr.Name + " = \"" + curr.Value.Trim() + "\" (" + curr.ColumnType + ")");          
  }
  Console.WriteLine("");
}
The output from the above code will look something like this:
FUNCNAME = "RFCPING" (ctCharacters)
GROUPNAME = "SYST" (ctCharacters)
APPL = "" (ctCharacters)
HOST = "" (ctCharacters)
STEXT = "RFC Ping" (ctCharacters)

FUNCNAME = "RFC_ABAP_INSTALL_AND_RUN" (ctCharacters)
GROUPNAME = "SUTL" (ctCharacters)
APPL = "S" (ctCharacters)
HOST = "" (ctCharacters)
STEXT = "" (ctCharacters)

FUNCNAME = "RFC_CALL_TRANSACTION_USING" (ctCharacters)
GROUPNAME = "MRFC" (ctCharacters)
APPL = "S" (ctCharacters)
HOST = "" (ctCharacters)
STEXT = "Verification Program for Execution of RFCs via CALL TRANSACTION USING" (ctCharacters)

...

This property is not available at design time.

Default Value

""

 
 
Copyright (c) 2017 /n software inc. - All rights reserved.
Build 2.0.6240.0