SAP ABAP Table OIU_SB_NIMB (Marketing representative imbalance volumes)

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_NIMB	Table Relationship Diagram
Short Description	Marketing representative imbalance volumes

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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
4	SA_DT	☑	OIU_SA_DT	DATS	DATS	8	0	Sales date
5	FREQ_CD	☑	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
6	MK_REP_NO	☑	OIU_MK_REP_NO	KUNNR	CHAR	10	0	Marketing Representative No	KNA1
7	MK_REP_ISQ_NO	☑	OIU_MK_REP_ISQ_NO	OIU_MK_REP_ISQ_NO	CHAR	2	0	Marketing Representative Interest Sequence No
8	QY_U	☐	OIU_UOM	MEINS	UNIT	3	0	Unit of Measure	T006
9	ORIG_BEG_IMB_QY	☐	OIU_ORIG_BEG_IMB_QY	OIU_VOLUME_SIGN	DEC	13	3	Beginning imbalance from NMR table (Volumetric or Energy)
10	NEW_BEG_IMB_QY	☐	OIU_NEW_BEG_IMB_QY	OIU_VOLUME_SIGN	DEC	13	3	New beginning imbalance calculated in CABS700
11	UNAPPL_PPA_QY	☐	OIU_UNAPPL_PPA_QY	OIU_VOLUME_SIGN	DEC	13	3	Unapplied Prior Period Adjustment (Volumetric or Energy)
12	APPL_PPA_QY	☐	OIU_APPL_PPA_QY	OIU_VOLUME_SIGN	DEC	13	3	Applied Prior Period Adjustment (Volumetric or Energy)
13	UNAPPL_MAN_QY	☐	OIU_UNAPPL_MAN_QY	OIU_VOLUME_SIGN	DEC	13	3	Unapplied Manual (Volumetric or Energy)
14	APPL_MAN_QY	☐	OIU_APPL_MAN_QY	OIU_VOLUME_SIGN	DEC	13	3	Applied Manual (Volumetric or Energy)
15	MK_REP_IMB_QY	☐	OIU_MK_REP_IMB_QY	OIU_VOLUME_SIGN	DEC	13	3	Marketing representative imbalance (Volumetric or Energy)
16	IMB_MKUP_QY	☐	OIU_IMB_MKUP_QY	OIU_VOLUME_SIGN	DEC	13	3	Imbalance Makeup (Volumetric or Energy)
17	PHASE_5_IMB_QY	☐	OIU_PHASE_5_IMB_QY	OIU_VOLUME_SIGN	DEC	13	3	Phase 5 Imbalance (Volumetric or Energy)
18	ORIG_END_IMB_QY	☐	OIU_ORIG_END_IMB_QY	OIU_VOLUME_SIGN	DEC	13	3	Original Ending Imbalance (Volumetric or Energy)
19	NEW_END_IMB_QY	☐	OIU_NEW_END_IMB_QY	OIU_VOLUME_SIGN	DEC	13	3	New Ending Imbalance (Volumetric or Energy)
20	ADJ_ENTL_QY	☐	OIU_ADJ_ENTL_QY	MENGE	QUAN	13	3	Adjusted Entitlement (Volumetric or Energy)
21	SALE_QY	☐	OIU_SALE_QY	MENGE	QUAN	13	3	Sales (Volumetric or Energy)
22	PPA_IMB_ADJ_QY	☐	OIU_PPA_IMB_ADJ_QY	OIU_VOLUME_SIGN	DEC	13	3	Prior Period Adjustment Imbalance Adjustment (Vol or Energy)
23	.INCLUDE	☐				0	0	Creator and date/time created
24	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
25	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_NIMB	DN_NO	OIU_PR_DN	DN_NO		1	CN
2	OIU_SB_NIMB	MATNR	OIU_CM_MAT_PRCD	MATNR		1	CN
3	OIU_SB_NIMB	MK_REP_NO	KNA1	KUNNR		1	CN
4	OIU_SB_NIMB	QY_U	T006	MSEHI		1	CN

History

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