SAP ABAP Table OIUH_JE07 (Genaral Ledger Query)

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_JE07	Table Relationship Diagram
Short Description	Genaral Ledger Query

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_GL_GL_SYS_NO	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
2	C_GL_OR_LVL_1_NO	☐	OIUH_COMPANY	CHAR3	CHAR	3	0	Company Name Code
3	C_OR1_OR_LVL_1_NM	☐	OIUH_CHAR40	CHAR40	CHAR	40	0	OIUH_CHAR40
4	C_GL_ACCT_PERD_DT	☐	OIUH_ACCOUNTING_PERIOD10	CHAR10	CHAR	10	0	Accounting Period
5	C_GL_BTCH_NO	☐	OIUH_BATCH_ID	CHAR4	CHAR	4	0	Batch ID
6	C_GL_BTCH_TYPE_CODE	☐	OIUH_JEBATCH_TYPE	OIUH_BATCH_TYPE	CHAR	2	0	Batch Type for Journal Entry
7	C_A_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
8	C_GL_ACCT_NO	☐	OIUH_ACCTID	CHAR10	CHAR	10	0	Account ID
9	C_COA_ACCT_NM	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
10	C_GL_WL_NO	☐	OIUH_WL_NO	CHAR6	CHAR	6	0	Well Number
11	C_GL_WC_NO	☐	OIUH_WC_NO	CHAR2	CHAR	2	0	Well Completion Number
12	C_WC_WC_NM	☐	OIUH_CHAR35	CHAR35	CHAR	35	0	OIUH_CHAR35
13	C_GL_PR_NO	☐	OIUH_PROPERTY_DOI	CHAR8	CHAR	8	0	Property / DOI
14	C_GL_DOI_NO	☐	OIUREP_DOI_NO	CHAR5	CHAR	5	0	DOI No.
15	C_DI_DI_NM	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
16	C_GL_PD_CD	☐	OIUH_PRODUCT_CODE	CHAR3	CHAR	3	0	Product Code
17	C_B_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
18	C_GL_SA_DT	☐	OIUH_SALES_MONTH	CHAR10	CHAR	10	0	Sales Month
19	C_GL_CT_NO	☐	OIUH_CONTRACT_ID	CHAR6	CHAR	6	0	Contract ID
20	C_GL_CT_TYPE_CD	☐	OIU_CT_TYPE_CD	OIU_CT_TYPE_CD	CHAR	2	0	Contract Type	OIU_CM_CTTYP
21	C_C_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
22	C_GL_DN_NO	☐	OIUH_DN_NO	H_DELIVERY_NWK	CHAR	4	0	Delivery Network number
23	C_GL_SUB_NWK_NO	☐	OIUH_SUBNWK_NO	H_SUBDN_NO	CHAR	4	0	Subnetwork Number
24	C_CHV_RPT_CD	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
25	C_DN_DN_DE	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
26	C_GL_PU_NO	☐	OIUH_PURCHASER	CHAR6	CHAR	6	0	Purchaser ID
27	C_GL_PU_SEQ_NO	☐	OIUH_BASEQNR	CHAR2	CHAR	2	0	Business Associate Sequence Nr.
28	C_BA_NM_1	☐	OIUH_CHAR38	CHAR38	CHAR	38	0	OIUH_CHAR38
29	C_GL_TRANS_AM	☐	OIUH_TRANS_AMT	OIUH_CURR11_2	CURR	11	2	JE Transaction Amount
30	C_GL_TRANS_QY	☐	OIUH_TRANS_QUANTITY	OIUH_DEC11_2	DEC	11	2	JE Transaction Quantity
31	C_GL_GR_AM	☐	OIUH_GROSS_AMOUNT	OIUH_CURR11_2	CURR	11	2	Gross Amount (Value)
32	C_GL_GR_QY	☐	OIUH_GROSS_QTY	OIUH_DEC11_2	DEC	11	2	Gross Quantity
33	C_GL_SA_MP_NO	☐	OIUH_MP_NO	OIUH_MP_NO	CHAR	6	0	Measurement Point
34	C_MP_MP_DE	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
35	C_LEDGER_LEVEL	☐	OIUH_CHAR18	CHAR18	CHAR	18	0	OIUH_CHAR18

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUH_JE07	C_GL_CT_TYPE_CD	OIU_CM_CTTYP	CT_TYPE_CD

History

Last changed by/on	SAP	20130529
SAP Release Created in