How achieve Drag and Relate for SAP backend system (R/3, BW, etc.)
Drag & Relate is one of the most powerful functionality of the Unification Platform. This short Weblog will explain step by step how to create iViews above SAP backend systems (R/3, BW) that implements Drag & Relate between them.
There are few pre-requirements that one must fulfill prior to going over this document:
- SAP backend system with Plag in installed
- Full installation of NetWeaver 04 Portal
For scenario sake will suppose that you have IDES data in your R/3 backend system.
We will implement the scenario in which you are a Customer and would like to check all orders where specific material was ordered.
In order to create our demo scenario we will create:
1. System Landscape for the R/3 backend system.
2. Import Business Objects
3. iViews that presents R/3 transactions.
Beside this, you’ll have to set all needed Portal permissions because without doing this you won’t be able to do anything.
Let's start working...
Login to the Portal as a System Administrator; go to System Administration -> System Configuration -> System Landscape. Create a new folder in which all our content will reside. Let's call this Folder Unification Practice Content. Inside the Unification Practice Content we will create our R/3 System. In order to select what system wizard to use you should know what kind of system connection you use: Application Server or Message Server.
For Application server use “R/3 Dedicated” and for Message server use “R/3 Load balancing”. Properties for both kinds of connections are almost the same, but for Message server you should set ‘Group’ parameter.
For each system you should fill following properties:
* Due the reason that there are a lot of properties to fill it is really convenient to choose one Property Category at a time.
Category ‘Connector’ fill:
· Application Host:
System Server Host name or IP address.
· Logical System Name:
your System Logical Name (usually the syntax is going like this: <System ID>CLNT<SAP Client number>, for example if your System name SP2 and Client number is 900, the System Logical Name will be SP2CLNT900).
· SAP Client:
your System Client number
· SAP System ID:
your System name
· SAP System Number:
your System Number (usually ‘00’ for Application Server)
· System Type:
Category ‘User Management’ fill:
· Logon Method:
Select Authentication Method of connection to System. UIDPW – User Mapping. If you want to use ticket authentication select – SAPLOGONTICKET.
· User Mapping type:
Admin/user – here you set who will be able to set User Mapping.
Category ‘Distributed Query Engine’ fill:
· Admin Password (DQE):
Set Password of Administrative user for the backend system (R/3).
· Admin User ID (DQE):
Set User ID of Administrative user for the backend system (R/3).
Category ‘Internet Transaction Server (ITS)’ fill:
· ITS Host name:
The Host name of ITS for your system.
· ITS path:
· ITS Protocol:
http or https
*These properties must be filled only in case you what to view iViews using WebGui.
After filling all needed properties, create System Alias
Logoff (*) and now login as a User Administrator. Here you will set the User Mapping for the System we have just created (with the alias which is equal to your System Logical Name). Go to User Administration -> User Mapping, search for ‘Everyone’ group and set the user mapping for the system we have just created.
Logoff (*) and login as a Content Administrator in order to import relevant Business Objects create all our content.
First go to import relevant Business Objects (BO). You should import all BO that participate in Drag and Relate including those that participate only as bridges is automatic relations as it is in our case. There is no Foreign Key relation between Orders (BUS2004) and Customers (KNA1), but there are relations between Orders and Plants and between Plants and Customers. We should import Orders, Plants and Customers in order to achieve successful Drag and Relate result.
To Import Business Objects Right click on the Business Objects folder, select Import Business Objects, browse into your system (expand your system alias) and import BUS2004 (Stock Orders), BUS0008 (Plants) and KNA1 (Customers).
Now create New SAP Transaction iView over BUS2004 (Transaction Code md13), call it ‘Orders’.
Create another New SAP Transaction iView over KNA1 (Transaction code vd03), call it ‘Customers’. In iView properties navigate to category ‘Drag and Relate’ and set property Drag and Relate target to ‘True’ and verify the correctness of main object.
Navigate to iView ‘Orders’ that you just created right click on it and select OpenàDrag&Relate Targets. Add the iView ‘Customers’ as Drag and Relate target to iView ‘Orders’.
Import the relevant Business Objects. Right click on the Business Objects folder, select Import Business Objects, browse into your system (the MyPubs system) and import the sales and stores objects.
Now, let's verify the automatic relation between the BUS2004 and KNA1. You don’t have to do it but just to be on the ‘safe side’ we’ll verify the existence of the relation. Go to: Content Administration -> Unification; add BUS2004 BO as source and KNA1 BO as target. Verify that you can see automatic relation between them in the relationship editor (pay attention: the relation will display only when you choose to display it).
Finally, we will create a Role; let's name this Role, Unification Role. Inside the role we will create a folder and add (as delta-link) the ‘Orders’ iView; assign the role to one of your end users and we are done.
The one last thing we should configure before runtime is to set permissions for your user. You should set ‘Full Control’ permissions for your user on System, all iViews and all Business Objects. To do it the easiest way is to set permissions on the entire folder which contains your System, all your iViews and for ‘Business Objects’ folder.
Congratulations, we are done! Login to the Portal as your end user and navigate to iView ‘Orders’. Once you click on iView ‘Orders’ iView ‘Customers’ appear in Drag and Relate Targets Area. The UI is familiar for you, isn’t’ it?
Enter Order number in field ‘Planned Order’ in the iView and press ‘Enter’. Now screen with Order Details is open and the Order number is Drag and Relate link (if it isn’t, see Troubleshooting doc).
Drag the Order number link and relate it to iView ‘Customers’. The window with number of Customer for this Order is opening!!! If you click ‘Enter’ you will see the properties of this Customer. Exactly as you would do it in real R/3.
I hope this document will help you to realize what a great technology is Drag and Relate!
Any comments are very welcome and if you have any troubles, check for solution in Troubleshooting for Unification doc.
(*) One may work as a Super Administrator user instead of logging off and logging in back