SAP ABAP Table OIU_SB_CTRWC (Volumes for sale)

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_SB_CTRWC	Table Relationship Diagram
Short Description	Volumes for sale

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	SA_DT	☑	OIU_SA_DT	DATS	DATS	8	0	Sales date
4	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
5	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
6	ORIG_MP_NO	☑	OIU_ORIG_MP_NO	OIU_MP_NO	CHAR	20	0	Original measurement point number	OIU_PR_MP
7	TRNSP_NO	☑	OIU_TRNSP_NO	KUNNR	CHAR	10	0	Transporter number	KNA1
8	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
9	FREQ_CD	☑	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
10	CT_NO	☑	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIU_RV_CT
11	VC_CD	☐	OIU_VC_CD	OIU_VC_CD	CHAR	1	0	Volume class code
12	STD_VOL_U	☐	OIU_STD_VOL_U	MEINS	UNIT	3	0	Standard volume unit	T006
13	STD_VOL	☐	OIU_STD_VOL	MENGE	QUAN	13	3	Standard volume
14	STD_HEAT_VAL_U	☐	OIU_STD_HEAT_VAL_U	MEINS	UNIT	3	0	Standardized Heating Value Unit	T006
15	STD_HEAT_VAL	☐	OIU_STD_HEAT_VAL	MENGE	QUAN	13	3	Standardized Heating Value
16	STD_ENERGY_U	☐	OIU_STD_ENERGY_U	MEINS	UNIT	3	0	Standard Energy UoM	T006
17	STD_ENERGY	☐	OIU_STD_ENERGY	MENGE	QUAN	13	3	Standard Energy
18	QY_U	☐	OIU_QY_U	MEINS	UNIT	3	0	Quantity Unit	T006
19	ENTL_QY	☐	OIU_ENTL_QY	MENGE	QUAN	13	3	Entitled Quantity
20	ADJ_ENTL_QY	☐	OIU_ADJ_ENTL_QY	MENGE	QUAN	13	3	Adjusted Entitlement (Volumetric or Energy)
21	PHASE_1_QY	☐	OIU_PHASE_1_QY	OIU_VOLUME_SIGN	DEC	13	3	Phase One Allocation Energy Quantity
22	PHASE_2_QY	☐	OIU_PHASE_2_QY	OIU_VOLUME_SIGN	DEC	13	3	Phase Two Allocation Energy Quantity
23	PHASE_3_QY	☐	OIU_PHASE_3_QY	OIU_VOLUME_SIGN	DEC	13	3	Phase Three Allocation Energy Quantity
24	PHASE_4_QY	☐	OIU_PHASE_4_QY	OIU_VOLUME_SIGN	DEC	13	3	Phase Four Allocation Energy Quantity
25	PHASE_5_QY	☐	OIU_PHASE_5_QY	OIU_VOLUME_SIGN	DEC	13	3	Phase Five Allocation Energy Quantity
26	ME_DOCNR	☐	OIU_ME_DOCNR	BELNR	CHAR	10	0	Meas. document number
27	ME_DOCYR	☐	OIU_ME_DOCYR	GJAHR	NUMC	4	0	Meas. document year
28	.INCLUDE	☐				0	0	Creator and date/time created
29	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
30	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_SB_CTRWC	CT_NO	OIU_RV_CT	CT_NO	KEY	1	CN
2	OIU_SB_CTRWC	DN_NO	OIU_PR_DN	DN_NO	KEY	1	CN
3	OIU_SB_CTRWC	MATNR	OIU_CM_MAT_PRCD	MATNR	KEY	1	CN
4	OIU_SB_CTRWC	ORIG_MP_NO	OIU_PR_MP	MP_NO	KEY	1	CN
5	OIU_SB_CTRWC	QY_U	T006	MSEHI		1	CN
6	OIU_SB_CTRWC	STD_ENERGY_U	T006	MSEHI		1	CN
7	OIU_SB_CTRWC	STD_HEAT_VAL_U	T006	MSEHI		1	CN
8	OIU_SB_CTRWC	STD_VOL_U	T006	MSEHI	KEY	1	CN
9	OIU_SB_CTRWC	TRNSP_NO	KNA1	KUNNR	KEY	1	CN
10	OIU_SB_CTRWC	WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
11	OIU_SB_CTRWC	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

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