cancel
Showing results for 
Search instead for 
Did you mean: 

Urzent: Z-Table creation in PI 7.3 single stack

former_member189441
Active Participant
0 Kudos

Hi Experts

How can i create Z-Table in PI 7.3 single stack and use JDBC look ups to access the data.( I dont want to create the table in ECC and use RFC lookups)

Thanks,

Murali.

Accepted Solutions (0)

Answers (1)

Answers (1)

Harish
Active Contributor
0 Kudos

Hi Murali,

Z Tables in on ABAP stack and in PI 7.31 single stack no abap stack is present. If you want simple value mapping then use value mapping object in ID or Fixed value in message mapping.

If you have other requirement, then you need to use ECC or other DB.

regards,

Harish

former_member189441
Active Participant
0 Kudos

Hi

Can't we create one custom Table in PI 7.3 back-end DB(ex: oracle) and use DB lookups??

Thanks,

Murali.

former_member184720
Active Contributor
0 Kudos

Hi Krish - It would be like creation of table on any other oracle database and connecting to it.

Your basis can create a table/you can create using java dictionary(as mentioned the blog) which can be accessible using the JDBC channel.

All these approaches discussed here -

it might not be a good practice to use application system DB tables

Harish
Active Contributor
0 Kudos

Hi Murali,

I am not sure if you can use the back end DB, but you can use any external data base and have JDBC lookup to retrieve the values. If you have any existing DB in the landscape then it is good to use other wise better to use the ECC tables (with RFC lookup).

regards,

Harish