[BASIS] – Create DB Link from SAP to External Oracle Database

25 08 2011

BASIS STEPS

Insert TNSNames Alias into file TNSNames.ora under Oracle Directory (C:\oracle\<SID>\102\network\admin\ tnsnames.ora)

CE7.WORLD =

(DESCRIPTION =

(ADDRESS =

(COMMUNITY = TCP.WORLD)

(PROTOCOL = TCP)

(HOST = sykapsrv12.replynet.prv)

(PORT = 1527)

)

(CONNECT_DATA =

(SID = CE7)

(GLOBAL_NAME = CE7.WORLD)

)

)

Insert the same TNSNames Alias into file TNSNames.ora under Sap Profile Directory (C:\usr\sap\<SID>\SYS\profile\oracle\tnsnames.ora )

ADMINISTRATION STEPS

DBACOCKPIT Transaction -> DB Connections Tab -> Add

SAMPLE CODE FOR CONNECTION TO EXTERNAL DB

DATA: lv_dbs_connection      TYPE dbcon-con_name VALUE 'BDXXX',
lv_current_connection  TYPE dbcon-con_name.

DATA dbtype TYPE dbcon_dbms.

SELECT SINGLE dbms
FROM dbcon
INTO dbtype
WHERE con_name = lv_dbs_connection.

IF dbtype = 'ORA'.
TRY.

EXEC SQL.
CONNECT TO :lv_dbs_connection
ENDEXEC.
IF sy-subrc <> 0.
RAISE EXCEPTION TYPE cx_sy_native_sql_error.
ENDIF.
EXEC SQL.
SET CONNECTION :lv_dbs_connection
ENDEXEC.

EXEC SQL.
DISCONNECT :lv_current_connection
ENDEXEC.
ENDTRY.
ENDIF.





[ABAP] – Filter View Data by Authorization-Object Field

31 03 2011

Method for get dynamic content value for a TABLE VIEW,

by adding custom field in AUTHORIZATION-OBJECT (ZFIELD & ZFIELDVAL).

1 – Authorization Object Creation (you can refer to this document)

2- Assign Role to User & Input Value for your Authorization Fields

3- Go to SE11, select your table, generate the Table View

4- Go to SE11 -> Utilities -> Table Maintainance Generation -> Environment -> Modification -> Events

5- Set a Program Name for Event type AA


6- Develope your Authorization Get Value Method


 

7- Call Method in your Program for TableView Event

8- Check your RESULT!








[SAP PI] – Choose the Right Adapter to integrate with SAP systems

23 03 2011

Often we come across the dilemma of which adapater should I use while integrating with SAP systems. Will try and discuss on the options available and what could be some of the points that one should consider before you zero in one of the adapters.
If you see the list of Adapters given by SAP, a quick seggregation can be done depending on the type of systems that these adapters are going to communicate with.

Now, one of the obvious systems with which XI is going to communicate will the SAP systems (SAP R/3 – 4.6C, 4.7, ECC 5.0, CRM, SRM etc etc). Now these systems could be on the sending side or on the receiving side or could be on both sides where R/3 is integrating with SRM / CRM …. or vice versa.
So, what are the options that SAP gives us to communicate with SAP systems.

1. IDOC Adapter
2. RFC Adapter
3. Proxy

Now, how do you choose the right one for a given scenario. One of the things that SAP strongly suggests is the usage of PROXIES.

Now, if you take a close look at the adapters specified here, the one thing that strikes right away is the usage of proxies. We know that proxy generation is possible only if your WAS is >= 6.20. So, that is one parameter that comes up straight away for the usage of proxies.

— Use Proxies only if the WAS version is >= 6.20.

We will also look into other reasons where we should go for a proxy.

Let’s take a case and discuss the same.
The immediate question that probably you are getting is :
I am on WAS 6.2 or higher and also at the same time either I have a standard BAPI / Remote enable function module for the given functionality on the application system. So, what should I do now?

In this case, there are 2 ways in which the implementation can happen.

1. Configure a RFC Adapter and call the BAPI / RFC. However the potential problem that I could see is that the RFC adapter existing on the Java stack communciating with the BAPI existing on the SAP application system.
2. The second option that I have got is to write a proxy on the SAP application system (which will be called by XI) and internally the proxy will call the BAPI.
At this point of time if your question is, as long as I am dealing with the latest versions of SAP systems, should I totally avoid using RFC Adapters – MY TAKE on this would be, YES. Do NOT use RFC Adapter, rather go ahead and use the proxy.
However, the problem could be that the pre-built meta data and the mapping that SAP delivers might not be useful as the BAPI is wrapped with a PROXY now. But as the proxy is also expected to have the same message interface as that of the BAPI, we might still be able use the pre-defined mapping. This is something that we need to try out and then decide how do I go about this interface.

But for whatever reasons, if you are not getting advantage of the pre-defined integration content, PROXY is the way to go.
Now, if you are dealing with SAP systems < 6.20, we do NOT have choice of PROXY anyway, so go ahead and use a RFC adapter.
Now, as far as the IDOC adapter is concerned I think the choice would be straight forward. Where ever there is a standard IDOC given by SAP (usually mapping also will be delivered for SRM / CRM system integrations), so go ahead and use the same.
The questions that you might be having now is that for a standard object if I have an IDOC as well as a BAPI, which one do I go for. My opinion would be its going to be dependent on the specific scenario that you are trying to develop. We can think of multiple variations of design for this case.
For Exapme

1. Send one IDOC at a time.

2. Club multiple IDOCS and send as a single IDOC.

3. Make one single RFC call, for each business transaction.

4. Avoid making multiple calls to the same BAPI / RFC, rather have a wrapper BAPI and send all the records in one time.

5. Use the PROXY and send all the data in one shot and make single calls to the BAPI from the PROXY on the application system – only if you can use PROXIES.

The biggest advantage of the proxy is that it always by passes the Adapter Engine and will directly interact with the application system and Integration engine – so it will and should give us a better performance.

So, there are the choices that you have while designing a SAP interface, so take a close look at the interface and identify your priorities for the interfaces. The parameteres could be some thing like PERFORMANCE, ERROR LOG, AUDIT LOG, MONITORING OF THE TRANSACTIONS INDIVIDUALLY. Do a comparison of the pros and cons of the choice of adapters that you have for the parameters for the specific interface and then make a call.

Initially, it might look alike – what’s the big deal, its a simple case of sending / receiving data from SAP – especially if you are coming from R/3 world, but bellive me, you have got good chances of landing up in trouble, if you don’t take care of your priorities of the interface.

 

 

 

Ravikumar Allampallam
Business Card
Company: Wipro Technologies
Posted on Aug. 14, 2005 05:25 AM in SAP Process Integration (PI)

 





[SAP XI] – SSL Certificate installation procedure for SAP J2EE engine 6.30 – steps in visual administrator

8 03 2011

Author: Aniket Tare

Pre-requisite (refer installation guide for detailed procedure of pre-requisites):
1. You have installed the SAP cryptographic libraries as mentioned in the installation guide.
2. The Keystore and SSL services are enabled. 

Following are the steps for installing the SSL certificates in the portal
Start the Visual Administrator. Navigate to the directory given below.
<Installation Drive>\usr\sap\<Instance Name>\JC<Instance Nr>\j2ee\admin\go.bat
1. Login to the Visual Administrator using the Administrator user id and password.
2. Navigate to the ‘Keystorage’ service as shown in the screen below.

image
3. In the ‘Views’ pane select service_ssl and click the ‘Create’ button to generate a certificate signing request (CSR). Screen as shown below will pop-up. Maintain the entries in the screen below.
image
4. Give an entry name. Select the store certificate checkbox.
5. Click on ‘Generate’ button.
6. Two entries will be created in ‘Entries’ pane as shown in the screen below.

image
7. Place the cursor on the private key pair entry in ‘Entries’ pane and click on ‘Generate CSR request’ and save the file with a ‘.csr’ extension. (Note – you will have to type the extension yourself, the visual administrator will not add it to the file). You have created a certificate signing request. The Certification Authority (CA) will be issuing a signed certificate against this .csr file.
8. Now send the .csr file created to the certificate signing authority. The CA will then send you the signed certificate.
9. After receiving the signed certificate change the extension of the file (if not already changed) to ‘.crt’ (different CAs send files with different extensions, please change the extension to .crt).
10. Place the cursor on the private key pair entry and click the Load button and load the signed certificate into the system.

This ends the process if the certificate sent by the CA also contains the intermediate certificate. If that is not the case the intermediate certificate needs to be installed separately as described in two additional steps (11 and 12) below:

11. Download the intermediate certificate from the web site of signing authority (The CA should be able to provide you with the URL for downloading intermediate certificate) and store it as a ‘.crt’ file.
12. Now place the cursor again on the private key pair entry and click the load button. This loads the intermediate certificate into the system.

This completes the procedure of loading the certificates in the system. The entire certificate chain of root certificate, intermediate certificate and client certificate is now installed successfully.

Now we need to configure the SSL service to use this newly installed cetrtificate:

13. Navigate to <Instance name>->Server->Services->SSL Provider.
14. Choose the entry for dispatcher in pane of left hand side.
15. Choose radio-button ‘New sockets’, select entry.
16. Navigate to tab ‘Server identity’.
17. Select ‘Add’ and choose the newly created entry for SSL certificate.
18. Repeat the procedure for ‘Active sockets’.
19. Restart the portal.

 

 

How to configure FTPS in File Adapter.
Author: Raja Sekhar Reddy T

The main Moto of this blog was which explains FTP Secure configuration.

FTPS (also known as FTP Secure and FTP-SSL) is an extension to the commonly used File Transport Protocol(FTP) that’s adds support for the Transport Layer Security(TLS) and the Secure Sockets Layer(SSL) cryptographic protocols.

FTPS should not be confused with the SSH File Transfer Protocol (SFTP), an incompatible secure File transfer sub system for the Secure Shell (SSH) protocol. It is also different from the Secure FTP, the practice of tunneling FTP through an SSH Connection.

I am not going to compare FTPS with SFTP, and not going to discuss about SFTP, already blogs available on the same. (http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12426).

Before configuring Communication channel, we have to deploy the certificates

1) SAP Java Cryptographic Toolkit has to be deployed in J2EE Engine.

2) Public key Certificate (SSL Certificate) which is provided by FTPS Server has to be deployed in J2EE Engine.

3) The CA certificate used to sign the server certificate must be added to the Trusted As key store view in J2EE Engine. (For PI7.1/7.0 no needs to deploy these toolkit and CA certificate. Because those will be already present in the Server itself).

Take basis people help to deploy required certificates in PI J2EE server.

Refer below link for more info

http://help.sap.com/saphelp_nwpi71/helpdata/EN/e9/a1dd44d2c83c43afb5ec8a4292f3e0/frameset.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/964f67ec-0701-0010-bd88-f995abf4e1fc?QuickLink=events&overridelayout=true

1) Crete communication channel.

 

 

 

 

 

 

 

 

2) Select Connection security

 

 

 

 

 

 

 

 

 

FTPS (FTP Using/TLS) for control connection: The FTP control connection is protected using TLS/SSL (Transport Layer Security/Secure Sockets Layer).File transfer is unencrypted.

FTPS (FTP Using SSL/TLS) for Control and Data Connection:

All communication with the FTP server is encrypted and uses TLS/SSL.

 

 

3) In Command Order Specifies the sequence of commands used to authenticate and secure the connection. Retain the default setting. Only adjust the sequence of commands to match those expected of the FTP server if you encounter problems with the FTP connection.

 

 

 

 

AUTH TLS: Defines the authentication mechanism used for the current FTP session.

USER: Sends a User Logon ID to the Server

PASS: Sends a Password to the Server

PBSZ: Defines the largest buffer protection buffer size to be used for application-level encoded data sent or received on the data connection.

PROT : Defines the protection used for FTP data connections.

4) Use X.509 Certificate for Client Authentication, Set this indicator if the adapter, in contrast to the FTP server, is to use X.509 certificate and public-key cryptography to authenticate itself. The corresponding key/certificate pair must previously be saved in a keystore view of the J2EE server.

Give The Details in KeyStore and x.509 Certificate by selecting the help. If we already deployed the Certificates in J2EE Engine, help will be provided and we have to select from that as shown below.

Enter the Keystore and the X.509 Certificate and Private Key. To do this, you can use the input help.

Keystore contains certificates that are used for authentication and encryption.

 

 

 

 

 

 

 

 

 

 

5) An X.509 client certificate is a digital “identification card” for use in the Internet, also known as a public-key certificate. So public key Certificate has to be selected.

 

 

 

 

 

 

 

 

 

6) Final configuration looks like below.

 


The FTPS configuration for both sender and receiver communication channels is similar.

 





[JOB Gossip] – TechED 2010 EXECUTIVE SUMMARY

21 02 2011

 

http://www.sap.com/community/ebook/2011_TechED_2010/index.epx





[SAP NETWEAVER] – Install SapNetweaver 7.02

21 02 2011

Refer to this blog:

http://weblogs.sdn.sap.com/cs/blank/view/wlg/23125?page=last&x-showcontent=off&x-order=date&x-maxdepth=0

This is my personal Installation on OracleVM Server:

Netweaver ABAP 7.02 - Start Instance

Netweaver ABAP 7.02 - Start Instance

Netweaver ABAP 7.02 Started DDIC User

Netweaver ABAP 7.02 Started DDIC User

Netweaver ABAP 7.02 Object Navigator

Netweaver ABAP 7.02 Object Navigator





[JOB “GOSSIP”] – Diventare Freelance

18 02 2011

SIATE COMPETITIVI
Se vi presenterete in ogni studio della vosta città con il vostro catalogo/Portfolio otterrete di cert oun Lavoro. Tutti quelli che avevano un impiego fisso nel campo dell’animazione lo hanno perso. E sono in una situazione peggiore di quella dei freelance, perchè non hanno una clientela già consolidata. Se avete una Mentalità aperta e offrite materiale per cellulari, internet, TV e via dicendo, farete centro.
Tom Baker

NON ABBIATE FRETTA
Non buttarti alla ricerca disperata di lavoro: prenditi 4 settimane per lavorare con il portatile e il tuo Portfolio lavori. Creati una lista di persone con cui vuoi lavorare e contattale. Se non riesci a contattarle tutte avrai già un punto di partenza. Con il tempo dovrai occuparti meno dei progetti autopromozionali poichè i contatti arriveranno da soli.
Oz Dean

NON FORZARE LA MANO
Non buttatevi testa e piedi nell’attività di freelance: prima lavorate un paio d’anni nel settore e createvi una serie di contatti. Presentatevi algli studi che preferite e frequentate le conferenze dedicate alla progettazione. Non siate invadenti, limitatevi a presentarvi e a dialogare con gli altri.
James Wignall

CONTATTI ESSENZIALI
Datevi da fare su Twitter! Per un freelance i contatti sono essenziali, non solo quelli relativi ai potenziali clienti ma anche quelli con altre persone che lavorano nel settore!! Si proprio cosi! Dovete mantenervi al passo con quello che stanno facendo i vostri concorrenti e come scoprirlo se non condividendo le conoscenze?
Oisin Prendiville

PRONTI AL RISCHIO
Adotta una mentalità specifica. Chi si adatta al proprio posto di lavoro può rimanerci per anni, anche se detesta il suo capo, solo perchè deve pagare l’affittuo o il mutuo. Quando ho deciso di voler migliorare la mia situazione mi sono messo in proprio.
Martin Fewell

SIATE PROFESSIONALI
Imparate ad essere professionai con i vostri contatti da subito. Che sia un amico o un perfetto estraneo non andate fuori dagli standard che vi fruttano di più. Un approccio professionale vi attribuisce un certo prestigio agli occhi dei vostri contatti che vi permetteranno di poter gestire con serenità il prezzo e le forme di pagamento. Utilizzate dei mini contratti anzichè dei classici preventivi.
Tom Lane

ELENCO DEI PARTNER
I contatti sono tutto! Nessuno conosce ciò che fate. Una deciso quel che si vuole offrire inviate il vostro portfolio ai siti professionali e richiedete una partnership. Cosi facendo avrete a disposizione più soluzioni. Inizialmente non titti risponderanno ma è sempre un inizio.
Matt Booth

GESTISCI IL TUO TEMPO
Lascia il tuo posto fisso finchè non riesci a guadagnare abbastanza per sopravvivere. Fai questo calcolo per almeno un anno. Se lavori solamente da freelance devi trovare il modo di ringiovanire l’attenzione nei tuoi confronti da parte dei clienti. Chiudere delle collaborazioni è un modo per garantirsi sempre delle entrate.
Non dedicare troppo tempo a quei lavori che portano pochi introiti.
Justin Maller

I BUDGET PRIMA DI TUTTO
Prima di buttarti nella carriera da freelance assicurati un budget abbastanza alto da garantirti un effetto
“cuscino” ne i periodi di magra! Lo start-up è il passo più dispendioso. L’acquisto di un buon computer e delle attrezzature necessarie ti costeranno un sacco di soldi.
San NG

PROMOZIONE ONLINE
Quando ritagliate uno spazio di tempo libero cercate nei forum, nei blog una particolare esigenza annessa al vostro lavoro e alle vostre capacità che vi permetteranno di acquisire una visibilità notevolissima.
Una risorsa particolarmente utile vi garantirà anche molte proposte interessanti oltre che una visibilità massima dovuta ai backlink alla risolrsa gratuita rilasciata.
Matt Gron