Rediger

Del via

Examples for EXEC Statement

  • Artikkel

This topic shows example syntax for various EXEC statements.

Sample statements

  • To execute a BAPI that takes no input parameters, use the following syntax; data is returned through a DataReader object:

    EXEC BAPI_COMPANYCODE_GETLIST

  • To execute an RFC that takes input parameters, use the following syntax:

    EXEC RFC_CUSTOMER_GET @NAME1='Contoso'

  • To execute an RFC that takes input parameters specified as a variable, use the following syntax:

    EXEC RFC_CUSTOMER_GET @var=@var

    In this example, you must create a parameter named @var and set the value explicitly (for example, to 1001), because the first parameter for RFC_CUSTOMER_GET corresponds to KUNNR (Customer Number)

  • To execute an RFC that uses a variable for the input parameter name, use the following syntax:

    EXEC RFC_CUSTOMER_GET @KUNNR=@var1, @NAME1='Contoso'

    You must create a parameter named @var1, specify the value, and then bind it to the corresponding command object. The default direction of the newly created parameter object is input.

  • To execute a BAPI and return tables as a parameter, use the following syntax:

    EXEC BAPI_COMPANYCODE_GETLIST @COMPANYCODE_LIST=@var1 OUTPUT

    You must create a parameter named @var1, specify the value, and bind it to the corresponding command object. The direction of the newly created parameter object should be InputOutput or Output.

  • The following EXEC example uses a table complex type parameter. In the example, @fields is a TABLE parameter.

    exec rfc_read_table @query_table='BNKA', @fields='<FIELDS xmlns='http://Microsoft.LobServices.Sap/2007/03/Rfc/'>  
            <RFC_DB_FLD xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">  
              <FIELDNAME>BANKL</FIELDNAME>  
            </RFC_DB_FLD>  
            <RFC_DB_FLD  xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">  
                <FIELDNAME>BANKS</FIELDNAME>  
            </RFC_DB_FLD>  
          </FIELDS>', @fields=@flds output

  • The following EXEC example uses a STRUCT complex type. In the example, @equimaster is a STRUCT parameter.

    exec BAPI_EQMT_MODIFY @equipment='000000000000000637', @equimaster='<EQUIMASTER>           
            <EQUIPMENT xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">equip</EQUIPMENT>  
            <EQUICATGRY xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">E</EQUICATGRY>  
            <MATERIAL xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">mat</MATERIAL>  
          </EQUIMASTER >', @equimaster=@em output

Support for Complex Parameter Types

There are two ways to support complex RFC parameters (tables and structures) when you use the Data Provider for SAP:

  • Provide an inline XML value for the complex type. This example shows how to pass XML to the complex parameter type fields. In the following example, @fields is a table parameter.

    exec rfc_read_table @query_table='BNKA', @fields='<FIELDS xmlns='http://Microsoft.LobServices.Sap/2007/03/Rfc/'>  
            <RFC_DB_FLD xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">  
              <FIELDNAME>BANKL</FIELDNAME>  
            </RFC_DB_FLD>  
            <RFC_DB_FLD  xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">  
                <FIELDNAME>BANKS</FIELDNAME>  
            </RFC_DB_FLD>  
          </FIELDS>', @fields=@flds output

  • Create a DataTable parameter with columns for the fields in the complex type and set the SAP parameter value to DataTable. This example shows how to set the @fields complex type by using a DataTable.

    cmd.CommandText = "exec rfc_read_table @query_table='BNKA', @fields = @p_fields";  
DataTable dt = new DataTable();  
dt.Columns.Add("FIELDNAME");  
SAPParameter p = new SAPParameter("@p_fields");  
p.Value = dt;

Limitations

The Data Provider for SAP has the following limitations for complex types.

  • When you pass a complex type in a parameter by using a DataTable, you must include all fields (columns) of the complex type in the DataTable.

  • The Microsoft BizTalk Adapter for mySAP Business Suite does not support DbNull. You cannot set DbNull as a value for parameters.