SAP ABAP Table OIUH_TR04 (SAP Oil & Gas)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV (Application Component) Revenue
     ⤷ OIU_H (Package) PRA Hybrid Solution

Basic Data

Table Category	INTTAB	Structure
Structure	OIUH_TR04	Table Relationship Diagram
Short Description	SAP Oil & Gas

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	C_SEV_SYS_NO	☐	OIUH_NUMC22	OIUH_NUMC22	NUMC	22	0	OIUH_NUMC22
2	C_SEV_OR_LVL_1_NO	☐	OIUH_COMPANY_NAME_CODE	CHAR3	CHAR	3	0	Company Name Code
3	C_OR1_OR_LVL_1_NM	☐	OIUH_CHAR40	CHAR40	CHAR	40	0	OIUH_CHAR40
4	C_SEV_PPA_RSN_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
5	C_SEV_MAJ_PD_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
6	C_SEV_PD_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
7	C_PDCD_PD_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
8	C_SEV_PR_NO	☐	OIUH_PR_NO	CHAR8	CHAR	8	0	Property
9	C_SEV_DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
10	C_DI_DI_NM	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
11	C_SEV_MP_NO	☐	OIUH_MEASUREMENT_POINT_ID	CHAR6	CHAR	6	0	Measurement Point ID
12	C_MP_MP_DE	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
13	C_SEV_WL_NO	☐	OIUH_WL_NO	CHAR6	CHAR	6	0	Well Number
14	C_SEV_WC_NO	☐	OIUH_WC_NO	CHAR2	CHAR	2	0	Well Completion Number
15	C_WC_WC_NM	☐	OIUH_CHAR35	CHAR35	CHAR	35	0	OIUH_CHAR35
16	C_SEV_CT_NO	☐	OIUH_CONTRACT_ID	CHAR6	CHAR	6	0	Contract ID
17	C_CTTYP_CT_TYPE_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
18	C_SEV_PU_NO	☐	OIUH_PURCHASER	CHAR6	CHAR	6	0	Purchaser ID
19	C_SEV_PU_SEQ_NO	☐	OIUCM_SEQ_NO	OIUCM_SEQ_NO	CHAR	2	0	Sequence Number
20	C_BA_NM_1	☐	OIUH_CHAR38	CHAR38	CHAR	38	0	OIUH_CHAR38
21	C_SEV_SA_DT	☐	OIUH_SA_DT	CHAR7	CHAR	7	0	Sales Date
22	C_SEV_VL_TYPE_CD	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	OIU_PR_VLTYP
23	C_A_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
24	C_SEV_RPT_FL	☐	OIUH_REPORTED_IND	CHAR1	CHAR	1	0	Reported Indicator
25	C_SEV_RVRS_FL	☐	OIUH_REVERSED_IND	CHAR1	CHAR	1	0	Reversed Indicator
26	C_B_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
27	C_SEV_ST_CD	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
28	C_STATE_ST_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
29	C_SEV_ACCT_DT	☐	OIUH_ACCOUNTING_PERIOD	CHAR7	CHAR	7	0	Accounting Period (Month)
30	C_SEV_ACTL_GRVL_AM	☐	OIUH_GROSS_QUANTITY_VOLUME	OIUH_DEC11_2	DEC	11	2	Gross Quantity (Volume)
31	C_SEV_A_MMBTU_VL_AM	☐	OIUH_GROSS_QUANTITY	OIUH_DEC11_2	DEC	11	2	Gross Quantity NGL
32	C_SEV_GRV_QY	☐	OIUH_GRAVITY	OIUH_DEC3_1	DEC	3	1	Gravity
33	C_SEV_PRD_DA_AM	☐	OIUH_PRODUCING_DAYS	DEC5	DEC	5	0	Producing Days
34	C_SEV_PS_BASE_QY	☐	OIUH_PRESSURE_BASE	OIUH_DEC6_3	DEC	6	3	Pressure Base Quantity
35	C_SEV_VL_DT	☐	OIUH_VALUATION_DATE	DATS	DATS	8	0	Valuation Date
36	C_SEV_ACTL_GRVA_AM	☐	OIUH_GROSS_AMOUNT	OIUH_CURR11_2	CURR	11	2	Gross Amount (Value)
37	C_SEV_NGPA_SECT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
38	C_C_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
39	C_SEV_CT_BTU_FAC	☐	OIUH_BTU_FACTOR	OIUH_DEC7_3	DEC	7	3	BTU Factor
40	C_SEV_TAX_CLASS_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
41	C_D_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
42	C_SEV_PLT_VL_RED_AM	☐	OIUH_PLANT_VOLUME_REDUCTION	OIUH_DEC11_2	DEC	11	2	Plant Volume Reduction (PVR)
43	C_SEV_BLPS_GR_VL_QY	☐	OIUH_GROSS_QUANTITY_BFR_SPLIT	OIUH_DEC11_2	DEC	11	2	Gross Quantity (Before Split Volume)
44	C_SEV_BLPS_GR_VAL_AM	☐	OIUH_GROSS_AMT_BFR_SPLIT	OIUH_CURR11_2	CURR	11	2	Gross Amount (Before Split Value)
45	C_SEV_SCHOL_DIST_CD	☐	OIUH_SCHOOL_DIST	CHAR3	CHAR	3	0	School District
46	C_E_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
47	C_SEV_VER_NO	☐	OIUH_NUMC22	OIUH_NUMC22	NUMC	22	0	OIUH_NUMC22
48	C_SEV_USER_ID	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
49	C_SEV_MP_TYPE_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
50	C_SEV_NWK_NO	☐	OIUH_DN_NO	H_DELIVERY_NWK	CHAR	4	0	Delivery Network number
51	C_SEV_SUBNWK_NO	☐	OIUH_SUBNWK_NO	H_SUBDN_NO	CHAR	4	0	Subnetwork Number
52	C_DN_DN_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
53	C_DI_PD_CD	☐	OIUH_PRODUCT_CODE	CHAR3	CHAR	3	0	Product Code
54	C_SEV_RPT_DT	☐	OIUH_EFFECTIVE_FROM	DATS	DATS	8	0	Effective From Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUH_TR04	C_SEV_ST_CD	OIU_CM_LXPGL	PRI_GEO_LOC
2	OIUH_TR04	C_SEV_VL_TYPE_CD	OIU_PR_VLTYP	VL_TYPE_CD

History

Last changed by/on	SAP	20130529
SAP Release Created in