SAP ABAP Table OIU_SB_AVD (Availability Detail)

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_AVD	Table Relationship Diagram
Short Description	Availability Detail

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	AVD_NO	☑	OIU_AVD_NO	OIU_SYS_NO	NUMC	12	0	Availability Detail Number	OIU_SB_AVH
3	AVH_NO	☐	OIU_AVH_NO	OIU_SYS_NO	NUMC	12	0	Availability Header Number (AVH)
4	OWN_NO	☐	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
5	OWN_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
6	OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
7	ORIG_GRI_PC	☐	OIU_ORIG_GRI_PC	OIU_PERCENT98	DEC	9	8	Original GRI Percentage
8	ORIG_ENTL_VL	☐	OIU_ORIG_ENTL_VL	MENGE	QUAN	13	3	Original Entitled Volume
9	MK_REP_NO	☐	OIU_MK_REP_NO	KUNNR	CHAR	10	0	Marketing Representative No	*
10	MK_REP_ISQ_NO	☐	OIU_MK_REP_ISQ_NO	OIU_MK_REP_ISQ_NO	CHAR	2	0	Marketing Representative Interest Sequence No
11	ADJ_GRI_PC	☐	OIU_ADJ_GRI_PC	OIU_PERCENT98	DEC	9	8	Adjusted GRI Percentage
12	ADJ_ENTL_VL	☐	OIU_ADJ_ENTL_VL	MENGE	QUAN	13	3	Adjusted Entitlement Volume
13	EST_CUMIB	☐	OIU_EST_CUMIB	MENGE	QUAN	13	3	Estimated Cumulative Balance
14	MKUP_FL	☐	OIU_MKUP_FL	OIU_X_FLAG	CHAR	1	0	Makeup Indicator
15	MKUP_OVRD_FL	☐	OIU_MKUP_OVRD_FL	OIU_X_FLAG	CHAR	1	0	Make Up Override Indicator
16	MKUP_VL	☐	OIU_MKUP_VL	OIU_VOLUME_SIGN	DEC	13	3	Make Up Volume
17	PYBAK_FL	☐	OIU_PYBAK_FL	OIU_X_FLAG	CHAR	1	0	Payback Indicator
18	PYBAK_PC	☐	OIU_PYBAK_PC	OIU_PERCENT96	DEC	9	6	Pay Back Percent
19	PYBAK_VL	☐	OIU_PYBAK_VL	OIU_VOLUME_SIGN	DEC	13	3	Pay Back Volume
20	NS_RSN_CD	☐	OIU_NS_RSN_CD	OIU_NS_RSN_CD	CHAR	2	0	Not Selling Reason	OIU_SB_NSRSN
21	SWING_FL	☐	OIU_SWING_FL	OIU_X_FLAG	CHAR	1	0	Swing Indicator
22	SWING_VL	☐	OIU_SWING_VL	OIU_VOLUME_SIGN	DEC	13	3	Swing Volume
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_AVD	AVD_NO	OIU_SB_AVH	AVH_NO	KEY	1	CN
2	OIU_SB_AVD	NS_RSN_CD	OIU_SB_NSRSN	NS_RSN_CD
3	OIU_SB_AVD	OWN_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD	KEY	1	CN
4	OIU_SB_AVD	OWN_NO	LFA1	LIFNR		1	CN

History

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