SAP ABAP Table OIURV03_DTL_BK (Valuation Transactions Level 1 - Vltxns)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV (Application Component) Revenue
     ⤷ OIU_RV03 (Package) MP to Well Completion Split Out

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIURV03_DTL_BK	Table Relationship Diagram
Short Description	Valuation Transactions Level 1 - Vltxns

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	DOC_NO	☑	OIURV_DOCNR	OIU_MP_NO	CHAR	20	0	Val. document number	*
3	DOC_YEAR	☑	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
4	LINE_NO	☑	OIU_DOC_LINENR	OIU_DOC_LINENR	NUMC	5	0	Document Line Number
5	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	OIU_PR_DN
6	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
7	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
8	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
12	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
13	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIU_RV_CT
14	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
15	FREQ_CD	☐	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
16	SALE_DT	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
17	FRML_NO	☐	OIU_FRML_NO	OIU_FORMULA_NO	CHAR	8	0	Formula number	OIU_RV_FRML
18	POS_NO	☐	OIU_DOC_POS_NO	NUMC10	NUMC	10	0	Position Number for
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	REJ_ZV_CD	☐	OIU_REJ_ZVCD	OIU_REJ_ZVCD	CHAR	2	0	Valuation REJ ZV code
32	RPT_POS_NO	☐	OIU_DOC_POS_NO	NUMC10	NUMC	10	0	Position Number for
33	REJ_RSN_CD	☐	OIU_REJ_RSN_CD	OIU_REJ_RSN_CD	CHAR	3	0	Rejection Reason Code	*
34	.INCLUDE	☐				0	0	Creator and date/time created
35	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
36	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	OIURV03_DTL_BK	BUKRS	T001	BUKRS	KEY	1	CN
2	OIURV03_DTL_BK	CT_NO	OIU_RV_CT	CT_NO	KEY	1	CN
3	OIURV03_DTL_BK	CT_TYPE_CD	OIU_CM_CTTYP	CT_TYPE_CD		1	CN
4	OIURV03_DTL_BK	DN_NO	OIU_PR_DN	DN_NO	KEY	1	CN
5	OIURV03_DTL_BK	DOI_NO	OIU_DO_DI	DOI_NO	KEY	1	CN
6	OIURV03_DTL_BK	FRML_NO	OIU_RV_FRML	FRML_NO	KEY	1	CN
7	OIURV03_DTL_BK	MATNR	OIU_CM_MAT_PRCD	MATNR	KEY	1	CN
8	OIURV03_DTL_BK	MP_NO	OIU_PR_MP	MP_NO	KEY	1	CN
9	OIURV03_DTL_BK	PPA_RSN_CD	OIU_CM_PPARSN	PPA_RSN_CD		1	CN
10	OIURV03_DTL_BK	UNIT_VNAME	OIU_DO_JV	VNAME		1	CN
11	OIURV03_DTL_BK	VNAME	OIU_DO_JV	VNAME	KEY	1	CN
12	OIURV03_DTL_BK	WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
13	OIURV03_DTL_BK	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

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