SAP PI 7.11 Interview Question and Answers and Answers 1. What is the Mapping Trace? Answer: This object enables to transfer message to the mapping trace if the trace level set correspondingly then the trace is visible to me ssage monitoring. 2. What is SAP Netweaver? Answer: SAP Net Weaver provides an open integration and application platform and permits the integration of the Enterprise Services Architecture. Exchange Infrastructure (XI) is an Integral part of SAP Net weaver. Position of XI is in the process integration layer of Net we aver stack. 3. What is a Global Container? Answer: This object enables you to c ache the value that you want to read again when you next call any user-defined function that is in the same message mapping. 4. What is a Container? Answer: This object enables you to c ache the value, which you want to read again when you next call the same user-defined function. 5. What is Multi Cast? Answer: you have an option of sending a message to multiple receivers and waiting for a response from the each of the receivers. This procedure of sending a message to multiple receivers and waiting for a response message is also known as 'multi cast'. 6. What are the Types of Node Functions? Answer: a) Remove Contexts: - remove all higher level contents of the source level message in order to map with the target message field. So you can get the node contexts removal.
b) Split by value: - Insert Context change for an element split by value is some as counter part of remove context. Here instead of delivering the context you can insert a context change in the source value queue. c) Collapse contexts: - Copies first values of the all contexts to one context empty context are replaced by empty string. d) Copy Value: - How many ever times I occur I am copied just once". This is not a node function but I am explaining it as it is used very frequently in real-time. Let us take an instance of mater ial group, which can occur as many times as the item node. But since we are mapping it to the header in the target node I just want to copy the first occurrence of mater ial group and map it to the header node. CopyValue
exactly does that.
e) Create if: - It will create a target node or element based on some condition.
f) Exists: - Function to determine whe ther a particular source field exists in instance to be processed. If it does it gives true or else false.
g) Use one as many.
h) Replace value: - Replace the value I with the value that you desired in the dialogue for function properties.
i) Sort: - Sorts all values of the multiply occurring inbound field with in the existing or set context. 7. What are the three objects used at user defined functions? Answer: a) Container b) Global Container c) Mapping Trace.
SAP PI -Process Integration Features PI 7.1 Features High volume support-Local processing in AAE & Message Packaging XML Validation WS-RM Direct point-point communication Service Interface with Operations Folders & Function Libraries Parameterized mapping Graphical Support -RFC & JDBC Lookups Importing SQL Tables Meta Data Principal Propagation - SAML1.1 Replacing the SAP XML Toolkit with JDK 1.5 tool kit CCBPM-Step Groups & User decision Step Local SWCVs for Testing purposes Copy Entire XML tree • • • • • • • • • • • • • •
PI 7.3 Features Single stack ESB capabilities through AAEX o Up to 60% less energy consumption •
o Lower footprint, easy maintenance o 1h installation*, ½ HW requirements* o comp. to double stack, 90 sec restart* Major Improvements for o Reduced cost of operations via increased fault tolerance o Design governance o Publish & Subscribe scenarios NWDS-based editors for creating and editing service interface and data type Support to use Eclipse based editors for viewing ES Repository content Web-based UI to enable quick access to ESR objects User defined payload search in message monitoring Directory Increased productivity and richer connectivity on AAE IDoc-and HTTP-adapters in AAE HTTP adapter with support of GET method Multi-mapping message split on AAE Large (binary) file-to-file transfer Configurable JDBC message size limits Time-out config. per comm. channel Java proxy generation in NWDS Automated Transport for Schema Validation Increased Integration Directory API support Publish and subscribe messaging for JMS Topics WS-RM based interoperability with Microsoft .NET 3.5, 4 Centralized monitoring via SAP Solution Manager 7.1 o Good morning page o Monitor multiple PI domains o Reduced time for root cause analysis Queues balancing Improved fault tolerance o Blacklisting o Optimization of cache refresh o Optimized message processing o “Safe Mode” during startup o Optimization of EOIO handling o Optimized technical acknowledgements Limitations of AAEX No support of ABAP mapping and CCBPM • •
• • • • • • • • • • • • • • • • •
• •
•
SAP PI 7.3 Latest ver - Interview Questions & Answers 1) What are the different ways of communication you can have with SAP System and Give the merits and demerits of each? You can use IDOC adapter, RFC adapter and Proxy communication. Depends on the situation you can decide which way you need to c onnect SAP ECC from PI. If WAS version is >= 6.20 then you c an go with
Proxy communication with ECC. With PI 7.3 you can use proxy with Integration engine or Advanced Adapter Engine through SOAP Adapter over XI 3.0 protocol. 2) Did you work on RFC adapter? If your answer yes then the interviewer ask you What is Program ID? Program id is one of the parameter in RFC sender Communication Channel. It should be same in RFC Destination ( Tcode -SM59 ) and XI RFC sender adapter. Once the XI components activated, sender RFC adapter will registers itself with program id specified, on SAP gateway. You can test this by using 'Test Connection' in SM59 for your RFC destination. If it is registered the t est connection will go fine otherwise it will give an error .
3) What is the difference between RFC adapter and IDOC adapter? Both RFC and IDOC adapter you can use for connecting SAP ECC from PI. But IDOC adapter you can use only for Asynchronous communication while RFC adapter you can use for Synchronous also. try to answer yourself. 1. What are the main difference of SAP PI release PI 7.11 and 7.3 ? 2. What is ICO? 3. What are Setting required in both ECC and PI system for make use Proxy communication over Advanced Adapter engine? 3. Can we use IDOC and HTTP adapter without Integration engine in PI 7 .3?
SAP XI Alerts - A step by step Solution
Whenever business critical error occurs, the responsible parties should be determined and informed immediately. SAP Alert Management play an important role in these scenarios. In this blog I am trying to explain the steps that are involved in the alert management. Also I am trying to explain some frequently asked questions on alert management. Step 1: Enter the Transaction Code 'ALRTCATDEF', go to change mode and enter your alert category. ( The definition of Alert Category - Alert Category contains various properties and other specifications that define the alerts within that category. The category defines the conditions when a specific alert is sent to whom.) Step 2: Create container element which we will later use to compose the text of our alert message. Step 3: In this step we use the above variables from the container to create an alert message Example Text: The error: &SXMS_ERROR_CODE& which occured in a message &SXMS_MSG_GUID& from the interface &SXMS_FROM_SERVICE&. Step 4: The next step is to add the recipients for the message. Step 5: Go to Runtime workbench then choose alert configuration and then create the Alert Rule. Step 6: Test the Alert by giving wrong entry in the scenario. Then check in the Alert inbox for the error message. You can use the Tcode ALRTINBOX or got RWB and then Alert inbox.
SAP XI Interview Questions and Answers - Mapping Part 1 1. What is MultiMapping, what interface do we use for it? Is Multi-Mapping with out BPM possible XI? Multi-Mapping is mapping any number of source messages to any number of target m essages. Since SP 14 Multi-mapping is possible with out BPM. Before that u nee d BPM. Inside the Integration Engine (IE), the messages are grouped together and persisted as one bulk message. The bulk message is sent to the AE where it splits the bulk message into individual messages and persists them. Messages that result from the split in a mapping-based message split are sent using one AE. So only the adapters running on the AE are supported. In particular, this means that target IDOC me ssage splits are not supported since the IDOC adapter is not part of the AE. 2. What is Value Mapping? How we can use it, where does the table get stored? If you want to implement a scenario where a value being sent depe nds upon various constraints and needs to be looked up in a table and sent across accordingly, you use value mapping. You use the value mapping function to map different representations of an object to each other. You save the mapping rules for different objects in a value mapping table. In the FixValues function (Conversions -> FixValues), key-value pairs are maintained within the Integration Repository. In the Value Mapping function (Conversions -> Value mapping), you can maintain multiple key value pairs externally e.g. you could maintain them in the Integration Directory. These are picked up at the runtime. SAP PI Interview Questions - Process Integration General 1. What is XI content and predefined XI Content? The contents of the Integration Repository are collectively known as XI Content (Process Integration Content); XI content is the integration knowledge that is required for describing collaborative processes (collaboration knowledge).XI Content is created at design time and can be shipped. In addition to the technical infrastructure, SAP also ships predefined XI Content to enable customers to integrate their processes as efficiently and cost-effectively as possible. 2. What are the process Components available for SAP PI ? Process Components in ESM AUTO-ID 7.0 Process Components in ESM CRM 7.0 Process Components in ESM ERP 604 Process Components in ESM EWM 7.0 Process Components in ESM FS 300 Process Components in ESM SCEMSRV 7.0 Process Components in ESM SCM 7.0 Process Components in ESM SCMTM 7.0 Process Components in ESM SCM_BASIS 7.0 Process Components in ESM SNC 7.0 Process Components in ESM SRM 700
What is SAP PI Enterprise Service Repository? What is Life Cycle Management in SAP PI ESR? 1.What is Enterprise Service Repository? Enterprise Service Repository is the Central Repository where Service Interfaces and Enterprise Services are Modeled and their Meta data is Stored. 2. What is Services Registry? Services Registry is UDDI v3 compliant registry that supports Publishing, Classifying and Discovering
Services. 3. What is Life Cycle Management and what are the Steps? Re-use Existing assets, Model definition, Implementation, Publishing and Consumption are the Steps in Life Cycle Management. 4. What are the Key Benefits of Enterprise Service Repository? 1. Enables the governed definition of SOA assets with contract first development process and end to e nd modeling support. 2. Provides transparency into the business semantics exposed via enterprise services, for designers and developers. 3. Provides out-of-the-box SOA business content built on SAP modeling principles and support for asset reuse to jumpstart your SOA implementation. 4. Provides a single source of truth t hough openness & interoperability within a heterogeneous landscape. 5. Enables higher developer productivity through model-driven architecture using an integrated toolset for defining, provisioning, and consumption of e nterprise services. 6. Supports a comprehensive software lifecycle management across the entire enterprise service lifecycle to reduce TCO 7. Enables discovery of SOA assets to build, modify, and run innovative and flexible composite applications & Business processes.
Advantages of SAP PI SOAP adapter over SAP .Net Connector - SAP PI FAQs SOAP is text based, it is able to move more easily across the firewalls than IIOP, ORPC or JRMP. SOAP is based on XML, which is standard driven rather than vendor driven. Potential adaptors are less likely to fear vendor lock in with SOAP. Finally we can say that SOAP can be picked up by different transport protocol and delivered in different ways. For ex ample, when used with HTTP it can be delivered t o a web server, when used over FTP it can be deposited directly into a file system and when used with SMTP it can be delivered to a user's mailbox. Advantages of SAP PI HTTP adapter over SOAP adapter? HTTP adapter directly runs on Integration Engine. Whereas the SOAP adapter runs on the Adapter Engine. So it will take more time when compared to HTTP. Also HTTP is good in performance to SOAP. Unless the business requirements needed we can go with HTTP when compared with SOAP.In case of SAP PI SOAP adapter, only message can be sent and in case of http adapter, some authentication can be sent along with the message. 1. Advantages or Comparison between SAP XI PI SOAP adapters over XI PI HTTP adapter? SAP PI XI Interview Question When you need to Send Data to XI from a Web service, your SOAP adapter is used. HTTP adapter is used when you want to post a HTTP request message from a web application to XI. Some remote clients or web services providers are only able to communicate by means of SOAP messages. SOAP adapter uses a helper class to instantiate and control these SOAP Components. The SOAP adapter receives a message from the remote client or web services provider, converts the SOAP protocol in to the XI message protocol (SOAP with Header e nhancements) and then sends the message to the integration server to be processed further. To forward messages to a receiver remote client or web services provider, the SOAP adapter receives
the message from the integration server, converts it to the SOAP message, and then sends it to the remote client or web services provider. What is SAP Data Archiving? - SAP Data Archiving Interview Questions & Answers 1. What is SAP Data Archiving? Data archiving refers to the removal of application data from the SAP system and storing of the data in an archive file (at least one file). Ar chiving is done using specific archiving programs, which are based on archiving objects. The archiving objects in turn ar e based on business objects. Data archiving in one sentence: Data ar chiving helps you control your data growth and your system performance.
Difference between SAP PI 7.0 and PI 7.1? - What is new in SAP Process Integration 7.1 ? SAP PI 7.1 has a lots of new features. Here I am discussing the major differences between SAP PI 7.1 and PI 7.0. You can add more points if I missed out something as Comments. 1. Universal Description, Discovery, and Integration ( UDDI) 3.0–compliant services registry for runtime management of enterprise services.UDDI server is shipped with SAP Web AS, that is implemented to UDDI v2 specifications. SAP WebAS provides the capability to publish and query webservices in UDDIRegistry 2. Enterprise Services Repository as a central storage location for enterprise service definitions and lifecycle management data for all enterprise services (Concept of Folders : Folders can be created under a namespace. As you will notice, mulitple folders can be created under the same namespace. And, folders can be created within folders.)
<script
3. Enterprise Service Oriented Architecture (ESOA), Global Data Types, Modeling Tool Concept. 4. Improved support for standards such as Web Service Reliable Messaging (WS-RM), WS Policy, Security Assertion Markup Language (SAML). 5. Support Business Activity Monitoring ( BAM). 6. Advanced Adapter Engine Features (Eg. Bypass Integration Engine Process) 7. Enhancement for Mapping (Eg. Re-usable User Defined Functions, Look-up function reads multiple fields, Specify mapping parameters at configuration time, Synchronous DB RFC lookups, Message Packing etc.) 8. Extended support for high volume scenarios
9. Business Activity Monitoring for process definition of milestone monitoring (event correlation). 10. Improved SAP NetWeaver Administrator support for central configuration and administration of both mediated and point-to-point scenarios. 11. XML payload validation and v alidations using JAVA. 12. Process editor modeling enhancements: step groups, integrated alert management and configurable parameters. 13. Integration of human interaction (generic user decision). 14. Language dependent texts for end-user display. 15. WS-BPEL 2.0 adoption (Preview and implementation BPEL4People, BPLE-SPE Simple User Defined Functions can be configured directly in the process.)
SAP PI 7.1 Mapping Enhancements - Graphical Variable - Share User Defined Functions - Part 1 Graphical Variable in PI 7.1 Graphical Variable is new enhancement in SAP P rocess Integration 7.1 Mapping. SAP PI 7.1 Mapping Graphical variable will replace a lot of previously development effort for global variables. How to define a Graphical variable in PI 7.1 Mapping? It is very easy to define a Graphical Variable in SAP PI 7.1 mapping. Right click on t he root node of the target message in the message mapping then select "Add Variable". Give a name for this variable. Then Assign the values to the variable. Then map the Graphical variable to an element in target message. Share User Defined Functions in Message Mapping PI 7.1 In the new enhancement in PI 7.1 allows you to share the user defined function. But the only restriction is that the library containing the UDFs has to be in the same Software Component Version (SWCV) as the message mapping. Therefore, if we wish to share the library in more than 1 SWCV, then we will need to create dependencies in the System Landscape Directory (SLD). How to create User defined Function and Share it? Right click on the Namespace and se lect New -> Then select Function Library -> Enter Name and then click create. In the following screen: Click on the "+" in "Functions and Java Area". Enter the function name, ". Enter "" as the Title. Enter the java code. Save and Activate Now you need reference the Function Library in Message Mapping Click on the new icon "Show U sed Function Libraries" In the following screen Click on the "+" in "Used Function Libraries". Click on the "down arrow" to select the function library from the value list. Then press Apply
Now, we can use the UDF, "", just as though we had developed it in the message mapping locally.
Basic Rules of XML 1. All XML Elements must have an opening and closing tag. 2. Attribute value must be in quotes 3. XML tags are case sensitive 4. XML elements must be properly neste d 5. XML documents must have a root element 6. Special characters in XML document Some characters have special meaning in XML and need to be replaced with an entity reference. For instance a & character inside an XML element will generate an error. Here are the entity references we can use inplace of these characters. 7. Comments similar to Html 8. White spaces preserved in XML XML Tutorial - XML Interview Questions - XML Technologies XML stands for Extensible Markup Language.XML is Markup Language but does not replace HTML because XML tags are not pre-defined and XML was designed to structure, describe and carry data not to display data. What is the difference between XML and HTML? HTML tags are mostly formatting-oriented and don't often provide information of a web page. But XML was designed to transport and store data. What are XML technolgies? Schema, XPATH, XQUERY, and XSLT are XML technologies. Schema describes the structure o f XML document and defined the building blocks. Extensible Path Language (XPATH) used to ext ract data from XML file. XQuery used to query functions on XML data, similar to SQL for database. Extensible Style Sheet Language(XSLT) is a styling language that c an transform an XML file in to another file type including HTML, PDF, MS word Etc. What are attributes? Attribute specify additional information about an element and appear with in the o pening Tag. Attribute values must always be enclosed in either single or double quotes. XML Document - Anatomy Prolog - The prolog must be on the first line and usually includes an XML declaration which defines the XML version(1.0) and the encoding (UTF-8). Root Element - The outermost element is referred to as Root element. Child element - The child element is an element nested with in a root e lement. SAP PI 7.1 Mapping Enhancements - Graphical Variable - Share User Defined Functions - Part 1 Graphical Variable in PI 7.1 Graphical Variable is new enhancement in SAP P rocess Integration 7.1 Mapping. SAP PI 7.1 Mapping Graphical variable will replace a lot of previously development effort for global variables. How to define a Graphical variable in PI 7.1 Mapping? It is very easy to define a Graphical Variable in SAP PI 7.1 mapping. Right click on the root node of the target message in the message mapping then select "Add Variable". Give a name for this variable. Then Assign the values to the variable. Then map the Graphical variable to an element in target message.
Share User Defined Functions in Message Mapping PI 7.1 In the new enhancement in PI 7.1 allows you to share the user defined function. But the only restriction is that the library containing the UDFs has to be in the same Software Component Version (SWCV) as the message mapping. Therefore, if we wish to share the library in more than 1 SWCV, then we will need to create dependencies in the System Landscape Directory (SLD). How to create User defined Function and Share it? Right click on the Namespace and se lect New -> Then select Function Library -> Enter Name and then click create. In the following screen: Click on the "+" in "Functions and Java Area". Enter the function name, ". Enter "" as the Title. Enter the java code. Save and Activate Now you need reference the Function Library in Message Mapping Click on the new icon "Show Used Function Libraries" In the following screen Click on the "+" in "Used Function Libraries". Click on the "down arrow" to select the function library from the value list. Then press Apply Now, we can use the UDF, "", just as though we had developed it in the message mapping locally.
SAP XI PI 1. BPM Process Steps 2. Check Channel Available 3. SAP XI Ariba Integration 4. iWay Adapters for SAP XI 5. Seeburger Adapters for SAP PI Seeburger Adapters for SAP PI SAP XI PI Technical EDI Adapters by SEEBURGER �� AS2 (EDIINT/HTTP(S)) Protocol: AS2 �� OFTP Protocol: OFTP/ISDN, OFTP/TCPIP �� VAN Access Protocol: P7 / X.400, VAN FTP Business EDI Adapters by SEEBURGER �� Generic EDI Protocol: OFTP/ISDN or P7 / X.400, VAN FTP EDI Converter: ANSI X.12, EDIFACT Mapping Templates: Purchase order, Order confirmation, Dispatch advice, Invoice
�� Payment (Financial Service Providers)
Protocol: OFTP/ISDN, P7 / X.400, VAN FTP EDI Converter: EDIFACT, SWIFT Mapping Templates: Payment orders, Debit advice, Credit advice, Account Statement
Industry Specific EDI Adapters by SEEBURGER �� Aerospace & Defense �� Automotive �� Chemicals �� Consumer Products �� High-Tech �� Paper �� Pharmaceutical �� Retail Business Content �� Mapping Templates within Enterprise Services Repository �� Message Library for Enterprise Services Repository �� Huge message catalog with EDI XML schemas Communication Protocols �� OFTP/ISDN, P7 / X.400, VAN FTP EDI Converter (EDI XML) �� AECMA/SPEC 2000, ANSI X.12, CHEM eStandards, EDIFACT, GALIA, ODETTE, TRADACOM, VDA
iWay Adapters for SAP PI - Ariba, Baan, JDE, Clarify.. SAP XI PI SAP NW PI 7.1 Connectivity – Developed by iWay, Adapters not yet ce rtified for SAP NW PI 7.1 Application Adapters �� Ariba �� Baan �� Broadvision �� Clarify �� JDE One World XE (*) �� JDE World (*) �� i2 �� Lawson �� Microsoft CRM �� Manugistics �� Oracle Applications (*) �� Peoplesoft (*) �� QAD MFG Pro �� Siebel (*) �� Vantive Industry Standard Adapters �� Swift �� Transora �� UCCnet Technical Adapters�� AS1 (EDIINT/SMTP) �� AS2 (EDIINT/HTTP(S)) �� BEA WLI �� COM+/DCOM �� Corba �� Lotus Notes �� Tibco Rendezvous Mainframe/transaction Adapters �� CICS (*) �� TMS/IMS (*) �� Telnet (3270) �� Telnet (5250) �� Tuxedo
(*) Soon to be certified for SAP NetWeaver Process Integration 7.1
Ariba SAP PI (XI) Integration In this modern distributed business environment Integrating application to application and business to business is common scenario. Let us look What is Ariba and What are the services. Ariba (NASDAQ: ARBA) is a software and information technology services company located in S unnyvale, California. Ariba, Inc. (Ariba), incorporated in September 199 6, is a provider of on-demand spend management solutions. The Company provides spend management solutions, which allows enterprises to take a stepby-step approach with products and services that work toge ther. Its solutions combine on-demand software and services to help companies automate t he procurement process. Ariba operates in three geographic segments: North America; Europe, Middle East and Africa (EMEA), and Asia-Pacific (APAC). Ariba Spend Management Solutions The Company’s Ariba Spend Analysis Solutions provides enterprises with a set of products and services that allows enterprises to identify and prioritize savings opportunities and enable decision-making. Ariba Sourcing Solutions allows enterprises to identify top suppliers across a range of categories to negotiate procurement terms, leverage and aggregate spend, implement practices and manage procurement contracts. Ariba Contract Management Solutions enables enterprises to streamline and automate the contract process from contract creation to compliance management. Ariba Procurement and Expense Solutions delivers applications and services for requisitioning and procurement across all types of spend. Ariba Invoice and Payment Solutions enable enterprises to streamline and automate paper-intensive invoicing and payment processes. Ariba Supplier Management Solutions provides enterprises with a set of products and services to optimize buyer-supplier interactions throughout the spend management lifecycle. Ariba Spend Analysis Solution modules include Ariba Spend Visibility, Ariba Analysis and Ariba Data Enrichment. Ariba Spend Visibility module presents spend data for analysis. The offering includes project management services, data enrichment services and Web-based access to dashboards and pre-packaged reports that help identify sourcing and compliance opportunities. Ariba Analysis module delivers a view of spending activities across all suppliers, divisions and purchased goods or services. Dashboards help purchasing and sourcing professionals identify and realize significant spend reductions. Ariba Data Enrichment module facilitates spend analysis by normalizing and classifying real spend data from an enterprise’s various data systems. Ariba Sourcing Solution modules include Ariba Sourcing On-Demand, Ariba Sourcing, Ariba Supplier Performance Management and Ariba C ategory Playbooks. Ariba Category Playbooks module enables sourcing and procurement professionals to drive their activities programmatically by project management, knowledge management and resource management. The Company’s modules include Ariba Contract Management, Ariba Contract Workbench and Ariba Contract Compliance. The Ariba Procurement and Expe nse Solution offerings allow customers to manage the procurement process from requisition, through ordering, receiving, invoice reconciliation and payment. Its modules include the integrated Ar iba Procure-to-Pay module, Ariba Buyer, Ariba Category Procurement, Ariba Travel and Expense, and Ariba Procurement Content. Ariba Procure-to-Pay
is its Web-based procurement and expense module. The Ariba Invoice and Payment Solution offerings allow customers to automate the invoice management proc ess. Its modules include the integrated Ariba Invoice and Payment module and Ariba Invoice and Settleme nt.
Ariba Supplier Network Ariba Spend Management solutions also integrate with and leverage t he Ariba Supplier Network. The Ariba Supplier Network is a scalable Internet infrastructure that connects buying organizations with their suppliers to exchange product and service information, as well as a range of business documents, such as purchase orders and invoices. Approximately 200,000 registered suppliers of an array of goods and services are connected to the Ariba Supplier Network. The Ariba Supplier Network is a multi-protocol network that allows buyers to send orders from Ariba Buyer or other eProcurement systems in one standard format that are then converted into the supplier’s preferred tr ansaction format. Ariba Spend Management Expertise Ariba Spend Management Expertise includes Ariba Strategic Consulting, Ariba Sourcing Se rvices, Ariba Implementation Services, Ariba Customer Support Service s and Ariba Supplier Enablement Services. Ariba Strategic Consulting enables decision making, organization assessment and process design. Ariba Implementation Services executes installation and set-up of software. Ariba Customer Support Services supports customers’ direct usage of software (training and product support). The Company competes with SAP AG, Oracle, Emptoris, BravoSolution, Zycus, American Express S2S, Perfect Commerce, cc-Hubwoo, Ketera Technologies, Iasta, A.T. Kearney and McKinsey & Company. SAP Integration You can easily integrate Ariba by using SAP Process Integration.
How to Remove Leading zeroes in SAP PI Mapping in SAP PI 7.1 Mappin is very important task in any middleware. The mapping between and Source and target message is the real task in any interface programming. Let us take a situation or requirement where we need to remove all the leading zeroes. Suppose the the Product ID field containing an integer. But the source system send this integer w ith leading zeroes. eg. 000000000123456789
Importance of SAP PI over Other Commercial EAI tools: Reduced maintenance costs: As the client replaced multiple integration technologies with SAP XI, it gained immediate cost savings by reducing associated maintenance costs. Additionally, the client gained the capability to utilize its manpower more e ffectively. Enhanced message monitoring functionality: As SAP XI provides auto handling of persistence of messages, it has enabled the client t o monitor and restart failed messages. This has also eliminated the possibility of redundant/duplicate data into the system along with related efforts to identify the same. As all messaging is routed through one system, the client needs to monitor only SAP X I instead of having to monitor other systems Enhanced flexibility: The ability to modify applications and add new functionalities without impacting other systems and businesses gave the c lient tremendous flexibility in reacting to dynamic changes in the market.
Standardizes on the technology integration layer that wo uld be used for connectivity between all systems Eliminate the need for “point-to-point” connectivity between systems Achieve a central monitoring of message flow, instead of having to monitor several systems
SAP PI 7.11 JDBC Adapter Stored Procedure Error JDBC Adapter Error SAP PI 7.11 JDBC Adapter Error in Runtime Work Bench Could not execute statement for table/stored proc. "PROC_MAT" (structure "Mat_Stmt") due to com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure "PROC_MAT".
Solution This error occured at SAP PI 7.11 due to the non-existence of the Stored Procedure at the database level. Verify the SQL server Database and resend the message.
Import SQL Table metadata in SAP PI 7.1 Mapping Enhancements - Graphical Support for JDBC and RFC Lookups In SAP PI 7.1 we can import SQL Meta data. In the earlier version of SAP Netweaver Process Integration you can import IDOC and RFC Metadata from the R/3. The only r equirement is that we have to have a JDBC receiver communication channel. How to import the SQL Meta data from a MS SQL Server? First Create a JDBC Receiver Communication Channel in the Integration Directory. In the Enterprise Service Repository (ESR), create an External Definition in a namespace. Right-click on a namespace and select "New" -> Select "External Definitions" and enter "" for the name. In the create screen, select "dbtab" in the dropdown for "Category" and click on the wizard to import the external definition, In the wizard, select the Communication Component and the Communication Channel, and click "Continue", Enter "", or use the "Display" button to see all the available tables and select a table. Click "Finish". You have imported the metadata from MS SQL Server. Graphical Support for JDBC and RFC Lookups Another new feature of SAP PI 7.1 Mapping is the Graphical Support for JDBC and RFC Lookups. In the previous versions like XI 3.0 and PI 7 .0 you have to create User Defined Function with relevant lookup code. It was more time consuming and complicated. The pre-requisite of this is The JDBC c hannel to be used for the lookup must be configured and ac tivated in the Integration Directory and the definition of the table used for the lookup must already be imported into the ES Repository as an external definition. How can you configure the Graphical JDBC lookups in the Message mapping? Here I am discussing how you can do the JDBC lookups with Graphical JDBC lookup. The first ste p is to create a message mapping parameter within the Signature tab. The parameter should be an 'Import' parameter and have Category 'Adapter' and Type 'JDBC'. Then select the Category "Conversion" from Standard Function at the below of mapping editor. Select the JDBC Lookup and Insert in to the Data
Flow Editor. After the JDBC Lookup function is inserted into the data-flow editor of the mapping, bring up the properties for the function by selecting 'Properties' from the context menu or simply doubleclicking on the function. Now you have to define the select statement for JDBC Look up. Within the property Select the parameter to be used for the lookup, then Select the relevant external definition that corresponds to the table definition, Move all fields to the left that should be used for reading a row in the database table and finally Move all fields to the right that should return a result from t he SELECT statement. Now you can use this JDBC look up in Mapping. How can you do the Graphical RFC lookups in the Message mapping? You can do Graphical RFC lookups similar to Gr aphical JDBC lookups in PI 7.1. Pre-requisite for Graphical RFC lookups are The RFC channel t o be used for the lookup must be configured and activated in the Integration Directory and the definition of the RFC structure used for the lookup must already be imported into the ES Repository as an imported archive. The first step is to create a message mapping parameter within the Signature tab. The parameter should be an 'Import' parameter and have Category 'Adapter' and Type 'RFC'. Then select the Category "Conversion" from Standard Function at the below of mapping editor. Select the RFC Lookup and Insert in to the Data Flow Editor. Now do the settings for RFC lookup within the properties. Select the parameter to be used for the lookup, then Select the r elevant RFC function module that will be used for the lookup. The left column represents the RFC Request message and the right column represents the RFC Response message. Now the RFC lookup setup is complete and you can use in Mapping.
CopyXML - Parameterized Message Mappings in SAP PI 7.1 Mapping Enhancements Parameterized Message Mappings in SAP PI 7.1 Mapping Enhancements The new feature of SAP PI 7.1 is the support for using parameters in mapping programs. Parameterized Message Mappings is the ability to pass parameters to/from mapping programs gives them m ore flexibility and applicability by allowing for the transfer of values at configuration time . Prese ntly this Parameterized Message Mappings supports Message Mappings, Java Mappings, and XSLT Mappings. Parameters can be Import or Export. Import parameters are parameters which transfer values to mapping. Standard functions only allow for import parameters and Values can be passed from both interface determinations and transformation steps. Export parameters are parameters which transfer values from mapping. Parameter Category would be Simple Type and Adapter. "Simple Type" category parameters are used to transfer simple typed constants that can be used as import or export parameters. "Adapter" category parameters are used to transfer the channel name that is to be used for mapping lookups. An adapter type (e.g. JDBC, RFC) must in addition be selected. Parameters are defined in the Signature tab. CopyXL Another new feature of SAP PI 7.1 Mapping is copyXML. The use of copyXML is w e do not need to define the target elements and only one elemet-to-element mapping is required, no matther how many elements are in the subtree. To create the copyXML right click on the source Node and select "Return as XML". So, when there is any mapping done to any of the sub-element of the target node, that mapping will take priority and void the CopyXML done to that target Correct Structural Inconsistencies Correct Structural Inconsistencies is a new enhancement to the mapping tool in P I 7.1 allows for adjustments to the mapping in an interactive w ay to relieve some of the pain when structural changes are introduced to the mapping.
New Functionality of SAP PI Enhancement 1 (EPH 1) In Normal SAP Practice you can Package IDOC in Partner Profile (WE20). But this won't help the IDOC Interface in PI. SAP XI/PI internally splits them and creates one XI message from one IDOC even though they have come from in one RFC. If you use the Sender IDOC Adapter Packaging (Enhancement Package 1 (EhP1) New feature) SAP PI/XI does not split them anymore.
SAP PI 7.3 Adapters ( Advanced Adapter Engine Extended) SAP PI 7.3 contain the following adapters RFC Adapter SAP Business Connector Adapter File/FTP Adapter JDBC Adapter JMS Adapter SOAP Adapter Marketplace Adapter Mail Adapter RNIF Adapter CDIX Adapter IDoc Adapter (Advanced Adapter Engine) (adapter type I DOC_AAE) HTTP Adapter (Advanced Adapter Engine) (adapter type HTTP_AAE) • • • • • • • • • • • •
How to See Message Size in SAP PI There are different ways of finding out the message size in SAP PI.
Go to SXMB_MONI-->Inbound Message or Receiver Grouping-->SOAP Header-->Runtime--> here is the sample from where you can see the message size
SAP:MessageSizePayload>437 //this is the size of your payload
1175 143 0 0 0 You can also save the payload in Notepad and see the size. Or else use Performance Monitoring tool in RWB
Createif Sap PI - Example IDOC to File Sceanrio CreateIf is one of the Node functions in SAP PI. It is used when you want to create target node or element based on some condition. To create a tag in the target structure independently of a condition, we use CreateIf. Example
Suppose you want to create target field depending on existence of source field. For example If you are working on IDOC to File scenario and you need to create a target node when the source field exists. Then use combination of function createIf and exists and map it to target field. Check first existence of source field by using exists then use createif and in condition map this to target field.
collapseContexts() in SAP PI collapseContexts() is one of the Node Function in SAP P I Mapping. collapseContexts()copies the first value from all contexts to one context. Empty contexts are replaced with an empty string. It simply removes all the context changes in between any two elements in a queue. It is similar to remove context but it selects only the first value from each context. This can be useful if an upper-level node is to be created each time a lower-level node exists. Java Mapping in SAP PI 7.11 Out of the SAP PI mapping techniques (Graphical, XSLT, Java and ABAP) Java mapping improves the performance and are preferred as they gets executed on J2EE engine directly. JAVA mapping can be done in two ways DOM Parsing and SAX P arsing. Parsing is a technique of reading and identifying XML tags from an XML document. In the Java programming language, you can instantiate the parsers by using the Java API for XML Parsing (JAXP). SAX - Simple API for XML DOM - Document Object Model
What is the difference between SAX and DOM Parsing in SAP PI Java Mapping?
SAX Parses node by node, does not store the XML in memory, we cannot insert or delete a node and Top to bottom traversing. While DOM Stores the entire XML document into memory before processing, Occupies more memory, we can insert or delete nodes and traverse in any direction.
What are the five methods are used when SAX parsing the XML documents?
startDocument endDocument startElement endElement characters
SAP PI 7.3 Installation options In releases prior to SAP NetWeaver 7.3, an SAP NetWeaver PI installation was always based on both AS ABAP and AS Java (dual-stack). As of SAP NetWeaver 7.3, you have the option to choose an AS Java-only installation option, the Advanced Adapter Engine Extended. SAP PI Interview or Certification Questions WHich was latest version which you worked on PI?
What is diff between PI 7.1 and PI 7.3? How do you get an error condition to generate an alert? Could multiple instances of an integration process be running at the same time? If so, how does a message find its way to the correct instance?
Which XI objects can be used in an integration process? What happens after an exception is raised in BPM? Send message within an integration process to 8 receivers at the same time, how can I do this? Describe the triggering of exceptions in BPM? What is a correlation and what is local correlation? Which steps can trigger an alert? What does a control step do? How does integration process kill itself? What are other possibilities? What are the 2 visibilities of container elements? What are the different types that a container element can be based on? Can container elements be based on dictionary structure MARA? What is the relationship between an integration process and business workflow? Parameters of JDBC, IDOC, RFC, FILE, FCC? What is correlation and Context object? Why IDOC do not need sender agreements and communication channel? Briefly explain about Ur scenario in Project? What is an Xpath? What are the mapping u have done? What is a proxy and Alert? What is BPM and where and why it is used? What does a RFC adapter support? Is EOIO supported by RFC? What are advantages and why would you install a dece ntralize adapter engine? Comment on the following, adapter engine is also known as a PCK? What is the different monitoring status? Where do you find them?
What adapters are not in adapter engine? Which ABAP proxy, in or outbound has code yo u can type in? With an optional node what is the car dinality? How do you make sure the subordinate's fields get mapped? What is it WSDL? Where do you find it in DR? Does Is used in Java or ABAP Proxy? In XI 3.0 Stack 9, what are the supported mapping types? What are prerequisites for importing customer defined IDOC? What are the three IDOC transactions in XI? Context object replace what? Two things can make up a collaboration agreement, what are they? What is a logical system, with respect to SLD? What is the sender communications channel? If er ror during inbound or outbound binding, where do you look to solve? What is URI, URL, and URN and what are their difference? To perform content based routing, two places it can be done, what are the two places? What is an integration process? What is a block step and why is it used? Message Mapping, advanced user function, can you test for context changes, if yes how? What is multi-mapping? Where is it used? What are the advantages? What are the two XSLT tags, previously that could not be used in XI Why? Using a simple user defined function how can you send trac e information to be monitored? What is function exists in message mapping? What Jar file is required to pe rform Java Mapping? What is context in message mapping? What is remove context and what is Split by Value?
Source message occurs 3 times, target only once what is wrong? Java mapping class, which class must it implement? What is scope of mapping template? In BPM Async-Sync Bridge, does the QOS change? List 4 ways to enable logging / trace? What is logging / trace? Properties of an Async message? Inbound XI message has problem, where do you look for solution? Describe XI message format? Describe end-end monitoring? In XI 3.0 where do you configure adapters? Different steps to make an IDOC adapter work? What is a mail adapter? JMS adapter can talk with what type of systems? What format can JDBC adapter communicate in? If communications with JDBC using XML format, what are 4 actions you could do? Installing PCK what platforms can you install it on? How does PC K and adapter framework engine differ? Can JDBC adapter query DB tables? JMS adapter scenario messaging system provider needs to submit what? What are the properties of receiving IDOC adapter? JDBC/JMS require certain steps before they can work? Properties of the PCK who developed it? What is it similar too? Does it support B2B? What is ALE audit with respect to IDOCS? How does a Boolean function work in message mappings? Where can you use a user-defined function, scope? In simple mapping - one source re sults in 4 identical target messages, with regarding c ardinality what is the problem?
What is a prerequisite to do ABAP mapping for a complex transformation? What step can be inserted into an exception branch? Where can you find business process engine? What actions can you perform in SX ICACHE? What is a wait step and why is it used? Can we do scenario without BPM how we can do it? What is synchronous and Asynchronous Communication? What is User defined functions and how to c reate it? What are predefined functions? How the BPM starts explain step wise? What is multiple mapping? Transaction code (very important)? Tell me how to handle the error in BPM (transaction to monitor the e rrors). If I have a sender and multiple receivers how do i send single se nder to multiple receivers and also adv and disadv of BPM Can i import any number of idocs from R/3 and is there any way to get the idocs with importing from R/3 If I have 100 files in a folder, if XI come s and picking the files from the folder, while picking 50 files connection was lost in between and they are remaining 50 files are there to pick, in this scenario what happens after connection established XI will collect remaining 50 files or again it starts from first. What is Persistence? What is SLD explain and difference between Technical system and business system and how do u assign it to IR and ID? Explain me about FCC? What is business system and business service? What is query and Queues? Difference between an RFC and BAPI? What are different design times components used by XI? What services does the integr ation server provide?
What are the 4 functions does adapter framework provide? What is Java webstart and why is it used? What are the different XI components? What is XI domain? What is XI pipeline and what is a pipeline service? Describe the alert functionality of the runtime workbench? Name different monitoring functions of the runtime workbench? Web application server 6.2 has an integration e ngine. Why is this so?
SAP PI 7.3 Java IDOC Adapter The Java IDoc adapter has the following properties:
Adapter Type: IDoc_AAE Namespace: http://sap.com/xi/XI/System Software Component Version: SAP BASIS 7.30 Related Links: http://help.sap.com/saphelp_nw73/helpdata/en/cc/be413f7c8c4f978b7c755a4bc957d8/content.htm http://help.sap.com/saphelp_nw73/helpdata/en/7b/ebc8b9e34b434d9f3e80ef6776d77a/content.htm http://help.sap.com/saphelp_nw73/helpdata/en/34/66c81241874285851e2497aa6f0573/content.htm
SAP PI 7.3 Availability Time Planning - ATP Communication Channels Suppose you have a business requirement of sending the employee details on the last day of every month. You can plan availability times for communication channels to enable them to be starte d and stopped automatically instead of manually.
The below Table gives you the Information About Scheduled Availability Times Column Meaning Description Short text of your choice
Active Communication Channels
Availability Time
Displays whether the availability time is active (yes/no) Makes specifications for the communication channels selected for the availability time, such as selection mode, name, and number of existing exceptions. Scheduled availability time
You can now create further availability times, or change or delete existing availability times. You can also copy
What is new in PI 7.3? SAP Process Integration 7.3 has lot of new things including Java only installation option via advanced adapter engine eclipsed based design environment, Central Monitoring Dashboard via solution manager and enhanced local monitors.
XML Validation in SAP PI 7.3 XML Validation in PI 7.3 XML validation – To check the structure o f a PI message payload. The structure check is performed using saved data types. You activate the validation in the collaboration agreement. Monitoring and administration takes place in message monitoring of the RW B and in the Integration Engine. In the previous versions you need to add the schema in the specified file directory of the server. But in 7.3 just activate the validation in collaboration agreement or in the integrated configuration in the Integration Directory. This will automatically do the validation. Whenever a sender agreement, receiver agreement, or an integrated configuration with enabled XML validation is activated, the corresponding XSD for the sender or receiver interface is sent to the Runtime and stored in the persistent cache. The cache is located on the central or de-central AAE.
SAP PI JDBC Adapter Transaction Isolation Levels Setting the transaction isolation level for a connection allows a user to specify how severely the user's transaction should be isolated from other transactions. The isolation level determines how transactions running in parallel influence each other. In the advanced Tab page of SAP PI JDBC adapter you can enter the "Transaction Isolation Level". These are the following options. Default (default setting of the respective database) None read_uncommitted (weakest setting) - Allows dirty reads, non-repeatable reads, and phantom reads to occur. read_committed - Ensures only committed data can be read. repeatable_read - Is close to being "serializable," however, "phantom" reads are possible. serializable (strongest setting - Dirty reads, non-repeatable reads, and phantom reads are prevented. Serializable. How can you avoid the file to be picked up by receiver while SAP PI channle is still writing it? When configuring the receiver fiel adapter, use "use temporary file " as write mode when you want to avoid your file to be picked up by receiver while PI channel is still writing it. Obviously larger the file, more chances you have that this issue could occur.
• • • •
WSDL style RPC or Document in SAP PI interface scenario While doing the PI scenario to a third party web service, I came across a situation where need to select the RPC style of the wsdl. Business Opportunities Qa Testing Antivirus Software Roof Materials Initially bit confused and does not why I c hose the RPC style. My enquiry took me to google and ask the same. A WSDL document which describes a web service. A WSDL binding which describes how the service is bound to a messaging protocol, particularly the SOAP me ssaging protocol. RPC(Remote Procedure Call) /encoded
RPC(Remote Procedure Call)/literal Document/encoded Document/literal Add to this collection a pattern which is commonly called the document/literal wrapped pattern and you have five binding styles to choose from when creating a WSDL file. Which one should you choose in my scenario? The style has nothing to do with a programming model. It merely dictates how to translate a WSDL binding to a SOAP message. Nothing more. You can use either style with any programming model. RPC style web service are easier to create and are usually synchronous in nature. RPC encoded web services are easiest create but offers least control in terms of usage of custom data types, validation and interoperability. RPC encoded web service are slower in performance because of added overheads of marshalling and un marshalling.
• • •
Object Locked in SAP XI PI - How to unlock ? You might have experienced object lock situations in SAP PI. How do you unlock the same. Here I am giving you the steps to unlock the same. use the url below to get your PI starting page. http://
:/dir/start/index.jsp Click on the Administration in the Top menu. Business Ideas Business card designs Business Opportunities Click on the Lock Overview from the Lock and cache Administration menu. Select the object which is locked Click on the Button Remove Selected Locks
Import Software Components Versions (SWCV) from SLD to IR ( ESR) You might have worked on different versions of SAP XI PI. Each time you go to new projects you may get some confusion due to the changes in t he PI tool. Here I am giving one of such chnage in PI. I created the Software component version in SLD. Now I wanted to start build the Integartion Repository (ESR ) part of it, Usually in older version you have a menu in the "tool" menu called "Trasfer SWCV from SLD". But 7.1 version onwards it changed. Right click in the Design objects tab in ESR and then it will o pen a new window for creating new o bject. Select the "Software Component Version" under Work Areas. Here you have 2 options like Local software component version and Import from from SLD . Selct Import from from SLD Click on the Display button Select the Software Component Version from the lIst Click on the Import Button.
• • • •
SAP PI Proxy Testing - Request, Original Request, Response, Original Response Today I had a funny scenario. I am working on a Proxy to SOAP synchronous interface. The response I am producing using Java mapping. The interface developed and tested successfully at SAP PI Net weaver run time work bench test message functionality. The test was successful in RW B. Business Opportunities Qa Testing Roof Materials Business Cards Later the counterpart generated the proxy at the ECC side. He tested the the proxy and getting an empty response in proxy. We investigated about the issue. The original response tab contain the message from the target. But it is not in the Response tab. My investigation gave me some indication that the payload developed by java mapping is not matching with the actual structure in proxy. This is was the reason. I changed the Java mapping and tested again both Response, Original Response tab contain message..
• • •
How to send message to SAP PI without having user credentials Recently I had a requirement from thirdparty system, to send message to P I without user name and password. We having the scenario SOAP to IDOC. In sender side SOAP adapter and in IDOC as the receiver. I have developed the Interface and tested using SOAP test tool. Business Ideas Business Opportunities Notebook Computer After my testing I had send the WSDL to the thirdparty SaaS system. They told that they can't use this WSDL and use the URL end point instead. But here is the problem. Their Even Brocker system can't call the PI webservice with User ID and Password. They want webservice URL which should not have any user credential requirement. As the SOAP adapter in PI requires the user ID and password to send message to PI. The normal way of extracting WSDL at the Sender Agreement level (Display WSDL) use Adapter Engine to send message and it requires user credentials. Solution Go to Integration Repository –> Tools -> Display WSDL This will popup another window. Press the continue button and click on t he button propose URL. http://:/sap/xi/engine?type=entry Then click continue and specify Interface and Specify Sender and finally save the WSDL to your computer. Showing posts with label BPC FAQ . Show all posts SAP BPC online training - SAP BPC FAQs - SAP BPC Interview Questions BPC FAQ, BPC Interview Questions, SAP BPC 1 The last couple of months the market for software is not as good as previous years. But still there are some tools of SAP are doing good. One of them are SAP BPC ( SAP BusinessObjects Planning and Consolidation ).
The Business Planning and Consolidation tools. -------------------------------------------1. BPS 2. IP 3. BO extended analytics 4. Cartesis 5. BPC What is SAP BPC? BPC was a product of outlooksoft and SAP has taken over this.The versions of SAP BPC 5.1, 7.0 ( Netweaver and Microsoft version) FAQs of SAP BPC?
1. Is BW basic u required to learn BPC.? No, with that you would know how the data is stored. You have to make plans by using historical data also. 2. Is FICO module is reqd for learning BPC? No, But functional knowledge always good to have. And you are talking more to the business people and you have to use your common sense to do a better job. 3. How many versions you have in BPC? BPC 5.1 is on the market now. In first quarter of 2010 BPC netweaver version 7.0 will come up. Microsoft version of BPC are also in mark et. 4. How long the full cycle implementation of BPC will last? Less than a year. Example --------If only sales planning - 4-6 months If it is supply chain - 4- 6 months 5. What are FICO topics nice to have before study BPC? Currency Translation Intercompany elimination 6. Which combination will be good for BPC consultant?
BW/BI -> BO -> BPC 7. Billing rate? ( 100 - 250 /hr) 8. What are all the BO tools you use in BPC implementation? Xcelsius Crystal Reports 9. What about the security part? As consultant you have to take c are the securities in BPC. securities up t o the record level. Interview Questions in BPC? ============================ 1. How many Dimensions you have created? 2. What is the purpose creating Dimension?
What is new in SAP PI 7.3? SAP Process Integration 7.3 has lot of new things including Java only installation option via advanced adapter engine eclipsed based design environment, Central Monitoring Dashboard via solution manager and enhanced local monitors.
