SAP ABAP View V_OIUCWOPSL_GL (Join RV_OPSL and RV_GL tables and rename field(s))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-CW (Application Component) Check Write
     ⤷ OIU_CW (Package) PRA Revenue: Payment Processing

Basic Data

View Type	D	Database View
Database View	V_OIUCWOPSL_GL
Short Description	Join RV_OPSL and RV_GL tables and rename field(s)
Root table	OIUH_RV_OPSL	Journal Entry Owner Payable Subledger Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIUH_RV_OPSL	OIUH_RV_OPSL
2	OIUH_RV_GL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIUH_RV_OPSL	MANDT	JL	EQ				0	0
2	OIUH_RV_GL	MANDT	JR	EQ			AND	0	0
3	OIUH_RV_OPSL	OPSL_GL_SYS_NO	JL	EQ				0	0
4	OIUH_RV_GL	GL_GL_SYS_NO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIUH_RV_OPSL	MANDT		☐	MANDT	☐	Client
2	SYS_NO	OIUH_RV_OPSL	OPSL_GL_SYS_NO		☐	OIUH_DEC18	☐	OIUH_DEC18
3	OPSL_BTU_QY	OIUH_RV_OPSL	OPSL_BTU_QY		☐	OIUH_DEC7_3	☐	OIUH_DEC7_3
4	OPSL_PS_BASE_QY	OIUH_RV_OPSL	OPSL_PS_BASE_QY		☐	OIUH_DEC6_3	☐	OIUH_DEC6_3
5	OPSL_GRV_QY	OIUH_RV_OPSL	OPSL_GRV_QY		☐	OIUH_DEC3_1	☐	OIUH_DEC3_1
6	OWN_NO	OIUH_RV_OPSL	OPSL_OWN_NO		☐	OIUH_CHAR6	☐	OIUH_CHAR6
7	OWN_SEQ_NO	OIUH_RV_OPSL	OPSL_OWN_SEQ_NO		☐	OIUH_CHAR2	☐	OIUH_CHAR2
8	PRDR_NO	OIUH_RV_OPSL	OPSL_PRDR_NO		☐	OIUH_CHAR6	☐	OIUH_CHAR6
9	PRDR_SEQ_NO	OIUH_RV_OPSL	PSL_PRDR_SEQ_NO		☐	OIUH_CHAR2	☐	OIUH_CHAR2
10	OWN_INT_DECM_QY	OIUH_RV_OPSL	OWN_INT_DECM_QY		☐	OIUH_DEC9_8	☐	OIUH_DEC9_8
11	OWN_INT_TYPE_CD	OIUH_RV_OPSL	OWN_INT_TYPE_CD		☐	OIUH_CHAR2	☐	OIUH_CHAR2
12	OWN_INT_SEQ_NO	OIUH_RV_OPSL	OWN_INT_SEQ_NO		☐	OIUH_CHAR2	☐	OIUH_CHAR2
13	UNIT_OF_MEAS_CD	OIUH_RV_OPSL	UNIT_OF_MEAS_CD		☐	OIUH_CHAR3	☐	OIUH_CHAR3
14	SUS_RSN_CD	OIUH_RV_OPSL	OPSL_SUS_RSN_CD		☐	OIUH_CHAR2	☐	OIUH_CHAR2
15	OPSL_ORIG_MP_NO9	OIUH_RV_OPSL	OPSL_ORIG_MP_NO9		☐	OIUH_CHAR1	☐	OIUH_CHAR1
16	OPSL_ORIG_MP_NO	OIUH_RV_OPSL	OPSL_ORIG_MP_NO		☐	OIUH_CHAR6	☐	OIUH_CHAR6
17	DED_RMB_AM	OIUH_RV_OPSL	OPSL_DED_RMB_AM		☐	OIUH_CURR11_2	☐	Local amount
18	DED_GR_RMB_AM	OIUH_RV_OPSL	L_DED_GR_RMB_AM		☐	OIUH_CURR11_2	☐	Local amount
19	TAX_RMB_AM	OIUH_RV_OPSL	OPSL_TAX_RMB_AM		☐	OIUH_CURR11_2	☐	Local amount
20	TAX_GR_RMB_AM	OIUH_RV_OPSL	L_TAX_GR_RMB_AM		☐	OIUH_CURR11_2	☐	Local amount
21	PAY_CD	OIUH_RV_OPSL	OPSL_PAY_CD		☐	OIUH_CHAR2	☐	OIUH_CHAR2
22	STATE_CD	OIUH_RV_OPSL	OPSL_ST_CD		☐	OIUH_CHAR2	☐	OIUH_CHAR2
23	OWN_BAL_DECM_QY	OIUH_RV_OPSL	OWN_BAL_DECM_QY		☐	OIUH_DEC9_8	☐	OIUH_DEC9_8
24	UNIT_PR_NO	OIUH_RV_OPSL	OPSL_UNIT_PR_NO		☐	OIUH_CHAR8	☐	OIUH_CHAR8
25	NET_TRANSP_AM	OIUH_RV_OPSL	L_NET_TRANSP_AM		☐	OIUH_CURR11_2	☐	Local amount
26	NET_OTH_MK_AM	OIUH_RV_OPSL	L_NET_OTH_MK_AM		☐	OIUH_CURR11_2	☐	Local amount
27	GR_TRANSP_AM	OIUH_RV_OPSL	SL_GR_TRANSP_AM		☐	OIUH_CURR11_2	☐	Local amount
28	GR_OTH_MK_AM	OIUH_RV_OPSL	SL_GR_OTH_MK_AM		☐	OIUH_CURR11_2	☐	Local amount
29	AES_FL	OIUH_RV_OPSL	OPSL_AES_FL		☐	OIUH_CHAR1	☐	OIUH_CHAR1
30	TXN_VAL_AM	OIUH_RV_OPSL	OPSL_TXN_VAL_AM		☐	OIUH_CURR11_2	☐	Local amount
31	PLT_VL_GRED_AM	OIUH_RV_OPSL	OPSL_GR_PVR_AM		☐	OIUH_DEC11_2	☐	OIUH_DEC11_2
32	PLT_VL_ORED_AM	OIUH_RV_OPSL	OPSL_OWN_PVR_AM		☐	OIUH_DEC11_2	☐	OIUH_DEC11_2
33	MMBTU_OVL_AM	OIUH_RV_OPSL	MMBTU_OWN_VL_AM		☐	OIUH_DEC11_2	☐	OIUH_DEC11_2
34	LGND_CD	OIUH_RV_OPSL	OPSL_LGND_CD		☐	OIUH_LEGEND_CODE	☐	Legend Code
35	PSL_INT_PAID_FL	OIUH_RV_OPSL	PSL_INT_PAID_FL		☐	OIUH_CHAR1	☐	OIUH_CHAR1
36	SL_OP_NON_OP_FL	OIUH_RV_OPSL	SL_OP_NON_OP_FL		☐	OIUH_CHAR1	☐	OIUH_CHAR1
37	ORG_LVL_1	OIUH_RV_GL	GL_OR_LVL_1_NO		☐	OIUH_CHAR3	☐	OIUH_CHAR3
38	ACCT_PERD	OIUH_RV_GL	GL_ACCT_PERD_DT		☐	OIUH_ACCOUNTING_PERIOD8	☐	Accounting Period(YYYYMM01)
39	BATCH_NO	OIUH_RV_GL	GL_BTCH_NO		☐	OIUH_BATCH_ID	☐	Batch ID
40	LINE_NO	OIUH_RV_GL	GL_LE_NO		☐	OIUH_CHAR8	☐	OIUH_CHAR8
41	ACCT_NO	OIUH_RV_GL	GL_ACCT_NO		☐	OIUH_CHAR10	☐	OIUH_CHAR10
42	BTCH_TYPE_CD	OIUH_RV_GL	BTCH_TYPE_CODE		☐	OIUH_CHAR2	☐	OIUH_CHAR2
43	TRANS_AM	OIUH_RV_GL	GL_TRANS_AM		☐	OIUH_CURR11_2	☐	Local amount
44	SYS_SRCE_CD	OIUH_RV_GL	GL_SYS_SRCE_CD		☐	OIUH_CHAR2	☐	OIUH_CHAR2
45	TRANS_QY	OIUH_RV_GL	GL_TRANS_QY		☐	OIUH_DEC11_2	☐	OIUH_DEC11_2
46	GR_AM	OIUH_RV_GL	GL_GR_AM		☐	OIUH_CURR11_2	☐	Local amount
47	GR_QY	OIUH_RV_GL	GL_GR_QY		☐	OIUH_DEC11_2	☐	OIUH_DEC11_2
48	PD_CD	OIUH_RV_GL	GL_PD_CD		☐	OIUH_CHAR3	☐	OIUH_CHAR3
49	VL_TYPE_CD	OIUH_RV_GL	GL_VL_TYPE_CD		☐	OIU_VL_TYPE_CD	☐	Volume Type Code
50	PU_NO	OIUH_RV_GL	GL_PU_NO		☐	OIUH_CHAR6	☐	OIUH_CHAR6
51	PU_SEQ_NO	OIUH_RV_GL	GL_PU_SEQ_NO		☐	OIUH_CHAR2	☐	OIUH_CHAR2
52	CT_NO	OIUH_RV_GL	GL_CT_NO		☐	OIUH_CONTRACT_ID	☐	Contract ID
53	CT_TYPE_CD	OIUH_RV_GL	GL_CT_TYPE_CD		☐	OIU_CT_TYPE_CD	☐	Contract Type
54	DOI_PR_NO	OIUH_RV_GL	GL_PR_NO		☐	OIUH_CHAR8	☐	OIUH_CHAR8
55	DOI_SEQ_NO	OIUH_RV_GL	GL_DOI_NO		☐	OIUH_CHAR5	☐	OIUH_CHAR5
56	WL_NO	OIUH_RV_GL	GL_WL_NO		☐	OIUH_CHAR6	☐	OIUH_CHAR6
57	WC_NO	OIUH_RV_GL	GL_WC_NO		☐	OIUH_CHAR2	☐	OIUH_CHAR2
58	SA_MP_NO	OIUH_RV_GL	GL_SA_MP_NO		☐	OIUH_CHAR6	☐	OIUH_CHAR6
59	SA_DT	OIUH_RV_GL	GL_SA_DT		☐	OIUH_CHAR14	☐	OIUH_CHAR14
60	NWK_NO	OIUH_RV_GL	GL_DN_NO		☐	OIUH_CHAR4	☐	OIUH_CHAR4
61	SUBNWK_NO	OIUH_RV_GL	GL_SUB_NWK_NO		☐	OIUH_CHAR4	☐	OIUH_CHAR4
62	GL_CHV_RPT_CD	OIUH_RV_GL	GL_CHV_RPT_CD		☐	OIUH_CHAR10	☐	OIUH_CHAR10

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C