Importing a Data Source (RFC/BOR Interface)

Creating an entity type from a data source comprises three steps:

1. Importing the data source.

2. Selecting the parameters from the data source.

3. Editing the selected parameters.

To create entity types from a data source, proceed as follows:

1. Log onto the SAP Gateway system.

2. Open transaction SEGW.

   The SAP Gateway Service Builder opens.

3. Create a new project. For more information, see Creating a Service Builder Project.

4. Right click the Data Model folder and select  Import   RFC/BOR Interface .

   The Wizard 1 of 3: Create Entity Type from Data Source-Import Entity Type From Data Source screen of the wizard opens.

5. Do the following in the wizard:

   1. Enter a name for the new entity type in the Entity Type Name field

   2. In Target System select either the Remote data source or the Local data source radio button.

      • Remote: Select this option to fetch properties that resides in the remote system. On selecting this option the RFC Destination field is activated.

      • Local: Select this option to fetch properties that resides in the local system. The RFC Destination field is not activated for this option.

      Note

      If a model is created using the Import RFC/BOR function and later has to be transported to another system where the DDIC objects may not be available, it is recommended to create the model using the RFC destination as NONE so that no DDIC objects is assigned to the entity type and the individual data element assignment to the properties (in the ABAP type editor) do not happen and local data types generate in the MPC.

   3. For Remote Data Source, enter the parameters of the connection in the RFC Destination field. For example, TCP/IP or SAP connections. Alternately, you can also use input help available for this field.

   4. Select the type of the data source from the Type field drop-down list in the Data Source Attributes region.

   5. Depending on the selection in the Type field, enter the name of the data source in the Name field. Alternately, you can also use the input help available for this field.

   6. Click Next to proceed.

      Note

      If any entries are incorrect, an error message is displayed.

   If the validation check is successful, the Wizard Step 2 of 3: Create Entity Type from Data Source-Select Parameter(s) screen of the wizard opens.

   This screen displays the structures/table types and their properties.

6. Expand the Data Source Parameter and select the required structures, tables types, and properties.

   On selecting the parent structure or table the corresponding Assign Structure also gets selected by default. If you select individual property in structure or table Assign Structure should be selected manually.

   • Structures are imported into the Service Builder as complex type.

   • Tables are imported into the Service Builder as new entity types

   • Properties are defined for the entity type and complex type imported

     To remember during the selection of the properties:

     • If the Target System is Local, and when you select a property without selecting its structure/table type, the property will be assigned with the corresponding data element. Whereas, if the Target System is Remote, then the data element assignment will not happen.

     • If the Target System is Local, and when you select a property along with its structure/table type, then the DDIC structure is assigned to the Complex Type/Entity Type. Whereas, if the Target System is Remote, then the DDIC structure assignment will not happen.

     Recommendation

     The new entity type, if created with a structure assigned to it, has the following advantages:

     • Conversion exit routines are used automatically

     • Labels are used from the DDIC

     • In the DPC class, the RFC or BOR interface parameters with structure or table types can be directly assigned instead of using move-corresponding.

     Note

     Parameters not selected can be selected later by using the Import  Properties  function as mentioned in the Importing Properties section below.

7. Select the check-box under Assign Structure to create additional artifacts.

   • Complex types will be created if the parameter is a structure type and entity types will be created if the parameter is a table type. In addition, DDIC assignment will be retained for the newly created artifacts.

   • If this check-box is not selected then all the properties will be created under one root as a flattened structure.

8. Click Next.

   The Wizard Step 3 of 3: Create Entity Type from Data Source-Modify Entity Type screen of the wizard opens.

   This screen provides the following editable and non-editable information:

   Name	Description	Edit Status
   Is Entity	If the property belongs to the entity type, this check box is selected. If it is not selected, the property belongs to the complex type.	Non-Editable
   Complex/Entity Type Name	This is the name of the property. It can either be a complex type or entity type	Editable
   ABAP Name	This is the technical name. This will not be displayed in the metadata.	Non-Editable
   Type	Type of property.	Non-Editable
   Name	This is external name displayed in the metadata.	Editable
   Is Key	Indicates whether the imported property is to be imported as a key of the entity type. Each entity type must define at least one key property.	Editable
   Label	This is the label for the properties which will be displayed in the metadata.	Editable

   Note

   The Create Default Entity Set will be selected by default if an entity type is chosen for creation. You can choose not to create entity sets by deselecting this box. If there are no entity types then this will be disabled. All entity sets will be created with the suffix name Set. For example, If Entity type name is E1 then the default entity set name will be E1Set.

9. Click Finish.

   The selected data source parameters are imported into the Service Builder.

   
   
   

   Figure 1: Selected data source parameters imported into the Service Builder

   The new entity type you have created can also be assigned to a structure. The advantages of assigning a structure to the entity types are:

   • Conversion exit routines are used automatically

   • Labels are used from the DDIC

   • In the DPC class, the RFC or BOR interface parameters with structure or table types can be directly assigned instead of using move-corresponding.

   You can verify that:

   • the selected ABAP Structure name is displayed in the ABAP Structure Type Name field of the imported entity type/complex type

   • the properties selected without their structures/table types are assigned with a data element

   
   
   

   Figure 2: Data Element automatically assigned
   Note

   The Service Builder runs an OData compliance check. The appropriate information messages resulting from the check are displayed. Double click the message to repair the error. See Entity Types for editing the entity types in the mass edit view.

10. After fixing all the errors you can generate runtime objects.

    See Generating the Service for detailed instructions to generate a service.

11. After generating the runtime objects, you can register and then maintain the service in the configured SAP Gateway hub systems.

    See Service Maintenance to maintain services.

There might be instances you do not select some properties during an import of RFC/BOR Interface and later you want to import those properties as well. For such cases, a function Import properties is used to import more properties from the same data source.

This section will guide you to import more properties for the entity/complex types from the same data source that were created during an import of RFC/BOR.

To import properties proceed as follows:

1. Right click on the entity type or on the complex type you have imported and select  Import   Properties .

   The Wizard Step 1 of 2: Import Properties-Select Parameter(s) page appears.

   The properties that were already selected are disabled, and the other properties can be selected.

2. Select the required properties and click Next.

   The Wizard Step 2 of 2: Import Properties-Modify Entity Type page appears.

   The properties that were added are represented with the editable Name, Is Key and Label columns.

3. Click Finish to complete the import.

   You can see selected properties in the tree view. Service Builder also performs an OData Compliance and the messages are displayed in details region.

For RFC/BOR, an input mapping will be created only if you click Propose Mapping and there is an Import parameter in the Data Source with the same name as the Data Source Attribute from which the property was created.