SAP ABAP View V_OIU_PR_DNAP (Materials and Volume Types per DN, Frequencey and Date Range)

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

View Type	D	Database View
Database View	V_OIU_PR_DNAP
Short Description	Materials and Volume Types per DN, Frequencey and Date Range
Root table	OIU_PR_DNAPH	Network Allocation Profile Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIU_PR_DNAPH	OIU_PR_DNAPH
2	OIU_PR_DNAPD
3	MAKT
4	OIU_PR_VLTYP_TX

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIU_PR_DNAPH	MANDT	JL	EQ				0	0
2	OIU_PR_DNAPD	MANDT	JR	EQ			AND	0	0
3	OIU_PR_DNAPH	DNAPH_NO	JL	EQ				0	0
4	OIU_PR_DNAPD	DNAPH_NO	JR	EQ			AND	0	0
5	MAKT	MANDT	JL	EQ				0	0
6	OIU_PR_DNAPD	MANDT	JR	EQ			AND	0	0
7	MAKT	MATNR	JL	EQ				0	0
8	OIU_PR_DNAPD	MATNR	JR	EQ			AND	0	0
9	OIU_PR_VLTYP_TX	VL_TYPE_CD	JL	EQ				0	0
10	OIU_PR_DNAPD	VT_CD	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIU_PR_DNAPH	MANDT		☐	MANDT	☐	Client
2	DNAPH_NO	OIU_PR_DNAPH	DNAPH_NO		☐	OIU_DNAPH_NO	☐	Delivery network allocation profile number
3	DN_NO	OIU_PR_DNAPH	DN_NO		☐	OIU_DN_NO	☐	Delivery network number
4	FREQ_CD	OIU_PR_DNAPH	FREQ_CD		☐	OIU_FREQ_CD	☐	Frequency
5	EFF_FROM_DT	OIU_PR_DNAPH	EFF_FROM_DT		☐	OIU_EFF_FROM_DT	☐	Effective from date
6	EFF_TO_DT	OIU_PR_DNAPH	EFF_TO_DT		☐	OIU_EFF_TO_DT	☐	Effective To Date
7	MATNR	OIU_PR_DNAPD	MATNR		☐	MATNR	☐	Material Number
8	VT_CD	OIU_PR_DNAPD	VT_CD		☐	OIU_VL_TYPE_CD	☐	Volume Type Code
9	PD_SEQ_NO	OIU_PR_DNAPD	PD_SEQ_NO		☐	OIU_PD_SEQ_NO	☐	Product sequence number
10	DEP_MATNR	OIU_PR_DNAPD	DEP_MATNR		☐	OIU_DEP_MATNR	☐	Dependent Material
11	DEP_VT_CD	OIU_PR_DNAPD	DEP_VT_CD		☐	OIU_DEP_VT_CD	☐	Dependent volume type code
12	SUM_DLY_FL	OIU_PR_DNAPD	SUM_DLY_FL		☐	OIU_SUM_DLY_FL	☐	Summary daily flag
13	AUTO_FLO_FL	OIU_PR_DNAPD	AUTO_FLO_FL		☐	OIU_AUTO_FLO_FL	☐	Automatic flow flag
14	CALC_VT_CD	OIU_PR_DNAPD	CALC_VT_CD		☐	OIU_CALC_VT_CD	☐	Calculated volume type
15	ALLOC_FL	OIU_PR_DNAPD	ALLOC_FL		☐	OIU_ALLOC_FL	☐	Allocate flag indicating whether to do allocations
16	CMP_ALLOC_FL	OIU_PR_DNAPD	CMP_ALLOC_FL		☐	OIU_CMP_ALLOC_FL	☐	Component allocation flag
17	SUM_TKT_FL	OIU_PR_DNAPD	SUM_TKT_FL		☐	OIU_SUM_TKT_FL	☐	Summarize Run Tickets Flag
18	MAKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
19	VL_TYPE_DE	OIU_PR_VLTYP_TX	VL_TYPE_DE		☐	OIU_VL_TYPE_DE	☐	Volume Type Description
20	SPRAS	MAKT	SPRAS		☐	SPRAS	☐	Language Key

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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