SAP ABAP Table ROIU_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	INTTAB	Structure
Structure	ROIU_SB_AVD	Table Relationship Diagram
Short Description	Availability Detail

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	Availability Detail
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	AVD_NO	☐	OIU_AVD_NO	OIU_SYS_NO	NUMC	12	0	Availability Detail Number	OIU_SB_AVH
4	AVH_NO	☐	OIU_AVH_NO	OIU_SYS_NO	NUMC	12	0	Availability Header Number (AVH)	*
5	OWN_NO	☐	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
6	OWN_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
7	OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
8	ORIG_GRI_PC	☐	OIU_ORIG_GRI_PC	OIU_PERCENT98	DEC	9	8	Original GRI Percentage
9	ORIG_ENTL_VL	☐	OIU_ORIG_ENTL_VL	MENGE	QUAN	13	3	Original Entitled Volume
10	MK_REP_NO	☐	OIU_MK_REP_NO	KUNNR	CHAR	10	0	Marketing Representative No	*
11	MK_REP_ISQ_NO	☐	OIU_MK_REP_ISQ_NO	OIU_MK_REP_ISQ_NO	CHAR	2	0	Marketing Representative Interest Sequence No
12	ADJ_GRI_PC	☐	OIU_ADJ_GRI_PC	OIU_PERCENT98	DEC	9	8	Adjusted GRI Percentage
13	ADJ_ENTL_VL	☐	OIU_ADJ_ENTL_VL	MENGE	QUAN	13	3	Adjusted Entitlement Volume
14	EST_CUMIB	☐	OIU_EST_CUMIB	MENGE	QUAN	13	3	Estimated Cumulative Balance
15	MKUP_FL	☐	OIU_MKUP_FL	OIU_X_FLAG	CHAR	1	0	Makeup Indicator
16	MKUP_OVRD_FL	☐	OIU_MKUP_OVRD_FL	OIU_X_FLAG	CHAR	1	0	Make Up Override Indicator
17	MKUP_VL	☐	OIU_MKUP_VL	OIU_VOLUME_SIGN	DEC	13	3	Make Up Volume
18	PYBAK_FL	☐	OIU_PYBAK_FL	OIU_X_FLAG	CHAR	1	0	Payback Indicator
19	PYBAK_PC	☐	OIU_PYBAK_PC	OIU_PERCENT96	DEC	9	6	Pay Back Percent
20	PYBAK_VL	☐	OIU_PYBAK_VL	OIU_VOLUME_SIGN	DEC	13	3	Pay Back Volume
21	NS_RSN_CD	☐	OIU_NS_RSN_CD	OIU_NS_RSN_CD	CHAR	2	0	Not Selling Reason	OIU_SB_NSRSN
22	SWING_FL	☐	OIU_SWING_FL	OIU_X_FLAG	CHAR	1	0	Swing Indicator
23	SWING_VL	☐	OIU_SWING_VL	OIU_VOLUME_SIGN	DEC	13	3	Swing Volume
24	.INCLUDE	☐				0	0	Creator and date/time created
25	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
26	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
27	OWN_NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
28	LONGTEXT	☐	OIU_LONG_TEXT	CHAR01	CHAR	1	0	Long Text
29	EST_CUM_BAL	☐	OIU_EST_CUM_BAL	MENGE	QUAN	13	3	Adjusted Entitlement Volume
30	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
31	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_AVD	AVD_NO	OIU_SB_AVH	AVH_NO	KEY	1	CN
2	ROIU_SB_AVD	NS_RSN_CD	OIU_SB_NSRSN	NS_RSN_CD
3	ROIU_SB_AVD	OWN_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD		1	CN
4	ROIU_SB_AVD	OWN_NO	LFA1	LIFNR		1	CN

History

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