SAP PO mapping Sync SOAP to JDBC

Well, this time I would like to share this tip to create a service interface to retrieve data from Database with SAP PO/PI.

When you develop the message types to get SQL data you must to check the names and the structure of the Data Types, for example, this is a simple structure to do this query:

SELECT VC_PEDIMENTO, INVNUM, VC_PRC_FILE_FLG
FROM MYTABLE WHERE (INVNUM='4900005421')

For the request sender message type you can write your own structure with any label names:

2018-03-07 11_00_30-MM_ConsultarPedidos_ECC_to_DLX_req_ Display Message Mapping

For the request receiver message type, the name of the structure is very important because when we retrieve the data  is necessary to write in the receiver structure the same label  names and add “_ response” (internally SAP PO create the XML with this convention)

2018-03-07 11_01_05-MM_ConsultarPedidos_ECC_to_DLX_req_ Display Message Mapping

note: the attribute hasQuot it’s used to add single quotes in the field on the WHERE clause.

Then in receiver message type your structure It must be like this, notice the “_response” on the two first elements, the are the same of the previous request structure:

2018-03-07 11_13_01-MM_ConsultarPedidos_ECC_Res_to_DLX_Res_ Display Message Mapping

The label statement_response it’s not mapped because in the runtime execution will be added. And that’s it, now the mappings look like this, the request:

2018-03-07 11_24_41-Enterprise Services Builder (vhephxidci_XID_00)

The important fields are mapped with:

  • action: has the SELECT operation
  • table: the name of the table on DB
  • access: has the all fields to retrieve, they are mapped with a constant with an empty blank space character.
  • key1: it’s the fields on WHERE clause, it has the attribute to add single quotes

The response:

2018-03-07 11_22_51-Enterprise Services Builder (vhephxidci_XID_00)

The fields are mapped one to one except statement_response.

If you want to know more about the document formats and attributes on JDBC adapter I recommend check this document.

Cheers,

References

Anuncios

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión /  Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )

Conectando a %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.