Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Creating a BAPI/RFC Transformation

Creating a BAPI/RFC Transformation

You can create a BAPI/RFC transformation in the Transformation Developer or the Mapping Designer. If you click Transformation > Import SAP BAPI/RFC in the Transformation Developer, you can select one or more BAPIs to import. The BAPI/RFC Wizard creates a transformation for each BAPI you import. If you click the BAPI icon in the Transformation Developer or import a BAPI/RFC transformation, you can select one BAPI to import.
Connect to SAP to import BAPI/RFC metadata. You can enter a DEST entry from the
sapnwrfc.ini
file or a host name to connect to SAP. When you start the wizard, click Connect String to enter a DEST entry. Click Host Name to enter a host name.
You can enter the following connection string parameters when you connect to SAP:
Field
Description
Connect String
Required. DEST entry for a connection to a specific SAP application server or DEST entry for a connection that uses SAP load balancing defined in the
sapnwrfc.ini
file.
User Name
Required. SAP source system connection user name. Must be a user for which you have created a source system connection.
Password
Required. Password for the user name.
Client
Required. SAP client number.
Language
Optional. Language you want for the mapping. Must be compatible with the PowerCenter Client code page. If you leave this option blank, PowerCenter uses the default language of the SAP system.
You can enter the following host name values when you connect to SAP:
Field
Description
Host Name
Required. DEST entry for a connection to a specific SAP application server or DEST entry for a connection that uses SAP load balancing defined in the
sapnwrfc.ini
file.
System No
Required. SAP source system connection user name. Must be a user for which you have created a source system connection.
User Name
Required. SAP source system connection user name. Must be a user for which you have created a source system connection.
Password
Required. Password for the user name.
Client
Required. SAP client number.
Language
Optional. Language you want for the mapping. Must be compatible with the PowerCenter Client code page. If you leave this option blank, PowerCenter uses the default language of the SAP system.
You can filter BAPIs based on the name or the description of the BAPI. When you enter a filter condition, you can enter an exact name or description. Or, you can perform wildcard search. Use the following filter syntax rules and guidelines:
  • To filter on a description, enter a filter condition of 20 characters or fewer.
  • Use the percent sign (%) as a wildcard search for multiple characters. For example, to find a BAPI whose name begins with the letter “I”, enter
    I%
    as the filter criterion.
  • Use an underscore (_) as a wildcard search for single characters.
  • If you filter BAPIs by description, the filter condition is case sensitive. If you filter BAPIs by name, the filter condition is not case sensitive.
When you select a BAPI to import, you can view information about the BAPI parameters on the Parameters tab. You can also view and edit information about the return structure on the Return Structure tab.
When you create a BAPI/RFC transformation with table type parameters, the PowerCenter Client generates an XSD file for each table type group in the transformation. You cannot import BAPIs with a parameter whose name includes a forward slash (/) and was defined using a table type parameter. The Designer does not generate the XSD file for the corresponding parameter.
The Designer uses the following naming convention for XSD files:
<parameter_name>-<associated_type_name>.xsd
If the parameter name or associated type name includes a name space, the Designer replaces the forward slash (/) with a pound sign (#).
You cannot create a transformation from a BAPI that contains a field with the same name as its parent structure. If you create a transformation from a BAPI with a parameter defined with a deep structure or table or a table type with a deep structure in the line type, the wizard shows the root and leaf nodes. It does not show intermediate nodes.
To create a BAPI/RFC transformation:
  1. In the Transformation Developer, click Transformation > Create, select SAP BAPI/RFC transformation, enter a transformation name, and click Create. Or, in the Transformation Developer, click Transformation > Import SAP BAPI/RFC. Or, in the Mapping Designer, click Transformation > Create, select SAP BAPI/RFC transformation, enter a transformation name, and click Create.
    Step 1 of the wizard appears.
  2. Enter connection string parameters to connect to SAP with the
    sapnwrfc.ini
    file. Or, click Host Name and enter host name parameters to connect to SAP. Click Next.
  3. Optionally, enter a filter condition to filter BAPIs by name or description.
  4. Click Get Objects.
    The wizards displays BAPIs that you can import.
  5. Expand the list of objects and select the BAPIs you want to import.
    If you clicked Transformation > Import SAP BAPI/RFC to start the wizard, you can select multiple BAPIs to import. Otherwise, you can import one BAPI.
  6. Optionally, select a BAPI name to view information about the BAPI parameters on the Parameters tab.
  7. Optionally, click the Return Structure tab to edit information about the BAPI return structure.
  8. Click Next.
    Step 3 of the wizard provides information about the BAPI you want to import.
  9. Optionally, edit the name of the BAPI/RFC transformation.
  10. Click Finish.

0 COMMENTS

We’d like to hear from you!