GHO_IMRG_STD_H
Header for Standardized QCI Volumes
GHO_IMRG_STD_H is an SAP database table in S/4HANA. Header for Standardized QCI Volumes. It contains 30 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_GHONtwkObjMeasurements | view_entity | from | BASIC | Network Object Measurements |
| UPO_INT_V_STD_VOL_DIM | view_entity | from | Standardized Measurement Volumes | |
| UPOV_ME_MEDOC_IT_UOM | view | inner | Measurement document item (UOM) | |
| UPOV_ME_MEDOC_UOM | view | inner | Measurement document header UOM Data | |
| UPOV_MEASDOC_DTL | view | inner | Measurement document Details | |
| UPOV_MEASURE_STD_UNIT | view | inner | Standardized Measurement Units | |
| UPOV_PPN_MP_BA_UOM | view | left_outer | Event Detail Ref - Before/After data | |
| UPOV_PR_MPVL_UOM | view | inner | Measurement Point Volumetric Data (UOM) | |
| UPOV_UOM_DATA | view | inner | UOM data for a Business Key | |
| UPOV_UOM_STD_UNIT | view | from | Standardized Measurement Units | |
| UPOV_UOM_WCDPS | view | from | Well Completion Daily Pressures (UOM) | |
| UPOV_WCDPS_MEAS_VALUE | view | from | WCDPS - Choke Size and Tubing Pressure |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | netid | GHO_PFN_ID | Production Flow NW | |||
| KEY | netobj | GHO_NODE_ID | Node ID | |||
| KEY | alloc_material | GHO_ALLOC_MATERIAL | Allocation Material | |||
| KEY | quantity_type | GHO_QTY_TYPE | Quantity Type | |||
| KEY | prod_timestamp | GHO_TIMESTAMP | Timestamp | |||
| KEY | alloc_type | GHO_ALLOC_TYPE | Allocation Type | |||
| KEY | frequency | GHO_ALLOC_FREQUENCY | Frequency ID | |||
| KEY | gho_meas_cat_id | GHO_MEAS_CAT_ID | Measurement Category | |||
| KEY | bus_key | GHO_MEAS_GUID | Meas. GUIDD | |||
| mdocm | IMRC_MDOCM | MeasDocument | ||||
| mrh_sub_flag | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| manual_flag | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| created_by | GHO_CREATED_BY | Record Created By | ||||
| created_tst | GHO_DE_CREATED_ON | Created On | ||||
| changed_by | GHO_CHANGED_BY | Changed By | ||||
| changed_tst | GHO_DE_CHANGED_ON | Changed On | ||||
| ref_network_id | GHO_PFN_ID | Production Flow NW | ||||
| ref_node_id | GHO_NODE_ID | Node ID | ||||
| business_status | GHO_FDC_BUSINESS_STATUS | FDC Bus Status | ||||
| status_object_number | GHO_DE_OBJECT_NUMBER | Object Number | ||||
| to_prod_network | GHO_DE_NETOBJ_PRNW | Asgn. Prod. Net | ||||
| to_netobj_type | GHO_NETOBJ_TYPE | Nw Obj Type | ||||
| to_network_obj | GHO_DE_NETOBJ_ID | Network Object ID | ||||
| ld_oil_wo_recov | OIU_LD_OIL_WO_RECOV | Ld Oil w/o Recovery | ||||
| trnsp_no | OIU_TRNSP_NO | Transporter | ||||
| trnsp_ref_no | OIU_TRNSP_REF_NO | Trsprt.Ref. | ||||
| tkt_no | OIU_TKT_NO | Ticket Number | ||||
| transp_name | UPO_TRANSP_NAME | Transporter Name | ||||
| originating_mp | GHO_DE_NODE_ID | Node ID |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Header for Standardized QCI Volumes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_IMRG_STD_H (
MANDT, -- Client [MANDT]
NETID, -- Production Flow NW [GHO_PFN_ID]
NETOBJ, -- Node ID [GHO_NODE_ID]
ALLOC_MATERIAL, -- Allocation Material [GHO_ALLOC_MATERIAL]
QUANTITY_TYPE, -- Quantity Type [GHO_QTY_TYPE]
PROD_TIMESTAMP, -- Timestamp [GHO_TIMESTAMP]
ALLOC_TYPE, -- Allocation Type [GHO_ALLOC_TYPE]
FREQUENCY, -- Frequency ID [GHO_ALLOC_FREQUENCY]
GHO_MEAS_CAT_ID, -- Measurement Category [GHO_MEAS_CAT_ID]
BUS_KEY, -- Meas. GUIDD [GHO_MEAS_GUID]
MDOCM, -- MeasDocument [IMRC_MDOCM]
MRH_SUB_FLAG, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
MANUAL_FLAG, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
CREATED_BY, -- Record Created By [GHO_CREATED_BY]
CREATED_TST, -- Created On [GHO_DE_CREATED_ON]
CHANGED_BY, -- Changed By [GHO_CHANGED_BY]
CHANGED_TST, -- Changed On [GHO_DE_CHANGED_ON]
REF_NETWORK_ID, -- Production Flow NW [GHO_PFN_ID]
REF_NODE_ID, -- Node ID [GHO_NODE_ID]
BUSINESS_STATUS, -- FDC Bus Status [GHO_FDC_BUSINESS_STATUS]
STATUS_OBJECT_NUMBER, -- Object Number [GHO_DE_OBJECT_NUMBER]
TO_PROD_NETWORK, -- Asgn. Prod. Net [GHO_DE_NETOBJ_PRNW]
TO_NETOBJ_TYPE, -- Nw Obj Type [GHO_NETOBJ_TYPE]
TO_NETWORK_OBJ, -- Network Object ID [GHO_DE_NETOBJ_ID]
LD_OIL_WO_RECOV, -- Ld Oil w/o Recovery [OIU_LD_OIL_WO_RECOV]
TRNSP_NO, -- Transporter [OIU_TRNSP_NO]
TRNSP_REF_NO, -- Trsprt.Ref. [OIU_TRNSP_REF_NO]
TKT_NO, -- Ticket Number [OIU_TKT_NO]
TRANSP_NAME, -- Transporter Name [UPO_TRANSP_NAME]
ORIGINATING_MP, -- Node ID [GHO_DE_NODE_ID]
PRIMARY KEY (MANDT, NETID, NETOBJ, ALLOC_MATERIAL, QUANTITY_TYPE, PROD_TIMESTAMP, ALLOC_TYPE, FREQUENCY, GHO_MEAS_CAT_ID, BUS_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA