SAP_Open_Catalog_Interface_5_1.pdf

PDF 714 KB Posted

Attached to
Comprehensive Community Needs Assessment State and local contract opportunity
Solicitation number
RFP-CSID-26-0198
Issued by
Maricopa County, Phoenix City, Arizona

About this file

This is a Request for Proposal (RFP) from the City of Phoenix Human Services Department soliciting professional consulting services to conduct a comprehensive Community Needs Assessment. The assessment will span three years, commencing July 1, 2026, and will address service areas across six divisions: Community Services and Initiatives, Early Education, Senior Programs, Workforce, Victim Services, and Strategic Initiatives. The consultant must deliver a full comprehensive needs assessment report by October 31, 2026, with a final report due March 16, 2027, followed by targeted update reports in years two and three. The assessment must analyze community strengths, needs, resources, and service gaps across twelve focus areas including employment, education, income management, housing, emergency services, safety, nutrition, self-sufficiency, health, mental health, youth services, and senior services. The methodology must incorporate both qualitative and quantitative approaches with direct community engagement through a minimum of four focus groups and data collection from multiple sources including First Things First, Maricopa County Department of Public Health, and low-income households. Written inquiries must be submitted by February 6, 2026, with responses provided by February 13, 2026, and sealed proposals are due by March 6, 2026, at 3:00 p.m.

Minimum qualifications require three years of experience with similar projects, current registration with the Arizona Corporation Commission, and demonstrated business activity in community needs assessment work; professional liability insurance of $1,000,000 per claim and $1,000,000 annual aggregate is mandatory. The evaluation criteria are weighted as follows: Method of Approach (600 points, 60%), Qualifications and Experience (300 points, 30%), and Pricing Proposal (100 points, 10%). This procurement is anticipated to be funded through a combination of Community Development Block Grant (CDBG) and Head Start federal appropriations. Payment will be made on a cost-reimbursement basis not to exceed annual amounts specified in the fee schedule, with no more than 90 percent of the total contract price paid before work is completed and accepted by the City. Contractors must comply with extensive federal requirements including Head Start Contractor Special Terms and Conditions, FTA federal certifications, disadvantaged business enterprise requirements under 49 CFR Part 26 mandating prompt payment to subcontractors within seven days and return of retainage within seven days of satisfactory completion, debarment and suspension certifications, Byrd Anti-Lobbying certifications for contracts exceeding $100,000, Clean Air Act and Federal Water Pollution Control Act compliance for contracts exceeding $150,000, federal immigration and nationality law compliance with I-9 verification through E-Verify, and nondiscrimination and civil rights compliance requirements.

View the file

Other files for this state and local contract opportunity

Other files attached to Comprehensive Community Needs Assessment, newest first.
File Type Posted
Comprehensive_Community_Needs_Assessment_(Addendum_#2_Revision).pdf PDF
Comprehensive_Community_Needs_Assessment_(Addendum_#2_Revision).pdf PDF
Exhibit_D_-_CNA_Subbmittals.pdf PDF
Exhibit_D_-_CNA_Subbmittals.pdf PDF
CNA_Scope_2026_including_Ex_C_and_Eval_Rubric.pdf PDF
Exhibit_D_-_Head_Start_Contractor_-_Special_Terms_and_Conditions_.pdf PDF
CNA_Scope_2026_including_Ex_C_and_Eval_Rubric.pdf PDF
Exhibit_D_-_Head_Start_Contractor_-_Special_Terms_and_Conditions_.pdf PDF
Comprehensive_Community_Needs_Assessment.pdf PDF
Exhibit_B-Fee_Schedule.pdf PDF
Exhibit_B-Fee_Schedule.pdf PDF
Exhibit_D_-_Head_Start_Contractor_-_Special_Terms_and_Conditions_.pdf PDF
Exhibit_B-Fee_Schedule.pdf PDF
CNA_Scope_2026_.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Sensitive_Security_Information_Acknowledgement_Form.docx DOCX document
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
SAP_Open_Catalog_Interface_5_1.pdf PDF
Supplemental_-Terms-And-Conditions-To-All-Airport-Agreements-REV.-9.2.25.pdf PDF
Sensitive_Security_Information_Acknowledgement_Form.docx DOCX document
Supplemental_-Terms-And-Conditions-To-All-Airport-Agreements-REV.-9.2.25.pdf PDF
Sensitive_Security_Information_Acknowledgement_Form.docx DOCX document
Supplemental_-Terms-And-Conditions-To-All-Airport-Agreements-REV.-9.2.25.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
SAP_Open_Catalog_Interface_5_1.pdf PDF
Show all 25

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Open Catalog Interface (OCI)

R e l e a s e 5 . 0

SAP Open Catalog Interface 5.0 2

© 2003, 2013 SAP AG or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain propriety software components of other software vendors.

These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notes.

http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark

SAP Open Catalog Interface 5.0 3

Icons in Body Text

Icon Meaning

Caution

Example

Note

Recommendation

Syntax

Additional icons are used in SAP Library documentation to help you identify different types of information at a glance. For more information, see Help on Help General Information Classes and Information Classes for Business Information Warehouse on the first page of the any version of SAP Library.

Typographic Conventions

Type Style Description

Example text Words or characters quoted from the screen. These include field names, screen titles, pushbuttons labels, menu names, menu paths, and menu options.

Cross-references to other documentation.

Example text Emphasized words or phrases in body text, graphic titles, and table titles.

EXAMPLE TEXT Technical names of system objects. These include report names, program names, transaction codes, table names, and key concepts of a programming language when they are surrounded by body text, for example, SELECT and INCLUDE.

Example text Output on the screen. This includes file and directory names and their paths, messages, names of variables and parameters, source text, and names of installation, upgrade and database tools.

Example text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.

<Example text> Variable user entry. Angle brackets indicate that you replace these words and characters with appropriate entries to make entries in the system.

EXAMPLE TEXT Keys on the keyboard, for example, F2 or ENTER.

SAP Open Catalog Interface 5.0 4

Table of Contents 1 Introduction

2 Calling Up the Catalog Using the SRM Server

2.1 Settings in the SRM Server

2.2 URL of the Product Catalog

2.2.1 Parameters

2.2.2 Return URL

2.3 Additional Functions in the Product Catalog

2.3.1 Detailed Display of a Product or Service

2.3.2 Validation of a Product

2.3.3 Sourcing/Product Search

2.3.4 Background Search

2.4 Overview of the Call-Up Parameters

3 Return from Catalog

3.1 Use of the Call-Up Parameters from Section 2.4

3.2 Fields and Field Checks

3.2.1 Required and Optional Fields

3.2.2 Product Numbers

3.2.3 Configurable Products

3.2.4 External Product Categories

3.2.5 Introduction of New fields to enable transfer of Item Hierarchy to SRM

3.2.6 Introduction of Inbound Handler and Outbound Handler

3.2.7 Introduction of Portal Navigation while transferring data to SRM

3.2.8 Customer-Specific Extensions in the OCI

3.3 XML Variant of the OCI

4 Handling of the Browser Window

5 Secure OCI

5.1 Launching Catalog with Secure OCI

5.1.1 Initial Handshake

5.1.2 Response to backend call

5.2 Return from catalog

5.2.1 Initiate backend call

5.3 Enablement of Secure OCI for catalogs

6 Enhancements in OCI 5.0 for Mass Upload

SAP Open Catalog Interface 5.0 5

6.1 Mass replication of data delivered in a physical file

6.2 Mass replication of data over HTTP(s) connection

6.3 Replicating Attachments

6.4 Format for Data Transfer

6.5 Settings in the SRM Server

6.5.1 Define External Web Services

6.5.2 Activate SICF service for delivering images/attachments

6.5.3 Proxy server configuration in the BAdI SRM_GET_PROXY_INFO

6.5.4 Customer Enhancements

6.5.5 Additional settings for Mass Upload over Http(s)

6.6 Function for mass upload over Http(s)

6.6.1 Technical Specification for JSON download

6.7 Additional Functions

6.7.1 Catalog Managed Items

6.7.2 Technical Specification for real-time Quantity check

6.8 Data transfer format and rules

6.8.2 Product Numbers

6.8.3 Configurable Products

6.8.4 External Product Categories

6.8.5 Customer-Specific Extensions in the OCI

7 Troubleshooting

SAP Open Catalog Interface 5.0 6

1 Introduction The Open Catalog Interface (OCI) incorporates external product catalogs into SRM Server applications. This way, data that is required to create shopping cart items in the SRM Server can be transferred directly from the external catalog to the SRM Server application.

The mass upload feature is available with the release of Open Catalog Interface version 5.0, where it is possible to replicate the data from external catalogs into the SRM system using JSON (Java Script Object Notation) format over Hyper Text Transfer Protocol (HTTP) or physical file upload. This capability is offered only with the SAP SRM User Interface Add-On 1.0 for SRM Server. The OCI 5.0 standard adds the following capabilities on top of OCI 4.0:

a. Catalog data replication to SRM so that the end users can search for items in all catalogs using SAP Enterprise Search without leaving the SAP SRM screen. Catalog service providers can choose which items are replicated to SAP SRM and to what extent. Details are provided in section 6.

b. Introduction of new fields to enable transfer of item hierarchy to SAP SRM. Details are provided in section 3.2.5.

c. Introduction of the inbound and the outbound handler. Details are provided in section 3.2.6.

d. Secure transfer of user credentials (Secure OCI). Details are provided in section 5.

For a catalog to be OCI 5.0 compliant, it must also be OCI 4.0 compliant and support the features listed above.

SRM Server continues to adhere to the OCI version 4.0 and below, which offers the transfer mechanisms over Hyper Text Transfer Protocol (HTTP).

Figure 1 Overview of Open Catalog Interface 4.0

In this case, the user is working with an SRM Server application, which displays the available catalogs. The user calls up one of these, selects the required products, and then transfers the product data back to the SRM Server application.

This documentation describes both the architecture and the structure of the OCI and thus

SAP Open Catalog Interface 5.0 7 provides all the information that is necessary to support the OCI with a product catalog. In addition, it describes the possible processes and their prerequisites. The documentation has been written both for producers of catalogs and for system administrators of SRM Server systems.

Section 2 describes how the SRM Server calls the catalog as specified in OCI 4.0.

Section 3 describes how the data is transferred from the catalog to the SRM Server as specified in OCI 4.0.

Section 4 describes the handling of the different browser windows specified in OCI 4.0.

Section 5 describes the additions made to Secure OCI.

Section 6 describes enhancements that have been made for OCI 5.0.

2 Calling Up the Catalog Using the SRM Server In order for a product catalog to be called up using the intranet or internet, its URL must be known in the SRM Server. If the product catalog requires additional parameters for the call-up (for example, logon names or a language identifier), these parameters also have to be known in the SRM Server before the call-up.

Figure 2 Calling the Web Service

The URL and the catalog parameters are defined in the Customizing for SAP Supplier Relationship Management under Master Data Define External Web Services (Catalogs, Vendor Lists etc.). In the technical settings, you can set GET or POST as the HTTP method for the call-up, the standard value is POST. The user’s browser then calls up the catalog using the URL and the parameters.

Depending on the situation, other parameters besides those defined in Customizing for SAP Supplier Relationship Management can also be transferred to the catalog on call-up. These might be, for example, to provide the catalog with generic data or to activate specific functions in the catalog.

Section 2.4 describes a summary of the transferred parameters.

SAP Open Catalog Interface 5.0 8

2.1 Settings in the SRM Server

In the SRM Server, you must enter the URL and parameters of the catalog in the following order in the Customizing for Supplier Relationship Management: SRM Server Master Data Define External Web Services (Catalogs, Vendor Lists etc.).

2.2 URL of the Product Catalog

You enter the URL of the catalog in the first line of the call structure; all subsequent entries (including the return URL in line 4) are transferred to the catalog as parameters. You do not need to specify a parameter name for the URL itself. URL is used here as the type. If the URL is longer than the field, you can distribute the URL over several successive fields that are then all of the type, URL. You cannot enter Parameters as part of the URL; maintain them separately as described in the following section.

2.2.1 Parameters

Following the URL, you must specify all parameters that the catalog requires on call-up. The provider of the catalog must have documented the names and valid values of these parameters.

The parameter type can be either Fixed Value or SAP Field. This parameter type determines how the value of the parameter is determined from the Content column. In the case of parameter type, fixed values, the system enters the value of the parameter directly in the Content column. In the case of parameters of type, SAP Field (generic parameters), the name of a SAP System variable exists. For the value of the parameter, the content of this system variable at runtime is used. This way it is possible, for example, to transfer the system language as a parameter, you choose the parameter type as SAP Field and sy-langu as content. In this manner, you can transfer all the globally available fields at runtime from the SRM Server as parameters.

Transfer of additional parameters

If the fixed values and the generic parameter values are not sufficient for the chosen process, you can implement the Business Add-In (BAdI), Transfer Additional Parameters (BBP_CAT_CALL_ENRICH) to transfer additional parameters from the SRM Server system to the catalog. Using this BAdI, you can determine and transfer multiple name-value pairs, to come up when you call a catalog. In addition, if you want to change the format of generic parameters, you can use this BAdI to convert these parameters. For example, you can use this BAdI to convert the system language to a different format: DE- de instead of simply DE.

As of SAP SRM 2.0, a sample implementation is available for the BAdI Transfer Additional Parameters (BBP_CAT_CALL_ENRICH), which reads the relevant user data in the SRM Server and transfers it to the catalog (however, the sample implementation is only run if the business type of the category is set to E-form).

As an example of how this data can be used by the catalog, see the ASP page (ASP = Active Server Pages) that is stored in the SRM Server System in the Internet Service BBP_FREEFORM in the file freeform.zip. When you open all the data in an executable directory on an ASP-compatible Web server, you can use this page as a catalog application for ordering business cards. All the form fields automatically have the default values that have previously been transferred by the BAdI implementation. The user only needs to check the accuracy of the entries.

This ASP page can, of course, only serve as a template. The example is intended to show the options that are available on a project basis with a catalog and the implementation of the BAdI Transfer Additional Parameters (BBP_CAT_CALL_ENRICH).

2.2.2 Return URL

The return URL is required so that the data from the catalog can be transferred back to the SRM Server application via the user’s browser. The catalog must place it in the Action attribute of the transfer form. The return URL is also transferred to the catalog as a parameter. It usually contains other parameters (see below) that must first be extracted and placed in separate input fields (of type hidden) of the form.

SAP Open Catalog Interface 5.0 9

All parameters after the return URL are generated as parameters for the return URL; they are not transferred to the catalog as individual parameters. You can name the parameter for the return URL as you wish since the parameter must be evaluated by the catalog (usually HOOK_URL is used as the parameter name). The value of the return URL must be empty; the actual return URL is determined during run time.

As of SRM Server 4.0, the specification of the return URL and the following parameters is optional in Customizing. If they are not specified, the return URL including the parameters is generated automatically. In this case HOOK_URL is used as the name for the return URL. The name of the return URL must be specified only if the catalog expects a different name for the return URL than HOOK_URL. Even if the name has been specified for the return URL, as of SRM Server 4.0 the parameters for the return URL need no longer be specified; they are also generated automatically in this case.

2.3 Additional Functions in the Product Catalog

The product catalog can provide additional functions that can be used by SRM Server applications. In order to trigger these functions, additional parameters (defined within OCI) are transferred to the catalog when it is called up. If the product catalog supports one or more of the following functions, this is to be stated in the product catalog documentation. This is because an appropriate flag must be set in SRM Server Customizing so that the relevant SRM Server application can make use of the functionality. The fact that the interface supports the additional functionality does not necessarily mean that the functionality is actually used by a SRM Server application.

Currently the following functionality is supported by the OCI:

2.3.1 Detailed Display of a Product or Service

A product that has already been transferred to a SRM Server document using the OCI is to be displayed again later in the catalog. This serves to display detail data directly in the catalog that may not be defined in the OCI and that is also not available in the SRM Server.

In order to activate the function, the following parameters are transferred to the product catalog on call-up:

Name Value

FUNCTION DETAIL

PRODUCTID <Database key for the product in the catalog>

Then the product catalog should immediately display the detail view of the corresponding product. With this function no data is transferred from the product catalog to the SRM Server.

A prerequisite for this function is that before the first time this product is transferred from the product catalog to the SRM Server System, the field NEW_ITEM- EXT_PRODUCT_ID is filled with the database key of the product in the catalog. In addition, in Customizing for SAP Supplier Relationship Management under SRM Server -> Master Data -> Define External Web Services (Catalogs, Vendor Lists etc.) for the corresponding catalog, the Display Product Data Again in Catalog checkbox must be selected.

2.3.2 Validation of a Product

If an item from a product catalog has been added to a template for an SAP SRM document then it is possible, for example, that the price of the product has changed over time. If a new SAP SRM document were to be created from this template, the price change would usually not be taken into account. The function serves to update the product information in the template while the SAP SRM document is being created.

In order to activate the function, the following parameters are transferred to the product catalog on call-up:

Name Value

SAP Open Catalog Interface 5.0 10

FUNCTION VALIDATE

PRODUCTID <Database key for the product in the catalog>

QUANTITY <Current purchase order quantity>

The parameter QUANTITY is transferred as of OCI 3.0 so that the catalog can determine the correct price from a scale, if appropriate.

Then the product catalog replies with an HTML page that contains a form with the product data in OCI format. The return URL must be split here as described in Sections 2.2.2 and 3.1.

The HTML page may not contain any visible elements (the input fields must be of the type hidden). The form must be sent automatically by JavaScript after the page has been loaded.

A prerequisite for this function is that before the first time this product is transferred from the product catalog to the SRM Server System, the field NEW_ITEM- EXT_PRODUCT_ID is filled with the database key of the product in the catalog. In addition, in SRM Server Customizing the Validate Product Data from SAP Enterprise Buyer checkbox must be selected for the relevant catalog.

2.3.3 Sourcing/Product Search

In order to activate the function, the following parameters are transferred to the product catalog on call-up:

Name Value

FUNCTION SOURCING

SEARCHSTRING <Search term>

VENDOR <Business partner number in EBP>

The catalog replies with the display of the search results that correspond to the specified parameters. By navigating further in the product catalog, you can select items as normal and transfer them to the SRM Server application.

This function has not yet been implemented in the SRM Server.

2.3.4 Background Search

In order to avoid the situation where a user searching for a particular product has to search multiple catalogs in sequence, a Cross-Catalog Search has been introduced as of SRM 3.0.

The user enters a search term once in the SRM Server application and this term is transmitted to all catalogs that support the function when the catalogs are called up. The SRM Server displays the search results from all catalogs in a list and the user can select individual products from here.

In order to activate the function, the following parameters are transferred to the product catalog:

Name Value

FUNCTION BACKGROUND_SEARCH

SEARCHSTRING <Search term>

The product catalog replies with a HTML page that contains the search results in OCI format.

All search results must be accessible on this page without having to use a scroll function since the page is evaluated automatically. The form from this page may not be sent automatically to the return URL (in contrast to validation of a product).

A prerequisite for this function is that the Cross-Catalog Search checkbox is selected in SRM Server Customizing for the relevant catalog.

2.4 Overview of the Call-Up Parameters

The following parameters are transferred when the catalog is called up using either HTTP

SAP Open Catalog Interface 5.0 11

GET or POST, depending on what you define in SRM Server Customizing:

Description Name of the Parameter Content or Example

Parameters from SRM Server Customizing

As specified in SRM Server Customizing See Section 2.2.1

Parameters from a BAdI implementation As implemented in the BAdI See Section 2.2.1

Parameters to trigger additional functions

As described in Additional Functions in the Product Catalog See Section 2.3

Return URL If not specified differently in SRM Server Customizing: ‚HOOK_URL’

URL with parameters in the query string See Section 2.2.2

Interface version OCI OCI_VERSION For example: 4.0

Interface version OPI OPI_VERSION For example: 1.0

Character set of SRM Server application http_content_charset For example: iso-

8859-1

Target (HTML target) for return to the SRM Server application returntarget For example: _parent

3 Return from Catalog An HTML form is used to transfer the selected product data to the SRM Server. This form is part of a HTML page that must be created by the catalog. This page (the last page that is displayed by the catalog) is sent to the user’s browser. The user can now send the form from this page to the SRM Server application that then takes over the form data.

SAP Open Catalog Interface 5.0 12

Figure 3 Returning data to SRM Server

In order for you to transfer the data from the catalog to the SRM Server using the user’s browser, the return URL described in Section 2.2.2 and 3.1 must be inserted into the Action attribute of the HTML form created by the catalog (the Action attribute of the form is the URL to which the form data is sent).

The data to be transferred is transported within the input fields of the form; the field names must adhere to the syntax specified below. The Type attribute of the input fields should be text or hidden. The HTTP method recommended in all cases is POST because using GET can lead to browser-dependent length restrictions.

3.1 Use of the Call-Up Parameters from Section 2.4

Use of the parameters from SAP SRM Customizing is catalog-specific; here the only parameters transferred are those that the catalog expects.

Use of the parameters from a possible BAdI implementation is project-specific; here the only parameters transferred are those that the catalog expects in the context of a customer project.

The expected reactions to the parameters for activating additional functions have already been described in Section 2.3.

The interface version has purely informative character; it clarifies which fields or processes are already supported by the SRM Server application.

The return URL points to the current SAP SRM application. It also contains further parameters.

The URL without these parameters must be placed by the catalog into the action attribute of the transfer form. The parameter names and their values must be placed into the attributes name and value of the individual input fields of the transfer form;

the fields are to be of the type hidden.

The character set used by the SAP SRM application is transferred to the catalog (parameter name: http_content_charset). When generating the HTML page with the transfer form, the catalog must use this character set and must insert it into the meta

SAP Open Catalog Interface 5.0 13 tag after the detail charset=.

The target for the return to the SRM Server application (parameter name: returntarget) must be inserted into the target attribute of the transfer form.

3.2 Fields and Field Checks

The naming convention for the fields in the OCI is as follows:

NEW_ITEM-<Field name>[<index>]. The field type is always CHAR.

Field name Length Description

NEW_ITEM-DESCRIPTION[n] 40 Description of the item

NEW_ITEM-MATNR[n] 40 SRM product number of the item

NEW_ITEM-QUANTITY[n] 15 Item quantity (1.)

NEW_ITEM-UNIT[n] 3 Quantity unit for item quantity (3.)

NEW_ITEM-PRICE[n] 15 Price of an item per price unit (1.)

NEW_ITEM-CURRENCY[n] 5 Item currency (3.)

NEW_ITEM-PRICEUNIT[n] 5 Price unit of the item (if empty, 1 is used)(2.)

NEW_ITEM-LEADTIME[n] 5 Delivery time of the item in days (2.)

NEW_ITEM-LONGTEXT_n:132[] Long text for the item (4.)

NEW_ITEM-VENDOR[n] 10 SRM vendor number (business partner) for the item

NEW_ITEM-VENDORMAT[n] 40 Vendor product number for the item

NEW_ITEM-MANUFACTCODE[n] 10 SRM manufacturer number of the item

NEW_ITEM-MANUFACTMAT[n] 40 Item’s manufacturer part number

NEW_ITEM-MATGROUP[n] 10 SRM material group for the item

NEW_ITEM-SERVICE[n] 1 Flag: the item is a service.

NEW_ITEM-CONTRACT[n] 10 SRM contract to which the item refers

NEW_ITEM-CONTRACT_ITEM[n] 5 Item within the SRM contract

NEW_ITEM-EXT_QUOTE_ID[n] 35 Number of an external bid for this item (as reference for a subsequent purchase order)

NEW_ITEM-EXT_QUOTE_ITEM[n] 10 Item of external bid

NEW_ITEM-EXT_PRODUCT_ID[n] 40 Unique database key for this item in the catalog

NEW_ITEM-ATTACHMENT[n] 255 URL of the attachment (the attachment must be accessible for downloading under this

URL)

NEW_ITEM-

ATTACHMENT_TITLE[n] 255 Title of the attachment (if this is empty the file name from the URL above is used)

NEW_ITEM-

ATTACHMENT_PURPOSE[n] 1 Purpose of the attachment. C corresponds here to configuration.

NEW_ITEM-

EXT_SCHEMA_TYPE[n] 10 Name of a schema via which it was imported in the SRM Server

NEW_ITEM-

EXT_CATEGORY_ID[n] 60

Unique key for an external category from the schema above, independent of the version of the schema

SAP Open Catalog Interface 5.0 14

NEW_ITEM-EXT_CATEGORY[n] 40 Unique key for an external category from the schema above, dependent on the version of the schema

NEW_ITEM-SLD_SYS_NAME[n] 60 Name of a system in the System Landscape Directory (SLD)

NEW_ITEM-CUST_FIELD1[n] 10 User-defined field

NEW_ITEM-CUST_FIELD2[n] 10 User-defined field

NEW_ITEM-CUST_FIELD3[n] 10 User-defined field

NEW_ITEM-CUST_FIELD4[n] 20 User-defined field

NEW_ITEM-CUST_FIELD5[n] 50 User-defined field

NEW_ITEM-ITEM_TYPE[n] 1 Item type Root, Outline, Leaf. Introduced since SRM 7.0 onwards.

NEW_ITEM-PARENT_ID[n] 5 An integer field that defines what the parent of the current item is in the Hierarchy structure. This field will be blank for an item which does not have any parent.

Introduced since SRM 7.0 onwards.

1.) 11 digits before the decimal point, 3 after it. Do not use commas for thousands.

2.) In whole numbers.

3.) Must be maintained as ISO code in the SRM Server.

4.) The field NEW_ITEM-LONGTEXT_n:132[] is an exception as far as the syntax of the index n is concerned.

The field length is unlimited.

3.2.1 Required and Optional Fields

The following fields are required fields in all cases:

Either NEW_ITEM-DESCRIPTION[n] or NEW_ITEM-MATNR[n] must be filled. Only one of the two should be filled.

NEW_ITEM-QUANTITY[n]

The following fields are required fields depending on conditions:

NEW_ITEM-UNIT[n] if NEW_ITEM-MATNR[n] has not been filled

NEW_ITEM-CURRENCY[n] if NEW_ITEM-PRICE[n] has been filled

NEW_ITEM-EXT_SCHEMA_TYPE[n] if NEW_ITEM-EXT_CATEGORY_ID[n] orNEW_ITEM-EXT_CATEGORY[n] are used

NEW_ITEM-EXT_QUOTE_ID[n] if NEW_ITEM-EXT_QUOTE_ITEM[n] has been used

NEW_ITEM-CONTRACT[n] if NEW_ITEM-CONTRACT_ITEM[n] has been used

All other fields are optional.

3.2.2 Product Numbers

There are four fields in the interface that describe product numbers:

NEW_ITEM-MATNR[n]: The product number in the SRM System of the purchaser

NEW_ITEM-VENDORMAT[n]: The supplier’s product number

NEW_ITEM-MANUFACTMAT[n]: The manufacturer’s product number

SAP Open Catalog Interface 5.0 15

NEW_ITEM-EXT_PRODUCT_ID[n]: The number that uniquely identifies the product in the catalog.

These product numbers must not be mixed or used for other purposes; in particular the field NEW_ITEM-MATNR[n] must only be filled if the product number in the customer system is known to the catalog.

3.2.3 Configurable Products

Some products (such as PCs) can be configured in the catalog. However, the configuration information is not part of the OCI since the structure of this information differs greatly between providers. There are three options for transferring such products with the OCI without losing the configuration information.

The catalog can create a bid in the sales system and can store the configuration information there. It can then use the fields NEW_ITEM-EXT_QUOTE_ID[n] and NEW_ITEM-EXT_QUOTE_ITEM[n] to transfer a reference to the bid. The bid number is copied to the SRM Server. The configuration information is only available in the sales system if you use this option. This variant is suitable for the local and extended classic scenario since the bid reference is not transferred to MM backend systems as standard. If, however, you wish the bid reference to be transferred, you can copy it in BAdI BBP_CATALOG_TRANSFER into the purchase order text for the item.

The field NEW_ITEM-LONGTEXT_n:132[] can be used to transfer the configuration information as text. The content of the field is included in the purchase order text of the SRM Server shopping cart and of the subsequent purchase order; this way the configuration information is available in the SRM Server.

The fields NEW_ITEM-ATTACHMENT[n] and NEW_ITEM- ATTACHMENT_PURPOSE[n] can be used to transport the configuration information.

Since you can transfer files of any type as attachments, you should ensure that the file can also be displayed (using proprietary or uncommon file types is therefore not recommended). If you use XML files, for example, you should ensure that the formatting information (XSLT) is also included so that the file can be displayed. The configuration information is also available in the SRM Server with this alternative. This variant is only suitable for the local and the extended classic scenario because attachments are not currently transferred to MM backend systems.

3.2.4 External Product Categories

As of SAP Enterprise Buyer 3.0, product categories from external schemas can also be used in the OCI. However, a prerequisite is the import of the relevant schema using the Product Content Workbench (PCW). If the imported schema is also used internally in the SRM Server, then no further action is required. If, however, there is to be a link from the product category from the external schema to an internal product category in the SRM Server, the mapping of the imported (or parked) schema must first be completed using the PCW. The fields NEW_ITEM-EXT_SCHEMA_TYPE[n] and NEW_ITEM-EXT_CATEGORY_ID[n] are used for the external product categories.

If, for example, an UNSPSC schema has been imported into the SRM Server under the name UNSPSC_Vendor1, then UNSPSC_Vendor1 is the value that must be transferred in the field NEW_ITEM-EXT_SCHEMA_TYPE[n].

3.2.5 Introduction of New fields to enable transfer of Item Hierarchy to SRM To accommodate the transfer of item hierarchy information from the catalog to SAP SRM, the following new fields have been added to the current OCI interface. This function is supported from SRM 7.0 onwards.

Field Name Length Description

SAP Open Catalog Interface 5.0 16

NEW_ITEM-PARENT_ID[n] 5 An integer field that defines what the parent of the current item is in the hierarchy structure. This field will be blank for a parent/normal item.

NEW_ITEM-ITEM_TYPE[n] 1 A character field that defines the type of the current item is in the hierarchy structure.

The above addition will ensure that each item is transferred along with its parent’s ID and item type to SAP SRM.

Possible values for the Field PARENT_ID o For hierarchical items which are the top most parent node: The parent field is blank.

o For hierarchical items which are children of other items: The parent field is set to the immediate parent in the hierarchical structure with the ID of the parent line item.

o For regular items, which are neither parent nor child, the transfer will happen in the same way as it happened previously. In this case the PARENT_ID field is blank.

Possible values for the Field ITEM_TYPE o If the item is at the top level of the hierarchy, then the value will be “R” o If the item is an outline, then the value will be “O” o If the item is a functional line item, then the value will be “F”

3.2.6 Introduction of Inbound Handler and Outbound Handler

Previously., the catalog was launched directly from SAP SRM and the item data was passed to SAP SRM directly from the catalog.

From SAP SRM 6.0 onwards, SAP SRM no longer uses ITS technology and several features which were previously supported by ITS were missing, including code page conversion, encoding and decoding HTML tags, launching catalog in an external popup window without ending the SRM session. To include these features, SAP SRM introduced two new services called inbound handler and outbound handler.

Outbound handler is called while launching the catalog. This displays a Back to Application link at the top of every catalog page to allow user to navigate back to SAP SRM without shopping for any items.

Inbound handler is called while transferring the items back from catalog. It is involved in code page conversion and encoding and decoding the HTML tags present in the OCI data.

These services are very useful but if customers want to improve the performance of the system they can switch off these services by adding some new entries in the catalog standard call structure in transaction SPRO.

These new entries are described below:

Parameter Name Type Remarks BYPASS_OUTB_HANDLER Fixed Value This entry is needed to switch on or off the outbound handler. By default, the outbound handler is switched on. If the entry is there in the standard call structure and the value is “X”, then outbound handler will be switched off.

SAP Open Catalog Interface 5.0 17

BYPASS_INB_HANDLER Fixed Value This entry is needed to switch on or off the inbound handler. By default the inbound handler is switched on. If the entry is there in the standard call structure and the value is “X”, then inbound handler will be switched off.

3.2.7 Introduction of Portal Navigation while transferring data to SRM Changes have been made to the previous approach to data transfer processes between the catalog and SAP SRM. Previously, catalog posted a blank HTML form with OCI data in the hidden input fields and SAP SRM read the data and displayed it in the shopping cart or in other business objects.

To activate this portal navigation, customer must make a new entry in the standard call structure of the Catalog.

Parameter Name Type Remarks usePortalNavigation Fixed Value This entry is needed to enable portal navigation for catalog. If the entry is present in the standard call structure and the value is X, then catalog will use Portal Navigation API to transfer the items back to SRM. If this is turned on, Inbound Handler and Outbound Handler is automatically turned off.

3.2.8 Customer-Specific Extensions in the OCI

To transfer additional fields in the OCI, there are two options:

Using the Fields NEW_ITEM-CUSTFIELD1-5 These fields have no fixed semantics in the OCI and this means that you can transfer any contents in order to then evaluate them in BAdI BBP_CATALOG_TRANSFER. In releases prior to SAP Enterprise Buyer 3.0 it is not possible to transfer these fields directly to the shopping cart item. If the content is to be reused later, it must be saved in the BAdI above in the customer’s own database table.

As of SAP Enterprise Buyer 3.0, it is possible to include these fields (without the prefix NEW_ITEM-) in the customer-specific Include CI_BBP_ITEM_SC; the contents are then automatically forwarded to the shopping cart and saved there.

Using the Include CI_OCI_CUSTOMER_EXTENSION This customer-specific Include is available as of SAP Enterprise Buyer 3.0; it allows you to extend the OCI generically. All fields that are created in the Include can then be transferred by the catalog as NEW_ITEM-<field name from Include>[n].

The fields are also available in the BAdI BBP_CATALOG_TRANSFER. If you require the fields to also be available in the shopping cart and saved there, you must also create them in the Include CI_BBP_ITEM_SC.

For more information on the use of customer-specific Includes in SRM Server, see SAP Note 458591.

3.3 XML Variant of the OCI

The OCI can also process an XML file. Here, the same architecture is used as in the pure HTML variant, this means that the XML data is embedded in an HTML form for the transfer from the catalog to the SRM Server using the user’s browser.

To transfer an XML file, aside from the fields mentioned in Section 2.3, two further HTML-inputfields are used:

xmltype:

This parameter specifies the type of the XML file used so that the correct XML mapping can be found. Up to and including SAP Enterprise Buyer 3.0 the mapping of the received XML

SAP Open Catalog Interface 5.0 18 data is done exclusively in the Business Connector, which must be set up for this purpose for the relevant SAP Enterprise Buyer System.

As of SAP Enterprise Buyer 3.5, the mapping can also be done in the SRM Server itself. A prerequisite is that the corresponding XML schema is used. The previous schemas are also supported.

Valid values for the field type xmlType as of SRM 3.0 are:

Value Description DTD/Schema/Mapping

ESAPO Encoded SAP Object for OCI Version up to and including 3.0

PDI_OCI.dtd/PDI_OCI.xsd/BC

ESAPO3.0 Encoded SAP Object for OCI Version up to and including 3.0

PDI_OCI_30.dtd/PDI_OCI_30.xsd/BC

ESAPO3.5 Encoded SAP Object for OCI Version as of 3.5

OpenCatalogInterface.xsd/im SRM Server.

~xmlDocument:

In this parameter, the XML file that must correspond to one of the schemas above is transferred as a Base64-coded character set. The coding can be done either directly on the server page of the catalog or, as shown in the sample application, by JavaScript on the client’s page.

4 Handling of the Browser Window The catalog is displayed in a separate browser window. This window is both opened and closed using the SRM Server application.

The HTTP response of the SRM Server application to the HTTP request with the OCI data consists of an HTML page that contains script for refreshing the window with the SRM Server application and for subsequently closing the catalog window. This page assumes that the JavaScript reference window.opener points to the browser window of the SRM Server application.

You must not change the name of the original window object because this would destroy the reference between the SRM Server application window and the catalog window. If this were to happen, the SRM Server application would no longer be able to correctly display the data that has been transferred from the catalog or close the catalog window.

If the catalog opens additional windows during the search, it must close these before the data is transferred back to the SRM Server.

5 Secure OCI As of OCI 4.0, it is now possible to integrate the catalog in such a way that sensitive data including username, password, price. is no longer sent to the catalog over the browser. This prevents unauthorized dissemination of confidential login information and modification of price with mischievous intentions. Confidential information can now be exchanged by the catalog over a backend HTTP call, which is safe from prying eyes and unwanted modifications.

5.1 Launching Catalog with Secure OCI

When using secure OCI, the launch of catalog application does not happen in a single call from SRM Server to catalog application. There are two calls sent from SAP SRM to the catalog application:

1. Backend call to retrieve the IDs.

2. Request to launch the catalog application using one of the IDs.

SAP Open Catalog Interface 5.0 19

Figure 4 Launch catalog through Secure OCI

5.1.1 Initial Handshake

If Secure OCI is inactive, the call is generated as mentioned in Section 2. Otherwise, the OCI must check whether the following parameters are provided in the request or not:

Here is the list of parameters and their possible values required to use Secure OCI:

PARAMETER NAME Description VALUE TYPE SECURE_AUTH_URL Contains the URL of the web service or servlet that handles the backend call from OCI

URL of the web service or servlet.

Fixed Value

SECURE_TRANSMISSION Indicates the call for retrieving session data

X Fixed Value

FUNCTION Indicates the action to be taken by the catalog application, in this case generate ‘SessionId’ and ‘SessionTransmissionId’

INITIALIZE Fixed Value

SECURE_AUTH_METHOD Determines the HTTP method to be used to send response to the backend call

GET/POST

Default to

POST

Fixed Value

A backend call is generated using the following parameters along with the other parameters such as username and password.

5.1.2 Response to backend call

In response to the backend call, the catalog application sends an XML. The following XML will be sent as a response to the initialization backend call:

<SecureOCI>

Calling Application

(SRM/ERP)

Browser

Catalog Server

1) Backend Call with sensitive data

3) Send SessionId and SessionTransmissionId

4) Request to launch catalog sending Call up Parameters along with the session Id

J2EE DB

2) Persist sensitive data and generate ‘SessionId’ and ‘SessionTransmissionId’.

5) Retrieve Data for authentication using SessionId

6) Launch catalog

SAP Open Catalog Interface 5.0 20

<SessionId>8081457345719230120</SessionId>

<SessionTransmissionId>7551489217863242754</SessionTransmissionId>

</SecureOCI>

These elements along with username and password need to be persisted for further communication.

SessionId: This should be sent as an URL parameter to launch the catalog.

SessionTransmissionId: This parameter will be used in the OCI backend call structure that will be sent when the control returns from the catalog application to retrieve the checked out item data.

NOTE

The ‘SessionId’ and ‘SessionTransmissionId’ can be used only once per session. Once the items are transferred to SAP SRM, the entry corresponding to these IDs must be deleted from DB.

5.2 Return from catalog

In the absence of Secure OCI, when the control returns from catalog, the item data is directly sent as an HTML form. When Secure OCI is enabled, the catalog application will not send the item data in the response. In order to fetch item data from the catalog application, the calling application has to initiate a backend call.

Figure 5 Return from catalog through Secure OCI

5.2.1 Initiate backend call

The OCI has to initiate the backend call to the catalog application by including the following parameters in its call structure:

Calling Application

(SRM/ERP)

Browser

Catalog Server

3) Returns non sensitive Data

4) Backend call to retrieve Item data

5) Catalog sends all Item Related information using OCI parameters

J2EE DB

1) Shop and transfer

2) Persist Item Data

SAP Open Catalog Interface 5.0 21

Here is the list of above mentioned parameters and their possible values required to use Secure

OCI:

PARAMETER NAME Description VALUE TYPE SessionTransmissionId Used in the backend call to retrieve the checked out item data

7551489217863242754

FUNCTION Indicates the action to be taken by the catalog application, in this case send the item data

‘RETRIEVEOCI’ Fixed Value

SECURE_AUTH_METHOD Determines the HTTP method to be used to send response to the backend call

POST Fixed Value

5.3 Enablement of Secure OCI for catalogs

For the implementation details, refer to the SAP Technical Note - 1574737.

6 Enhancements in OCI 5.0 for Mass Upload With OCI 5.0, data from catalogs can be replicated to the SRM Server and to SAP Enterprise Search to enable a federated search. End users can then directly search for catalog items within the SAP SRM shopping cart application, view the item details, and add them to the shopping cart directly. These enhancements are currently only available to customers of SAP SRM who have also installed the SAP SRM User Interface Add-On.

Figure 6 OCI 5.0 changes in Web Service Communication

SAP Open Catalog Interface 5.0 22

NOTE

The search function uses SAP Enterprise Search and TREX. For more information on configuring SAP Enterprise Search & TREX, please see SAP Help documentation on http://help.sap.com/saphelp_nw70ehp3/helpdata/en/48/72305df518055ee10000000a421 89b/frameset.htm

NOTE

Images are stored in SAP Content Management System (SAP CMS) under the content repository SRMNXP_IMG. For information on how to configure SAP CMS, please see SAP Help documentation on http://help.sap.com/saphelp_nw70ehp3/helpdata/en/1f/2df44eeebf8145b67b31f513a83fc 5/frameset.htm

There are multiple ways by which data can be mass replicated to the SRM System.

JSON (Java Script Object Notation) from a physical file as explained in Section 6.1 JSON over HTTP (Hyper Text Transfer Protocol) as explained in Section 6.2

Catalogs have the option of sending only partial data from their catalogs for mass replication.

This may be required in scenarios where the price or other important attributes change too often (for example, the prices for crude oil can change every hour). In such scenarios, the catalog can chose not to send the price data. Catalog should send value X for the parameter CATALOG_MANAGED . The item will appear in the search results, but it can be bought only from the catalog. The end user will see the button “Go to Catalog” instead of “Add to Cart” for such items in their search results. This is explained further in Section 6.7.1.

6.1 Mass replication of data delivered in a physical file

This option allows mass replication of data using physical files in Java Script Object Notation (JSON) format. Catalogs can deliver a JSON file along with images. The images can be referring to a http(s) URL or can be provided in a physical file placed in the application server (if indexing is scheduled in a background task). In case of images being provided in a physical file all the images should be in one folder and not contained within subfolders. The names of the images should match the names specified in the JSON file. HTTP based transfer of attachments is recommended over physical upload of images from a folder location. Details regarding attachment upload are provided in Section 6.3.

6.2 Mass replication of data over HTTP(s) connection

This option allows for mass replication of data in Java Script Object Notation (JSON) format sent over an HTTP(S) connection. Catalog providers must provide an HTTP(S) URL through which the data can be pulled from the catalog server in JSON format. Attachments should be delivered as an HTTP(S) URI or as a physical folder on the application server. The names of the attachments should match the names specified in the JSON data. All attachments should be in one folder and not contained within subfolders. HTTP based transfer of attachments is recommended over physical upload of images from a folder location. Details regarding attachment upload are provided in Section 6.3

6.3 Replicating Attachments

There are three ways of making item attachments available to end-users in the SRM NXP Shopping Cart screen.

Provide the physical files of the attachments and store them in a server location as a folder or a zip file. For example, an attachment named laptop.jpg is stored in a folder http://help.sap.com/saphelp_nw70ehp3/helpdata/en/48/72305df518055ee10000000a42189b/frameset.htm http://help.sap.com/saphelp_nw70ehp3/helpdata/en/48/72305df518055ee10000000a42189b/frameset.htm http://help.sap.com/saphelp_nw70ehp3/helpdata/en/1f/2df44eeebf8145b67b31f513a83fc5/frameset.htm http://help.sap.com/saphelp_nw70ehp3/helpdata/en/1f/2df44eeebf8145b67b31f513a83fc5/frameset.htm

SAP Open Catalog Interface 5.0 23 named Catalog Attachments. In the JSON file, for the item laptop in the object attachments laptop.jpg is specified as the attachment name with the attachment type 01 identifying it as the main image. Then the system would read it and upload it to SAP Content Management System (CMS) against the item laptop.

Provide URL for an attachment, which can then either be:

1. Downloaded from the URL and uploaded into SAP CMS. When the user views this item, the attachments are served from SAP CMS.

2. URL is stored without any changes. When the user views the associated catalog item, the attachments are pulled directly from the URL by the browser.

CAUTION

If you are running your SRM Server instance in HTTPS (Secure HTTP) mode, and the attachment URL is in HTTP (standard HTTP) mode, end users may get a warning that the page is accessing unsecure resources. If the attachments are being retrieved from a URL located on the internet, then your users will need access to the internet.

NOTE

Reading and uploading attachments takes time irrespective of whether they are read from a URL location on the internet or from file system. If your data has lot of attachments, the upload report/job can take a long time to finish..

6.4 Format for Data Transfer

Data transfer for mass upload in OCI 5.0 happens in JSON format. This enables high volume data processing with high performance. The rules and complete details of the format are specified in Section 6.8.

To indicate a delta or a full transfer of the catalog items, the Complete Transmission Indicator has to be sent as part of the first JSON response. In case of manual file upload, the system administrator chooses whether the upload is a full upload or a delta upload.

6.5 Settings in the SRM Server

In this section, settings required on the SRM Server are described.

6.5.1 Define External Web Services

For authorization management and management of catalog data visibility between different Purchasing Groups and Organizations, SAP SRM customers are required to create a logical entry for each catalog in the Customizing for Supplier Relationship Management under SRM Server Master Data Define External Web Services (Catalogs, Vendor Lists etc.). You can find the complete documentation in the description of the Customizing Define External Web Services (Catalogs, Vendor Lists etc.).

6.5.2 Activate SICF service for delivering images/attachments The service to fetch images and attachments can be activated in SAP SRM either in transaction SPRO, navigate to Customizing for Supplier Relationship Management -> SAP SRM User Interface Add-on -> Activate ICF Service for Image Delivery, or in transaction SICF, navigate to

SAP Open Catalog Interface 5.0 24 the service, Default_host -> sap -> srmnxp -> attachment loader then right-click on this service and activateit.

6.5.3 Proxy server configuration in the BAdI SRM_GET_PROXY_INFO

If your organization mandates usage of a proxy server for accessing resources over the internet and you have selected the Download attachments from their HTTP/HTTPS location checkbox in the data upload report and the JSON data file you are uploading has documents (images/attachments) accessible over the internet, then for downloading such attachments you must specify the proxy server configuration to be used for accessing the internet in BAdI

SRM_CAT_GETPROXYINFO. You can find more documentation on the relevant configuration required in transaction SPRO, navigate to the Customizing for - Supplier Relationship Management underSRM Server -> Customer Extension -> Business Add-ins -> Proxy Server Configuration.

6.5.4 Customer Enhancements

You can enrich the existing data, by using the following two BAdIs:

/SRMNXP/CATALOG_TRANSFER_DATA: You can use this BAdI for data enrichment before writing to staging…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .