SAPB1 - How To Make a Multiple Query (Magic xpi 3.x)
You can query multiple records using the XML configuration. To make a multiple query:
-
Drag an SAPB1 connector into the flow.
-
In the Component Properties dialog box's Settings tab, select a resource. If you did not define a resource, from the Project menu, select Resources to open the Resource Repository. Here, you should define an SAPB1 resource, which in turn defines the connections to the SAP databases. For more information on how to do this, click here.
-
Click the Component Properties dialog box's General tab, and select XML as the interface.
-
Click Configuration.
-
The SAPB1 Configuration dialog box opens. Select Query as the Operation.
-
Select the data object where the information is to come from. For example, if you want to make a query about business partners, select BusinessPartners as the data object.
-
Click OK to open the Data Mapper Source/Destination Management dialog box. The Destination side of the dialog box will have SAPB1 entered as an IFC Model type.
-
Click New on the Source side of the Source/Destination Management dialog box.
-
Select the Type according to where you are getting your original data. You can have a flat file with indexes or get the information from a database.
-
Click Properties and enter the information about your data. For example, if you are using a flat file select the flat file and delimiter information. For more information on how to configure Source properties, see Source/Destination Management dialog box in this Help. Click OK to close the Source Properties and return to the Source/Destination Management dialog box.
-
Click Map to open the Data Mapper.
-
Map the data type in your file to the same data type in the destination. For example, you should have a Source node called CardCode if you are mapping Card Code information. Map this to the CardCode node in the SAPB1 destination. This indicates what data should be mapped.
-
Map the compound node called Record where the data type in the previous step resides to the BO compound node on the Source side. This tells the Data Mapper to map all the business object data with the card codes indicated.
-
Click OK to close the Data Mapper.