Read meta data of a table
This sample shows how to read the meta data of an SAP table using the ReadTable class.
| Table MKPF |
|---|
| using System;
using ERPConnect;
using ERPConnect.Utils;
// Set your ERPConnect license
LIC.SetLic("xxxx");
// Open the connection to SAP
using var connection = new R3Connection(
host: "server.acme.org",
systemNumber: 00,
userName: "user",
password: "passwd",
language: "EN",
client: "001")
{
Protocol = ClientProtocol.NWRFC,
};
connection.Open();
ReadTable read = new ReadTable(connection);
read.TableName = "MKPF";
read.RetrieveAllFieldsOfTable();
// Fill the fields collection with detailed information on each column
for(int i=0; i < read.Fields.Count; i++)
Console.WriteLine(read.Fields[i].FieldName + " (" +
read.Fields[i].ABAPType + ", " + read.Fields[i].Length + ")");
connection.Close();
|
Last update: January 2, 2024