Which table holds the JDE Table Prefix Mapping information?

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Which table holds the JDE Table Prefix Mapping information that is displayed on the JDE agent in client 0?

Environment

Release : 12.3

Component : RA JD EDWARDS

Resolution

The data is stored in the table OCV.

OCV - object cit values

select oh_name,ocv_vname,ocv_value from oh,ocv where oh_name='JDE_01' and oh_idnr=ocv_oh_idnr and oh_deleteflag=0

The prefix is part of the column ocv_vname, ocv_value tableMappingData

JDE_01	tableMappingData	Versions~z!F983051~z!JVM.~z!false~z;Reports~z!F9860~z!JDM.~z!false~z;Queues~z!F986130~z!~z!false~z;Environments~z!F0094~z!~z!false~z;Printers~z!F986167~z!~z!false~z;RunNumber~z!F986111~z!~z!false~z;JobTable~z!F986110~z!~z!false~z;