SAP Upstream Operations Management Tables

Are you looking for the right table related to SAP Upstream Operations Management Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Upstream Operations Management (IS-OIL-UOM) module.

Top 10 tables in Upstream Operations Management

TableDescription
GHO_PPA_DATAPPA request details
GHO_AUDIT_PROFAudit Profiles for Production Network
GHO_MEAS_RULESMeasurement Rules Mapped With Meas Point, Meas Grp, Meas
GHO_PPA_REQUESTPPA request details
GHO_ALERTStore Network Alerts
GHO_CUSCAL_USG_TText table for Custom Calculation Usage
GHO_PPA_FIELDSFields for Selective PPA trigger
GHO_AUDIT_CDOCChange Document number mapping with Reason Code
GHO_CUSTCALC_USGCustom Calculation Usage Area
GHO_DPP_T_MAPMapping table for DPP

List of tables in Upstream Operations Management

TableDescription
GHO_PPA_DATAPPA request details
GHO_AUDIT_PROFAudit Profiles for Production Network
GHO_MEAS_RULESMeasurement Rules Mapped With Meas Point, Meas Grp, Meas
GHO_PPA_REQUESTPPA request details
GHO_ALERTStore Network Alerts
GHO_CUSCAL_USG_TText table for Custom Calculation Usage
GHO_PPA_FIELDSFields for Selective PPA trigger
GHO_AUDIT_CDOCChange Document number mapping with Reason Code
GHO_CUSTCALC_USGCustom Calculation Usage Area
GHO_DPP_T_MAPMapping table for DPP
GHO_AUDT_STA_PROAudit Status Profile
GHO_HIER_DETForecast Hierarchy Details
GHO_DISPOSITIONDispositions
GHO_FREQUENCYFrequency configuration
GHO_CUSTCALC_TText table for table GHO_CUSTCALC_DET
GHO_PROC_AREAProcess Areas in UOM for Custom Calculation ID's
GHO_RSP_OBJTYPMapping of Object Type and Record Status Process
GHO_FILE_OBJTYPObject Type/Run Number and Object type Mapping
GHO_FACTOR_UOMConversion Factor UOM
GHO_CUSTCALC_DETDetails for custom calculation
GHO_PS_CACHEPrimary Selector Cache Manager (Customizing)
GHO_AUDT_STA_PRFAudit Status Profile
GHO_PS_OBJ_ATTRAttributes for a Group Selector Pair
GHO_FREQUENCY_TFrequency descriptions
GHO_RULE_DETAIL2Generic Rule Details
GHO_ALLOC_CUSTOMAudit Document for Management Customizing
GHO_DPP_T_PERSTable for DPP Personal Data
GHO_AUDIT_PROFILAudit Profiles for Production Network
GHO_RULE_DATESValidity Dates for Rule
GHO_JOB_WORKLISTJob Worklist Table
GHO_RSP2Record Status process
GHO_PROC_AR_TEXTText Table for Process area's for Custom Calculation ID's
GHO_EQUATIONEquation
GHO_PS_ATTR_LISTList of Attributes for Primary Selector
GHO_SAM_STATUS_TConfiguration: Status
GHO_STATUS_PROFPermitted object types for status profile
GHO_AUDT_CSTMZNGAudit Number Cusomizing Data
GHO_HIERARCHYHierarchy Header
GHO_HIER_MAPHierarchy Mapping
GHO_SAM_PROFILEProfiles for Production Network
GHO_IMRG_STD_H_SGHO: Do not use ( Check Documentation using info button )
GHO_FC_TEMPLATEList of Templates
GHO_SAM_STATUSConfiguration: Status
GHO_PS_ATTRLST_TAttribute List Texts
GHO_CONV_FACTConversion Factor Table
GHO_RSP_T2Text table for Record Status Processes
GHO_SAM_ACTIONSConfiguration: Actions
GHO_DISP_TDisposition Texts
GHO_PS_CACHE_MNGPrimary Selector Cache Manager (Transactional Data)
GHO_SRC_TYPSource Type
GHO_PS_OBJ_TYPEObject Types of Primary Selector
GHO_SRC_TY_TSource Type Text
GHO_SAM_TRANSStatus Transition
GHO_TARGET_MAPTarget Mapping
GHO_WEB_DISPTable for Web data maintenece
GHO_PS_OBJ_TYP_TObject Types of Primary Selector
GHO_ZONCNT_ACTIVZonal Contribution Active Fields
GHO_SAM_ACTION_TConfiguration: Actions
UPS_OD_PRSNLZTNPersonlization for UOM application
GHO_RSPRecord Status Processes
GHO_VIEWAlert Category
UPS_OD_VARIANTUser Variants
GHO_SAM_RSPRecord Status Process
GHO_RULE_DETAILObselete: Generic Rule
GHO_PS_DATAObject Attribute data for the primary selector
GHO_MAP_OBJTYPMapping of Object Type/User and Logical Path