SAP ABAP Table ROIU_SB_BDI (Balancing Direct Input: Maintenance Structure)

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	INTTAB	Structure
Structure	ROIU_SB_BDI	Table Relationship Diagram
Short Description	Balancing Direct Input: Maintenance Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Well Completion Imbalance
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	OIU_PR_DN
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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
7	SA_DT	☐	OIU_SA_DT	DATS	DATS	8	0	Sales date
8	OWN_NO	☐	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
9	OWN_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
10	OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
11	FREQ_CD	☐	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
12	ADJ_NO	☐	OIU_ADJ_NO	NUMC3	NUMC	3	0	Adjustment No
13	TRANS_TYPE_CD	☐	OIU_TRANS_TYPE_CD	OIU_TRANS_TYPE_CD	CHAR	2	0	Transaction Type Code
14	DI_TXN_RSN	☐	OIU_TXN_CD	OIU_TXN_CD	CHAR	3	0	Balancing transaction reasons	OIU_SB_BLRSN
15	QY_U	☐	OIU_QY_U	MEINS	UNIT	3	0	Quantity Unit	*
16	CUM_ADJ_QY	☐	OIU_CUM_ADJ_QY	OIU_VOLUME_SIGN	DEC	13	3	Cumulative Adjusted Quantity
17	STD_ENTL_QY	☐	OIU_STD_ENTL_QY	MENGE	QUAN	13	3	Standardized Entitled Quantity
18	STD_ACTL_QY	☐	OIU_STD_ACTL_QY	MENGE	QUAN	13	3	Standardized Actual Quantity
19	STD_HEAT_VAL_U	☐	OIU_STD_HEAT_VAL_U	MEINS	UNIT	3	0	Standardized Heating Value Unit	T006
20	STD_HEAT_VAL	☐	OIU_STD_HEAT_VAL	MENGE	QUAN	13	3	Standardized Heating Value
21	ENTL_INT_PC	☐	OIU_ENTL_INT_PC	OIU_PERCENT98	DEC	9	8	Entitlement Interest %
22	.INCLUDE	☐				0	0	Creator and date/time created
23	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
24	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25	SA_MONTH	☐	OIU_SALES_MONTH	OIU_SALE_DT	ACCP	6	0	Sales Month (YYYYMM)
26	SA_TO_MONTH	☐	OIU_SALES_MONTH_TO	OIU_SALES_MNTH	ACCP	6	0	To Sales Month
27	DN_DE	☐	OIU_DN_DE	OIU_TEXT35	CHAR	35	0	Delivery network description
28	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
29	MP_DE	☐	OIU_MP_DE	OIU_TEXT35	CHAR	35	0	Measurement point description
30	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
31	NAME	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
32	OWN_NM	☐	OIU_OWN_DE	OIU_OWN_DE	CHAR	30	0	Owner Description
33	PBA_NO	☐	OIU_PBA_NO	OIU_PBA_NO	CHAR	10	0	PBA Number	*
34	PBA_DE	☐	OIU_PBA_DE	OIU_TEXT35_CI	CHAR	35	0	PBA description (Product Balancing Agreement)
35	TXN_TYPE_DE	☐	OIU_TXN_DE	OIU_TEXT20	CHAR	20	0	Transaction Type description
36	TXN_RSN_DE	☐	OIU_TXN_DE	OIU_TEXT20	CHAR	20	0	Transaction Type description
37	STD_ENTL_VOL	☐	OIU_STD_ENTL_VL	MENGE	QUAN	13	3	Standard Entitlement Volume
38	STD_ENTL_VOL_U	☐	OIU_STD_ENTL_VL_U	MEINS	UNIT	3	0	Standardized Entitled Volume Unit	*
39	STD_ACTL_VOL	☐	OIU_STD_ACTL_VL	MENGE	QUAN	13	3	Standard Actual Volume
40	STD_ACTL_VOL_U	☐	OIU_STD_ACTL_VL_U	MEINS	UNIT	3	0	Standardized Actual Volume Unit	*
41	STD_ENTL_ENERGY	☐	OIU_STD_ENTL_ENERGY	MENGE	QUAN	13	3	Standardized Entitled Energy
42	STD_ENTL_ENERGY_U	☐	OIU_STD_ENTL_ENERGY_U	MEINS	UNIT	3	0	Standardized Entitled Energy Unit	*
43	STD_ACTL_ENERGY	☐	OIU_STD_ACTL_ENERGY	MENGE	QUAN	13	3	Standardized Actual Energy
44	STD_ACTL_ENERGY_U	☐	OIU_STD_ACTL_ENERGY_U	MEINS	UNIT	3	0	Standardized Actual Energy Unit	*
45	UOM_GRP	☐	OIU_UOM_GRP	OIU_UOM_GRP	CHAR	10	0	Unit of Measure Group
46	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIU_SB_BDI	DI_TXN_RSN	OIU_SB_BLRSN	TXN_CD	KEY	1	CN
2	ROIU_SB_BDI	DN_NO	OIU_PR_DN	DN_NO
3	ROIU_SB_BDI	MATNR	OIU_CM_MAT_PRCD	MATNR	KEY	1	CN
4	ROIU_SB_BDI	OWN_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD	KEY	1	CN
5	ROIU_SB_BDI	OWN_NO	LFA1	LIFNR	KEY	1	CN
6	ROIU_SB_BDI	STD_HEAT_VAL_U	T006	MSEHI		1	CN
7	ROIU_SB_BDI	WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
8	ROIU_SB_BDI	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in