使用Pyrfc的SAP R/3表中的条目数

Question

如何使用Pyrfc Python库查询SAP /3数据库表中的条目数？

Answer 1

我知道使用Pyrfc进行此操作的三种方法。使用SAP /3服务器连接设置和所需的表名修改以下示例：

from pyrfc import Connection

params = dict(
    ashost="1.1.1.1",
    sysnr="1",
    client="100",
    user="username",
    passwd="password",
)
table = "MKAL"
with Connection(**params) as conn:
    # Method 1
    result = conn.call("RFC_GET_TABLE_ENTRIES", TABLE_NAME=table, MAX_ENTRIES=1)
    entries = result["NUMBER_OF_ENTRIES"]

    # Method 2
    result = conn.call("EM_GET_NUMBER_OF_ENTRIES", IT_TABLES=[{"TABNAME": table}])
    entries = result["IT_TABLES"][0]["TABROWS"]

    # Method 3
    short_field = "MANDT"  # table field with short data length
    result = conn.call(
        "RFC_READ_TABLE",
        QUERY_TABLE=table,
        ROWCOUNT=0,
        FIELDS=short_field,
    )
    entries = len(result)