SAP ABAP Table OIU_RV_VLTXNS (Valuation Transactions)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIU_RV_VLTXNS	Table Relationship Diagram
Short Description	Valuation Transactions

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DN_NO	☑	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	OIU_PR_DN
3	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
4	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
5	MP_NO	☑	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
6	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
7	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	VNAME	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
9	DOI_NO	☑	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
10	CT_NO	☑	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIU_RV_CT
11	MAJPD_CD	☑	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
12	FREQ_CD	☑	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
13	SALE_DT	☑	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
14	SCHOOL_DIST_CD	☑	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
15	TAX_CLS	☑	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
16	VLTXNS_NO	☐	OIU_VLTXNS_NO	OIU_SYS_NO	NUMC	12	0	Valuation Transaction Number
17	POS_NO	☐	OIU_LAST_POS	NUMC3	NUMC	3	0	Last used (highest) position number
18	FRML_NO	☐	OIU_FRML_NO	OIU_FORMULA_NO	CHAR	8	0	Formula number	OIU_RV_FRML
19	LVL_CD	☐	OIU_LVL_CD	OIU_LVL_CD	NUMC	2	0	Level Code
20	GROUP_CD	☐	OIU_GROUP_CD	OIU_GROUP_CD	CHAR	1	0	Group Code
21	PPA_RSN_CD	☐	OIU_PPA_RSN_CD	OIU_PPA_RSN_CD	CHAR	2	0	Prior Period Adjustment Reason Code	OIU_CM_PPARSN
22	UNIT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
23	DOI_SUM_FL	☐	OIU_DOI_SUM_FL	OIU_X_FLAG	CHAR	1	0	Summarize RD to DOI Level Flag
24	RM_FEE_FL	☐	OIU_RM_FEE_FL	OIU_X_FLAG	CHAR	1	0	CO2 Removal Fee Flag
25	DUAL_ACCT_FL	☐	OIU_DUAL_ACCT_FL	OIU_X_FLAG	CHAR	1	0	Dual Accounting Flag
26	TXN_PRCS_CD	☐	OIU_TXN_PRCS_CD	OIU_TXN_PRCS_CD	CHAR	2	0	Transaction Process Code
27	CT_TYPE_CD	☐	OIU_CT_TYPE_CD	OIU_CT_TYPE_CD	CHAR	2	0	Contract Type	OIU_CM_CTTYP
28	VL_VAL_ON_VAL_FL	☐	OIU_VL_VAL_ON_VAL_FL	OIU_X_FLAG	CHAR	1	0	Value on Value indicator
29	REJ_REPRCS_FL	☐	OIU_REJ_REPRCS_FL	OIU_X_FLAG	CHAR	1	0	Reject Reprocess Flag
30	FULL_SMPL_PLT_CD	☐	OIU_FULL_SMPL_PLT_CD	OIU_FUL_SP_PLT_DN_NO	CHAR	1	0	Full Simple Plant Network
31	.INCLUDE	☐				0	0	Creator and date/time created
32	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
33	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIU_RV_VLTXNS	BUKRS	T001	BUKRS	KEY	1	CN
2	OIU_RV_VLTXNS	CT_NO	OIU_RV_CT	CT_NO	KEY	1	CN
3	OIU_RV_VLTXNS	CT_TYPE_CD	OIU_CM_CTTYP	CT_TYPE_CD	REF
4	OIU_RV_VLTXNS	DN_NO	OIU_PR_DN	DN_NO	KEY	1	CN
5	OIU_RV_VLTXNS	DOI_NO	OIU_DO_DI	DOI_NO	KEY	1	CN
6	OIU_RV_VLTXNS	FRML_NO	OIU_RV_FRML	FRML_NO	KEY	1	CN
7	OIU_RV_VLTXNS	MATNR	OIU_CM_MAT_PRCD	MATNR	KEY	1	CN
8	OIU_RV_VLTXNS	MP_NO	OIU_PR_MP	MP_NO	KEY	1	CN
9	OIU_RV_VLTXNS	PPA_RSN_CD	OIU_CM_PPARSN	PPA_RSN_CD		1	CN
10	OIU_RV_VLTXNS	UNIT_VNAME	OIU_DO_JV	VNAME		1	CN
11	OIU_RV_VLTXNS	VNAME	OIU_DO_JV	VNAME	KEY	1	CN
12	OIU_RV_VLTXNS	WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
13	OIU_RV_VLTXNS	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

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