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

History

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